0

Two referenced fields in one field and filtering contacts from one company

Apologies if these have already been asked, but I want to take the first name and last name of a contact table and insert them into one field of another table. I have tried dragging and dropping them but this gives me the two names with no spaces ('First Name' + 'Last Name'). What do I need to add to the formula to include a space between the two names?

Secondly, but related to the above, how can I filter a form so that when I add a company to a sales form (from a referenced company table), it will only show me a list of contacts (from a referenced contact form) I can choose that are employed by the referenced company.

Hopefully this makes sense and many thanks in advance.

4 replies

null
    • Nick
    • 5 yrs ago
    • Reported - view

    The formula sould be:

    'First Name' + " " + 'Last Name'

    • davidw
    • 5 yrs ago
    • Reported - view

    Hi Nick,

    Thanks for the reply, amazing how easy these things are when you know what you are doing:)

    Any thoughts on my other question?

    • Nick
    • 5 yrs ago
    • Reported - view

    If I undertand you correcltly look here:

    https://ninoxdb.de/en/manual/tables/table-references-and-relations

    and the chapter: Constraints

    • davidw
    • 5 yrs ago
    • Reported - view

    Hi Nick,

    Thanks for the link I have it working now.

Content aside

  • 5 yrs agoLast active
  • 4Replies
  • 1508Views