Came across this thread while looking for a way to link fields and find record ids. Here is the function I use to find a unique value and get the id. async function findRecord(tableName, fieldName, searchValue) { let returnID = ''; let thisT...

My workaround right now is to create a field for each status I need to count then roll them up in a related table. Example: Employee Status field is Active, Inactive, Starting, or Leaving. I create 4 hidden formula fields with If(Status=“Active”,1),...