Solved: Two tables with the same column - Page 2

Gregorrrry · 12-13-2022 01:46 AM

I have two tables, both tables have a 'Date of next examination' column.

I would like the 'Date of next examination' from one table to automatically update the other table.

Table to be pulled from is called 'Inspection Record'.

Steve

Add a virtual column to the Assets table with an App formula expression similar to this:

MIN([Related inspections][Date of next examination])

Replace Related inspections with the name of the Related ... column in the Assets table that contains the list of related inspection rows for each asset.

View solution in original post

SkrOYC

@Gregorrrry wrote:

When someone then looks at the asset table, we would like the 'Date of next examination' within the form to be updated automatically when the inspection record is completed.

Use actions.
You need an action that fires in form save and the action should be of type "Execute an action on a set of rows".
The rows should be referenced by using an expression like this:

LIST(
  [Chained].[Dereference].[To].[Id]
)

You create another action on the table that has the data you want to update with the expression you want, and you select this one in the previous one

View solution in original post