Learning Center
Learning Center
The Convert Records button can help you to post some data values in a record from one sheet to another. For example, you can convert "Quotations" to "Sales Order" or "Purchase Requisition" to "Purchase Order".
You can decide which field values should be copied to another sheet. After converting, you can still manually edit the record.
Let's say we already have "Quotes" and "Sales Order" sheets in the database, and their designs are very similar.
"Quotes" Format:
"Sales Order" Format:
When a client has placed an order, we can execute the Convert Records button to convert from the "Quotes" sheet to the "Sales Order" sheet. This will be much faster and more accurate than manually copying and pasting clients' information and order details.
Clicking on the Convert Records under Form Tools in the Design Mode from the Quote sheet's Form Page.
In the next step, you can select which sheet to convert to and map the fields.
After saving the settings, we can click the button to Convert Records.
(1) Only converting part of the records in the Subtable: For example, if you would like to convert a "Sales Order" to a "Delivery Note", yet not all the products on the "Sales Order" would need shipping, you can add a field to state whether the product would need shipping.
In this case, you may apply Subtable Filtering Criteria to only convert Subtable records matching the designated condition.
(2) Group the records and create a new record for each group while converting: For example, we want to convert the Subtable records to another sheet, but wish to only create a new record for each salesman, and the other affiliated data would be populated in the Subtable.
In this case, you may apply Subtable Grouping Criteria.
Thank you for your valuable feedback!
