Not signed in (Sign In)

Vanilla 1.1.5a is a product of Lussumo. More Information: Documentation, Community Support.

Support Requests: formula for "is blank/null"

Bottom of Page

1 to 2 of 2

  1.  
  1.  
    I'm trying to create a formula for the salesforce connector where I want to create a new record but only if a certain field is blank. I've looked here (http://www3.formassembly.com/blog/support-documentation/managing-your-forms/using-formulas/) and taken some guesses, but can't figure out how to make a condition to determine if a field has any value in it. I want to say "But skip this step if... @ISNULL(%%tfa_fieldname%%)" or something like that. Anyone know?
    • CommentAuthordbuschho
    • CommentTimeOct 11th 2011
     
    Hello,

    We've resolved this from your request in the support queue, but for anyone else who comes across this issue:

    You'll want to try something like:
    @IF(%%tfa_id%%,"FALSE","TRUE")
    which says:
    If field with id "tfa_id" is *not* empty, return "FALSE", otherwise return "TRUE".
    This means it should skip any time the field is empty.

    Happy to help further,
    Drew
    FormAssembly.com Support

1 to 2 of 2

  1.