Update Mother Table if new row in Child Table is updated

[finkployd]

Hi,

I have two tables

1. Work Orders - list of all WOs available

2. 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.

[SkrOYC]

Please share some screenshots because it seems things should work normally

[Suvrutt_Gurjar · Accepted solution]

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.

[finkployd]

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.

[Suvrutt_Gurjar]

---

@finkployd wrote:

new Work Orders, if the user adds a new WO no. in Table 2

---

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.

---

@finkployd wrote:

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?

---

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"

INPUT() - AppSheet Help

---

@finkployd wrote:

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.

---

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.

Slice based on user input