This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

PDF File creation won’t update edits

Posted on 03-25-2022 11:48 AM
rakhie_urs
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

Hi!
I have set an automation to create a pdf file when a form is submitted or updated.

I also have a File type column that links to the created file.

Its working fine when form is submitted.

But when form is edited or updated file won’t change to new values.

But back in drive it will contain updated file only.

1 9 1,048
Topic Labels
9 REPLIES 9

Posted on --/--/---- --:-- AM
WillowMobileSys
Platinum 1
Platinum 1
Reply posted on --/--/---- --:-- AM

If I understand correctly, when a Form submits changes, the automation is overwriting the existing file?  If so, you may be hitting a scenario where the file contents have been cached.  Maybe they are not being updated in a timely manner?  Do you see the updated details after Syncing?

Posted on --/--/---- --:-- AM
rakhie_urs
Bronze 2
Bronze 2
In response to WillowMobileSys
Reply posted on --/--/---- --:-- AM

Yes I'm not able to see the update changes in file. But drive contains updated one.

0 Likes

Posted on --/--/---- --:-- AM
JuneCorpuz
Gold 1
Gold 1
In response to rakhie_urs
Reply posted on --/--/---- --:-- AM

Check this post


https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/File-Column-open-action-loads-old-Cached-versio...

Posted on --/--/---- --:-- AM
rakhie_urs
Bronze 2
Bronze 2
In response to JuneCorpuz
Reply posted on --/--/---- --:-- AM

Yep. Thanks for your reference.

I was also hoping to get rid off cached version.

0 Likes

Posted on --/--/---- --:-- AM
ABHIJEET_PATIL
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

Just go in behavior then offline sync and turn "The app can start when offline" off and turn "Server caching" on and also turn "Delta sync" on. Now when you edit the data and save the new version of pdf the file is updated and you see the updated pdf when you click on open pdf file button. This worked for me let me if it works for you as well.

Posted on --/--/---- --:-- AM
LeviP
Bronze 3
Bronze 3
In response to ABHIJEET_PATIL
Reply posted on --/--/---- --:-- AM

Not working, Always show the old version of the PDF

0 Likes

Posted on --/--/---- --:-- AM
WillowMobileSys
Platinum 1
Platinum 1
In response to LeviP
Reply posted on --/--/---- --:-- AM

I assume you are overwriting with the SAME file name?   

Google maintains file versions. I think that maybe AppSheet doesn't handle this well.  As if it gets the same file name and seeing it already has that file, discards the new version sent thinking its not needed.

If you have Server Caching ON, try turning it off to see if the problem resolves.

I have ALWAYS created a NEW file with a different name and therefore never run into this issue.

0 Likes

Posted on --/--/---- --:-- AM
LeviP
Bronze 3
Bronze 3
In response to WillowMobileSys
Reply posted on --/--/---- --:-- AM

Thanks, I already solved it with this thread
https://www.googlecloudcommunity.com/gc/Tips-Tricks/Open-a-file-action-get-current-not-cached-file/t...

it doesn't  need a new file

0 Likes

Posted on --/--/---- --:-- AM
LeviP
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

For me working here https://www.googlecloudcommunity.com/gc/Tips-Tricks/Open-a-file-action-get-current-not-cached-file/t...

[Name]  & "&" & UNIQUEID()

0 Likes
Top Labels in this Space