In this tutorial we're getting data from a table in PostgreSQL, using the data to build a dropdown, sending an external user an email step with the link to the drop-down to make a selection, and sending them a confirmation email with the selected item specified.
The drop-downs are dynamic so when new items are added to the PostgreSQL table, they will be reflected in the dropdown.
In this tutorial we're getting data from a table in Google Sheets, using the data to build a dropdown. The dropdown is dynamic, which means that any change to the Google Sheets will result in a change in the dropdown when a new instance is run.
The URL we're calling is: https://sheets.googleapis.com/v4/spreadsheets/1J5F8TzXhLJ2V9rpRoAVG5ppBTbh74sdeodXJ6mO3Hrg/values/TEST!A2:B100/ and contains the sheet ID, name and range. For details, see Connect with Google Sheets.
The source of a dynamic drop-down needs to be a JSON list.
A JSON list (array) contains zero, one, or more ordered elements, separated by a comma. The JSON array is surrounded by square brackets [ ]. Each element is in double quotes.
Note that when you have a key=value pair (["name":"John"]), we'll only display the value in the dropdown.
When you create a dropdown from, for example, Google Sheets, using a data reference, make sure to select the data reference in (json) format.
Updated 2 months ago