Update fields from another table

  • 1
  • 1
  • Question
  • Updated 7 months ago
  • Answered
I do appology, since I've seen couple of posts on the subject but couldn't make it work in my case.
I have 2 tables: Request Pricing (Record ID is key field) and SalesForce (Record ID is key field).

Both tables have those 3 fields: Opportunity Number, Selling Stage, Expected Book Date.

I would like, after I import new data from excel to SalesForce table, for that particular Opportunity Number to update Selling Stage and Expected Book Date in Request Pricing table.

I created SalesForce table for this particular action: to use it to update Request Pricing table with any new updates to the fields Selling Stage and Expected Book Date, and that's why I added Opportunity Number which is unique in both tables.

Thank you very much.
Photo of Aleksandar Salapura

Aleksandar Salapura

  • 482 Points 250 badge 2x thumb

Posted 7 months ago

  • 1
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
If you change the Key field of the sales force table to the Opportunity number then you can make a relationship where 1 Sales Force has many Request Pricings, based on the opportunity number used on the right side of that relationship.

Then you can look up any fields from sales force down to Request Pricing.
Photo of Aleksandar Salapura

Aleksandar Salapura

  • 482 Points 250 badge 2x thumb
Works! Thank you very, very much!