Skip to main content
Question

Update fields from another table

  • April 4, 2018
  • 0 replies
  • 33 views
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.
      This topic has been closed for replies.

      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.
      • AleksandarSalap
      • Author
      • Quickbase Alumni
      • April 4, 2018
      Works! Thank you very, very much!
      Terms & ConditionsAccessibility statement