In multi-column list view, show field from linked form

Tap Forms – Organizer Database App for Mac, iPhone, and iPad Forums Using Tap Forms In multi-column list view, show field from linked form

Viewing 4 reply threads
  • Author
    Posts
  • May 12, 2023 at 8:30 PM #49409

    alang
    Participant

    Hello. In a multi-column list view, nothing is shown if the field is a “Link to Form”. I suppose it does not know which field from the linked form to show. Can you specify a field from the linked form to show in the multi-column list view? Thank you.

    • This topic was modified 1 year, 7 months ago by alang.
    May 13, 2023 at 7:46 PM #49414

    Brendan
    Keymaster

    hi Alang,

    This can be done if you create a Script field which joins together values from a field that you want to extract from the Link to Form field.

    You could have multiple records in your Link to Form field, so you have to tell Tap Forms which record to get the value from. Or you can just loop through all of the child records and join the values together into a single string. That could then be displayed in the multi-column list view.

    Thanks,

    Brendan

    May 13, 2023 at 7:48 PM #49415

    alang
    Participant

    Thank you Brendan!

    May 13, 2023 at 7:59 PM #49417

    Brendan
    Keymaster

    I forgot to mention, the Child Records Loop snippet on the Script Edit window will write most of the code for you. Just add a Script field to your parent form, then open the Script edit window. Then select a field from the Link to Form field on the list of fields on the left of the Script Edit window. Then double-click on the Child Records Loop snippet. Tap Forms will write the code you need to loop through all the child records. Then just join the value from the field into an array using the push() function and then join them together as a string using the join(", ") function.

    May 13, 2023 at 8:01 PM #49418

    alang
    Participant

    Ah! Just starting to learn scripting. So that’s very helpful. Thank you again!

    • This reply was modified 1 year, 7 months ago by alang.
    • This reply was modified 1 year, 7 months ago by alang.
Viewing 4 reply threads

You must be logged in to reply to this topic.