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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

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