Lookup Mapping on Form Director

-

 Lookup Field Mapping




What is Lookup Field Mapping?

Lookup field mapping allows users to map form fields with data from other external sources. Lookup Field Type enables the users to look up the Google Sheets data, search and select results from GoogleSsheets based on user entry.




Lookup from Google Sheets

  • Select the external source as Google Sheet also select the required spreadsheet tab from where the data needs to be used.
  • Select the range that is required.



How configuration is done?

  • Select the lookup conditions required.
  • Mapping consists of Form Field, Lookup Field, Result Field & Default Field.
  • Users can add any number of conditions required.
  • Form Fields refers to the Form field values.
  • Lookup Field refers to the value from the selected spreadsheet lookup column.
  • If all the conditions satisfy then the result field value is the lookup value from the spreadsheet.
  • If none of the conditions satisfies then it will look up to the default value.
  • Check the condition by providing sample data.



Read more about the Lookup field type from Form Director website.

Contact Us or write to support@jivrus.com for any queries

                                                           Visit us at www.jivrus.com

Comments

Post a Comment

Popular posts from this blog

Form Builder Newsletter for the month of September_2024

-
Image
     Form Builder Newsletter for the month of September 2024 Form Builder updates Features Spotlight: Form Builder Parser streamlines the form creation process by enabling easy data extraction from Google Forms, Sheets, Docs, and Slides. It allows you to pull specific questions, fields, and responses from these sources, helping you efficiently organize and manage the extracted data for use in building structured and well-organized forms.  With advanced configurations, you can customize how data is parsed and imported to suit your needs. Additionally, Form Builder Parser supports exporting form questions and data back into Google Sheets, Docs, or Slides for reuse and further content manipulation. Read more @   https://formbuilder.jivrus.com/features/form-builder-parser Note:  Transform your business and achieve breakthrough results with our expert  Professional Services , designed to help you harness the power of intelligent integration and hyper-automa...
Read more

Form Director Newsletter for the month of October_2024

-
Image
                    Newsletter for the month of October 2024 Form Director updates Features Updates: Multi-level Approval : This update introduces the capability for multi-level approval. Users can configure a series of approval levels (stages). The process will proceed through several approval levels (stages), and execution will be completed once all approvals are granted. Automated Hourly Processing : This update introduces the capability to enable automatic processing of missed responses each hour. Every hour, it starts and fetches the responses that were missed and processes them. Videos Spotlight: Streamline your Workflow with Google Forms & Zoho Books -  Watch Video Note:  Transform your business and achieve breakthrough results with our expert  Professional Services , designed to help you harness the power of intelligent integration and hyper-automation.
Read more

Fillable Document Newsletter for the month of October_2024

-
Image
     Fillable Document Newsletter for the month of October 2024 Fillable Document updates Updates:   Auto Detect in Fillable Document : The  Auto Detect  feature will intelligently identify potential fields based on the content of the active document, making them fillable fields efficiently and smoothly.  Instead of manually creating new fields, this feature will identify all potential fields from your document content. It can detect various types of potential fields, such as names, numbers, dates, times, URLs, mentions, currency, phone numbers, and more.  Read more about Auto Detect feature @ https://fillabledocument.jivrus.com/features/visually-build-fillable-forms#h.jrs2un89e2rh Note:  Transform your business and achieve breakthrough results with our expert  Professional Services , designed to help you harness the power of intelligent integration and hyper-automation. The User of the Month - October 2024 Join us in congratulating L...
Read more