Versions Compared

Old Version 29

changes.mady.by.user Administrator

Saved on

compared with

New Version 30

changes.mady.by.user Andrew

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

FORMDATA(formDefId, primaryKey, fieldName) - Used to load form data valuein Spreadsheet "Formula" column.

where:

  • formDefId: The form id of the form containing the available data to 'pull' from.
  • primaryKey: The dependent field id in your spreadsheet design, that provides the WHERE condition to select the data to populate
  • fieldName: The field id to populate in this spreadsheet cell based on the above 'primaryKey' value

Use this function to 'pull' and populate a spreadsheet cell based on available data in other forms.

For example, to make spreadsheet pull and display the population value after the user picks the city name (pulldown menu), use FORMDATA("city_formId",select_city,population) where 'select_city' is the first field id in your spreadsheet.