Hi,
I have two tables
Work Orders - list of all WOs available
Operations - Whereby, Work Orders is selected from Table 1
However, sometimes, our operations will have new Work Orders, if the user adds a new WO no. in Table 2, can this be updated into Table 1?
Thank you.
Please share some screenshots because it seems things should work normally
If the Work Orders table is referenced by the Operations table, then the user can add a new works order record through the add option as shown in the screenshot below. This is possible if you do not have any valid_if in the reference column in the Operations table that references Work Orders table.
In the below example, Customers table is referenced in the Orders table, so user can add a new customer while creating a new order.
Hi! Thank you.
Say if they want to update more than just the WO? Say the description of the WOs. Can it be done in Table 2 as well?
Another question, say WOs are a lot, hundres of them. But they are sorted by region. So, how can I make a dropdown menu, that filters the region first, then the user can select the WOs from the selected region.
Thank you.
Your earlier post mentioned about adding new work orders. So the suggestion was with respect to adding new works order. And while adding new work order, it anyway creates an entire form so you can add description and whatever fields in the work order record.
You may want to elaborate on this. Do you want to update just the description of multiple work orders at a time? If so, in general , you could use INPUT() function in an action type of " update the values some columns in this row"
The easiest option will be to use “Group by” option in summary views. So if you have hundreds of WOs, possibly you could first group by say years and quarters meaning 2022 Q1(Jan-Mar), 2022Q2(April- Jun) and so on) and then by region in the summary view. Quarter is just a suggestion. You may want to use any other column to group by that best suits your app.
Control grouping - AppSheet Help
Yet another option is user can make use of filter option in search bar to select the region they want.
There are many other filtering options as well such as below. The best one will depend on your app configuration.
