...

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.

Below is a sample app to demonstrate the use of Spreadsheet form element:

Download Demo App

• Demonstration Spreadsheet app Example app using Spreadsheet in Form APP_spreadsheet app.jwa.

...