Forum Discussion

GonzaloLesperg1's avatar
GonzaloLesperg1
Qrew Member
5 years ago

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 how to do it.

for example, the saved value field1 = 10 when updating field1 = 9, when doing this action does not allow it to be saved.

Thank you in advance for your help.


------------------------------
Gonzalo Lesperguer
------------------------------
Tables and fields
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    I 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
    ------------------------------