How to apply Multiple IF condition across data bundle during every single workflow trigger

Screenshot 1 at below is the google sheet that represent our source of data. Bundle 1 to Bundle 5 are the line items that I need to create Xero Invoice for. However, Bundle 6 data to Bundle 10 data are the line items that I need to create another separate Xero Invoice For.

Here’s my requirement and any great suggestion over the function available in Make.com can be recommended?
Requirement: I need to create Xero invoice which the account code varies according to the description on each data bundle.

  • Bundle 6 data’s account code in Xero Invoice suppose to depends on Bundle 1 Data description. If the description comes with “Shell V-Power 97 BULK”, the account code is “9O00/S01”.
  • Bundle 7 data’s account code in Xero Invoice suppose to depends on Bundle 2 Data description. If the description comes with “Shell FuelSave Unleaded 95 BULK”, the account code is “9O00/S02”.
  • Bundle 8 data’s account code in Xero Invoice suppose to depends on Bundle 3 Data description. If the description comes with “Shell FuelSave Unleaded 95 BULK”, the account code is “9O00/S02”.
  • follows the rule at the above.

In such a case, any function or modules in make.com that i can apply in order to achive the above requirement?


@Keng_Foo

Try with aggregate all input data and sort-out using bundle order number for each case (within the filter use accordingly).

If you require additional assistance, please don’t hesitate to reach out to us.

MSquare Support | Book Live Implementation
Visit us here
Youtube Channel

  • Msquare
2 Likes