Jump to content
Sign in to follow this  
WF7A

Calc needed to limit record creation

Recommended Posts

This one's a little tricky and I'm sure there's an elegant, simple solution that I'm overlooking.

I want to limit the number of records a user can create in a runtime demo file to say, five records. I also want to leave the Status Area available since it'd save time/coding for such a simple project.

So far, I have a Summary field ("record_count") that will count the number of records in the Master table. What I figure is that a calculation can be created using that field: if its count exceeds five records then the user is flashed a Custom Dialog message saying that he or she has reached the five-record limit and cannot create any more records.

...and therein lies the problem: With the Status Area available, all a user has to do is click the New Record button and a new record is created. So, is there a way to prevent the user from creating that sixth record or am I really stuck with hiding the Status Area and scripting a button?

TIA for your help,

Rich

Share this post


Link to post
Share on other sites

Of course I never thought of that; I'll have to check that out. Thanks!

Share this post


Link to post
Share on other sites

Rats! In Custom Records Privileges you can insert a formula for editing records using "Custom...", but not creating them (per table): you can only choose Yes or No.

Yet another suggestion for the FileMaker Wish List. :S

*heavy sigh* Well, I guess it's Button City time.

Share this post


Link to post
Share on other sites

If you use custom menu sets, then the New Record script tied to the New Record command and button in the status area will use your New Record script which is limiting to a record count.

I would point out that the more records they create, the more they want to purchase the full version. How about another limit? Export, print?

Share this post


Link to post
Share on other sites

If you're trying to really lock down a solution, Access Privileges is the way to go. Why not simply use the formula in the Edit box? What good is a New Record if you can't edit it?

Share this post


Link to post
Share on other sites

Try searching in the Advanced and Developer Features subforum for "demo" using any date. Lots of threads debating approaches.

Share this post


Link to post
Share on other sites

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
Reply to this topic...

×   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.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.