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

In this guide, we will explain how to create new Opportunity and Product records on Salesforce using Formyoula. We will use a Salesforce lookup field to search for existing Products (Price Book Entries) that will be linked to the newly created Opportunity 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 Opportunity object fields onto our form. A Salesforce lookup field to search for existing Account records, a Text field for the Opportunity name, a Select field for the Stage and a Date field for the Close 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 Opportunity record to an existing Price Book so that we can create Opportunity 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 Opportunity Product records that will be linked to the new Opportunity record.

image

7. Please drag and drop all required fields inside the Repeat Group for the Opportunity 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 Opportunity 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 “Opportunity” 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 “Opportunity 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 Opportunity record. Next, we will select the Close date and add as many Opportunity 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 Opportunity record with multiple Opportunity Products linked to the Account record.

image

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