Hi,
I have an expression of a conditional concatenation that if true returns a string but Appsheet turn this string into a date which produce an error. Here is a screenshot of the situation :
Normal :
Observations :
Any idea how to prevent this ? I had to search so long just for that . For now I will just modify all the texts to prevent Appsheet to transform into a date.
Thanks for any input. Best regards, Mic
Solved! Go to Solution.
That’s a way !
For now I added a “p” in the string (“p10-20”) and changed the other formula accordingly.
Thanks for your input. Mic
May be not very elegant , but for those strings that get converted to date, you could use another concatenate statement such as
CONCATENATE(“10-”,“20”)
That’s a way !
For now I added a “p” in the string (“p10-20”) and changed the other formula accordingly.
Thanks for your input. Mic
Nice. Got it. You are welcome. Yes , there are many times different interesting approaches to solve a problem.
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |