ADDING ROWS I am trying to get my mind aroun...

(Brett Mason) #1

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?

(Bellave Jayaram) #2

We do this using Virtual Columns added to the table (in your case WIDGET_ORDERS).

(Brett Mason) #3

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?

(Bellave Jayaram) #4

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