...
- formDefId: The form id of the source form containing the available setup data to 'pull' from.
- primaryKey: The dependent pulldown field id in your spreadsheet design, that provides the WHERE condition to select search the data to populate.
- fieldName: The field id id of the source form to populate in this spreadsheet cell column 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.
...