What is your goal?
Derive a Domain value (Art, Design, or Education) from a Dropbox filename using a text-search function inside Tools → Set multiple variables, and pass it to a Notion select field.
What is the problem & what have you tried?
Inside Tools → Set multiple variables, if(“DESIGN” = “DESIGN”; “Design”; “No match”) returns “Design” correctly. But if(contains(“SR_DESIGN_Test_129.png”; “DESIGN”); “Design”; “No match”) returns “No match”, and indexOf(“SR_DESIGN_Test_132.png”; “DESIGN”) returns −1. Both formulas were built using Make’s function panel as grey pills, not typed or pasted. The pipeline runs without errors. The issue is specific to text-search functions.
Error messages or input/output bundles
Notion RuntimeError: body.properties.Domain.select.id should be defined, instead was ‘undefined’ — caused by −1 being passed as the Domain value.
Screenshots (scenario flow, module settings, errors)
Hey there,
“DESIGN” and DESIGN are two different text strings. Ditch the quotation marks.
Thanks Stoyan — that resolved the domain question completely! All three values (Art, Design, Education) are now writing to Notion correctly.
I have a follow-up question for you or anyone else who can help, if you don’t mind.
Goal
We are building a Dropbox → Make → Notion intake pipeline. Filenames follow this convention:
SR_Art_Test_221.png
We want Notion to receive a clean numeric Project ID — 221 — not the full final token 221.png.
What we have achieved
This formula inside Tools → Set multiple variables successfully extracts the final filename token:
get( split( [File Name chip] ; _ ) ; 4 )
This returns 221.png correctly.
What we have not been able to achieve
Stripping the .png extension to leave only 221.
We tried building this nested formula:
get( split( get( split( [chip] ; _ ) ; 4 ) ; . ) ; 1 )
The logic is correct but we could not construct it reliably in Make’s formula editor. The outer pills kept sitting beside rather than nesting inside each other.
We also tried replace() but could not get it to evaluate rather than pass through as text.
I am on a plan that does not allow variables from one item in Set multiple variables to be referenced in another item of the same module.
Questions
- What is the correct way to build the nested get/split formula in Make’s editor?
- Is there a simpler function — replace() or similar — that strips a file extension cleanly from a string like 221.png?
- If neither works inside Set multiple variables, is there another module that would handle this more reliably?
Thank you very much in advance again, William
That is the correct formula.
Make sure you have the cursor in the correct place inside the each function when selecting them from the menu. The UI likes to reset it at the end of the function and leaving them side by side instead of nesting them.
Or type the functions manually, should also work.
Thank you very much Stoyan. You were absolutely precisely right both times 
