I am designing a portal for my employees to submit orders to a database. After submitting you can view the orders in a table. I have a dynamic page that links each order to the table and displays it full page with any images or notes that may have been added by them.
I would like my management team to be able to view these orders on the dynamic page and select a checkbox or drop down to “Complete” the order. I want the complete to show up as a “boolean” check mark or the word “complete” on the table. I’m stuck right now because no matter what submitted order I choose from the table its only changing the boolean or text field of the most recent submission. In an ideal world I would love to have the completed Date & Time as well, but right now I am more concerned on getting the complete function to work
Any help?
Hi,
i don’t know if it is exactly what you need but it seems simular.
https://www.wix.com/corvid/forum/main/comment/5eb3c9bf0ef3270017786f85
i added a whole example with images to connect dropdown to table.
it works simular as yours only you will need a read & write dataset.
kristof.
I don’t want to really filter any data… Let me see if I can explain better:
This is a portal for food & beverage orders to supply a restaurant to be more specific
I have one page that allows users to upload an order with multiple text boxes ( Order, Quantity, Notes, Order Date)
Once those are uploaded it goes to my “Order Review” page that has a list with all the orders in a table. There is a column for all mentioned above, as well as a “Completed” column.
I have the order column linked to a dynamic page that will bring up that specific order on a new page for “review”.
Once reviewed I want to have a checkbox/drop down that would signify that the order has been placed/completed. Once that action has been done I want the table on my “Order Review” page to update the column of that specific order to say “Completed” or have a check mark.
My problem:
If one order is submitted and reviewed at a time it seems to work and update just fine. However I have many different orders being placed daily by multiple people, so that would never be the case.
Right now if I upload 5 orders and click the one on the bottom of the table, select complete, it only updates the one on the top of my table. They are not working individually.
Ive uploaded some images to hopefully give a better idea. You will see only one record is selected as complete
