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

    Access your files securely from anywhere

      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









                                            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

                                                                                                              • FAQs: Restrict Form Entries

                                                                                                                This page covers everything from customizing form messages to implementing Geo-fencing, empowering you with effective strategies for managing entries and enhancing security. Restrict Form Entries includes Enable Captcha, Allow one entry per user, ...
                                                                                                              • 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 Detail View Layout

                                                                                                                This page is applicable to all report types except spreadsheet, pivot chart, and pivot table. There are two specific predefined layouts for detail view: Summary layout and Block layout. Set summary layout for detail view of a record Navigate to the ...
                                                                                                                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