Came across an interesting error. For some reason the order of text in a column is being jumbled around. For example, testing the column in the expression editor we get:
This is consistent with what is displayed in the app, and what is in the database. However, when we try to export this column into a PDF report we get the following:
It just flips the first half of the string. I’ve tried SUBSTITUTE on the quotation marks, TEXT_ICON, even CONCATENATE to add an extra character at the beginning, and I manually reconstructed the full string in the template, but I always end up with the flipped text.
I’m about out of easy ideas.
That’s weird. Let’s see some screenshots.
1 Like
I made a quick test with that value on an Email subject + with the GDoc template, and for me it works just fine.
Sure thing!
Here is the virtual column formula:
The result of that virtual column in the expression editor “Test”:
The data in the database:
The formatting in the DOCX template:
The PDF result:
I was able to get the formatting right if I slammed some additional text in front of it, like so:
I would prefer not to do that, since it just looks unprofessional and messy.
I tested this with just a normal text column. The difference here is also the template. You are using Word and my test uses gDocs. If you write the value directly on Email body field for example, does it work properly then?
Dumping the data straight into an email using an action or bot does format the text as expected.
I also went ahead and copied the template into a gDoc and now they are formatted correctly. Very strange that the DOCX template was causing the issue.
Very strange indeed.. maybe there was something wrong on that Word template. I have seen that now and then.
