JohnVan_Horn
7 years agoQrew Trainee
merging tables help
Greetings,
needing help correcting a design flaw I made in our app.
As a sub-contractor we bid jobs daily to many General Contractors. Hundreds a week.
To try and segment our bids from the sales process I created two tables. Bids and Sales.
An automation creates the Sales record when the Bid status is changed to 'Sales'. But, since the bid folks also handle sales it's created two sections for them to enter data into and two tables to view.
I'd like to merge the two tables back into one Master table with info from both so as to have one point of reference for these employees to view.
Any thoughts on an easy way to get this done? I know the calendars and dashboards will need some clean up after but I can get that done easily enough on my own. Just having a booger of a time figuring out how to get all the data on one table.
Thanks in advance.
-John
needing help correcting a design flaw I made in our app.
As a sub-contractor we bid jobs daily to many General Contractors. Hundreds a week.
To try and segment our bids from the sales process I created two tables. Bids and Sales.
An automation creates the Sales record when the Bid status is changed to 'Sales'. But, since the bid folks also handle sales it's created two sections for them to enter data into and two tables to view.
I'd like to merge the two tables back into one Master table with info from both so as to have one point of reference for these employees to view.
Any thoughts on an easy way to get this done? I know the calendars and dashboards will need some clean up after but I can get that done easily enough on my own. Just having a booger of a time figuring out how to get all the data on one table.
Thanks in advance.
-John