Security filter does not filter second table data

[Michel_van_Ruij]

IN([Company], SELECT(company[company], [name] = USEREMAIL()))

This fomula is in the security filter for a data table with company as a column, it works fine and does filter correct on Primary view and also for Form view for this table.

This app has a second data table with company as a column and also this formula in the security filter for this table.
This filter works fine for the Primary view but not for the Form view of this table.

I don’t understand why the second table is not filtered for the data in the Form view.
Should a security filter not filter data of the table and have affect on all views for that table ?

[Steve]

Michel_van_Ruijven:

Should a security filter not filter data of the table and have affect on all views for that table ?

A security filter affects all uses of the table.

Michel_van_Ruijven:

This filter works fine for the Primary view but not for the Form view of this table.

Please elaborate. You’ve given us nothing to work with.

[Michel_van_Ruij]

Explanation:
In a form for table named “24h avg” there is a column named company, which is ref to a table in an other spreadsheet, this table name is “company” and has a column named company.
The column in the Form for table “24h avg” should only show data wich is designated for the useremail.

These are the columns in the table named “company”. Column name contain useremail :

key company location block name crop nr local staff
|1| ES Yigit| Ashgabat | c| michelvanruijven@gmail.com |1| Josh|
|2| Delflandasia| Boka 1| 1| him@gmail.com | 1| Jenny|
|3| Delflandasia| Boka 1| 1| her@gmail.com | 1| Joe|

The form for “234h avg” table has to evaluate it’s column company against the column name in table 3 : Only companies wich are on the same row as the name (=useremail) in table “company” can be shown in the dropdown.

I tried this as security filter for table company:
IN([Company], SELECT(company[company], [name] = USEREMAIL() ))
Result: nothing is shown in form field colomn

I tried this as valid if in 24h avg[company]
FILTER(“company”, ( [name] =useremail() ))
Result : all fields are shown in form field column.

Both do not give me what I need.
I cant find a better solution.

[Steve]

I’m still confused.

Are you trying to use both a security filter and a Valid If expression? If so, why?

[Michel_van_Ruij]

Hi Steve,

No not both, I tried one by one.
But I am looking for a security filter because that will only load the rows that equal the filter condition.

Michel.

Outlook voor Android downloaden

[Steve]

Which table do you want to use the security filter for?

Does the security filer for that table correctly filter the rows of that table?

[Michel_van_Ruij]

I type the filter condition in the security filter of the table I want to be filtered.

its this formula:
IN([Company], SELECT(company[company], [name] = USEREMAIL()))

The to be filtered table has a “company” column.
The company table also has a “company” and the email column, to be compared with the useremail.

This works all well in my Crop Track app, which has all tables in Excel.

But not in a comparable app, the difference is, the app where the security filter works well and shows only the useremail rows thus is filtered well, has the “company” table in the same spreadsheet as the to be security filtered table, in Excel.

The Scouting app, where the same security filter filters out ALL data, lets nothing through.
This Scouting app has the same “company” table as the Crop Track app ( from the crop track Excel file ) but has the to be filtered table in Google sheets.

[Steve]

That the tables are in Excel or Google Sheets is entirely irrelevant.

Please post screenshots of the Company table configuration for each of the two apps, showing at least the Storage and Security sections for each table configuration.

[Michel_van_Ruij]

This is the “company” configuration for the cropTrack app:

This is çompany table configuration for Scouting app:

[Steve]

I see nothing odd about the table configurations. I note, though, that both tables refer to the same spreadsheet, though you’d previously said one was in Excel and one was a Google Sheet. So either I’ve misunderstood your problem, or you’ve miscommunicated it. I also see that you have no configured security filter for either, so the configurations you shared are not the configurations that don’t work as desired.