Lookup a value in one SQL table with another SQL table

[Madhav.Seelam]

I want to look up a value in one SQL table and compare it with another SQL table. If the value is found, then I want to send a message to the contact number associated with that value

 

[Preeti Paryani]

Hello @Madhav.Seelam

Can you please elaborate on the exact use case you are trying to achieve? Please try to explain the scenario as:

1. Trigger (If this happens)
2. Action (Do this)
3. Action (Do this).............

 

[Madhav.Seelam]

1 Trigger (New Row in a 1st Mysql table): Take a value(Example battery serial number) in column
2 Action: look for the battery serial number in the 2nd MySQL table and pick the contact number associated with that battery serial number
3 Action: send a message to that contact number

 

[Preeti Paryani]

Hello @Madhav.Seelam

We have created a reference workflow in your account which can fulfill your use case. Please add a test record in the SQL capture the response on the "Save and Send Test Request" button and map the details accordingly, refer to the attached screenshot to learn more about the workflow.

Workflow Name: pabbly test
Workflow URL: https://connect.pabbly.com/workflow/mapping/IjU3NjYwNTZjMDYzMDA0M2M1MjZiNTUzYzUxM2Ei_pc

Do a few tests and let us know if it works for you.

 

[Madhav.Seelam]

Hi, I have created a similar flow with my requirements; please check and let me know if that works

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

 

[Preeti Paryani]

Hello @Madhav.Seelam

Can you please confirm if you have added a new row in the table before clicking the Save and Send Test request button?

If not please add a row and capture the response by clicking the Save and Send Test Request button.

 

[Madhav.Seelam]

Sure will add a new row, test it and let you know