One database record per user (Pages)

[jair101]

I want to do a Pages database, but where each user has permissions to add only one record. Is this achieavable?

Basically my idea is to have something similar to the custom profile fields, but to use more  advanced visualization I want the flexibility of pages database. But I have no idea how to limit the amount of records each user has to 1...

[opentype]

8 minutes ago, jair101 said:

But I have no idea how to limit the amount of records each user has to 1...

You can’t. 

You can however create a member field and set it to be a “unique field”. That way, every member name could only be used once. Maybe that’s a way to build what you want, even though that’s not the solution you asked for. 

[jair101]

Thanks, thats a shame.

I guess there is way to hide the add record button based on conditional whether a record by this user exists, but it seems like an awful workaround and I can imagine issues with it too. Oh well, I guess I will source the data from the custom profile fields with a raw query and then try to visualize it in pages block.  

[TAMAN]

You could use user groups 

once a user adds a record move him to a another group that dont have access to add records  

[jair101]

7 hours ago, TAMAN said:

You could use user groups 

once a user adds a record move him to a another group that dont have access to add records  

Great idea, definitely creative  

Now that I think about it, it might actually work.