Hello Community,
I require your help regarding my issue.
I’m dealing with two tables: ‘event’ and ‘job_log.’
The ‘job_log’ table is a child table of the ‘event’ table.
I’m utilizing this formula in one of the slice tables named ‘_job_log.’ This slice is derived from the primary ‘job_log’ table:
AND(
OR(
IN(
[event].[driver].[email],
SELECT(
employee[email],
[email]=USEREMAIL()
)
),
IN(
USEREMAIL(),
SELECT(
employee[email],
AND(
[role]="Super Admin",
[email]=USEREMAIL()
)
)
)
),
[date]=TODAY()
)
I have also set up the ‘ref_rows’ as shown in the picture below
It functions correctly in the emulator, but when I attempt to use the nested form from the event form via the browser, it doesn’t function at all. What I mean is that I’m unable to input any data for the ‘job_log’ table
I’m aware that I can switch the referenced table to ‘job_log’ since the ‘job_log’ table doesn’t have any security filters. However, I’m curious if using the slice as a referenced table for a nested form is causing a bug. Is there any way to continue using that slice for the reference?
Thank you so much for your help.