Hello to all !
Starting my Appsheet learning path. I’m seeking some inputs, on learning ressources, to resolve an issue..
I am trying to build a simple Inventory App, with 2 tables : “Inventory” and “Stock releases”, mostly in the way of this youtube tutorial : Joe Tayactac - AppSheet Inventory Management Part 1 of 2.
I just want to track the [Available Stocks] in my “Inventory” Table, trough each row created in “Releases Stocks” table. Which include a Ref to “inventory” and data pulled with standard “Dereferencing” (and not ANY(SELECT() formulas as mostly used in the video)…
Btw Actually my Data tables comes from linked 3rd party “Smartsheet”…
What would be the best way, for the [New Available Stocks] value to replace the [Available Stocks] in “Inventory”, for each Row submission inside “Release Stocks” table ?
The tutorial achieves this by using a “Bot automation” and a “Task Webhook” which include the following API call (on “Release Stocks” Add row) :
*> {*
*> "Action": "Edit",
*> "Properties": {
*> "Locale": "en-US",
*> "Location": "47.623098, -122.330184",
*> "Timezone": "Pacific Standard Time"
*> },
*> "Rows": [
*> {
*> "Item Code": "<<Any(Select(Release Stocks[Item Code],[_thisrow].[Item Code]=[Item Code]))>>",
*> "Available Stocks": "<<Any(Select(Release Stocks[New Available Stocks],[ID]=MAXROW("Release Stocks","_Rownumber")))>>"
*> }
*> ]
*> }
This is where I am getting lost. I don’t fully understand yet, what is happening here and in these 2 formulas. And even by using the exact same column naming this don’t work on my side.
Could you please guide me to the correct ressource, subject on which to learn, to be able to achieve this kind of workflow ?
Could using “Smartsheet” as table source, rather than plain google sheets or integrated tables be an issue ?
Many thanks !
Best Regards,