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

MichaelFrishma1

Qrew Trainee

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
------------------------------