Skip to main content
Question

New Form Field Error - There are extra characters beyond the end of the formula

  • October 23, 2023
  • 0 replies
  • 119 views
Forum|alt.badge.img+5

I am trying to create a rich text field to put in the form that shows what the current value is in another field. This doesn't work directly in the new form. Instead, I am building a formula rich text field that I will then add to the field. I am getting an error that I'm not sure how to get around: There are extra characters beyond the end of the formula. Thoughts?

"Current State is" ToText([state])". Current Target Completion Date is" [target completion date]"."



------------------------------
Elizabeth Schlagel
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+9
    • ChayceDuncan
    • Quickbase Alumni
    • October 23, 2023

    Since you're combining strings you need to put & between the different components so QB knows to combine them properly. 

    See below: 

    "Current State is" & ToText([state]) & ". Current Target Completion Date is" & [target completion date] & "."



    ------------------------------
    Chayce Duncan
    ------------------------------
    Terms & ConditionsAccessibility statement