Problems with the image from a parent table to a child table

[Avalenzuela]

Dear Sirs:

I have a problem with my application, which is the following:

I have a parent table called: Hallazgos and when registering in the application, we fill in a field called Foto, which is called in our child table: Acciones Correctivas. Using the formula [IdHallazgo].[Foto] in the app.
It happens that when I register in table Acciones Correctivas, at first the Foto can be seen, but then it disappears and becomes a triangle.
I need your help to find out what the problem is.

[WillowMobileSys · Accepted solution]

When the triangle appears, it almost always means that the path is not correct.

Using the formula as you are, it simply copies the path + file information - i.e. the same photo will be used.  So, you need to make sure that your [Foto1] column in the child table is defined exactly like the [Foto] column in the parent table - including folder configuration.

Additionally, you don't mention the datasource you are using.  If you are using sheets, then relative pathing applies - i.e. any paths are relative the physical location of the sheet.  This means that your child table sheet and the parent table sheet need to be in the same exact location in the cloud storage providers folder scheme...OR...you need to adjust the photo storage folder and photo column paths configuration so that BOTH columns can get access to the photo.

If you still need more help, please provide more details on your app datasource (and location if sheets) and photo column configurations. 

I hope this helps!!

[Avalenzuela]

Thanks for the help, it helped me identify the reason. On the other hand, I would like to know how I can make it so that even though my secondary table is in another folder, AppSheet can show me the image. Should I use some kind of statement or action?

[WillowMobileSys]

Buckle up...here we go!!

@Avalenzuela wrote:

even though my secondary table is in another folder

---

Do you mean that you have sheets used for tables in different folders?

The relative pathing is based on the sheet where the Image column resides.  Configure the path based on THAT sheet.

For example, consider this file and folder hierarchy:

...
File -Main Sheet
Folder - Secondary Tables
                Folder - Table 1
                                File - Table 1 Sheet
                                Folder - Work Images
                                Folder - User Images
                Folder - Table 2
                                File - Table 2 Sheet
                                Folder - Work Images
                                Folder - User Images

******************************************************

You load Table 1 and Table 2 into your app.  Both have  "Work Image" and "User Image" as columns.

For BOTH tables the:

Work Image column Folder path is set to "Work Images" and images uploaded from either table will be written into their respective table sheets as "Work Images/upload_image_name.xxx"

User Image column Folder path is set to "User Images" and images uploaded from either table will be written into their respective table sheets as "User Images/upload_image_name.xxx"

However, when a Work Image File is uploaded in Table 1, it will go into the folder "Table 1/Work Images", while one uploaded from table Table 2 will go into "Table 2/Work Images".  This is because of where the sheets for each table reside in the hierarchy.

Similarly, User Image File for Table 1 goes into "Table 1/User Images and for Table 2 goes into "Table 2/User Images".
******************************************************
Now consider this hierarchy:

File -Main Sheet
File - Table 1 Sheet 
File - Table 2 Sheet
Folder - Secondary Tables Data
                Folder - Table 1
                                Folder - Work Images
                                Folder - User Images
                Folder - Table 2
                                Folder - Work Images
                                Folder - User Images

******************************************************
If I had moved the sheets like shown above, any existing images would break because the paths already written into the sheets would look for the files starting from the modified location of the sheets and the Folders "Table 1" and "Table 2" do not exist there. 

But, when a NEW image is uploaded, AppSheet would use the existing column Folder Path config and CREATE a new folder - either "Work Images" or "User Images" depending on which column is uploaded (or both).  Also, because both sheets now reside in teh same folder location, they would SHARE the same image folders.  So, the new "Work Images" and new "User Images" folders would contain images from both tables.

You can force the images into the SAME folders as before by configuring the Image column Folder paths as follows:

Table 1 Work Image - "Secondary Tables/Table 1/Work Images"
Table 1 User Image - "Secondary Tables/Table 1/User Images"
Table 2 Work Image - "Secondary Tables/Table 2/Work Images"
Table 2 User Image - "Secondary Tables/Table 2/User Images"

NOTE:  With the moved sheets and the new column configurations to use the same folders, existing rows with images would STILL break.  All the existing rows would need to be updated to append the additional folder path config to the beginning of each entry.

******************************************************

One last point.. using the standard image upload capabilities,  the image folders can only be at the same or lower level than the location of the sheet.  You cannot place images in completely different folder location and still access them through the standard image feature.

There are other options to access images not controlled by AppSheet should you ever need that.

I hope this helps!