Hey There
I wondered if anyone has ever tried to use the connection for Salesforce in appsheet? I have run into a a complete roadblock and i'm getting nowhere with appsheet support.
So we have a large scale app acting as a CRM for a client. The CRM started by taking their data from Salesforce as an export and moving that to google sheets, from there we created all the same views they had in salesforce and that was that, however the have since decided to use the Appsheet app in some situations and Salesforce in others. This means it would be better if we stored the data in salesforce not google sheets, luckily we have a salesforce connector for data in appsheet!
I followed the guide, installed the app in salesforce and connect the data in appsheet. Since adding this data source we have been unable to get the app to start up. It simply times out after trying for a little while. When checking our account we have an error on the account after adding this source that says "Plan upgrade needed โ click to fix it!
You should be on the AppSheet Core secure plan. Please see the
App Info pane for details.
CRM....: Advanced data source 'salesforce' not allowed with the APPSHEET CORE plan"
If we try a known small table in the saleforce account in appsheet (one with 6 records) we can get this data to load however the load times are insane with syncs increasing up to 120 plus seconds.
Support asked me to create a new download of the data and put that on a google sheet to prove the data isnt an issue, we have been able to do this with no issue with very fast load times.
From what i can see this is clearlty an issue with the salesforce api connection to appsheet but in the docs i cannot see any listed limitations of this data source. I'd expect to see something like the 100k row limit of google sheets but nothing is listed.
Has anyone used this data source and actually got it to work?
LinkedIn
Twitter
