Skip to main content

Calc: Concatenate

Making a text based on values from other fields.

The field supports a basic version of Complex formulas as of version 6144, the last and innermost formula i calculated first. The separators ? and : has to have a space on both sides!

Supported comparisons and mathematics:

  • One level of math, eg. [DESCRIPTION]FIELDX] + [FIELDY] == [FIELDZ] + [FIELDQ]
  • Supported mathematics are: plus, minus, divide, multiply and modulus
  • Supported number comparators are: equal (= or ==), unequal (!=), less than (<), greater than (>), less than or equal (<=) and greater than or equal (>=)
  • Supported text comparators are: equal (= or ==) and unequal (!=)

Samples of basic formulas:

ExpressionResult
( [FIELDX] > [FIELDY] ? X ([FIELDX]) is greater : Y ([FIELDY]) is greater )Given that the value of both fields are numbers (int or float), and FIELDX has a greater value.

The result would be: X ([FIELDX]) is greater, where [FIELDX] would be replaced with the value of the field

( [RADIO] = Yes ? User accepted : User didn't accept )Given that [RADIO] is a FieldNumberBoolean and the TRUE value has been set to "Yes", if the user selects it.

The result would be: User accepted

(
    [PROVIDER] = IMDB
    ? <a href="https://www.imdb.com/title/[ID]/">Link to IMDB<a/>
    : (
        [PROVIDER] = TheMovieDB
        ? <a href="https://www.themoviedb.org/movie/[ID]">Link to TheMovieDB<a/>
        : Unknown provider
    )
)
This is an example of two nested formulas, enabling comparison of an element against multiple values.

Given that [PROVIDER] is a string value (text, dropdown, etc), [ID] could be anything.

If provider equals "IMDB" a link to IMDB would show up, and the ID would be input.

If provider equals "TheMovieDB" a link to TheMovieDB would show up, and the ID would be input.

( [ACCEPT] != YES ? <a href=\"https://acme.com?( [X] > [Y] ? test1 : test2 )\">Link</a> : <a href=\"https://acme.net?( [X] < [Y] ? test1 : test2 )\">Link</a> )This is just an example of nesting.

Properties

  • Type: Complex
  • Groupable: [YES/NO]No
  • Show in lists: [YES/NO]Yes
  • Searchable: [YES/NO]Yes

User interface

Field in show mode

[INSERT IMAGE]image.png

FieldDue into editits mode

nature

[INSERTthis IMAGE]field has no special editing mode.

Configuration

[INSERT IMAGE]image.png

[EventuelDescription beskrivelse afof configs]

Developer info

  • FeltTypeID: 82
  • SQL datatype: TEXT
  • Class name: FieldCalcConcatenate
Back to top