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
------------------------------
Original Message:
Sent: 10-29-2021 18:56
From: Mark Shnier (YQC)
Subject: Formula Queries - Finding Min/Max of Value Using Foreign Key in Other Table
At this time we are only able to Sum the values that are returned or count them with the size function. But there is no max function yet.One assumes that they will be offering this in the near future
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
Original Message:
Sent: 10-29-2021 18:50
From: Jake Rattner
Subject: 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.'"& [StateID] &"'}", "DBID"), 212)
In the query, I'm returning a text list that shows all the 'prices' (fid212), where the 'stateID' (fid249) matches the 'StateID' on the record. This part works.
Now I'm trying to figure out for to derive the min and/or max from the resulting text list.
I've used SearchAndReplace to modify the text list in a few different ways to that I can pass it into the Max function, but no luck yet.
Do you konw how to do this?? Thanks!
------------------------------
Jake
------------------------------