Hey guys here’s the scenario: I have table 1 with leads and table 2 with clients.
Once I update the status of a lead in table 1, I’d like it to appear in my table 2 as a client.
It sounds so easy but I can’t find a way to set this up. Please can someone help? Thanks :v:
Without knowing what else is going on in the two tables, using one table for both is the best option. The main reason this is better is that it reduces data entry redundancy, keeping your data consistent.
For example, you converted a lead to a client, and a month later your customer’s company changes its name and moves offices. With two tables you would need to update the company name, address, email domains, maybe phone numbers and more in both tables. With one table you only have to update one record.
Also if the Client is no longer a customer, you will need another automation to clear the ‘converted to client’ checkbox or something to show what happened to the lead record that now has no client associated.