LinkedIn
Twitter
As is known, AppSheet still doesn't have its own feature or function to make API calls in order to return content to the fields. Normally, this is done by making a call to a Google Apps Script through a Bot, where this script makes the API call and writes the returned data using the AppSheet API itself.
In the example below, I will use an API that returns address information from a ZipCode used in Brazil.
To make a GET API call while filling out a Form, you can use the Google Sheet IMPORTDATA(url) function, which must be resident in the worksheet. Below is an example that uses the public API to fetch the string with address fields from the zip code entered in another cell:
In the Form, you can use a Detail type form with โQuick editโ and create an Action of type โApp: Go to another view within this appโ to force data synchronization: LINKTOVIEW("view name")& "&at="&(NOW()+1)
PS: "Busca CEP" is "Search ZipCode" in Portuguese.
Thus, after fill the field that will be used by API GET call, you can just hit the Action to get data updated:
