Best way to display fields side by side….
DOB Age
When I use concat it gets messed up because one is a date and one is a number.
Is there a better way to write a record script to simple display fields side by side for viewing?
I’m sure there is.
Thanks,
Well with a Calculation field you can use the DATE() function to format the date however you’d like. So I’m not sure why it screws up the format to have them side by side.
Make sure the return type of the field is set to “text”, calculation fields default to “number” but CONCAT returns text.
The other item on iOS is to make sure that you’re using the quote button from above the keyboard. If you use the keyboard quotes then you will insert smart quotes and the calculation evaluation will fail. I learned that one the hard way.
Attached a screenshot of something that worked for me on the Mac.
Attachments:
You must be
logged in to view attached files.
Nice, thank you. I get it.
You can also tap-and-hold on the quote button on iOS to choose straight quotes. Not sure why it defaults to curly quotes or how to change that behaviour.
.
