Solving Splitting Categories Issue in Notion for Make.com Users

Have you ever tried to split different categories from a Google Sheets input and put it on Notion, only to be told that it's a string? Well, you're not alone. This is a common issue that many Make.com users face. But don't worry, there's a solution to this problem.

Understanding the Problem

The issue arises when you try to use the split() function on a field that is supposed to be text. The split() function creates an array, which can cause problems if the field you're trying to split is not set up to handle arrays.

The Solution

The solution to this problem is surprisingly simple. All you need to do is change the field in Notion from a select field to a multi-select field. This allows Notion to handle the array that the split() function creates.

Step-by-Step Guide

  1. Go to your Notion page and find the field that you're trying to split.
  2. Change the field from a select field to a multi-select field.
  3. Try using the split() function again. It should now work without any issues.

Troubleshooting Tips

If you're still having issues after changing the field to a multi-select field, try the following:

  • Double-check that you've changed the correct field.
  • Make sure that you're using the split() function correctly.
  • Try restarting Notion and trying again.

Conclusion

In conclusion, the issue of not being able to split different categories from a Google Sheets input and put it on Notion can be easily solved by changing the field in Notion from a select field to a multi-select field. This allows Notion to handle the array that the split() function creates, solving the problem. So next time you run into this issue, remember this simple solution and save yourself some time and frustration.

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.