Solved: Action in a table for another table? - Page 2

Joe_Seiler · 12-14-2022 10:19 AM

I'm having trouble understanding how to properly set this up. Can anyone help out? Particularly with ref's, and actions across tables

Table 1: Jobs

Table 2: Time

What I need to do is have an action in Table 1 that executes an action tied to Table 2, as well as carry some fields over from Table 1 to Table 2

So, the Jobs Tables has jobs listed. I need a "Clock In" action in the Jobs record that will execute the Action "Clock In - Time" in the Time table.

i also need to have various columns from the Jobs table duplicate over to the Time table

The Time table will be an ongoing list of all clocked time entries from all Jobs records

Anyone know where I need to start? I believe first I need to get the ref's figured out first, and then the double action.

Thanks in advace!

Markus_Malessa

I would possibly suggest going a slightly different route using MAXROW() like this:

LIST(MAXROW("Time", "On Site Date Time", AND([Entered By Email] = USEREMAIL(), ISBLANK([Off Site Date Time]), [Fushion Job #] = [_THISROW]))

//OR//

SELECT(Time[Record #], AND([Entered By Email] = USEREMAIL(), ISBLANK([Off Site Date Time]), [Fushion Job #] = [_THISROW]))

The first formula will only grab a single row matching the largest 'Clock in Time' where the clocked in user is the current user and the clock out time is blank and the Job # is the currently selected job. The LIST() function is necessary here to convert a single record to a list since your action is running on a list of rows.

The second formula would grab all rows where the clocked in user is the current user and the clock out time is blank and the Job # is the currently selected job.

I would also make sure that you set limitations on the behavior for when the action is available.

ISNOTBLANK(MAXROW("Time", "On Site Date Time", AND([Entered By Email] = USEREMAIL(), ISBLANK([Off Site Date Time]), [Fushion Job #] = [_THISROW]))

//OR//

ISNOTBLANK(SELECT(Time[Record #], AND([Entered By Email] = USEREMAIL(), ISBLANK([Off Site Date Time]), [Fushion Job #] = [_THISROW])))

View solution in original post