SECURITY Filter out all existing rows?

[11166]

Filter out all existing rows? Used only in forms apps that collect new data rows but never show any pre-existing rows.

Ask the teacher
How to use this switch function?
Is there a sample explanation?
My test doesn’t seem to affect or respond?
Thank you

[Marc_Dillon]

You use this option in cases where that table is only for entering in new data, and you do not want any users to be able to see existing data.

[11166]

Is there any difference in setting permissions here?
Thank you!

[Marc_Dillon]

Yes. Those are permissions for Adding, Updating, and Deleting records. Those permissions do not affect whether or not certain records in a table will be loaded into the app. A very different thing.

In contrast, you could easily re-create the option you referred to in your initial post by setting a Security Filter expression, because those two things are very similar.

[11166]

As the teacher said …
“and you do not want any users to be able to see existing data.”
Can’t even see this material when creating it?
Is there any specific timing?
Thank you

[Steve]

11166:

Can’t even see this material when creating it?

Yes, the users will be able to see the data they enter while entering it in the form. After the form is saved, the user will no longer be able to see the data. You (the app creator) will have access to the saved data, and can use it in other ways, such as in another app.

[James_McFarlane]

HI @Steve ,

I have an app with a customer table and a questioner table, both have this option set to TRUE.

After filling customer customer form the app takes user to questioner form automatically. I noticed that while filling questioner form the customer name changed to customer_id. Can this be avoided and how for I still need to reference customer table while filling questioner form?

[Koichi_Tsuji]

Are you setting customer name as label on the cutomer table?

[James_McFarlane]

Hi @tsuji_koichi

Yes I am.

[11166]

Thank you, teacher

[OptimiX_XcrY]

I am interested in how can i use this feature for collecting data , in a simple app with a parent and children table…

[Lynn]

Hi @OptimiX_XcrY
Did you try it?

[OptimiX_XcrY]

Hi. No. I am still thinking that children will “dissapear” one after the other, when I record them, before I have a chance to see parent and all that parent children at once

[OptimiX_XcrY]

I made an app, I see all children before saving parent row.

I have issues with workflow reports, they end up empty in email

[Lynn]

Hi @OptimiX_XcrY
Did you try this?

[OptimiX_XcrY]

I did

[OptimiX_XcrY]

Parent row appear in workflow. Children are missing

[Lynn]

@OptimiX_XcrY
I believe @Aleksi replied to you in another thread.

[OptimiX_XcrY]

Yes, thank. I’ll continue in that thread