cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Automation Master
Automation Master

Conditional text calculation for Office 365

Jump to solution

Hi all, with the Salesforce DocGen action, formulas can be used as per this help article.  The article leverages MS Word, quick parts and formula builders to generate conditional text.

Is the same thing possible using the Drawloop action in Nintex for o365?  I've tried but the field codes don't seem to be recognised.

I've tried writing a formula just to display the contents of the variable as a basic test and that fails.  My conditional statement (IF formula) also fails - always evaluating to false.  By way of example, here's my IF statement: =IF <<varQty>> > 5 "This is a large quantity" "This is a small quantity"

Cheers,

Chris

Tags (3)
Reply
4 Replies
Highlighted
Not applicable

Re: Conditional text calculation for Office 365

Jump to solution

Hi Chris,

It looks like the help article you are referencing is specific to a Word template. Excel templates are a bit difference. Below is documentation on using conditional text in an Excel template.

http://help.nintex.com/en-US/docgen/docservices/#Services/ConditionalTextExcel.htm?TocPath=Drawloop%...

Tagging your Excel template will be different than tagging a Word template. Below is documentation on how to tag an Excel template:

http://help.nintex.com/en-US/docgen/docservices/#Services/TaggingExcel.htm?TocPath=Drawloop%20Docume...

Essentially, you will rename the cell from A1 to varQty (no brackets around the tags for Excel templates).

You will then reference that cell in your formula.

If you do not want to have the value of the tag be visible you can put the tags on Sheet2, hide Sheet2, and have your formula on Sheet1. If you want to edit or remove a tag you will need to go to Formulas > Name Manager.

Please let us know if you have any additional questions.

- Haley Walsh

0 Kudos
Reply
Highlighted
Automation Master
Automation Master

Re: Conditional text calculation for Office 365

Jump to solution

Hi Haley,

Thanks for your response.  I am trying to get this going in Word, not Excel.  I think the help text was written for the Salesforce Drawloop and I'm not sure the same functionality exists for the Nintex Drawloop.  That, or I've done something wrong! :)

Cheers,

Chris

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Conditional text calculation for Office 365

Jump to solution

Hi Chris,

That capability hasn't been added to Nintex Workflow for Office 365. The Help you want for that product is here:

http://help.nintex.com/en-US/O365/Default.htm#cshid=2005

View solution in original post

0 Kudos
Reply
Highlighted
Automation Master
Automation Master

Re: Conditional text calculation for Office 365

Jump to solution

Thanks Tim.  Any hints as to when this feature might arrive for Nintex Workflow?

0 Kudos
Reply