Single value from multiple tables

Ask for Help
1

Hi,
I have an app where the user inserts about 10 types of forms to different tables.
I want to show the last time that the user inserted a form of any type.

In SQL What I need is :
SELECT
MAX(dateTime)
FROM
(SELECT MAX(dateTime) FROM Table 1
UNION
SELECT MAX(dateTime) FROM Table 2
UNION
SELECT MAX(dateTime) FROM Table 3
… etc
)

I am looking for a solution without using an action to update the current date and time in the user data on each form insert.
Is there any way to get a single value from multiple tables?

2

just update the time in the user sheet… everytime they submit the form, use after submit action

3

…

4

then you need to get the max time using rollup column and IF_ELSE column to get the user email or row ID

5

Just curious, why don’t you want to use an action to update a field in the user profiles table?

6

Its an app for collecting data on Autism for behavior analysis professionals.
The users are mainly the parents of the autistic kids, teachers and professionals that view and analyze the data to build a long term program.
so the data is saved under a different entity: the kid, not the user that fills the form…
Just more work, and I was also curious if anyone thought of it because I couldn’t find a solution without 10 extra rows.

7

I do not get, 10 extra rows??? each record is 1 row… now, to get the user record… is one column… to get the max value… is one more column… so, just 2 columns…
it looks like your data is spread across multiple sheets/tables… if these are Google Sheets… then you need to join all sheets into one… if is Glide tables, do rollup max on each table with the user id assign to the value… then the rollup again max value from that… not an easy way… but the only one

8

This has been an issue a time ago. I guess we need a “easy” way to do it

9

You should be able to build the relation to the related kid, though? From that relation, you can use set the column method, I suppose.