I would like to make display Forms checklist items by accessing a simple database.
It shows item dynamically.
To achieve this, it is known that JSM's Data Connection function is used to obtain JSON data.
When creating JSON data, I tried accessing the data using the Google Sheets API, but I was unable to successfully retrieve the Excel values from the Data Connection page. (*See image)
Then, I checked the following page as a solution for this case, but I cannot implement the answer.
Is this because the version change ?
Is the reason I can't run it because it's the free version?
If I use the paid version, will I be able to run it?
We are currently testing the functionality and plan to use the paid version internally in the near future.
Thanks in advance.