Blog of Jivrus Technologies

  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 provi...

Form submission to as many as Google Sheets You being here in this blog means you already know that Google Form supports writing into Google Sheets off-the-shelf. But you may want the form submission to write into multiple Google Sheets and may be with custom column mapping. For example, you want your order form to create an entry in Orders sheet with order details, create an entry in Projects sheet with only project tracking details and create  jobs in  another sheet.  Now you can direct your Google Form submission to write into as many as Google Sheets as you want using  Form Director  add-on. Just create your custom services in Form Director choosing Google Sheets as the application. Steps 1. Choose the App and Service  2. Choose the Target Google Sheet using Google Picker. Then continue with standard steps 3. Map Form fields and Google Sheet fields 4. Save and activate Form Director Now, your form su...

You have got an email. That is a good news And that brings you new business. Expand your business reach. Collaborate more with your customers, employees, vendors, and any stakeholders of your business by simply opening up a Google Form that does more than what a Google Form does. I mean - power up the Google Form with Form Director add-on, that can direct the submitted data to various applications. You can now improve collaboration and communication from your Google Form submission by configuring notifications in Form Director. When a service (e.g. insert into database, generate merged doc/slide, create calendar event/contact etc) is successfully executed with submitted form data, Form Director can send notifications. Templated notifications can be configured to send to specific emails to form owner, editors and viewers to emails submitted from form attached the generated Google document, slide and PDFs with templated email subje...

Ever felt the need of sending Google Form data to your business applications? Storing into just Google Sheet is too restrictive? Form Director  is an easy way of directing your form data into various applications and databases. GSuite customers and Gmail consumers can now make Google Form to do much more things than just store responses into Google Sheet. Applications and services supported now Database Google Calendar Google Contacts Google Document Google Slides Google Task Watch out for more applications and services on the list. Visit us at  www.jivrus.com