How can I make automaticaly a column to get data from another column once I save the changes?

Cucho
New Member

Well, it happens to me that Iโ€™m learning to write the URL of the pictures that I take in App.
So, Iโ€™ve this columns:

  1. ImageRoute: Itโ€™s the image that I take, it shows the picture on the app, and on the sheet it writes the location and name of the picture.
  2. ImageURL: It uses the ImageRoute [1] text to concatenate the Image URL.
  3. Image: itโ€™s not processed on the appsheet, itโ€™s used on google sheets and itโ€™s the command =Image(Cell with โ€œImageURLโ€ [2]), so it shows on the google sheets the image that has been taken.

Well, the problem that iโ€™m having is that when the user takes a picture creating a new instance, it does not instantly fills the columns 2 and 3. I think that itโ€™s because it saves the three at the same time, and it should save the first one and then, with that info, to save the other two. Because if i edit that same instance and then save it again without changing anything, it fixes everything.

How can I automate the action of:

  1. save the image route.
  2. then do everything else. ?

Thanks for your time

0 1 194
1 REPLY 1

If you simply need to โ€œupdateโ€ the row - this will show you how

Top Labels in this Space