Create New Order And Order Product Records Using Existing Price Book Entry Records

In this guide, we will explain how to create new Order records on Salesforce using Formyoula. We will use the Salesforce lookup field to search for existing Price Book Entries and create new Order Products that will be linked to the Order record.

We will be able to use this form while our mobile device is offline. All records will be created on Salesforce once the device has regained internet connection.

Please start by following these steps:

1. Please go to app.formyoula.com and click “Sign In With Salesforce”.

image

2. Please click on the “New Form” button to create a new form.

image

3. Please click “Rename” to name your new form.

image

4. We will drag and drop all required Order object fields on our form. A Salesforce lookup field to search for existing Account records and a Date field for the Order Start Date.

image

5. Next, drag and drop a Hidden field on your form that will hold the Order Price Book ID. Please copy the Price Book ID from your Salesforce Price Book record detail page URL. This will link the new Order record to an existing Price Book so that we can create Order Products from the Price Book Product list.

image
image

6. Please drag and drop a Repeat Group field on your form. This will be used to create any number of new Products that will be linked to the new Order record.

image

7. Please drag and drop all required fields inside the Repeat Group for the Order Product record creation. First, drag and drop a Salesforce Lookup and edit the field.

Please add a record filter option to search for Price Book Entry records linked to a particular Price Book in Salesforce. For example:

  • Pricebook2Id = ‘01s58000000Hezx’
image

8. Drag and drop all other necessary fields for the new Order Product record creation.

image

9. Click “Save & Close” to save your form.

image

10. Click on “(Add)” under the “Connections” column or click on the “Create a Connection” button, or select “Add/Edit Connections” from the “Actions” available list.

image

11. Select “Salesforce” from the available connections list and click “Create Connection >>”.

image

12. Select “Order” from the available Salesforce Object list and click “Save”.

image

13. Select the matching fields from both mapping select lists and click “Create Map”.

image

14.  When done, click on the “<< Back to Connections” button.

image

15. Select “Salesforce” from the available connections list and click “Create Connection >>”.

image

16. Select “Order Product” from the available Salesforce Object list and click “Save”.

image

17. First, we will enable the repeat group function that will make sure each Formyoula repeat group entry is created as a new record on Salesforce.

image

18. Save the record settings once done.

image

19. Next, please select the matching fields from both mapping select lists and click “Create Map”.

image

20. When done, please click on the “Try Form >>” button. This will open the mobile web app.

image

21. Select the newly created form.

image

22. First, we will find an existing Account record on Salesforce that will be linked to the new Order record. Next, we will select the Order start date and add as many Order Products as necessary by creating new repeat entries. Once done, please submit the form entry.

image

23. When you open Salesforce, you will be able to see the newly created Order record with multiple Order Products that are linked to your selected Account record.

image

For any questions, please contact us - [email protected]