Skip to main content
Question

Record picker functionality

  • February 14, 2023
  • 0 replies
  • 144 views
Forum|alt.badge.img+6

I'm searching for a way to use a record picker field without a related table. I want to add a record and as I can enter part of the data the matches are listed in the dropdown, otherwise, I have the option to add the record. I can only find ways to use this function from child table.

I'm sure this is easy to do and I'm just not seeing it. But I would be eternally grateful if someone could say, "it's right there in front of your face!"



------------------------------
Barry Dolan
------------------------------
    This topic has been closed for replies.

    • BlakeHarrison
    • Registered
    • February 15, 2023

    Do you mean that you'd like the user to enter a value into a field (Name, for example) and as they're typing, it would search for matches in that field on the same table? Essentially making sure no duplicates are entered on the same table? If so, you can change the "Unique" flag in the field properties, which will limit the ability of users to create duplicate records. It won't, however, allow for a real-time search-as-you-type drop-down. Those would only be available when you're typing in a reference field, as in the child table setup you mentioned.



    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    /
    ------------------------------
    Terms & ConditionsAccessibility statement