Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Switching from Handbase to Tap Forms – importing linked records and pick lists
October 11, 2015 at 6:20 AM #14970October 11, 2015 at 9:00 PM #14977
On iOS there’s an Import Values function when editing a Pick List which lets you import a file that has your values in it. I didn’t add that function to the Mac version because on the Mac version it’s super easy to just copy a list of values and paste them into the “Add values…” popover view that appears on the Edit Pick List screen. Tap Forms will split each value that’s on a separate row into its own Pick List value. It’s a very quick way of importing your values.
The Link to Form field can only see the records from another form if you create them from the parent form itself. If you want to select from a list of records in a child form, then you need to set the Link Type to be a “Many to Many”. Then you’ll see a checkmark button which lets you pick from the list of child records. Yes, it would be daunting with 600 records either way you do it. How does HandBase associate your records together from different tables/forms?
BrendanOctober 12, 2015 at 5:50 AM #14982
Thanks for the fast reply, Brendan! I think pick lists will do what I want for this 600 record database, er, I mean form! I have others that are related that I’ll try to move over. I don’t know how HanDBase links forms, but I’m guessing it is the same. The others aren’t as big, so reconnecting them probably will be doable. I will try the “many to many” type – that may be my issue. Again, thanks so much.
You must be logged in to reply to this topic.