How can I match new values with a predefined list in Airtable using Make.com?

How To
, , , , , , , ,
1

I have a predefined list of programming languages stored in Airtable:

  1. C
  2. Java
  3. Python
  4. C++
  5. C#
  6. JavaScript
  7. PHP
  8. VB.NET
  9. R
  10. SQL
  11. Go
  12. Swift
  13. Perl
  14. Assembly language
  15. Ruby
  16. MATLAB
  17. Classic Visual Basic
  18. Apache Groovy
  19. Objective-C
  20. Rust
  21. SAS
  22. Scratch
  23. D
  24. Dart
  25. PL/SQL
  26. Logo
  27. Delphi
  28. COBOL
  29. Kotlin
  30. OpenEdge ABL
  31. Julia
  32. ABAP
  33. Scala
  34. Transact-SQL
  35. Scheme
  36. Prolog
  37. Ada
  38. Lisp
  39. Apex
  40. Lua
  41. Fortran
  42. Haskell
  43. Hack
  44. VBScript
  45. Visual FoxPro
  46. TypeScript
  47. AWK
  48. ActionScript
  49. Tcl
  50. Smalltalk

I have new values such as “Altium” and “Proteus” obtained from resumes. These values do not belong to the predefined list, so the output should be null. How can I achieve this using Set Variable or Filter in Make.com?

3

Hi,

If I understand your question correctly, you have a single-select/multi-select field with specific values. If the option on the resume is not listed, you want to use null.

You can achieve this in various ways.

Scalable Options:

  1. Create an Airtable Table with Values:
  • Create an Airtable table with the possible values and use the search module. If an item is not found, use “null”. This is the most scalable option, as you are storing possible options within Airtable. If any new language is added, you only have to add it to the table.
  1. Use Make’s Datastore and Sync with Airtable:
  • Store the values in Make’s datastore and sync it with Airtable using a second scenario.
  1. Use “Smart Links” Option in Create/Update Record Module:
  • When you have the “Smart Links” option in the create/update record module set to “no” (default option), you are not able to create a new option for multi-select. If that’s the only multi-select/single-select field in your project, you can benefit from it and use an error as your second route. This is the most advanced option because there could be potentially other errors, but it can save operations and Airtable’s API usage.

Less Scalable Options:

  1. Using Datastore Without Syncing:
  • In this case, when a new language is added, you have to add it into Make’s datastore manually.
  1. Using “Switch” Function Within Make:
  • Use the “Switch” function to handle different cases. This option is less scalable because you need to manually update the switch function for each new option.

Choose the method that best fits your project’s needs and constraints.

Have a nice day,
Michal

4

@mszymkowiak @Mr.Make Thank you for the answer. Could you please provide an example scenario for this? I’ve been trying to solve it for the past few days but haven’t been successful. Specifically, I’m looking to create a database in Airtable with predefined lists stored in a multiselect field. How can I set up a scenario for this in make.com?

6

Sorry, I do not provide private consultations on this forum.

Thanks for your understanding.