Forum Discussion

JohnVan_Horn's avatar
JohnVan_Horn
Qrew Trainee
6 years ago

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
Tables and fields

2 Replies

Sort By
  • JustinTorrence's avatar
    JustinTorrence
    Qrew Cadet
    6 years ago
    That's tough, because there can be many Sales to one Bid. What is your plan when there are 2 Sales for one bid? Will you have a duplicate field to hold the value, like Sale Price 1 and Sale Price 2?

    If there is only ever one sale to one bid, you can use the Import feature:
    1. Create a report in the Sales table that has all of the columns you want to copy over (make sure the "Related Bid" is one of those columns).
    2. Use the Save as Spreadsheet function to save a CSV copy.
    3. Rename the column headers in the CSV to their corresponding field name in the Bid table, and change Related Bid column header to Record ID#.
    4. Save your CSV
    5. From the App home page, click on More, then Import/Export.
    6. Select the "Import into a table from a file" option.
    7. Under Select Table, choose the Bid table
    8. Under Select Merge Field choose Record ID#
    9. Select the csv you created with the Choose File button
    10. Click Import From File...
    11. Look over the preview that is provided to ensure all the correct values are going into the correct columns
  • JohnVan_Horn's avatar
    JohnVan_Horn
    Qrew Trainee
    6 years ago
    Usually it's one sale to one bid. In VERY RARE occasions will it be multiple sales per bid. Not enough for me to worry about honestly.
    Let me give this export/import a try and I'll let you know how it goes. Seems simple enough :)

    Thank you Justin!!