How to Add records from table to other table

Question

Dear QuickBase Expert,&nbsp;Greetings from Beginners.&nbsp;I have a problem that I need to solve and hopefully will get an insight by asking the experts here.&nbsp;I have two tables on my QB1. Purchase Request Order ( PuRF)&nbsp;2. Purchase Order&nbsp; ( PO )&nbsp;1. Purchase Request Order (PuRF)&nbsp;&nbsp; &nbsp;Contains :&nbsp;&nbsp; &nbsp;PuRF No&nbsp; &nbsp; &nbsp; &nbsp; Products&nbsp; &nbsp; &nbsp; Descriptions&nbsp; &nbsp; &nbsp;Qty&nbsp; &nbsp; &nbsp; Price/Unit&nbsp; &nbsp; &nbsp;Total Amount&nbsp; &nbsp;Manager Approval&nbsp; &nbsp;Once PuRF is approved it should should be saved as a record and we continue to PO steps ( separate table )&nbsp;2. Purchase Order (PO)&nbsp;&nbsp; &nbsp; Contains :&nbsp;&nbsp; &nbsp; &nbsp;Request by&nbsp; : Requester&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PuRF No&nbsp; Products&nbsp; &nbsp; &nbsp; Descriptions&nbsp; &nbsp; &nbsp;Qty&nbsp; &nbsp; &nbsp; Price/Unit&nbsp; &nbsp; &nbsp;Total Amount&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;PuRF No&nbsp; Products&nbsp; &nbsp; &nbsp; Descriptions&nbsp; &nbsp; &nbsp;Qty&nbsp; &nbsp; &nbsp; Price/Unit&nbsp; &nbsp; &nbsp;Total AmountIn this case, I would like to simply adding the records from PuRF ( yellow highlight ) to be added into PO without to create another records in PO table. I have tried to do relationship but unfortunately is not success. How can I execute this issue to add PuRF records to PO table ?&nbsp;I do hope my explanation is clear and easy to understand, and looking forward to hearing from the expert here.&nbsp;Regards,&nbsp;Devan
------------------------------Quickbase Admin------------------------------

evanmartinez · Answer

Hi Devan,For your workflow are you looking for a way to copy over records from one table to the other without having to manually reenter the information. So for example when you are done with a PuRF you would hit a button or check a checkbox and the record would be moved over automatically? Something like that is possible with a Pipeline that is set to copy records over. Or if this is something you would want to do once a day you can also use a function like a table to table import to bring records over once a day (for example if your PuRFs move over at the end of the business day. That would copy the records over into the PO table. Alternatively if you just want them to be related and pull down relevant information you can relate them and make sure you have lookup fields created for any field you want to pull down from PuRFs to PO.------------------------------Evan Martinez------------------------------

Forum Discussion

How to Add records from table to other table

Related Content

Custom Record Titles

Record Details

Filter records based on table connection

Filter out some records on related table

Moving Fields from One Table to Another

Recent Discussions

Expanded URL from Reports

Pipeline Error --> "Quickbase reported an error: No error"

View query record if single record otherwise view query list

How do I unhide an app that I have no idea what it is named?

Gnatt plugin