ADDING ROWS
I am trying to get my mind around something that would have been really easy in BASIC or FORTRAN, but I am stumpedโฆ
In WIDGET_ORDERS I have a row for each order#, including QUANTITY
When a New Order goes in, I want to automatically add QUANTITY rows to DETAILS, and insert calculated data to configure each widgetโฆ
Seeking a FOR-NEXT loop to go through the processโฆ
Am I thinking about this wrong?
We do this using Virtual Columns added to the table (in your case WIDGET_ORDERS).
If I receive an order with 7 WidgetAโs and 23 SmartWidgetBโs then I need 30 rows added to my DETAILS table.
In each row there are about 6 different configuration fields for each widget that need to be calculated and edited or confirmed.
Can you further explain how to use Virtual Columns to do this?
Please check out the order capture sample app - appsheet.com - Order Capture - An app for managing customers, products, and orders. Order Capture - An app for managing customers, products, and orders. appsheet.com
User | Count |
---|---|
36 | |
34 | |
27 | |
23 | |
18 |