Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › How to simulate nested pick lists
- This topic has 7 replies, 4 voices, and was last updated 3 years, 5 months ago by robinsiebler.
-
AuthorPosts
-
July 7, 2021 at 8:14 AM #44734
robinsieblerParticipantIt seems nested pick lists are not implemented, so what I want to do is probably impossible. But, maybe someone has a reasonable workaround…
I want to create a Packing Program (‘cuz my wife doesn’t like the one I always use and *paid money for*). :(
I envision something like this:
Categories:
….Accessories
……..coats
……..jackets
……..hats
……..shoes
…………dress shoes
…………tennis shoes
…………hiking boots
……………
……..gloves
……..misc.
….Clothes
….Gadets
….ToiletriesHow can I create something like this?
Also, I had to substitute periods for spacing because this forum would not honor the spacing I so carefully arranged in my post!
July 7, 2021 at 9:52 AM #44737
Daniel LeuParticipantHave a look at following post from @sam: https://www.tapforms.com/forums/topic/populate-pick-list-field-from-another-field-value/#post-39012
July 7, 2021 at 10:54 AM #44739
Sam MoffattParticipantYou could just use the pick list with the ancestors printed breadcrumb style, for example:
Accessories Accessories > Coats Accessories > Jackets Accessories > Shoes Accessories > Shoes > Dress Shoes
I think at the current moment for this sort of use case that’s likely the easiest path forward.
You can use backticks or the ‘code’ button to get preformatted text.
July 7, 2021 at 5:32 PM #44743
robinsieblerParticipantI downloaded Vehicle-Data.tff, but I get an error when I try to open it:
Attachments:
You must be logged in to view attached files.July 8, 2021 at 1:28 AM #44751
BrendanKeymasterSince that’s a .tff file, use the Import Form Template command in the File menu to import it into Tap Forms.
July 8, 2021 at 2:05 AM #44754
robinsieblerParticipantThanks for the breadcrumbs idea! I was able to take my Shopping List database and modify it for a Packing List and incorporate the breadcrumb idea! Now, I just have to add the bajillion items I want in it!
July 8, 2021 at 10:01 AM #44757
Sam MoffattParticipantYou can bulk import to the pick list or if you already have much of the structure defined you could use a form field as a source and import data into the form with a field per layer of your tree.
Attaching a form template with up to 9 layers to show how scripting can be used to build it. Import the template, fill in some values and then in the pick list setting set it up with the use values from field option (see screenshot). As you do each layer, you can duplicate the record and update the value you need to change. Should make data entry a little less error prone. Trees are rather unwieldily to deal with unfortunately.
Attachments:
You must be logged in to view attached files.July 8, 2021 at 11:08 AM #44763
robinsieblerParticipantAwesome! You rock!
-
AuthorPosts
You must be logged in to reply to this topic.