Hi guys! Inspired by 2 versions of looping with actions from the appsheet community, I have managed to loop amd reloop and rereloop as many times as I want just by using actions based on multiple inputs. My case is with employees availabilities. So let's say 100 employees over 10 days, 1000 records done by one record. If you're interested, reach out.
@@AppSheetTraining I think any tips/tricks that you pros have will be appreciated. Such as bulk updating/uploading data back into AppSheet from say a CSV or Excel file. My use case would be weekly updated market fresh produce prices that need to update existing prices in my app each Monday. :) Cheers
Good Morning I built an Appsheet API, which through the browser includes images in the Appsheet application. On Android phones it's working perfectly, on iPhone phones it doesn't work. Can you tell me why?
Hi, Thank you for the video. I have learnt new things. I want to create a slice based on some specific row-column. I have a table with columns - Invoice Date, Start Date and End Date. I want to filter data based on the value of Row # 2 of Column Start Date and End Date. How can I refer to this specific Row and column in my filter expression? Thank you very much.
Hello guys, I have been following this example in a test app, however I can't see the options Appsheet: add row, under call a Webhook > Preset > (I tried enable my appID under > manage > integrations, but nothing seems to be worked to make appear this options in preset Appsheet), thanks for comments,
Hey guys great presentation! As always thank you so much. I got called away from it live so I couldn't ask a question... In the last JSON body I was wondering why the START expression would be [_THISROW-1 ].[ID] at the end to grab the pay period ID. Wouldn't [_THISROW] refer to the pay period already? Or does the select statement imply the context at it's beginning? I'm confused a bit lol. Also what if you wanted to use a ref list column type instead of getting a list from a start expression to generate the list? Like for instance to edit column values for that pay period's associated time cards? Is that possible from a deref expression in a JSON body? Or do you always use something independent of context like a FILTER or START expression?
@@AppSheetTraining I was asking in the START expression why [_THISROW-1] is used instead of just [THISROW]. I was under the assumption that using [THISROW} already refers to the pay period which triggered the workflow? Thanks for the reply also
Imagine you’re in a 3 layer start expression. Using [_Thisrow] at the lowest level refers all the way up to the top level. [_thisrow-1] refers up only 1 level, so to the 2nd layer of the start expressions.
@@AppSheetTraining Ok thank you I'm actually viewing the advanced templates and doc path on appsheet training now which I assume might cover some of this. Basically I want to get better at writing these expressions to start using the appsheet api to bulk generate rows for an inventory software. Upon generation of a new Vendor Purchase Order for example, new related child line items get created. Thanks for the great content guys
Hey I just want to give a quick update. I finished a few of the videos from Ben on demand particularly start expressions and I FINALLY nailed the API JSON body template. Among other things I had START capitalized instead of Start. It would have taken me a while had Ben not mentioned that lol. Ben you're the man I love you guys!!! I'm gonna be going on this all night now!
