Forum Discussion

Qrew Trainee

3 years ago

New Formula Queries Don't Work when Adding Records?

I'm trying to use the new formula queries to prevent the addition of a new, duplicate record in my "Tours" table. There are reasons why I cannot just use the Unique flag... The Tour ID is the key f...

formula queries

MarkShnier__You

Qrew Legend

Try this. I know the quotes are tricky.

Size(
GetRecords("{6.EX." & [Tour ID (Paste)] & "}"),3))

If that is 1 (or higher) when you are in add mode and not yet saved, that means it will case a duplicate.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

MichaelFrishma1

Qrew Trainee

3 years ago

Thanks for the help, but it won't let me do a
,3))
on a "Size" formula query. It expects a closing parentheses after the "}")

------------------------------
Michael Frishman
------------------------------

MarkShnier__You
Qrew Legend
3 years ago
OK try this

Size(
GetFieldValues
GetRecords("{6.EX." & [Tour ID (Paste)] & "}"),3)))

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------