6/24/2023 0 Comments Notion vs airtable![]() However, it can be less intuitive to use than Notion. ![]() On the other hand, Airtable has proven to be more flexible and scalable, particularly when it comes to building and managing databases. But, how to choose the right tool for your business?Īs someone who has used both Airtable and Notion for various purposes, including team management, blog content calendar planning, and database management, I have found that both tools have their strengths and weaknesses.įor example, I have found that Notion is great for creating and organizing notes, tasks, and wikis, but sometimes falls short when it comes to scaling and integrating with other tools. Notion, on the other hand, is a customizable workspace that lets users create and manage a wide range of information, including notes, tasks, wikis, and databases. Airtable is a flexible database platform that allows users to create and organize information in a variety of ways, including using custom views and fields. I changed it to text and it worked, but might be something to look into.Airtable and Notion are two powerful tools that are designed to help users organize and manage their data and projects. One thing that I though was weird though was that even sending data as a number (came from sheets in that format and I selected option to maintain the formatting) notion did not identify it as number (would give me an error message). On that one I did a VLookup to SHEET#2 using the value from SHEET#1 as reference (example: SHEET#3!F1 = VLOOKUP(SHEET#1F1, SHEET#2!A:B, 2, FALSE)).Īnd then I would use the google sheets node on N8N to read the data from the spreadsheet on SHEET#3, which would already be in the correct structure to send to the notion node. Since I don’t know JS and I code like a 7-year-old, I preferred to send my data using the google sheets node to a SHEET#1, placed the Name and respective ID in SHEET#2 and then on SHEET#3 I made all the cells the same as SHEET#1 (example: SHEET#3!A1 = SHEET#1!A1) except for the column where I needed the select. ![]() So first I used the Notion node to get the ID for each item I wanted to add. Since I had one column that needed to be a select (because it was my GroupBy item for my board), it was necessary to transform the data. Just leaving my contribution to whoever has a similar problem. The data needs to be sent as field:, which is btw, the way Notion returns the data. Let’s say you have two possible options: option1 and option2. You do not need to send a string but an array of strings. ![]() Is it possible to send all such values as a string? In the future, all nodes with different field types (like Airtable) will work as the Notion node. We introduced this functionality with the Notion node. Unfortunately, it’s not the case because when we created the Airtable node, we did not have the possibility to create the fields “dynamically” depending on the type. In the example below, I had a multi_select field in Notion called “multi_select” and wanted to map that to a multi_select field called Category1 in Airtable.īut agree with you. If the names are different, then you need a set node to rename the field. As long as the multi_select field has the same name in Notion and Airtable, no modification it’s needed. Unlike the Notion node, the Airtable node needs the data you want to insert passed in the input.
0 Comments
Leave a Reply. |