Forum Discussion

MichaelFrishma1's avatar
MichaelFrishma1
Qrew Trainee
4 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
MichaelFrishma1's avatar
MichaelFrishma1
Qrew Trainee
4 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's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
OK try this

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

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