I have a list of cities. When you click on that City, I want to take to to the details for it.
Then inside that city I have two “Show New Screen” buttons, one that points to a “Relation” of Businesses, and the other that points to a “Relation” of Events.
Once I click either button, I’m presented with the list of Businesses/Events respectively.
These lists need to allow the user to “Add New”, and they do, however when I do, I’ve lost fidelity into the “CityId”, There is no payload passed to the “Add New” button aside from the user details.
One thing I tried (unsuccessfully) is to updat the user table with their last_viewed_city_id when they view a city, but I can’t seem to be able to update the user in that way, in fact the only thing “Set Column Values” lets me mutate is the would be the city itself.
Is there a way to either
a) pass the CityId from the City Details page all the way through to the Add new business page
b) modify the user record with their last known city when they select a city?
- note: I don’t want to add a new value to a new row as I think I could very quickly hit my 25,000 row cap.
I’m kind of at a loss here and am not sure how to proceed.
Another thing that I like to do is, instead of using Show New Screen → Relation, I use Show New Screen → This Item, which gives you a new screen for the city row. On that screen you could add an inline list that uses the relation to show the businesses. Then you can add a button or floating button that opens a form to add a new business. In that you will still have access to the city data since you are still on the city row.
