Create Salesforce Quotes and Quote Line Items (Products) with an offline form

In this guide, we will demonstrate how to create a new Quote record that is linked to an existing Opportunity record and assigned to an existing Contact record in Salesforce with a Formyoula mobile form. This mobile form can be completed while the mobile device is offline and the new record will be created on Salesforce once the device regains internet connection. Both Salesforce and non-Salesforce users can complete Formyoula mobile forms and the new records will be created on Salesforce. You can create any number of records on standard or custom objects with a single Formyoula mobile form. Child record creation is supported using repeat group elements.

1. Go to Formyoula.com and click “Sign In”.

image

2. Click “New Form”.

image

3. Click “Rename” to give your new form a name.

image

4. Forms can have multiple pages. We will leave one with the standard name “Details”.

image

5. Drag and drop two Salesforce Lookup fields on your form.

image

6. Click on the “pencil” icon to edit the fields.

image

7. We will use the first lookup field to link the Quote record to an existing Opportunity record in Salesforce.

image

8. We will use the second lookup field to assign the Quote record to an existing Contact record in Salesforce.

image

9. Drag and drop as many fields as you need for your new Quote record.

image

10. Drag and drop a Repeat Group field on your form. Edit the field and change the label. This will be used to add multiple products to your Quote record.

image

11. Drag and drop a Select field inside the Repeat Group field. Click on the “pencil” icon to edit the Select field.

image

12. Change the label and input Product names in the Select Options list.

image

13. Now go to your Salesforce profile. Find the exact products which ones you will use in the Select field list. And click on the “View” button next to the correct Price Book, from which you will use the Product.

image

14. Now please copy the Product ID from the URL, when on the exact Product record page.

image

15. Paste the ID in the Select field “Select Option Values” box. Please make sure to paste the ID in the correct row, so it matches the Product name.

image

16. Copy and paste all the Product IDs you are using for the Select field.

image

17. Drag and drop other fields inside the repeat Group field. In this case, we will use a Number field to set the quantity for the selected Product.

image

18. Now drag and drop a Hidden field on your form.

image

19. Go to your Salesforce profile, find the Price Book you are using the Products from and copy the Price Book ID from the URL.

image

20.  Click on the “pencil” icon to edit the Hidden field. Change the label and paste into the Price Book ID.

image

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

image

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

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

image

24. First create the “Quote” connection. Select “Quote” from the available Salesforce Object list and click “Save”.

image

25. Set the “Insert Sequence” as “1”. This will ensure to create the new Quote record before we add Products.

image

26. Click “Save Record Settings” when done.

image

27. In this connection we will map the Opportunity lookup to the Opportunity ID. Select the matching fields in both mapping sections and click “Create Map”.

image

28. The Contact Lookup to the Contact ID.

image

29. The text field “Quote Name” to the “Quote Name”.

image

30. And the hidden field “Catalog 1” to the Price Book ID.

image

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

image

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

image

33. Select “Quote Line Item” from the available Salesforce Object list and click “Save”. This connection will be used to add Products to our new Quote record.

image

34. Set the “Insert Sequence” as “2”. This will ensure to add the Products after the Quote record is created.

image

35. Select the Repeat Group field, in this case, we named the field “Product”, from the “Use Repeat Group” list. This will ensure to add as many Products for the Quote record as you need.

image

36. Click “Save Record Settings” when done.

image

37. Map the Formyoula “[New Quote] (Seq 1)]” field to the Salesforce “Quote ID” field. This will ensure to add the products to the new Quote record.

image

38. Map the Select field “Select Product” to the “Price Book Entry ID”.

image

39. And the Number field “Quantity” to the “Quantity”.

image

40. When done, go to your Formyoula dashboard.

image

41. Click on the “Try” button next to the form. This will open the mobile web app.

image

42. Select the newly created form.

image

43. Fill in the form. Press on the “Find” button to search for existing Opportunity records on Salesforce.

image

44. Select the Opportunity.

image

45. Search and add an existing Contact record. Fill in the rest of the fields.

image

46. Click on the “Add Products” button to add Products and the Quantity. When done click on the green button “Add”. You can add as many Repeat Groups as you need.

image

47. Fill in and submit the form when done.

image

48. Now, on Salesforce you will be able to see the new Quote record that is linked to an existing Opportunity record and assigned to an existing Contact record.

image

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