Thank you! Now it’s working properly! A great step to me, really thank you so much.
Now the next “problem”, the “start date” it’s the same for both test trips, but must be
a differente start date (in this case first trip start on 20/06, the second on 21/07) but
it get the same start date for both. Where I’m wrong?
Again, make sure you are utilizing the relation when configuring your start date.
Thank you, I understand what you are saying, but I’m terrified to made a mess again, and I don’t know which column modify or how many new ones I’ve to create. Don’t want to steal your time, thanks for precious help with other stuffs
Change your Single Value Start Date column to retrieve the date from the relation.
Done, thanks a billion. And thanks for your patience.
Change your Single Value Start Date column to retrieve the date from the relation
[/quote]
Hi everyone again, I’m facing the last problem, once this is solved the app will be ready.
Inside a “Trip days” page, where the total days planned for that trip are listed (as a preview with destination and date).
Opening the single day there are fields to fill in “location”, “accommodation”, and below a “create time slot” button through which you create all the time slots of the day in which to insert the various activities, for example: flight, taxi, restaurant, safari, etc. with relative time.
The button works correctly, it creates all the fields with a connected icon, the only problem is that it creates the same activities for each day, let me explain, any activity I create, on any day of the trip, will also be visible on all the other days and not just on that one.
I think it is connected to the DayID field that is not filled in. I tried with different relationships, but nothing seems to work. Can anyone help me?
So you have the hierarchy like this:
Trip > Trip days > Timeslots in each Trip day
Is that correct? And the problem should be because you should have a Trip day ID in the Timeslots table?
Can you show some screenshots on how you’re configuring this part?
And the data added for this part?
You don’t have the day ID in there. In the add time slot tab, you should add the dayID as a “screen”/“special” value. You can search for it on the left panel and point it to the Day ID column in the Time Slot table.
Done, thank you. Now the DayID is properly filled, but the activity created is still visible in all the days created, is not unique for that day

Make sure the activity collection is using a relation as it’s source, or you can apply a filter to the collection. Either will work, but I always prefer using a relation as the source. If you are pointing the collection to the entire table, then yes it will show the same list for all days because you haven’t given the collection any direction of which rows you want to see. Use a relation or a filter to narrow down to only that day’s activities.
I understood your indications, but I’m terrified to make some mistakes and ruin everything I’ve did.
Do you mean this collection? Or where is the collection to modify? Or do you mean I’ve to create a relation in data tabs?
Hi. I’ve fixed, I added another RowID in the create slot button, and now each day has only their own activities. Don’t know if it’s right, but it works
What do you mean by this? Can you show some screenshots?
If you’re looking at the day level on the previous screen before you open the form, it should only be the rowID (of the day) that be written.
You were trying to use TripID before, which might be the reason why it didn’t work.