I would like to know how I can display the first line in each text box using Google Sheets.
Hi dear,
This might be helpful,
I couldn’t find the solution; I just want to display the links in each text box. Do you have any pictures of the blocks, please?
This image is taken from this topic:
https://community.kodular.io/t/web-component-limits/301824/19
As you can see, when Button1 is clicked, the Web component is called with the link to your Google Sheet (it must be shared with anyone).
You just need to copy the blocks exactly as they are and create two variables, spreadsheetID and gid, which correspond to those shown in the image.
In Web.GotText, you receive the text in CSV format, which, once converted using the appropriate block, returns a list that you can manage however you prefer.