I want to always add a dollar sign to the beginning of my Cost input on a card. I tried to do this:
$%cost% as an input formula, but it returned a $ before every character. so I get this: $1$.$5$0 instead of $1.50. Is there a way to do this simply?
does something like "$"& work. In that you want text of a dollar sign concatenated with the cost variable that is pulled through?
Tried this, It just added "$"& between every character.
If you're entering the cost, can't you just type in $1.50 as the value and leave it at that? How are you using an Input Formula to enter cost? Using a $Cost in an Input Formula worked find for me. Screen shot below shows the data card editor with the actual data card to the left. I entered 1.50 in the Cost field and it updated the Cost 2 field via Input Formula just fine.
I was using an input formula simply to add the dollar sign, and yes typing in a dollar sign should be easy enough, but unfortunately, it doesn't always happen that way. you have cost in the cost 2 input formula, add cost 2 in the cost 2 input formula and you would get the same issue.
Best I came up with was to just add a $ sign to cost field by default and hope it reminds everyone to add the dollar sign.
You got me there. I've never used an Input Formula against the the same variable it's set on. Good luck to you
If you are wanting to use this value for calculations later, I think it best to leave the dollar sign off. Maybe add a label that the value is in dollars or if you have mixed currency units add a drop down with what currency it represents. That would future proof it in case you ever want to extract those values and perform math operators on them later.
Retrieving data ...