Change file location

[StaniP]

Hello again!
With my App I first create a Quotation and on the second step an Offer.
Each is exported as a PDF with a bot.

I would like to store the Quotation in the same folder as the Offer, because there is always 1 offer for one or multiple Quotations.

My issue is, that Quotations are (as per timeline) created first and have to be stored in an own folder. 
So I need to somehow move them to the right one.


I managed to retrieve the path for an Offer related to the Quotation if an Offer exists.

IF(
IN([Quote ID], [Related Offers By Quote 1 Reference][Quote 1 Reference]),
CONCATENATE(
"appsheet/data/LAMDAAPP-889656166/OFFERS/",
[Customer ID],
"/",
"OFFER_",
TEXT([Related Offers By Quote 1 Reference][Offer ID]),
"_",
TEXT([Related Offers By Quote 1 Reference][Customer ID])
),
""
)

can I move the file somehow? Webhook? If yes, how?

[KON_TROLL · Accepted solution]

We do this, but not in Appsheet. Google App Script has solutions for this, and can be used in combination with a BOT/WEBHOOK as Appsheet has an integration for this. 

See here: https://support.google.com/appsheet/answer/11997142?hl=en