Convert to text

[Betti]

Hi,

I have a formula. I want to convert this to text so that the name of the generated PDF is not perceived as a date, but as a continuous text. For example UID.

[Aurelien]

Hi @Betti 

In your expression, you may want to replace:

YEAR(TODAY())

With:

TEXT(TODAY(),"yyyy")

For reference:

TEXT() - AppSheet Help

[Betti]

@Aurelien 

Not working 😞 

@Steve 

If I enter the formula with a date, it splits it into folders in the drive. In this case, there will be a "M" subfolder within the main Folder, within that the YEAR folder (2024) and even within that the file named only with a number.
Need for me the file name should be is : "M/2024/1"

[Aurelien · Accepted solution]

---

@Betti wrote:

Need for me the file name should be is : "M/2024/1"

---

This can't happen. Any slash will create a subfolder.

You may want to replace it with an underscore.

[Betti]

I will try. Thank you for your help 🌺

[Betti]

one more question about this. If I leave it like that, how do I specify the PDF file formula so that it finds the document through the subfolder?
Right now, I'm saving generate files with UID, and this is what's currently set:

[Aurelien]

Basically you need to store the relative path to your file, from your default file folder.

Your expression looks fine to me.

I would suggest to read through a blog article I made a while ago, describing step by step how to do this (you will need to use a translator though): Google AppSheet Automation: Create and retrieve a PDF file

[Betti]

Thank you, I think I'll need it.
I hope you can help me with this other question. If I create an action by copying data to another table, how can I copy the uploaded PDF file from the main table so it opens in the other table as well?

[Aurelien]

This is the last question: I suggest you open another thread for the future 🙂

The relative path from your default app folder to your PDF file won't change, so you can simply copy it.

[Steve]

Please rephrase your request as it currently makes no sense. Your expression already produces a text result. Where or how is it "perceived as a date"? What is "continuous text"? How is "UID" an example?