Edit form

I am looking for how to authorize the edition of a member file by an administrator and to prohibit it to the member of a club (approximately 6000 members)
The administrator must be able to modify the details of a member, but the member can only view his file, without being able to modify it.
The problem is that the member’s file is always the same, viewed by the administrator and by the member, because the displayed row concerns the member.
EDIT Form rules only apply to the member’s form and the row being edited.
I have already been offered to duplicate the application with the same sheets.
The first ADMIN can modify
The second Member can not only visualize.
It sounds like the easiest solution, but it doubles the license price.
Please, do you have any idea?
ps: I hope I was clear.

Hi @Leonfort2 :wave:

So the Admin can change the details of the user but the user can’t change the details right?

If it is you can add a condition like creating a text column in the Users Table like Level and add Admin to the Admin’s details row and you can add the condition User Profile Level is Admin.

Thank you

Just add a condition to the Edit option to only allow editing by users with the correct role. Or if you’re not using roles, then you could restrict it to a specific user (or users).

1 Like


1 Like

Ok I’ll try to detail my case
A Admin file (sheet) with fields Admin, Rel-Admin-Club
(There are several Admin, one for each Club)
A Member File (sheet) with Name, Club, etc.

The admin-1 list by Rel-Admin-Club the all members of the Club, then he selects a member and the detail of this member is displayed. He can modify the record

If I code “Allow users to edit”, all people can edit, then what is it the condition to bloc users, but not the admin-1 ?
if you’re not using roles, then you could restrict it to a specific user (or users).
I dont use Roles, how I can restrict it to specific user. I dont understand, the admin can modify all users.

Roles are the same as Row Owners as far as securing data by applying row owners to email columns or role columns. In that sense, Roles are only available in Private Pro apps. But in your case, you wouldn’t use roles for securing data. Instead you are just using it to control who can edit. If you have user profiles enabled then you can have a column that contains a role type column. You can set up your edit condition to look at that user profile role type. If you do not have user profiles enabled, then you can create a template column in the members sheet that gets the current signed in user’s email, then create a relation to the admin sheet using that email. Then you can add a condition to only allow edit if the member email is the signed in user, or the relation is empty.

1 Like

Thank for your help.
My app is public without mail
Why? Because the members find it too restrictive to “log in with e-mail” for each consultation.
They want something quick and easy.
Currently the application opens with an input "code of connection, (each member has a code) to directly display the member’s information. And that’s all.
I tried with the e-mail technique, but there was a general refusal.
And I don’t use profiles.
I have an idea, but I don’t know how to make it happen
When admin1 logs in, it is identified as ADMIN in the “Admin file”
I would therefore like to put in the member file, on the first line, on connection (not via e-mail, just a code entered on the screen, a Flag-Admin1-Edit = true.
When Admin1 explores the member file and chooses to see the detail of a member to modify it,
in “ADD condition” I would like to be able to consult the first line of the file the Flag-Admin-Edit and if it is = True, then the Edit function is displayed.
If it is the member who consults his file, the flag = false and therefore not Edit.
In classic programming this is easy to do, but in Glide?

I would think that you could pull that code into the members sheet using a single value column, or use a template column to populate a generic key value on all member row, followed by a single relation and lookup to bring in that code onto all member rows. Then you can use that code for a single relation and lookup to the admin sheet get the admin flag. Then you should be able to set up your edit condition based on that flag.

1 Like

Thanks Jeff
How to set flag to false after update of one member ?
Ex The admin exit from App without return to his row.
If set to clear the field lokoop, he must restart from connexion to update another member.
What do you think about ?

And when the admin exit, the flag stay set to true.

As long as your users are not signing into the app, you can use user specific columns to hold values, and that user specific column will reset once the app is closed.

I’ll try this way and I tell you soon
Thanks Jeff

1 Like

I am sorry Jeff
I thought I understood, but in fact no.
Can you detail the handling?
there you are
admin file : name-admin, club, rel-name-member-club, (flag-edit ? )
member file : name-member, club, …,
Thanks a lot

I think I’ll need to see some screenshots or a video to better understand your app flow and how the data is set up. I’m having trouble visualizing how your app currently works and what you are trying to accomplish.

I prepare this and i’ll send you tomorrow.

1 Like

Is it possible to send file ?

2 files at all

  • file admin
  • file member

thanks for your help

Let me write this out to make sure I understand.

If you click on the associations button, then you show a list of associations. I assume this list uses the admin table. On the details for each association, there is an entry component to enter their admin code to get access to the member list as well as enable the ability to edit their admin profile. All of this is working correctly? If so, what kind of conditions do you already have to enable editing of the admin record and to show members list button?

I wasn’t quite clear after re-reading the thread. Should members be able to edit their own profile, or are admins the only ones allowed to edit the profile of only the members in their association?

Can you also explain in more detail how the code works? Does it just check an existing code in the admin table to see if it matches?

Are admins also listed in the members table or am I misunderstanding? You mention that you only have two tables, admin and member, but you also mention clubs. Is the admin table actually the club table?

I have some ideas for what you want, but I want to be completely sure that I understand how your app works and how everything is set up.

1 Like

In fact I need one file where “administrators” are included too, with an “admin code” field. The list of associations is filtered on this field. To obtain a list of members, there IS a relation on the admin field row with a club name so I get an “inline list” out of this field.
I have added an Admin file to resolve the edit problem with flag-edit. But I dont know how to use this.
Only the admin can edit a member. A member cannot do so.
The problem with glide IS that the member card has the same access rules.
So, if I authorise admin to edit a member card, the same code IS attached to member access.

Let me think about this for a bit. I’m still trying to get a clear picture in my head how you have everything set up…especially if you are adding new tables. In general, the code that is entered by the admin should be writing to a user specific column…whichever table that happens to be. If it’s the correct code, then it should be setting a flag somewhere to indicate that the user is an admin. You should then be able to use a relation/lookup, or a single value column to bring that flag into the members table. Then you can set you edit condition based on the admin flag that was brought into the members table. It should be a really simple setup, but since I don’t yet have a clear understanding of your app, I can’t give specific instructions on what needs to be set up and where.

The reason that a user specific column needs to be used for the code is so an admin can enter the code on their own device, but it won’t be visible to any members using the same app on their own devices. Also, when the app is closed, it will clear out the code as long as the user is not truly signed into the app. The user specific column will allow multiple users to use the app, but each user will have a different experience based on the code that was entered or not entered on each individual device.

1 Like