Solved: Shared Images Folder

lochtefeldm

Hi All,

I have images, videos & PDFs used in more than one table. I have just set up AWS and wanted to store one copy instead of duplicates. Is this possible for content uploaded via appsheet? The file names includes an identifier that is found in both tables to attach it to the record.

Suvrutt_Gurjar

@lochtefeldm wrote:

i was concerned about sync times being impacted with references.

In general, system created reverse reference columns do not impact the sync time.

@lochtefeldm wrote:

Can you give an example or link me to for what you mentioned?

Here it is

Dereference expressions - AppSheet Help

@lochtefeldm wrote:

Other table row key would be something from table a or b in the example given.

Could you share the image field content pattern of the table A and B

Is it something like below for table A

"TableA_Images/RowKey.ImageColumnName.Timestamp.png"

and something like below for table B

"TableB_Images/RowKey.ImageColumnName.Timestamp.png"

View solution in original post

Suvrutt_Gurjar

@lochtefeldm wrote:

The file names includes an identifier that is found in both tables to attach it to the record.

Could you elaborate this? What is this common identifier?

In general, it may not be very trivial to do the needful, though.

lochtefeldm

For the table where images would be uploaded, their row key is part of the name. The other table where i want to the image displayed have column that contains the key.

So table A of image origin has row key of Value_99024.
So table B of image origin has row key of Value_ABC.

Table Facilities has columns for other images, and other table row key.
Table Inventory has a column other images, and other table row key..
Table Accounts has a column other images, and other table row key.

For facilities, accounts and inventory there will be one matching row key but it could be from table a or table b.

Would like one image used in multiple tables.

With AWS i was thinking of an expression that creates a url that is used accross tables autocalculating things rather than relational location.

But this gets tricky for files uploaded by Appsheet, you dont get control over how it writes to aws s3. It creates its own folder structure which impacts the url.

Suvrutt_Gurjar

Thank you. If there is any referencing relationship between tables, then you could reference image uploaded in a parent table in a child table with dereference expressions.

@lochtefeldm wrote:

Table Facilities has columns for other images, and other table row key.
Table Inventory has a column other images, and other table row key..
Table Accounts has a column other images, and other table row key.

"By other table row key" - do you mean they are all referring to another but same table? Is that table parent table by any chance?

lochtefeldm

Other table row key would be something from table a or b in the example given.
The tables don't have reference columns, with some tables having 70k rows that are not filtered i was concerned about sync times being impacted with references.

Can you give an example or link me to for what you mentioned?

Suvrutt_Gurjar