Images missing in google sheet

AppSheet AppSheet Q&A
, ,
1

Hi is there anyone experiencing the same thing in which the image saved suddenly become ‘missing’ when it is actually required. This happened to few of my clients site that have different setup. I wonder what is the issue because we got the chronology but not too perfect so we cannot make any good solutions as of for now.

Chronology A:

  1. User A submits corrective problems regarding work matters to system. Status changes to responding.
  2. User B (doesnt know image is missing). Key in more data only to realize somehow image inserted before went missing because it is required for them to save the form.

Chronology B:

  1. User A submits corrective problems regarding work matters to system. Status changes to responding.
  2. User B key in more data and work pictures 3 of them then save the form.
  3. User B went to collect signature from User A only to realize somehow image inserted before went missing because it is required for them to save the form. at this stage there is 4 pictures.

Choronology C:

  1. same as chronology B for no 1 and 3 all successful.
  2. User C then comes in to acknowledge the work but they couldnt save it cause it is required for the image. all images gone

Chronology D:

  1. same as C all successful.
  2. User C wants to generate a report only to find that there are no images on the paper as the image is missing.

All of the chronology is not limited as we just deduce that on our own. Is there anyone who could give any opinion on this matter. This issue only happened suddenly and we are not sure what we do wrong as this never happened before, it occurs starting may 2025. the database that we used is using google sheet.

2

You could add more clarify. However please clarify one thing. Does it essentially mean in all the 4 chronologies you mentioned, are more than one user working on the same record simultaneously?

1 Like
3

To answer you question, they do have multiple user and they might be working on the same one simultaneously.

However, I do not think that is the issue because of the data recorded. Some of the data will affect one column named status and when i was fixing by replacing the image in database i noticed that it does not effect the status at all. I would do an audit trail to detect and conclude the chronology in most detailed way later on and will update again here.

1 Like
4

Thank you. If its is so, please carefully read the following help article.

The most relevant part from the article is as below.

image
image1077×302 25.6 KB

You may want to analyze situations such as if the image updated by user A is getting lost because user B works on the same record simultaneously and saves the record later after A saves it.

3 Likes
5

It sounds this is exactly coming from the reason Suvrutt explained. You can easily find this from the Google Sheets and its image column’s cell history.

To avoid this, one workaround is to use additional child table for images or even for all updates. Another workaround is to create a reservation functionality where the user needs to request access for that record. These workarounds would avoid app users working with stale data.

2 Likes