I have columns and I want to email the column name plus the value in the column. How can I get the value of the column?
[first name] = "John"
[last name] = "Doe"
I want to create an action button to email. The email will include the following...
firstname John
lastname Doe
app formula in the body of email
concatenate([?], [firstname], [?], [lastname]])
Solved! Go to Solution.
As @Steve said, you can't get the column name.
You will need to type it by yourself. It can be:
first name: <<[firstName]>>
last name: <<[lastName]>>
or, if you need to insert a line break n your expression:
<<CONCATENATE("first name: ", [firstName],"
last name: ", [lastName])>>
There is no way to get the column name using an expression. It's not clear why you'd want to.
When creating an email, I want to include the column name along with the column value.
I can retrieve the value but not the column name associated with it.
As @Steve said, you can't get the column name.
You will need to type it by yourself. It can be:
first name: <<[firstName]>>
last name: <<[lastName]>>
or, if you need to insert a line break n your expression:
<<CONCATENATE("first name: ", [firstName],"
last name: ", [lastName])>>
User | Count |
---|---|
43 | |
26 | |
23 | |
16 | |
12 |