Formula Query with custom key
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?
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
