Using fields from other forms

Viewing 7 reply threads
  • Author
    Posts
  • January 17, 2022 at 4:25 AM #46318

    John McArthur
    Participant

    Hi,

    Whats the best way to incorporate fields from one form into another?

    eg;

    – ‘Form_1’ has a field called ‘NAME’.
    – Also within ‘Form_1’ is a field that uses a ‘Link to form’ to ‘Form_2’.
    – When ‘Form_2’ is opened I want to show the ‘NAME’ field from ‘Form_1’ at the top of ‘Form_2’.

    Thanks

    January 17, 2022 at 11:02 AM #46319

    Sam Moffatt
    Participant

    Assuming it’s a 1:M from Form_1 to Form_2, create a new calculation field in Form_2, scroll down the list of fields to the Form_1 field and double click on it to add it to the calculation. Make sure you change the return type in the calculation over to “text” as the default is “number”.

    January 17, 2022 at 11:59 AM #46320

    John McArthur
    Participant

    Hi Sam,

    Thanks for your reply.

    The field used to link the two forms is a ‘One to Many’ link type.

    When I create the new calculated field in Form_2 (“NAME”) the list of fields from Form_1 do not show up so cannot be selected.

    What have I missed?

    Thanks

    January 17, 2022 at 1:39 PM #46321

    Brendan
    Keymaster

    Make sure you have the “Show Inverse Relationship” option enabled on your Link to Form field. That’ll allow you to then do what Sam suggested.

    January 17, 2022 at 5:22 PM #46324

    John McArthur
    Participant

    Xlent! Another fix, well done!

    Thanks Brendan & Sam for your help.

    The support level is amazing for this brilliant piece of software.
    Such quick responses, with proper fixes.
    Not used to this in todays environment where there is commonly very poor service levels.

    Many thanks guys.

    January 17, 2022 at 7:34 PM #46325

    Brendan
    Keymaster

    Happy to help!

    January 17, 2022 at 10:07 PM #46326

    Sam Moffatt
    Participant

    Didn’t realise “Show Inverse Relationship” was required for that though it makes sense. I almost always tick the box for it because it’s so useful to be able to single select parent records depending on your flow as well.

    January 17, 2022 at 10:46 PM #46328

    Brendan
    Keymaster

    Yes it’s required because the Link From Form isn’t even created if you don’t have that enabled. And without that field, Tap Forms can’t list the fields from that form.

Viewing 7 reply threads

You must be logged in to reply to this topic.