How to create an option of user consent to make record public/private?
So that once the selects private no other user can see the record, and if the current user selects public, then everyone can see.
Solved! Go to Solution.
I would do the following:
Perhaps more AppSheet-experienced fellows here can give us a better/simpler way.
Update:
There is also the Table’s Security filter, that you could fill with the same formula above, instead of creating the slice.
You can show us some screenshots, of the app editor and the table source.
Alternatively, you can also share a link to your own App editor. HOWEVER, I’m not experienced enough in AppSheet to assess the security impact of this action, never used it and haven’t read about it.
If you mean upload various fotos at once, then I don’t know a direct way to do it.
If you mean that you need a column to several photos that you can scroll and click, one way to do it is the following :
In this way, you’ll be able to have several photos in your Site view.
One way to do it, is to have a column of type: Show, with a custom message like: “No records available”, and make it visible only (Show_if) when there are no records.
I would do the following:
Perhaps more AppSheet-experienced fellows here can give us a better/simpler way.
Update:
There is also the Table’s Security filter, that you could fill with the same formula above, instead of creating the slice.
Hi KJ Seddik,
Thanks for the response.
I have done the 1st step as you mentioned, however have a question on 2nd bullet point. I already have a column in the sheet that’s ‘Submitted By’ where email id is captured. I guess this is the place. Could you please assist, if you mean the ‘initial value’ field against the column.
I am quite new into this.
Regards
Yes, this is the place.
In step 2, I meant the “App formula” field.
Thanks for the reply again.
I will try that. Could you assist with below, its the entire scenario.
Hope this makes sense. Looking forward to your response.
Regards
I assume “sites” stands for records. But what do you mean by “tab”, a separate view?
Yes Sites are the records.
Is there any way I can show you what I am creating?
Regards
I’m sorry I don’t understand your question. Please elaborate, show what, where?
Sorry, I mean to say - How can I show you the app that I am currently working on.
You can show us some screenshots, of the app editor and the table source.
Alternatively, you can also share a link to your own App editor. HOWEVER, I’m not experienced enough in AppSheet to assess the security impact of this action, never used it and haven’t read about it.
Here it is.
Please share your email id so that I can add you as the user.
In any case, I’ll give you a general answer, hoping it helps.
When you create the slice of my first reply, you go to UX and link it to a new View. The user will see all the records he created as well as all the other records marked as public.
While in UX, click on Options tab at the top menu then enable “Preview New Features”. When you do that, users will be able to filter the view based on any column. A user can filter using the “consent” column, choosing “Public” in this case he will see the public records of all other users, or “Private” which will show him records created only by the active user.
Otherwise, you can create two separate slices, and link each one to a separate view:
Hi again,
I could make the user particular sites appear for the selected user. However not sure where it went wrong in creating sites from all users. I wanted to show you if I have done it correctly.
To benefit other users who could have similar questions in the future and to maximize the benefit of this public forum, let’s start with some screenshots please. Thanks.
Sure, sounds wonderful. Here are the screenshots. And yes, your advise really helped me create slices. However not sure if its visible on the maps view in UX.
Also,
Regards
You have to create a new view, and choose the corresponding slice in the “For this data” field.
Go to Behaviour and look for the Add action and make it visible as Overlay. It should then be visible regardless of the view type. I’ve just tested it.
For each column of your table, there’s a checkbox called “Searchable”. You choose which columns should be used in the search criteria.
You can represent and use any column included in your table.
Hi KJS,
Your reply was helpful. I could do the slicing. Could you please assist on below.
When there are no Active user records, I want to show text ‘No records available’.
Regards
With Appsheet can we also use site status? e.g. Submitted, Pending Approval, Approved
Hi,
Thanks for the reply.
May I ask how can we create an option to add/upload multiple photos in, currently its only allowing me to add one photo.
Regards
If you mean upload various fotos at once, then I don’t know a direct way to do it.
If you mean that you need a column to several photos that you can scroll and click, one way to do it is the following :
In this way, you’ll be able to have several photos in your Site view.
One way to do it, is to have a column of type: Show, with a custom message like: “No records available”, and make it visible only (Show_if) when there are no records.
Thank you so much for taking time and posting the reply. Your reply helped a lot.
I have posted another question on subscription and slicing without username. Your help would be appreciated.
Have a great day.
Regards
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |