Question

Cal.com to Notion - Dropdown text number to dollar amount

  • 21 March 2024
  • 3 replies
  • 10 views

Hello,

I’m trying to create a lead workflow 
1. Cal.com meeting set up
2. Notion database item added
--- Works well until here

I want to have the budget dropdown populate the
# Deal Amount as a number so we can filter and do anything we need with it, rather than text be based. I’ve tried automating it with the AI but I can’t get it to populate the number field. 
 

 

 

Any suggestions?

Thanks!
Arnau

 


3 replies

Userlevel 7
Badge +14

Hi @arnau from macu 

To help us have more context, post screenshots with how the steps are outlined and configured in EDIT mode so we can see the field types and field descriptions.

Hi,

Thank you
this is the screenshot

Do you see anything that would cause it to not work?
 

 

Userlevel 7
Badge +14

@arnau from macu 

The provided Input is not a number (it’s a string of text) for the Zap step: Formatter > Numbers > Format Number

 

You may want to try using a lookup table instead to translate the text string to a number.

 

Reply