Allow New Entries and Set Value While Adding New Entries | Zoho Creator Help

Allow New Entries and Set Value While Adding New Entries

Allow New Entries

You can choose to allow the addition of new entries in a lookup field using a looked-up form. Follow the below steps to configure this:

1. Open the form builder of the target form.
2. Select the required lookup field.
3. Navigate to the Choices section in the Field Properties pane.
4. Check the checkbox next to Allow new entries. The Link Name property will appear. It will be set as 'Add New' by default. You can edit it as required.

Note:

  1. Ticking the Allow new entries checkbox in the form builder will allow the addition of field entries in the lookup field (live mode). You can add an entry only once if the source form allows only one entry per user. Otherwise, you can add multiple entries.
  2. The entries added here will automatically be populated in the report of the source form.

Set Value While Adding New Entries

After you've configured allowing new entries using the above steps, you can also choose to preset field values from the current form in the looked-up form that pops up.

To configure field mapping to automatically set values in a looked-up form while adding new entries, follow the below steps:

1. Navigate to the edit mode of the form containing the lookup field.

2. Check Allow New Entries under Choices in the Field Properties pane.

3. Check Set value while adding new entries which subsequently appears below the Allow new entries checkbox. The Map fields while adding new entries popup will appear.

4. In the popup, select the looked-up form's field on the left and map them to the corresponding field from the current form. The acquired information will be populated in the mapped looked-up form fields on load.
Note: The following fields are not supported for mapping: URLImageSubFormSignatureFile uploadAudioVideoAuto NumberFormulaSectionAdd NotesPredictionKeyword ExtractionSentiment AnalysisOCRObject Detection.

5. Click the + icon to the right of a mapped fields pair to add a new mapping below it.
You can also use the bin ()icon to the right of a mapped fields pair to delete the mapping.
Note: A maximum of 10 fields can be mapped from the current form to the looked-up form.

6. Click Save after mapping all necessary fields.

Edit Mappings
To edit the mappings again, click on the text box below the Set value while adding new entries checkbox in the Field Properties pane. The Map fields while adding new entries popup will appear.


Note:
  1. Make sure to match fields with the same data type. Eg. Email field can be mapped to Single Line field.
  2. To map a AR field or a Multi Select field, the exact field type must be used.
  3. If composite fields are present in the current form, you can either map one composite field to another or map each sub-field within to the corresponding sub-field of the looked-up form.
  4. A field from the current form can be mapped with one or more fields in the looked-up form as long as their data types match. Rationally, a field in the looked-up form cannot be mapped with multiple fields from the current form.

After configuration is successful, the field values get auto-populated in the looked-up form as seen below:


Limitations
  1. When the Set value while adding new entries option is enabled, a minimum of one field mapping should be configured. If not, the option should be disabled.
  2. A looked-up form might fail to load if there are too many selections in mapped Drop Down, Radio, Multi Select, Checkbox, Lookup, and Integration fields present in it.

Related Topics

  1. Understand Lookup Field
  2. Enable alphabetical sorting
  3. Manage filter
  4. Advanced search

    Zoho CRM Training Programs

    Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

    Zoho CRM Training
      Redefine the way you work
      with Zoho Workplace

        Zoho DataPrep Personalized Demo

        If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

        Zoho CRM Training

          Create, share, and deliver

          beautiful slides from anywhere.

          Get Started Now


            Zoho Sign now offers specialized one-on-one training for both administrators and developers.

            BOOK A SESSION





                        Still can't find what you're looking for?

                        Write to us:  support@zohoforms.com

                                                                       
                            



                            





                              You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                  Manage your brands on social media

                                    Zoho Desk Resources

                                    • Desk Community Learning Series


                                    • Digest


                                    • Functions


                                    • Meetups


                                    • Kbase


                                    • Resources


                                    • Glossary


                                    • Desk Marketplace


                                    • MVP Corner


                                    • Word of the Day


                                      Zoho Marketing Automation

                                        Zoho Sheet Resources

                                         

                                            Zoho Forms Resources


                                              Secure your business
                                              communication with Zoho Mail


                                              Mail on the move with
                                              Zoho Mail mobile application

                                                Stay on top of your schedule
                                                at all times


                                                Carry your calendar with you
                                                Anytime, anywhere




                                                      Zoho Sign Resources

                                                        Sign, Paperless!

                                                        Sign and send business documents on the go!

                                                        Get Started Now





                                                                Zoho TeamInbox Resources



                                                                        Zoho DataPrep Resources



                                                                          Zoho DataPrep Demo

                                                                          Get a personalized demo or POC

                                                                          REGISTER NOW


                                                                            Design. Discuss. Deliver.

                                                                            Create visually engaging stories with Zoho Show.

                                                                            Get Started Now










                                                                                                • Related Articles

                                                                                                • Set default entries

                                                                                                  Set the default number of entries for subform field Refer to this page to learn about the SubForm field. Open the form builder. Select the required subform. Navigate to the Field Properties > Display type section on the right. Check the checkbox next ...
                                                                                                • Set maximum entries

                                                                                                  Restrict access to a form after a certain number of entries Refer to this page to learn about the Disable form after a certain number of entries property. Refer to this page to learn about the ways in which you can restrict entries from being ...
                                                                                                • Understand set field value in form workflows

                                                                                                  The Set field value action allows you to assign a static value to a form field based on a condition. This action executes when a new record is created or when an existing record is modified. You can preset the form field with any default or initial ...
                                                                                                • Set initial value

                                                                                                  Set initial value for form fields Refer to this page to learn about the Initial value field property Set initial value for single line field Set initial value for numeric fields Set initial value for single line field Refer to this page to learn ...
                                                                                                • Set initial value

                                                                                                  Set initial value for the email field Refer to this page to learn about the email field . The email field's initial value cannot exceed its max characters . Open the form builder. Select the required email field. Its Field Properties will appear on ...
                                                                                                Wherever you are is as good as
                                                                                                your workplace

                                                                                                  Resources

                                                                                                  Videos

                                                                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                  eBooks

                                                                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                  Webinars

                                                                                                  Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                  CRM Tips

                                                                                                  Make the most of Zoho CRM with these useful tips.



                                                                                                    Zoho Show Resources