conditional copy values from on table to another

Tap Forms – Organizer Database App for Mac, iPhone, and iPad Forums Using Tap Forms conditional copy values from on table to another

Viewing 1 reply thread
  • Author
    Posts
  • November 14, 2020 at 2:29 AM #42579

    Winfried Ruetz
    Participant

    Hi Brendan,

    I’m quite new to tap forms. I build a recipe database with a table that has 3 fields. 1 text field for ingredients, 1 text field for the amount of the ingredients and 1 checkmark field to tick if the ingredients are available (no check) or I have to buy them (check).

    Now I try to create a new layout for a shopping list where I want to put a table with the ingredient fields and the corresponding checkmark for buying from my ingredient table.

    How can I manage this?

    Thanks in forward,

    Winfried

    November 15, 2020 at 3:19 PM #42607

    Brendan
    Keymaster

    Hello Winfried,

    The Table field is only available to the form that you put it on.

    If what you need is a Shopping List form that links to ingredients, then you’ll have to create a separate Ingredients form that you link to from your Shopping List form AND from your Recipes form.

    Or alternatively, skip the Shopping List form and just have your Recipes form and an Ingredients form. Then just visit the Ingredients form whenever you want to go shopping. Put your Checkmark field as your first field in the form and when you do that, on iOS, you’ll see a checkmark button to the left of the ingredient name. Tapping on it will check it on or off. Also, if you sort by the Checkmark field then you could have all the unchecked items at the top and all the checked items at the bottom. So as soon as you’ve bought an ingredient, tap on the checkmark and it will move down to the list of checked items.

    But then you’d want to have a way of resetting all of the checkmark fields back to unchecked before you go on your next shopping excursion. The only way to do this is to either manually uncheck the items you want to buy, or write a Form Script that un-checks them all for you in one go.

    Thanks!

    Brendan

Viewing 1 reply thread

You must be logged in to reply to this topic.