Forum Discussion

Jonathan_Gibson's avatar
Jonathan_Gibson
Qrew Cadet
4 months ago
Solved

Deleted records and record pickers / Formula check if related record has been deleted

I have a record that appeared to be missing a related record, but wasn't showing up on a report I have for identifying records with relational issues. It turned out that there was a value in my refer...
Forms
  • JCY's avatar
    JCY
    4 months ago

    I've done something similar before using a query like this:

    var text query = "{17.EX.'" & ToText([Reference Number]) & "'}"; var RecordList matches = GetRecords($query, [_DBID_CONTACTS]); ToNumber(Size($matches) > 0)

    Good luck.

Jonathan_Gibson's avatar
Jonathan_Gibson
Qrew Cadet
4 months ago

I thought I might be able to run the check based on a lookup to a field I can expect to always have a value if the record exists, i.e. one that is required at the table level. In my case I tried a string Name field, but it doesn't seem to work:

Trim([Donor - Name]) = "" or trim([Contact - Name]) = ""

...evaluates to false for a related donor or contact. Perhaps the old lookup value still persists in some way? I can't use IsNull here because of the type, but maybe this would work if it were a numeric field...