0

I'm trying to concatenate text from one field, add a hard return, a couple dashes along with the text from a related field. Any recommendations on how best to accomplish this?

This is for a simple quote database. Figured it was an easy way to learn the basics of Ninox.

My syntax is wrong here and this doesn't work but not sure how to fix it:
'Text (multiline)' + '
-- ' + 'Author.Name'

3 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 4 yrs ago
    • Reported - view

    Maybe this will work:

    'Text (multiline)' + "
    -- " + 'Author.Name'

     

    single quotation marks are used for fieldnames, double are used for text.

    • Personal
    • Art
    • 4 yrs ago
    • Reported - view

    Thank you Steven. I didn't know that about single and double quotes.

    I still get an error, but it's different this time. 
    Current error with the text you shared:
    Field not found: Author.Name at Line 2 Column 20

    Do I need to close the formula with a semi colon or something?
    Thank you for your help!!

    • Personal
    • Art
    • 4 yrs ago
    • Reported - view

    I renamed the Text (multiline) field to Quotes and added single quotes around the field names but not the related table and got it to work. Thank you Steven for pointing me in the right direction. Here is the finished code:

    'Quote' + "
    -- " + Author.'Name'


Content aside

  • 4 yrs agoLast active
  • 3Replies
  • 2053Views