• DOCUMENTATION
  • WORKATO BLOG
  • PRODUCT BLOG
  • Return to Workato
  • Log in
  • ☰
  • Community/Discussions
New Topic
Discussions Recipe Building Formula Mode Questions
C

Catherine Meyrat

started a topic over 6 years ago
Answered

How To Convert 0 Quantity To 1

Hi ,

Salesforce Quote Line Item required minium 1 quantity.
As we already added a condition that if Quantity is not presetn in invoice line item then we use 1 as quantity in Quote Line Item.

But in some cases user put 0 in Invoice Line Item in QB, so how can we check quantity is 0 and if its 0 then convert it to 1.

See attached screen shot formula that we are using for quantity.


Best Answer
A
Adam Goh said over 6 years ago

Hi Catherine,

 

Yes that will be possible. What you'll be looking for is to have indented condition On the first true statement (after ?) You can have the second condition. The second condition you may use [Quantity] == '0' ? [Quantity] : 1
 It should look similar to this screenshot

 


 

This can be read as: "If JobID is present, check if JobID is equals to 4748. If yes, use 'statement is true', or 'statement is false1' if otherwise. If the jobID is not present use 'statement is false2'.


Cheers,

Adam Goh

Customer Success Team

Email : success@workato.com

Phone : +1 844 469 6752

Answer

Adam Goh

said over 6 years ago

Hi Catherine,

 

Yes that will be possible. What you'll be looking for is to have indented condition On the first true statement (after ?) You can have the second condition. The second condition you may use [Quantity] == '0' ? [Quantity] : 1
 It should look similar to this screenshot

 


 

This can be read as: "If JobID is present, check if JobID is equals to 4748. If yes, use 'statement is true', or 'statement is false1' if otherwise. If the jobID is not present use 'statement is false2'.


Cheers,

Adam Goh

Customer Success Team

Email : success@workato.com

Phone : +1 844 469 6752

Login to post a comment

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2020   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato
Topic views count