Jump to content
  • 0
CMorris

Preventing a table from being updated based on logic criteria

Question

I am developing an app that will be account based.  Each parent account will be able to have a set number of active users.  Each active user will be able to login under the parent account and work with the app.  The parent account admin can currently activate or deactivate a user.  Currently the admin can view a report datapage of all users and choose which ones are active.  I would like to have a way to count the number of users that are currently activated whenever a record changes and check that against what is allowed for their account.  If they have too many activated, I want to send an error message or prevent them from saving/updating the user record.  I assume I will need to do this through a triggered action whenever my user accounts table is updated, but I'm not sure how to do so.  Is this even possible?

Share this post


Link to post
Share on other sites

3 answers to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...