My app has families and children. A user can create multiple families. I want them to be able to click on a family and then all actions are taken in the context of that family. For example when adding a child they will be automatically assigned to the current family.
I’m using Softr Databases if it makes a difference.
Create two linked fields - families and children
Create a details page for families
Use filters to display items based on the family of the details page you are on. Use hidden fields on the families details page to collect data based on the family you are within.
The part I was having trouble with was how to set the value of the family field to what I want. What I ended up with is using a formula field in the family table to build the url I want. ‘/add-address?family={family record ID}’
Then I set the value of the hidden field based on a url parameter and use the “family” parameter. This seems to work although it’s a bit buggy in Softer databases. I’ve submitted a different issue for that: Softr Databases: Invalid data can be added when submitting a form with related record
Thanks for your help.