Skip to main content
Solved

Formula Query with custom key

  • March 4, 2025
  • 0 replies
  • 261 views
Forum|alt.badge.img+7

I have a parent table with a custom key, and I have several formula fields with formula queries that pull data into the parent.  The ones that are summing into numeric fields work, but I also have one that is a checkbox formula.  I want the parent to have a checkbox if any of the children do.

var Textlist vals = GetFieldValues(GetRecords("{48.EX.'"&[Custom Key]&"'}", [_DBID_TABLE_NAME]),43);

If(Contains($vals, "High"),true,false)

There are no syntax errors but it's not working - there are child records with a checkmark in field 43 but on the parent records there isn't a checkmark.  I know the GetRecords function is returning the correct records because it works for my other functions that sum correctly.

I tried to run the formula checker, to check each step, but it doesn't work with my custom alphanumeric key.

How can I figure out what's going wrong here?

Best answer by QuickBaseJunkie

I would highly advise against using formula queries if you have a direct parent/child relationship between the records. A summary field with a filter for any checked child record would suffice.

That being said, if field ID 43 is a checkbox so the use of "High" isn't likely what you want. Try it with "yes" instead.

Let me know if that works - Sharon

Forum|alt.badge.img
  • SharonFaust
  • Quickbase Alumni
  • March 4, 2025

 see other comment

QuickBaseJunkie
Forum|alt.badge.img+15

I would highly advise against using formula queries if you have a direct parent/child relationship between the records. A summary field with a filter for any checked child record would suffice.

That being said, if field ID 43 is a checkbox so the use of "High" isn't likely what you want. Try it with "yes" instead.

Let me know if that works - Sharon

Terms & ConditionsAccessibility statement