Forum Discussion

Jonathan_Gibson's avatar
Jonathan_Gibson
Qrew Cadet
5 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
    5 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.

JCY's avatar
JCY
Qrew Trainee
5 months ago

In the old grid edit mode, if I click on a reference field (which is blank because the value no longer exists) like I'm going to edit it, it will show the existing/deleted value.

Regarding checking if a related record has been deleted: I think you would need some separate record or way to know if it was deleted, like a history table. But if you just want to know if it's not there (i.e., missing), you could have a formula query based on whatever is the common/related factor.