Can I have one table store images from several parent tables? - like a mass storage of sort
So, that all the parent tables have an inline view, showing respective images from the images table
I donât see why not. Seems like you could have a table with just an image column type and a key (foreign key from the parent tables). The add a REF so you can view the child table records from the parent. Have you tried that to see if it meets your need?
@Mike Iâm afraid this wonât work directly because you canât choose more than one table for your Ref field. You would need to have one Ref field table by table.
@Aleksi - ah⌠I missed a key word. I was thinking @Jeremy_F was looking to store images in one place to use in other parent tables. I missed the fromâŚ
Jeremy_F:
images from several parent tables
1 Like
Mike:
was looking to store images in one place to use in other parent tables
Yes, I want one table to store images to use in other tables, instead of creating multiple columns in each table for images
Move all of your images into a single image table, but add a column to indicate what âparentâ table each image belongs to. Then create slices on those parent table column values.
Steve:
Move all of your images into a single image table, but add a column to indicate what âparentâ table each image belongs to. Then create slices on those parent table column values.
This definitely works, but I decided to use one column per parent, instead of having many slices. Though it would be great if could have multiple âispartofâ
I am curious whether the number of images uploaded has an effect on the sync time for an app.
Jeremy_F:
I am curious whether the number of images uploaded has an effect on the sync time for an app.
Only if your app is configured for offline use, Iâd think. In that case, the app will try to download all images during a sync.
Sometimes, I might be in the field with almost zero Internet, will the app upload the images even if I am offline?
Iâm interested in this , I have a set up where my parent table containing jobs references an images table, and references a files table , and references notes tables. When I view a job I have a ref inline view of the child tables but Its getting very slow to load the app or to syn etc . I have offline use switched on but store content for offline use switched off. Would you suggest my structure is the issue?
I donât know what an appropriate syn / update time would be but generally looking at 12 seconds, even to update one field at times. It was previously 30 seconds but a bug was found and resolved and times dropped to around 4 seconds but its gone up again and I am not sure why.
Would the volume of images cause an issue? My inline view only shows one when they access the job, if they click to view the images it will show more.
Jeremy_F:
Sometimes, I might be in the field with almost zero Internet, will the app upload the images even if I am offline?
Thatâs good question! @Aleksi, do you know?
Ellie_F:
I have offline use switched on but store content for offline use switched off. Would you suggest my structure is the issue?
If you want all app-related content available when offline, you really have no choice but to switch Store content for offline use to ON.
Ellie_F:
I donât know what an appropriate syn / update time would be but generally looking at 12 seconds, even to update one field at times. It was previously 30 seconds but a bug was found and resolved and times dropped to around 4 seconds but its gone up again and I am not sure why.
Itâs virtually impossible to say what the âexpectedâ or âreasonableâ sync/update time for someone elseâs app should be without a review of the app configuration, the data, and the devices involved. There are a great many variables. A common cause of slow sync times is excessive or inefficient virtual columns. Itâs very easy to create an inefficient virtual column. A very large data set can also be a problem, especially when combined with inefficient virtual columns.
Ellie_F:
Would the volume of images cause an issue? My inline view only shows one when they access the job, if they click to view the images it will show more.
The number and size of images doesnât play a big role in sync times, I donât believe. Sync is when the app updates data in the tables. Images are updated separately in the background (as I understand it). The number and size of images will affect the volume of data (wi-fi or cellular) the device uses, and how long it takes new or updated images to become available on the device, but should not substantially affect sync time.
@Jeremy_F When you are offline, you are offline totally and the app wonât upload any images. When you are online again, you can sync the data again.
2 Likes
Thanks for the clarification