thank you for this video, simple and very useful. It helped me a lot. I needed to make a http post to a external service to calculate delivery price. The sumbited data should contain different informations like weight, state, town, address, zip code, how much money should the customer pay etc. In my case, the data should be taken from fields of a newly completed form. With the help of your video and chat gpt : ) I created a function that has the variable to be sent to the external service and the values to be taken from the appsheet. They will appear only if they are put in the parantheses. After that I created an automation to be triggered when data is added after I add a step to run a scipt. I added the script and for each varible I included the dataset related to each column, after that I check return value, set it to string text then added a new step to change row value, selected the column Delivery price and in the expression field I inserted the name of the previous step [name of the previous step].[output] In my case it was import to recieve JSON data as a string and in the step that runs the script, after selecting return value to select string data type.
Great overview Thanks Is there anyway to customise the delete action (or others) so its not either in the header or at the top of content. A really common device UI pattern is to have the delete button at the bottom of the edit page. delete in manny use cases is an uncommon action that should be harder to get to
Is there a way to utilise this functionality to return say an error message to the user, for a mismatched Login/Password. I can see how to return text, but unsure how to go about showing that message in Appsheet for only that user, and clearing the value on refresh (think this is the bit I a most unsure of) or subsequent correct login
What is the context of the mismatched Login/Password? Are they passing a pair to the app and is the app sending that data to the Apps Script function? You can always pass the useremail() as a parameter to the Apps Script. So that way the Apps Script can return that email back to AppSheet. With that you can then associate that with the user.
