A bit tricky and fundamental issue here. I have spent a lot of time trying to solve it myself. I have 3 collections “Users”, “Weddings” and “Venues”. Screen 1: a list of all venues for the current wedding Screen 2: a detail view of the venue Screen 3: add a venue screen For my business logic it…

Bit hard to follow… but no you should not have to do that I don’t think - would need to see more about your database setup to see why.

Thanks for the answer Tony! Here is my DB setup: [image]

I don’t think this is the way I would do it, but from the way you have said you want things, I think you need to add Users to Venue… likely as a 1 Venue to a User, Venue can have many users. When a new Venue is created, you would then be able to specify that that venue is related to that user.

Thanks for your assistance, Tony. I just tried this approach, but it is not working as expected and is also not achieving the desired business logic. If the Venue has relation to Users only (and not to Wedding), then when a new Venue is created I have to add all Wedding Users to it (in order for e…

You would link both users and weddings, you can have relationships to multiple things.

Thank you for your help, Tony. I tried this too, but I am now getting the sum of all issues (the ones reported in my initial post and the ones reported later). The setup that I have is pretty simple and can be quickly reproduced. Also the business logic is very straightforward. In my app there are…

Assuming that the user starts with a screen that is a list of weddings, and then clicking on one wedding takes them to a page where they can view the list of venues for that wedding with a button to add another venue… On the add venue form screen, add an action to the form’s submit button that upda…

Hello Ben, Thanks for the help. Your assumption is correct, although I am not showing a list of all weddings, because that is against the business logic.The user sees only the wedding that he participates in. He navigates to the venue list screen and adds a new one. Even after I add a back action…

Hey @Kiryazov , did you manage to solve this issue? :thinking: I am stuck in a similar situation Set automatically fields - #6 by sal

Automatic field. Value is not reachable

Get Help

sal May 5, 2021, 4:10pm 10

Hey @Kiryazov, did you manage to solve this issue? I am stuck in a similar situation Set automatically fields - #6 by sal

Topic		Replies	Views
How to set "Logged in user" field for forms Get Help	5	660	January 14, 2021
Database Relationship Not Working Get Help	6	1209	November 24, 2020
Default values for relationships Get Help	11	1785	January 12, 2022
Relational Database Collections Not Connecting to User Database	18	1124	May 2, 2021
Set automatic relationship field values Feature Requests open , form-and-field	5	42	January 20, 2026

Automatic field. Value is not reachable

Related topics