Forum Discussion
AustinK
6 years agoQrew Commander
Could you embed the screenshots rather than posting a pdf? You should be basically able to copy and paste them into the post. Also if you post your code as text then people can edit and view it easier.
DavidMcFadyen
6 years agoQrew Member
Austin,
Thanks for the tips. Below is the field displaying and the code.
Field on form
Code
If([Payment Breakdown Choice] = "10,20,30,30,10",
"<table cellspacing=30>" &
"<tr><td>" & "<b>" & "10%" & "</b>" & "</td>" & "<td style='text-decoration: underline'>" & "<b>" & [10% Due Upon (Various)] & "</b>" & "</td>" & "<td>" & "due upon acceptance of proposal" & "</td> </tr><br /><br />" &
"<tr><td>" & "<b>" & "20%" & "</b>" & "</td>" & "<td style='text-decoration: underline'>" & "<b>" & [20% Due to Initiate] & "</td>" & "<td>" & "due to initiate project construction." & "</td> </tr><br /><br />" &
"<tr><td>" & "<b>" & "30%" & "</b>" & "</td>" & "<td style='text-decoration: underline'>" & "<b>" & [30% Due at 50%] & "</td>" & "<td>" & "due upon completion of 50% of the project construction." & "</td> </tr><br /><br />" &
"<tr><td>" & "<b>" & "30%" & "</b>" & "</td>" & "<td style='text-decoration: underline'>" & "<b>" & [30% Due at 90%] & "</td>" & "<td>" & "due upon completion of 90% of the project construction." & "</td> </tr><br /><br />" &
"<tr><td>" & "<b>" & "10%" & "</b>" & "</td>" & "<td style='text-decoration: underline'>" & "<b>" & [10% Due Upon (Various)] & "</td>" & "<td>" & "due upon project completion and approval/acceptance by the Owner." & "</td> </tr><br /><br />" &
"</table>", "This is a test.")
------------------------------
David McFadyen
------------------------------
Thanks for the tips. Below is the field displaying and the code.
Field on form
Code
If([Payment Breakdown Choice] = "10,20,30,30,10",
"<table cellspacing=30>" &
"<tr><td>" & "<b>" & "10%" & "</b>" & "</td>" & "<td style='text-decoration: underline'>" & "<b>" & [10% Due Upon (Various)] & "</b>" & "</td>" & "<td>" & "due upon acceptance of proposal" & "</td> </tr><br /><br />" &
"<tr><td>" & "<b>" & "20%" & "</b>" & "</td>" & "<td style='text-decoration: underline'>" & "<b>" & [20% Due to Initiate] & "</td>" & "<td>" & "due to initiate project construction." & "</td> </tr><br /><br />" &
"<tr><td>" & "<b>" & "30%" & "</b>" & "</td>" & "<td style='text-decoration: underline'>" & "<b>" & [30% Due at 50%] & "</td>" & "<td>" & "due upon completion of 50% of the project construction." & "</td> </tr><br /><br />" &
"<tr><td>" & "<b>" & "30%" & "</b>" & "</td>" & "<td style='text-decoration: underline'>" & "<b>" & [30% Due at 90%] & "</td>" & "<td>" & "due upon completion of 90% of the project construction." & "</td> </tr><br /><br />" &
"<tr><td>" & "<b>" & "10%" & "</b>" & "</td>" & "<td style='text-decoration: underline'>" & "<b>" & [10% Due Upon (Various)] & "</td>" & "<td>" & "due upon project completion and approval/acceptance by the Owner." & "</td> </tr><br /><br />" &
"</table>", "This is a test.")
------------------------------
David McFadyen
------------------------------