Forum Discussion

HunnyVinod_Kuma's avatar
HunnyVinod_Kuma
Qrew Member
3 months ago

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...
Forms
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend

Maybe try this syntax

 

var text QUERY ="{9.EX.'"&[Vendor]&"'}";

Size(
GetFieldValues(
GetRecords($QUERY),3))

HunnyVinod_Kuma's avatar
HunnyVinod_Kuma
Qrew Member
3 months ago

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's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 months ago

    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?