adding records in different sheets

[Cannone_Cannone]

Good morning everyone,
I wonder if it is possible to do this.
I have a checklist that collects all the checks done by the various stations, I would like to know if it is possible to divide the records into different sheets when they are inserted.
the application is unique for everyone and access is done with the useremail formula. Everyone only sees the data of their own station but when they make the checklist of the machines they end up in a single sheet. I tried with the insert records on different function I use email sheets but I can't
do you have any suggestions?

Thank you

[TeeSee1]

Different sheets mean different tables and unfortunately you cannot dynamically select a table in an action.

The only way I see how you can do it is to use a bot with a bunch of branch conditions to run an appropriate data action based on USER EMAIL().

Maybe others can suggest better ideas, which I would also be interested in knowing.

[Cannone_Cannone]

Thanks for the suggestion, I await further responses

[calebch42]

Sheets as in, Google Sheets is where the data is being stored? If so, what I would do is create another Spreadsheet or add a worksheet to where the responses are being stored and use the IMPORTRANGE and FILTER functions to view each person's own responses.

You could do the same thing in the AppSheet editor if you wanted to hire the responses by person or track metrics by person. In the Data Tab you can take the main view of the responses table and break it into smaller views for each person. 

If those don't solve what you need there are Hot-Linking to move the records to another table or copy the records to another table. But I am not versed in this solution. 

[Cannone_Cannone]

Hi, thank you, I also thought about using import range, but unfortunately I'm using an online excel sheet. With Appsheet I know how to add recons rd in other tables, but as I wrote I don't know how to insert data with access in security filter with e-mail.

[AleksiAlkio]

If the goal is to have each stations with their own checklist table and they have all unique apps, why don't they all have their own sheets in a first place?

[Cannone_Cannone]

Hi, the idea was to have only one App so that if I have to make changes I only make them on one, for now they can see their data with user-friendly security filter access.

[AleksiAlkio · Accepted solution]

One solution is to use Partition feature, though it needs Enterprise subscription. What do you have?

[Cannone_Cannone]

Hi, I don't have a subscription for now