Can basic information copy to a new table once status is changed?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

Is it possible to have one table for tracking the bidding process and when the status of the bid is changed to "awarded" have the basic information copy from the bid to an order on a new table for project management tracking? 

I have three tables: Customers, Bids and Orders. I want a new order to pull information from the Customers table when the "Customer Name" matches up and  pull information from the Bids tables when the "Bid #" matches.


Thanks! 

Photo of Jasmine

Jasmine

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of Natalya

Natalya

  • 50 Points
Good morning Jasmine,

There are definitely a few solutions in creating this. Are you looking to just have an entry of when the bid became an order? 

If you are trying to convert a bid to an order you could create an API button that would create a new order based off of information from the bid.

If you are looking to create an API button, please feel free to submit in a case so we can help you set this up.

Thanks!

Natalya Waye | Customer Care Representative