Adding Fields within a sentence in Checkbox Field

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I have terms and conditions setup in my app that are checkboxes and want to be able to add fields within the sentences for the terms and conditions to be customized.  For example I have a term checkbox that says "Items must be submitted by this date in order for product to arrive on time." I want the word "date" within that sentence to be a date field so a person can put whatever date they want in there within the terms and conditions checkbox field.  Is this possible at all?

{Checkbox} Items must be submitted by this {date field} in order for product to arrive on time.


Photo of Derek

Derek

  • 30 Points

Posted 4 years ago

  • 0
  • 1
No problem.

Make a formula text field.

"Items must be submitted by  " & ToText([my date field]) &  " in order for product to arrive on time."

The date will render in MM-DD-YYYY format.  If you want it turned into words, then that would require a bit more complicated formula.  ie to show as AUG-05-2015.





Photo of Derek

Derek

  • 30 Points
Thanks for the reply.  I want the text to be a checkbox with the date field listed in the middle of the text.  Is this done the same way just with a checkbox formula field?
Photo of Derek

Derek

  • 30 Points
Also I tried what you listed above by making a formula text field and name the field "Items must be submitted by  " & ToText([my date field]) &  " in order for product to arrive on time." but the date didn't render
The name of th field should just be Terms and Conditions.  What I gave you was the formula for the text field, not the name of the field.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
#1> " sentence in Checkbox Field "
#2> " I have a term checkbox that says"
#3> " I want the text to be a checkbox "
#4> " {Checkbox} Items must be submitted by this {date field} "

You have many references to "checkbox" but I am not understanding where this checkbox fits in your usage scenario and the formula Mark gave you bypasses any reference to a checkbox. So I don't think either of us understand how this checkbox appears on your form or what functionality it has. Can you elaborate on this?

Do you in fact want a checkbox to appear on the form with a label next to it where the label itself is the sentence with the date substituted. One way to answer these questions without a lot of back and forth dialog might be to create a screenshot of what you want the form to look like.