compare the information of a field
Hello, I need to make a comparison of a numeric field. The field is editable, the new value cannot be less than the one that is already saved.
I'm new to this, I think it's basic, but I can't think h...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI would suggest setting up a new table with a single record in it. Call the table Last Number used. The single record will be [Record ID#]=1.
Make a relationship to all of your data entry records with a formula field called Link to last Record with a formula numeric formula of 1. Then make a summary of the Maximum of the number field.
You can then put that field on the form so the user knows what the next number is. Even better, you can then make a formula field called Next Number with a formula of Last Number plus 1 and use a for rule to populate th Number when that field is blank.
I suggest marking that Number field as being Unique so you do not get duplicate numbers in case two users enter a record at the same time.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Make a relationship to all of your data entry records with a formula field called Link to last Record with a formula numeric formula of 1. Then make a summary of the Maximum of the number field.
You can then put that field on the form so the user knows what the next number is. Even better, you can then make a formula field called Next Number with a formula of Last Number plus 1 and use a for rule to populate th Number when that field is blank.
I suggest marking that Number field as being Unique so you do not get duplicate numbers in case two users enter a record at the same time.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------