Re: function/formula explanation

Gennady Vanin (Геннадий Ванин, Новосибирск) — Fri, 19 Oct 2012 02:56:40 GMT

cnorris135:
1.) substring(eval(eval((

2.) . != ""], 'concat(", ", .)'), ".."), 3)

substring(someString, 3) - takes substring starting from 3d one, i.e. truncates 2 first symbols

So, for example, the result of substring("123456789", 3) will be 3456789

[.!= ""] means that previous fields in parenthesis are evaluated under condition (filtered) that the current field not blank

Double eval trick is explained in:

Email Submit "To" line (loops in formulas)

function/formula explanation

cnorris135 — Wed, 17 Oct 2012 20:28:07 GMT

awhile back I used this formula / function explanation... but i never fully understood it and would like to now....

my field names are in the middle of course but I was hoping to understand the beginning and the ending parts because i am trying to use this again(with a lot more fields)..... But i keep getting an error that the field is not found.......

1.) substring(eval(eval((

2.) . != ""], 'concat(", ", .)'), ".."), 3)

chris

Browser Forms

Re: function/formula explanation

Email Submit "To" line (loops in formulas)

function/formula explanation