How to search in Monday.com by column? (Monday and callin.io)

Hello,

Welcome to the community

In your board, are you not using the same column name for the contact number? I haven't used Monday.com, but would something like the below work for you?

image448×636 26.9 KB

In theory, that should search a specific column for a value. The only tricky part from there would be whether you are storing the 164 number or a different format?

Hello Jon !

Thank you for the warm welcome!

So, I need to retrieve it.

CleanShot 2022-09-23 at 17.34.20@2x948×1462 66.4 KB

And then, by using the column ID, will it find it?
But what if I have many boards with different IDs for the Telephone column? Do I need to process each board individually?

Thank you!

Hey @HBS_France,

Yeah if you have multiple boards you would need to have multiple nodes to cover each one, I am not sure if the Monday.com api has a generic option to make it easier. What did the same process look like in Make? It could be that the HTTP Request node has to be used with the API “manually” to work it out.

Hello!

In callin.io, it operated on a board-by-board basis.

However, how can I proceed from this point? I'm honestly not accustomed to this. Where should I place the column, and how should I handle the 'Get data' step? Apologies for all these questions; I'm quite lost, and callin.io is very different from anything I've used before.

CleanShot 2022-09-23 at 17.58.53@2x772×1186 163 KB

Greetings!

Please provide the rewritten markdown content *it should be in the markdown format.

Hey,

Try using Board Item as the Resource; that seems to be where all the useful data resides.

Hello!

Thank you very much for the responses, and apologies again for the continuous stream of questions.

This is where my issue with Board Items starts:

CleanShot 2022-09-23 at 18.42.35@2x764×1074 148 KB

Could you please offer some guidance on this?

Hey,

Change the Operation to “Get By Column Value”

Wow… I found it… Thank you so much!

No problem at all, it was my first time looking at the Monday node; there's a lot in there.

I have another question (apologies, you might get tired of me eventually).

I need the bot to retrieve a value from a column and increment it by 1 each time (n+1).

Is there a specific formula for such a straightforward operation? Perhaps something like parse(columnID) + 1?

You could try an expression and do something like {{parseInt($json["variable_name"])++}}

Thank you!

And my final question:
How can I search by telephone number? Should I wait for the webhook to trigger, or do I need to retrieve something specific from the Aircall API to get the phone number?

Hello,

I believe this depends on how Aircall functions. Based on your initial post, it seems Aircall may support webhooks for call events. I would suggest beginning with a webhook node to trigger the event. Then, within Aircall, configure it to use the URL of your callin.io webhook, which should then transmit the number.