Salesforce

{{jigx}} easily integrates with your salesforce instance, allowing you to share data about customers, sales processes, marketing campaigns, and more the {{jigx}} salesforce provider exposes the standard and custom salesforce objects you can manage your customer data, such as leads, contacts, accounts, and opportunities, using crud methods the endless possibilities depend on your specific needs and objectives and the type of data you want to show in your app build an app that provides current data about sales opportunities; deals won, leading sales teams, and open cases or tasks, through interactive {{jigx}} components such as charts docid\ n5mhyytoc2jxwu4lhpbf0 , jig list docid 5uifnxycbeewhizctnjqm , widgets docid\ ezcumo9pbezni9wt8sdrm , or stepper docid\ rndrafwpetkxhoxzythpp architecture the salesforce provider uses the {{jigx}} cloud service, where the data passes through the service and is not stored there is an intermediate layer between the mobile device and salesforce many records can exist in salesforce; as a result, {{jigx}} fetches the records in batches prerequisites you must have an active salesforce account permissions set in salesforce are adhered to in the {{jigxapp}} this means you can see the same data in the app as in salesforce when viewing the data in the {{jigxapp}} you will be prompted to sign in with your salesforce credentials building apps using the salesforce provider requires a pre existing knowledge of salesforce objects, their records, fields, tables, and variables take note of the required fields for each table an overview of salesforce objects is available in the salesforce platform; follow the path settings > setup home > object manager > schema builder or refer to the salesforce object reference documentation tools such as https //workbench developerforce com/login php https //workbench developerforce com/login php are helpful when building queries to return the correct salesforce data supported methods create objects docid\ jsdws beg8jqhbquzigmi delete objects docid 1utozx 0ffjavldcbxze8 save or update objects docid 7wlrx3jhchhuoxuaxtvqj save or update objects docid 7wlrx3jhchhuoxuaxtvqj list objects docid\ cg0q7nu3jrrau ec8j9 t syncing data by default, the provider returns all salesforce fields and columns consider the data size shown in the app and the number of columns you want returned salesforce can have many records, and showing large numbers of records can impact the performance of the app, your data plan, and your mobile device try to return just the data you require in the app and restrict the columns; this is achievable using queries below is an example of a query returning data between specific dates from the salesforce opportunity object type datasource sqlite options provider data provider local entities \ opportunity query > select id , sum(json extract(data , '$ amount')) as totalsales from opportunity where json extract(data, '$ stagename') = 'closed won' and json extract(data, '$ closedate') between '2020 01 01' and '2020 03 31' considerations the permission set assigned to a user in salesforce determining what they can view and interact with is adhered to in the {{jigxapp}} allowing the user to view and interact with only the data they have rights to limitation you can use the salesforce provider to create a list of reports in salesforce but cannot run the report from the app see using the salesforce provider docid\ zq7vx0sw j22gdi a2wye section for code examples on referencing multiple salesforce objects, queries that define the data to be returned and creating joins between objects using expressions salesforce is set up for your individual organization and each instance will be different, the examples in th section are provided for guidance on using the salesforce provider's methods and must be adapted to work with your specific instance tools such as https //workbench developerforce com/login php https //workbench developerforce com/login php are helpful when building queries to return the correct salesforce data you can copy and paste the queries into {{jigxbuilder}} examples and code snippets the following examples with code snippets are provided create records in objects docid\ jsdws beg8jqhbquzigmi delete records in objects docid 1utozx 0ffjavldcbxze8 save & update records in objects docid 7wlrx3jhchhuoxuaxtvqj list records in objects docid\ cg0q7nu3jrrau ec8j9 t