Forum Discussion

JakeRattner1's avatar
JakeRattner1
Qrew Cadet
4 years ago

Formula Queries - Finding Min/Max of Value Using Foreign Key in Other Table

Hi QB Community, I'm excited about the new Formula Query and am trying to use it to find the minimum and max fields in a seperate table.   I start with this: GetFieldValues(GetRecords("{249.EX....
formula queries
JakeRattner1's avatar
JakeRattner1
Qrew Cadet
4 years ago
Hi Mark, 

Thanks for replying so fast.  Agreed.  A ready-made function doesn't exist and hopfully it will be soon. I'm hoping there will be a ton of new functions once Quickbase is ready.

In the meantime, I'm wondering if there is a creative solution for getting the min/max out of a text list.  For example, I can use get the min/max from the text list by using the following formula:

Max(
ToNumber(Part([Text],1,";")),
ToNumber(Part([Text],2,";")),
ToNumber(Part([Text],3,";")),
ToNumber(Part([Text],4,";")),
ToNumber(Part([Text],5,";")),
ToNumber(Part([Text],6,";")),
ToNumber(Part([Text],7,";"))
)

But the above seems like a poor approach because I may have to add "ToNumber(Part([Text],1000,";")" some day soon.  Updating formulas like that is a nightmare.

Thanks!
Jake

------------------------------
Jake Rattner
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
Jake, until we get a function like MaxValues, you will just need to "enjoy" using Copy/Paste to grow your formula to keep up with your data.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
  • EvanMartinez's avatar
    EvanMartinez
    Quickbase Staff
    4 years ago
    With formula queries being so fresh in Quickbase and a big change up for what can be accessed in formulas the team is very focused right now in cleaning up a few items that came up from the launch and assessing the overall performance of formula queries in QB as it gets more adoption across even more accounts. I definitely suggest as you are using formula queries right now if you have any feedback for us on your experience or things you would like to see in the future like a MaxValues function that you put that feedback into our recently launched new feedback experience. You can find it right where we used to collect feedback on the My Apps page under the Feedback tab. From there you can add your feedback or see if there is other feedback like yours you want to support.

    ------------------------------
    Evan Martinez
    ------------------------------