This is my problem: I’ve placed the images for the properties on a different Google sheet tabs than the properties, this way I can add many images without having to create additional column on the properties tab. The problem is that when I add a new property on the front end, I need a way to add images to this property. Even though there’s a relationship between tabs, I am not able to come up with a way to do this.
Are you saying that you want to add images at the same time you create the property? I imagine they’re being linked right now via RowID or address? I also imagine you’re adding new properties via a form?
If so, you’re right—you can’t really add images to a property that doesn’t exist yet…you’d almost need to have an action that’s on form submission > view details > show form for this item
I’ve seen you mention this a few times lately. I starting using the same method on a new app and it works slick. In my case I use a custom form with an add row action, followed by a show screen action. It allows me to add a new row and navigate directly into it’s details with one button click. All based on unique ID.
Yeah, I use it a lot. I’ve had quite a few use cases where a record is created, and then there needs to be an inderminate number of images and/or documents uploaded and associated with that “master” record. So I use a separate table for the images/docs and associate via the unique ID. Works well
I’m camping with barely 0.05mbs of garbage wifi and no cell signal, so I’ll have to check all of this out later. Basically what I’m creating is a personal app with folder based notes. So I can create folders that each can contain multiple notes, checklists, images, etc. When I create a new folder or note I create a new unique ID in a USC column in my custom form. Then fill out the form and submit by adding a row to a new sheet, including that unique ID. Then I clear all USC columns, except for the unique id column. I use that to build a relation to the folder or note sheet where I added the new folder/note. I can then navigate right into it through the relation and show it’s details immediately after adding the row.