to retrieve the name of a contact in the form of a dropdown list

Tap Forms Database Pro for Mac, iPhone, iPad and Apple Watch Forums Using Tap Forms 5 to retrieve the name of a contact in the form of a dropdown list

Viewing 2 reply threads
  • Author
    Posts
  • June 18, 2020 at 8:26 AM #41008

    Azimut
    Participant

    Hi !
    Is it possible, in a Table field, to retrieve the name of a contact in the form of a dropdown list and make this list grow according to the number of entries added?
    Thank you

    June 18, 2020 at 9:02 AM #41013

    Brendan
    Keymaster

    You can enable the “Use Auto-Complete” option on a sub-field of a Table field. Tap Forms will then as you start typing into the field, Tap Forms will show a popup list of previously entered values for that field. Hope that’s what you’re looking for.

    June 18, 2020 at 12:48 PM #41019

    Sam Moffatt
    Participant

    I gave this a quick spin, there might be a bug though because I only got autocomplete options within the same record (I added Sam, John and Tim). If I went to another record and typed in entries (an S, J or T), it didn’t offer suggestions from my previous table entries. I then added a new entry to the second record (Jeff) and when I went back to the first record and added a new table entry, it suggested entries from that same record (Sam/John/Tim) but not from the other record (Jeff). Not sure if it’s supposed to be scoped to just a single record or global.

    This doesn’t work with table fields as well but before autocomplete was an option, I used lists to provide the same functionality. If you create a new list in the TF preferences screen and then point it at the form and field you want to autocomplete from, it’ll pull those details in for you. This is useful if you have a master list of something (in this case a master contact list) and want to be able to pull in named entries without the overhead of a link field or want the ability to put in your own values when they don’t exist in your master contact record (this can make certain data entry quicker). This doesn’t work as well with table fields because the list renders as a popup button style. I like the “single value popover” display option because on the Mac it gives you a little popover window with a search button in it that is a little nicer but the field itself doesn’t give you an autocomplete style interaction (as you tab in and type autofilling options). If you want that sort of experience, setting display as to “combo box” will give you that.

    Since this doesn’t work as well for table fields, a different approach is to create a different form and use the default layout to edit the form. In a sense a table field is creating that sub form structure for you with all of it’s fields but only showing you a table interaction like the Link to Form field would do. If you go down this path then the list option will work properly for autocompleting a field value.

    Attachments:
    You must be logged in to view attached files.
Viewing 2 reply threads

You must be logged in to reply to this topic.