Tap Forms Database Pro for Mac, iPhone, iPad and Apple Watch › Forums › Using Tap Forms 5 › Using fields from other forms
- This topic has 7 replies, 3 voices, and was last updated 3 years, 10 months ago by
Brendan.
-
AuthorPosts
-
January 17, 2022 at 4:25 AM #46318
John McArthurParticipantHi,
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 MoffattParticipantAssuming 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 McArthurParticipantHi 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
BrendanKeymasterMake 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 McArthurParticipantXlent! 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
BrendanKeymasterHappy to help!
January 17, 2022 at 10:07 PM #46326
Sam MoffattParticipantDidn’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
BrendanKeymasterYes 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.
-
AuthorPosts
You must be logged in to reply to this topic.