Is there a way to create a button on a form to return (and display) the highest value of a text field (not a key field) from the same table? I would assume a URL of some sort... Thanks so very much!------------------------------Cindy Johnson------------------------------

Do you mean that you gave a table with text field type and you want to return "Aardvark" (or maybe Zebra (not sure what your definition is of highest). Is that what you mean?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Yes, you have the correct understanding.... The text field created is an identifier that is given to records with the same association. So, the field has many 'identifiers' ex: 20132 that is sporadically located in the column in no specific order...Just want to return the maximum (highest) text(number) that has been entered for that field... with a click of a button...Thanks!------------------------------Cindy Johnson------------------------------

.. and just to be clear, the field might have text values or might have numeric values or a mix?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

All are text values------------------------------Cindy Johnson------------------------------

sorry, but to be clear, this was not an example of the data in the field 20132Mark------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Adding a button for a specific action

MarkShnier__You
Qrew Legend
4 years ago
Do you mean that you gave a table with text field type and you want to return "Aardvark" (or maybe Zebra (not sure what your definition is of highest). Is that what you mean?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- CindyJohnson
  Qrew Trainee
  4 years ago
  Yes, you have the correct understanding.... The text field created is an identifier that is given to records with the same association. So, the field has many 'identifiers' ex: 20132 that is sporadically located in the column in no specific order...
  Just want to return the maximum (highest) text(number) that has been entered for that field... with a click of a button...
  Thanks!
  
  ------------------------------
  Cindy Johnson
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    4 years ago
    .. and just to be clear, the field might have text values or might have numeric values or a mix?
    
    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------

Forum Discussion

Adding a button for a specific action

Related Content

Jinja Question: Adding business days to today

API Button Help

Formula Url Buttons

Specific permissions needed to run a copy master and detail button?

Previous and Next Record Buttons