Runway East — Make Scenario Build Map

What this scenario does

When the broker workflow creates a deal, it writes 7 complex values (dropdowns, a date, two multi-checkboxes) into single-line-text "Broker WF Helper" staging properties — the only type the workflow can set. This Make scenario reads those staging fields and back-fills the real typed properties, so the deal ends up fully structured for reporting and pricing.

Why there's no AI: the bot now sends valid HubSpot option internal values in the helper fields. So Make just parses the date and passes everything else straight through. Three modules, no AI credits.

Graceful by design: the staging text always stays on the deal. If a value is wrong or Make fails, the typed property blanks out but the raw value is still visible as a fallback — nothing is lost, and the reply email already went out independently.

HubSpot CRM — read the new deal, write the typed properties Tools — the one date conversion Make.com — the scenario wrapping it all

Trigger

New broker deal created (with 7 helper text fields populated)

▼

1HubSpot CRM · Watch Deals

Read the staging values off the new deal

Connection scopes: deals read + write (read-only 403s on the Update step)
Watch: Created deals · Limit 2 while testing · Parse Custom Fields: Yes
Output the 7 __broker_wf_helper fields + the deal Record ID
Polling trigger — only catches deals created after it starts; re-fire to test

staging values in hand

▼

2Tools · Set variable

Convert the move-in date text into a real date

move_in_date = parseDate(1.move_in_date__broker_wf_helper; "YYYY-MM-DD")
The only transform in the whole scenario
Confirm the helper actually holds ISO YYYY-MM-DD — the format string must match

date ready

▼

3HubSpot CRM · Update a Deal

Write all 7 typed properties back onto the same deal

Deal ID = {{1.hs_object_id}}
4 dropdowns + the date variable → mapped straight in
2 multi-checkboxes → the ;-separated string drops straight into the property (HubSpot's native storage format — no Iterator needed)
Add a Resume / Ignore error handler so one bad value can't fail the run

deal fully structured

▼

Done

Dropdowns, date & multi-checkboxes set · staging text retained as audit trail

Field mapping — 7 helper fields → typed properties

Helper field (Module 1 reads)	Typed property (Module 3 writes)	Type	Transform
`move_in_date__broker_wf_helper`	`move_date`	Date	parseDate
`rwe_location_interested_in__broker_wf_helper`	`location`	Dropdown	direct
`product_type__broker_wf_helper`	`type_of_membership`	Dropdown	direct
`current_office__product_type__broker_wf_helper`	`current_office___product_type__dropdown_`	Dropdown	direct
`current_office__notice__broker_wf_helper`	`current_office___notice_served_to_provider`	Dropdown	direct
`current_office__provider__broker_wf_helper`	`current_office___provider`	Multi-checkbox	passthrough `;`
`competitors_for_tours__broker_wf_helper`	`competitors_for_tours`	Multi-checkbox	passthrough `;`

Out of Make scope: nature_of_business (Multi-line text) and all Text / Number / Phone / Rich-text fields populate natively in the HubSpot workflow.

⚠ type_of_membership — internal value ≠ label on 3 options

HubSpot writes dropdowns by internal value, not the display label. The bot's helper field must carry the internal value, or these three blank out silently:

Deal Product Type (label)	Internal value the bot must send
Private Office	`Private Office`
Dedicated Desk	`Dedicated Desk`
Hotdesk	`Unlimited Hotdesk`
Hotdesk - 10 Day	`10 day Hotdesk`
Virtual Office	`Virtual Office`
Timeshare Private Office	`Time Share`
Day Pass Private Office	`Day Pass Private Office`
Self Contained Office	`Self Contained Office`

Allowed option values (copy exact from HubSpot — never retype)

current_office___product_type__dropdown_ Dropdown

Other FlexLease Hotdesk / All Access Product RemoteDon't knowOther

current_office___notice_served_to_provider Dropdown

YesNoDon't know

location Dropdown · 22 options

London BridgeSohoShoreditch FeatherstoneBorough MarketAldgate East BloomsburyWardourBorough High Street Covent GardenTottenham Court RoadCorinthian Queen SquareTemple MeadsBristol Bridge BathBirminghamBrighton MoorgateFinsbury ParkSoho ExtraOther

current_office___provider · competitors_for_tours Multi-checkbox · ~53 · shared list · ; separated

WeWorkUncommon (Uncommon)Regus Us&CoLandmarkWorkspace Group Boutique WorkplaceWork LifeFora BEOfficesBruntwoodOrega HuckletreeClockwiseSpaces ColonyImpact WorkingDesk Lodge LABSHQbyRegusArgyll MindspaceOffice Space in Town (OSIT)X+Why The TramperySoho Works …53 total Don't knowOther

Note: Mindspace IS a valid option on the real account — the demo dropped it, the production filter must keep it.

Silent-fail traps — any mismatch blanks the write with no error

Uncommon (Uncommon) has a double space before the parenthesis.
Don't know apostrophe is curly in some options, straight in others — copy the exact character, never type it.
type_of_membership writes the internal value (Unlimited Hotdesk / 10 day Hotdesk / Time Share), not the label.
The current-office option is Hotdesk / All Access Product, not bare Hotdesk.
Every dropdown & checkbox is written by internal value, not display label.

Confirm bot-side before go-live

Bot emits type_of_membership internal values (not labels)
Sample payload sends current_office__product_type = "Flex / Serviced office" — not a valid option; should be Other Flex
Move-date helper holds ISO YYYY-MM-DD (drives the parseDate format)
location [HIDDEN] entries — internal value may differ from the label