Nested form referenced from a slice

[alhazen]

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

 

Unable to fetch data with this nested form

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.

[AleksiAlkio]

When doing this, don't touch the original virtual REF_ROWS column. Instead of create a new one. The original is quite sensitive and it should not be used for a slice.