if a table have order numbers, status, delivery address and other information about product shopping
if we have 4 product booked by the user, it will automatically split the order with same order number with all the 4 products. We have a column called Status are usually have values called Ready to Drop, picked, packed, handovered. if we take the case here, 10016 has 4 rows, 10016-1 and 10016-2 (1,2 numbers are given for understanding purpose) is in status Packed, 10016-3 and 10016-4 are in picked condition. now in this sort we need to send the order 4 times with 4 sort of packing
my aim is to store and make all the data in picked condition (not to move to next step), once all the 4 products come to picked condition then the user can make a move to packed condition (this helps in making it in one single courier). Is it possible to change it for one step that upholods the changes to all the row-specific values. if so how? please help me out in this case
10016 Picked (should not move to next step) (button for packed to be disabled)
10016 Picked
10016 Picked
10016 Picked
here all the products become picked then we need to list the details in one single row with all the 4 products, if we change one as packed then all the 4 products status to be packed
So do you mean all 4 rows should be in the same status before a row can be moved to the next status?
If you’re on Business/Enterprise, you can leverage the Call API action to do this. Else, you would need to work with a webhook and a third party solution like Make.com to iterate and update all the rows, as long as that column is a basic column (not user-specific, not computed).
all the changes can be change till picked,
forchange in status to pack, all the orders with same number should come to picked then only they can change to packed.
change2: if i change it to packed. all the status of the same order no. should become packed
Then I think you would have to deploy two buttons, one on each item to move the status around until picked.
Another button to mass update everything to Packed, and only shows with the condition that all relevant status are “Picked”.
I don’t know if you have an “Order” table and an “Order Item” table, but you can add an If-Then-Else column in the table you’re showing. If Status is “Picked” then true, else false.
Create a query pointing to all relevant rows, and a rollup that uses the option “All true”. If the rollup is checked, then you show the button to change everything to “Packed”.
At that point, you can explore this to mass update the rows.
