Expression for bot-generated PDF's name

AppSheet AppSheet Q&A
,
1

Hi there appland,

I hope everyone is well. I am struggling with an expression, I am sure it will something obvious which will make me embarrassed.

I have created a bot to generate a PDF when something gets edited, and I have created the following expression for the file name:

CONCATENATE (“RM23”,“-”,[Stage #], " " ,[LEAVING COUNTRY], " to ",[ENTERING COUNTRY])

It worked for the first 2 or 3 entries and then files started being named as “AppSheetDoc” instead.

I have another bot which is working perfectly and the expression is:

CONCATENATE (“RM23”,“-”,[Stage #], " " , [Start], " to " ,[Finish])

Unless I am missing something here both expressions are structured exactly like each other.

Any ideas what I could be doing wrong?

Thank you!

2

The same way it had mysteriously stopped working, it is now working again. Problem solved, not the mistery.

Thanks!

3

From a Bot Try this idea:

BOT.jpg
BOT.jpg870×570 65.6 KB

4

Why are you doing this:

“RM23”,“-”,[Stage #]

When you could just do this:

“RM23-”,[Stage #]

?

1 Like
5

@TedM wrote:

“RM23-”,[Stage #]

You are correct

6

@Izzat_Safrah

@TedM

I think it must be an IQ issue :joy: it is so obvious now that you mentioned it. @Izzat_Safrah I had done just that, it worked for a few minutes and then it didn’t for a few hours. Then it did again. Now that the 2 of you pointed it out I have quite a few expressions to simplify across a handful of apps.

Thank you very much!