Jump to content

Wikiwi

Caspio Guru
  • Posts

    116
  • Joined

  • Last visited

  • Days Won

    12

Community Answers

  1. Wikiwi's post in Is there a way to populate multiple, Yes or No filed using a comma-delimited string? was marked as the answer   
    If you're looking for a trigger solution then you can use this.

    The trigger above will take your comma-delimited string and check for a "substirng" (in this case one of your choices) if it's in that string. If it did find the specific value then it will return a 1 which is greater than 0 causing the condition to set the value for that Yes/No field to True.
  2. Wikiwi's post in Can I remove blank fields on my notification email? was marked as the answer   
    You can create a virtual field on your submission form and use a bit of script just like below:
    COALESCE('Item1: '+NULLIF('[@field:item1]','')+'<br/>', '')+
    COALESCE('Item2: '+NULLIF('[@field:item2]','')+'<br/>', '')+
    COALESCE('Item3: '+NULLIF('[@field:item3]','')+'<br/>', '')+
    COALESCE('Item4: '+NULLIF('[@field:item4]','')+'<br/>', '')+
    COALESCE('Item5: '+NULLIF('[@field:item5]',''),'')
    This will remove all fields that doesn't contain any values. Once that is done, go to your email notification at the end of the DataPage configuration and put the Virtualfield in body. Don't forget to set it to HTML for the '<br/>' to work. This setting will show 1 field or item per line. If you want to show every item in one line then change <br/> to space or comma.

×
×
  • Create New...