Custom Rule to ADD a record?
Ive seen some creative ideas in posts on how to regulate which users can delete records. However, haven't seen much in the way of selecting users who can add a record.
I want to avoid using user r...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIf you have a table of users where the key field is the user, or even the users email address, then you can use that table as a user focus table.
Since the field is the user ID, you can relate that table to any other table through a reference field with the formula of the current user.
Then you can look up whether the current user is allowed to add records.
Then you would remove the ad button from most roles, except may be admin and make your own Add Record button. Of course, you'll have to figure out where to put this button. The button could be on existing records, or on some kind of parent record, or some kind of master record where there's a dashboard on the homepage to take you to the special admin record, which would have the various restricted add buttons on them.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Thats a good idea. Didn't think of the custom add button. I wish I could make a button like that on the new dashboards, but I suspect I would need to sneakily have a report showing with one record and the add button.
My other idea is very similar to yours, but I actually let the user add, however use a dynamic form rule to hide all the sections, and unhide one that just says 'You do not have permissions to add this record, push cancel to abort.'
Or something like that, havent worked out all the details. Perhaps it also checks a box that causes the record to delete itself once saved.
------------------------------
Mike Tamoush
------------------------------
