Mastering Array Output Limitation in Make.com

Problem: Limiting Array Output and Dealing with Auto-Conversion of 'if'

Recently, I came across a couple of challenges while working on Make.com. The first one was about limiting the output of an array or collection to a certain number of results. The second issue was about the auto-conversion of 'if' to a Make.com function, which was causing problems while trying to create a Google Sheets formula.

Solution: Using Slice Function and Various Workarounds

Limiting Array Output

To limit the results of an array or collection, you can use the 'slice' function. This function returns a new array containing only selected items. The first item in the array has an index of 0. The syntax is as follows:

slice(array; start; [end])

For example, if you want the first five items, you can use:

slice(array; 0; 5)

Dealing with Auto-Conversion of 'if'

There are several ways to deal with the auto-conversion of 'if' to a Make.com function:

  1. Type the formula somewhere else first, like a text editor program or the browser address bar, then copy and paste into the field.
  2. Use a text expansion program to replace something you've typed with the actual text you want to use. For example, you can set up 'ifx' or 'if!' as a shortcut so when you type that, it will replace it with 'if('.
  3. Type a space before the opening bracket, then type the '(', before deleting the space.

Conclusion

In conclusion, the 'slice' function can be used to limit the output of an array or collection, and there are several workarounds to deal with the auto-conversion of 'if' to a Make.com function. I hope these solutions will be helpful to other Make.com users facing similar challenges.

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.