@RandyHayes
I have an app that I need to email a PDF version of the form out to the user, I have built the HTML however I am stumped how to get the value into the HTMLText.
I have this in my html text
<tr>
<td>Crews Needed:</td>
<td><strong>" & Form1.LastSubmit.'Crews Needed'.Value & "</strong></td>
</tr>
However I get a red underline for the .Value and error message says it wants
I dont know how to fix this.
Solved! Go to Solution.
@Dorinda
Change your formula to the following:
<tr>
<td>Crews Needed:</td>
<td><strong>" & With({_crews:Concat(Form1.LastSubmit.'Crews Needed', Value & ", ")}, Left(_crews, Len(_crews, 2)) & "</strong></td>
</tr>
The With part of this is only there to help cut of the trailing ", " on the concatenated list of values.
Sorry, was typing too fast...
<tr>
<td>Crews Needed:</td>
<td><strong>" & With({_crews:Concat(Form1.LastSubmit.'Crews Needed', Value & ", ")}, Left(_crews, Len(_crews) - 2)) & "</strong></td>
</tr>
What kind of column is 'Crews Needed'? I am imagining that (based on the name) that it perhaps is a multi-value choice column, or a multi-record lookup.
Please clarify.
It is a multi-choice column
@Dorinda
Change your formula to the following:
<tr>
<td>Crews Needed:</td>
<td><strong>" & With({_crews:Concat(Form1.LastSubmit.'Crews Needed', Value & ", ")}, Left(_crews, Len(_crews, 2)) & "</strong></td>
</tr>
The With part of this is only there to help cut of the trailing ", " on the concatenated list of values.
I get this error
Sorry, was typing too fast...
<tr>
<td>Crews Needed:</td>
<td><strong>" & With({_crews:Concat(Form1.LastSubmit.'Crews Needed', Value & ", ")}, Left(_crews, Len(_crews) - 2)) & "</strong></td>
</tr>
You once again come to my rescue!!! Thank you!!
No problem. And I have your other email on my list to respond shortly.
User | Count |
---|---|
255 | |
106 | |
85 | |
51 | |
43 |