Hi. I’m a appsheet beginner.
I have 2 columns , let’s say
- “Order type” (Enum) “Stock” and “not stock”
- “Style” (text) if “order type” is stock show list of stock style (i can do this, it show dropdown of style list in other table) but
if not the
stock, user can fill what style they want. <<< this I can’t do because I don’t know which formula to fill in it if I want user to fill their input.
I have a table called “size & qty” and it’s “ref” type
it has size column and qty column with the ref id which is part of “order” table
And then I create the “order received” table and I don’t want to retype all of the size & qty in the new ref of “order received” table. I want to use an action to add all of the “size & qty” to the new ref table and then edit it if there is missing qty case.
Thank you in advance