Creating a button in order to convert records to post some data values in an entry to be saved in another sheet can be done with this custom action button.
Your users will be able to click an action button in your source sheet to create a copy of your data (which can be all of your fields, or a selection of your field values) to be saved in this other sheet.
This linking type is different from having multiple versions of the same sheet as when you convert a record, the data values will be essentially copied and saved in a new entry in another sheet, and will not be using the same data pool. Therefore, it is possible to overwrite the data in the converted record without having it being changed in the source.
To create an action that will enable users to convert an entry from a source sheet to another sheet that the data will be saved into, click on the Convert Records option under the Sheet Linking Options button in the Design Mode of your source sheets' form page.
In our example below, we will be creating a sales order sheet that will use values from a quote sent to a customer.
The Quotes sheet already has some values for the customer to decide if they would like to place a sales order or not. At this stage, we do not have a link with the Sales Orders sheet.
The Sales Orders sheet is very similar to the structure of the Quotes. Having a similar design or sharing many fields is not a necessity for converting records, but it's helpful to be consistent with your design.
Navigate to the Design Mode of your sheet that will contain the source values. In our example, this is the Quotes sheet, as we'll be creating a sales order according to the values we quoted to the customer.
Click Form Tools to see a list of custom action button types you can add to your form. Click Convert Records.
This will display a dropdown with a list of sheets in your account. Select the sheet where you'll save values from the source. For our example, this is the Sales Orders sheet.
In this step, you'll be asked to map fields to each other. The section Use value from this field will show you fields from the source sheet, while the Fill in this field section will display fields that are in the destination sheet. Select the fields that you'd like to save during the conversion, this can be all the fields on your sheet, or only some of the fields on your sheet depending on your specific requirements.
Make sure that you have mapped all fields correctly. Depending on your sheet design, the field names can be the same, or entirely different. It's always helpful to have clear field names in order to have clear communication with different database designers and other users in your account. Once your done with the fields you'd like to map, click Create convert record button.
Ragic will prompt you to enter a name for the action button that your users will see. Make sure that the action name you are writing will be clear to other users.
After confirming the above, Ragic will have added your record conversion as an action button, which will be accessible from the Actions menu under your Form Settings. Make sure that you save your form design for your new action button to take effect.
Once you have completed all the steps to create a convert record link, you'll be able to see your new action button on the lower-right corner of your saved records in your source sheet. When a user clicks this button, this will create a new record in your destination sheet.
In our example, after clicking the Create Sales Order from Quote action button, the values from our quote record will be saved as a new record in our sales orders sheet. This way, we're able to see the Quote ID of the original quote that was sent to the customer, and all other related field values from our quote such as the product line items are being copied as well.
Each time the action button is clicked, a separate new record will be saved in the destination sheet. In this example, this means that we can generate different sales orders from the same quote.
To prevent users convert an entries more than once, you can configure a unique value field in destination sheet with "Unique" feature. In our example, that means to configure "Quote ID" field in "Sales Order" sheet with "Unique" feature.
You can make revisions to your destination sheet to have more fields according to your specific requirements. In our case, this could be adding the tax percentage and amount, and a discount percentage that is applied before the sales order is finalized.
While you can convert a main form entry from one sheet to a main form entry in another sheet, you can also convert subtable entries from one sheet to become part of another sheet's main entries.
In the example "from a Quote to a Sales Order" we used above, we've been able to convert subtable entries from one sheet to another sheet's subtable entries. When we click "Create Sales Order from Quote" button, the data value of subtable fields like Product SKU and Product Name in the Quote sheet are copied to the subtable fields in the Sales Order sheet, and every time we click this button, there will be a record saved in the Sales Order sheet.
To convert subtable entries from one sheet to another sheet's main form entries would be a little different. If there are N entries in the subtable, every time you click the convert button, there would be N records added in the corresponding sheet.
In our example below, we will be creating a Quote Records sheet that will use subtable values from a Quote sheet.
The Quotes sheet already has fields including Quote ID, Contact Name, Address, Phone Number in the main form, and subtable fields including Product SKU, Product Name, Unit Price, Oty, Subtotal.
The Quote Records sheet has fields including Product SKU, Product Name, Unit Price, Oty, Subtotal.
Clicking on the Convert Records option under the Sheet Linking Options button in the Design Mode from the Quote sheet's form page, we select to convert to the Quote Records sheet, and map the subtable fields of the Quote sheet to the fields of the Quote Records sheet, to create a convert record button.
After saving our setting, when we click this "Create Quote Records from Quotes" button, 2 records will be converted to the Quote Records sheet since this subtable contains 2 sub-entries.
|to a main form entry||to subtable entries|
|from a main form entry||✔ (clicking the button once to create one record）||✘|
|from subtable entries||✔ (clicking the button once to create N records, N = the number of subtable entries)||✔ (clicking the button once to create one record）|
Note: The system will not allow you to convert a main form entry from a sheet to subtable entries in another sheet because a main form entry only has one value in a field, but the subtable entries may have more than one value in a field.
There are some additional settings you can configure for action buttons, you may refer to this article for detailed information.
If you want to remove the action button, you may refer to this article.