Smartsheet workflow copies row before all columns are stored by an AppSheet app

Joachim Mund · 02/01/22

Hi all,

I have an AppSheet app which saves its data including two pictures into a smartsheet sheet.

This smartsheet sheet has a workflow which copies the each new row to another table.

Sometimes the row is copied before all pictures are saved. I don't know why.

Does anybody has an idea how to fix this problem?

Thank you, Joachim

Genevieve P. · 02/04/22

Hi @Joachim Mund

What is the Trigger for your Copy Row Workflow? It sounds like it may be set to copy the row "When rows are added", however your app is updating cells with the images after the row has initially been added.

What I would do is set up a helper column the sheet that checks a box once both images have been populated. Then you can run the Copy Row workflow based on when that checkbox changes to checked. Will that work for you?

Cheers,

Genevieve

Joachim Mund · 02/04/22

https://community.smartsheet.com/discussion/comment/318664#Comment_318664

Thank you @Genevieve P. ,

this sounds good, but will not work because the photo images are optional :-(

Any other idea? Delay e.g. 30 sec. is not possible as I know

Genevieve P. · 02/04/22

Hi @Joachim Mund

Ah, thank you for clarifying.

Ok, what if you set up a Change Cell Workflow so that it checks that box when a new row is added? Then you can have the Copy Row Workflow be triggered by that checkbox.

It should give your row around 30 seconds to have any other updates applied before copying the row, but there still may be occasions where the Smartsheet workflows run faster than your outside application.

Smartsheet workflow copies row before all columns are stored by an AppSheet app

Answers

Categories