Search for already Existing Record
Hi, I have a scenario where user wants to check whether the record already exists or not at the time of creating record. For Example: User wants to create a product ,clicked on add record button of...
Forum Discussion
Hi MarkShnier,
Thanks for your reply,
I have used the below formula query, but it is not giving the desired result.
((Size(GetRecords("({9.EX.'"&[Vendor]&"'})",[_DBID_VENDOR_SEARCH]))))
instead it is showing question mark.
Here in the above formula query I'm putting the value of Vendor in Vendor table and searching it's existing value in another table called Vendor Search.
9 is the fid of Vendor in Vendor Search table where as Vendor field is in Vendor table.
Please have a look at it.
Thanks in advance.
- MarkShnier__You
Qrew Legend
Maybe try this syntax
var text QUERY ="{9.EX.'"&[Vendor]&"'}";
Size(
GetFieldValues(
GetRecords($QUERY),3))Hi Mark,
I tried the above one, but getting the same issue. I think will not work at the time of adding record.
- MarkShnier__You
I tested and it works for me. Did you try tabbing out of the data entry field to allow the form to know that you have completed your input?
