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.  [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: 

 

 

 

 Expression 

 Result 

 

 

 ( [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: No 

 Show in lists: Yes 

 Searchable: Yes 

 

 User interface 

 Field in show mode 

 

 Due to its nature this field has no special editing mode. 

 Configuration 

 

 [Description of configs] 

 Developer info 

 

 FeltTypeID: 82 

 SQL datatype: TEXT 

 Class name: FieldCalcConcatenate