Skip to content

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”.


Screen Shot 2016-06-28 at 213830png


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



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



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.



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.





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.



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’




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



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



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.



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



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



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



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



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



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



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.


RRepeatPNG


18. Save the record settings once done.



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



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



21. Select the newly created form.



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.



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







For any questions, please contact us - support@formyoula.com


Feedback and Knowledge Base