Hi! great work! many thanks. I wonder how you did what you did at 6:50 when you add some prodcuts to the child table but from another view. Or kindda that ^^!!
Hey Matt. Firstly can I say this is a fantastic little hack and i wish I'd found it sooner!! but I think I have subtly different requirement. I use a card view as a Home menu. When you tap on the card it fires a Go To App Link from an App column type. In the sheet, this column contains "#control=Log_form" which, as it suggests, takes you to a form view and with your bit added creating #control=Log_form&"&at="&(NOW()+1) it syncs as well which is great. However I think it does it in that order e.g. "open new form then sync". Is it possible to get it to Sync first then open the form as I need to grab any new data from the sheet first before it creates initial values?? I hope this is clear and that maybe you can help. Thanks in advance Rich
Hi Matt, i have a bot trigger on "Adds and Deletes" of sales table to add or delete the invertory movement, and a second step to update the stock column of that product on "available" column with a formula, that ok and work. I went to show abailable quantity of the product selected on new sale form, so i add a virtual column on sales with a formula [_THISROW].[id_product].[available] and work but... when product[available] update for the bot, i dont see the change on new sale form if i select the same product again, but i can see that my spreadsheet is updated for the bot, so.... i think maybe appsheet dont see the "change" over products table because was made from bot and no from app and thats why the app have a no-updated version of the products table. How can i force the pull?
Hi! How can I be it with differents tables? Example: I have two tables, Order and Stock. When I go finish the Order, I need update status of order to "Finished" and update the stock item. It's possible? If yes.. How? Thank you very much for your attention. Sorry my English, I'm Brazilian.😅
Hi Matt, I have been following along but I am struggling to find how you implemented the new Set | Status action. I haven't been able to make it work from the building ticket detail page. Could you help with that?
![INPUT for QTY || Shopping Cart [BUILD] - Part 3](http://i.ytimg.com/vi/-1Nd7-eRZmo/mqdefault.jpg)
![INPUT for QTY || Shopping Cart [BUILD] - Part 3](/img/tr.png)
Hi! great work! many thanks.
I wonder how you did what you did at 6:50 when you add some prodcuts to the child table but from another view. Or kindda that ^^!!
Hey Matt. Firstly can I say this is a fantastic little hack and i wish I'd found it sooner!! but I think I have subtly different requirement. I use a card view as a Home menu. When you tap on the card it fires a Go To App Link from an App column type. In the sheet, this column contains "#control=Log_form" which, as it suggests, takes you to a form view and with your bit added creating #control=Log_form&"&at="&(NOW()+1) it syncs as well which is great. However I think it does it in that order e.g. "open new form then sync". Is it possible to get it to Sync first then open the form as I need to grab any new data from the sheet first before it creates initial values?? I hope this is clear and that maybe you can help. Thanks in advance Rich
I have the same problem, did you find a solution?
Hi Matt, i have a bot trigger on "Adds and Deletes" of sales table to add or delete the invertory movement, and a second step to update the stock column of that product on "available" column with a formula, that ok and work. I went to show abailable quantity of the product selected on new sale form, so i add a virtual column on sales with a formula [_THISROW].[id_product].[available] and work but... when product[available] update for the bot, i dont see the change on new sale form if i select the same product again, but i can see that my spreadsheet is updated for the bot, so.... i think maybe appsheet dont see the "change" over products table because was made from bot and no from app and thats why the app have a no-updated version of the products table. How can i force the pull?
Fantastic tutorial!! ✅️💯
Hi!
How can I be it with differents tables?
Example:
I have two tables, Order and Stock.
When I go finish the Order, I need update status of order to "Finished" and update the stock item.
It's possible? If yes.. How?
Thank you very much for your attention.
Sorry my English, I'm Brazilian.😅
Hi Matt, I have been following along but I am struggling to find how you implemented the new Set | Status action. I haven't been able to make it work from the building ticket detail page. Could you help with that?
ruclips.net/video/p0b2FuIwrjI/видео.html
❤❤❤❤❤❤❤