I've been trying to get the "Edit Opportunities in Google Sheets (https://appexchange.salesforce.com/listingDetail?listingId=a0N3A00000EOGfLUAX)" app form SF Labs working. I've been able to run through the installation guide, and have the sync working that sends an Opportunity List View over to Google Sheets, however edits made in the sheet are not syncing back to SalesForce as they are supposed to.
According to the installation guide, any edit should produce a value of "synced" in the "sync status" field on the google sheet, and be copied to SalesForce. Instead, this field is populated with a value of "Edit" and no changes are made to the sync field.
Last night I got a Summary of Errors email from the Google Apps script you have to write for this. It appears to refer back to the same error I was having:
DNS error: http://null/google/trigger?row=2&col=3&docId=1dt_sx100VE5LqS-tqBWbil1VD_r2YFiUI7hGW6axM54 (line 118, file "Code", project "SFDCDriveSync Doc")
Where line 118 of the script is:
var response = UrlFetchApp.fetch(herokuUrl + "/google/trigger?row=" + rowParamenter + "&col=" + cellCol + "&docId=" + docId);
Has anyone run into anything like this before? Wondering if the issue is in the app I created in Heroku since this calls that, or on the SalesForce side?
The script at line 62 should be:
var herokuUrl = PropertiesService.getScriptProperties().getProperty('HEROKU_APP_URL');
Don't replace HEROKU_APP_URL in that line.
The HEROKU_APP_URL property is set to whatever your heroku URL is. So, if you heroku app is named 'SAMPLE', then you would have:
Property Value HEROKU_APP_URL https://SAMPLE.herokuapp.com
I can see in Winter16 that it was not available but I am searching to find out if it is coming in Spring17.
Trying to embed tableau dashboards in salesforce.
Please help me to achieve this.
Tableau enables to embed the dashboards into Salesforce.com just in few minutes. Following are the steps for the same:
- Login through Admin using login.salesforce.com
- Go to Setup tab and select Manage your Custom Tabs
- Select Web tabs and click Next and follow the below steps:
- Choose Layout as per the requirement and click Next
- Define Content and Display properties by providing necessary details
- Enter URL Details and click Next
- In Add to profiles select the users who can view the dashboards and click Next
- Add to Custom Apps and Save
For Further Classification Check This,
Let me know if you need any more information .
I created a new VR , view below.
ISCHANGED( Firm__c ),
Firm__r.Available_Provider__c = FALSE
When I create a new record, this VR does not fire. I want the VR to fire when someone created a new record as well.
Can you all help me on this?
However, when email is forwarded, the web email address is always the support email, rather than the original sender.
How do you get SalesForce to recognize the original sender, instead of the support email address it is forwarded from?
refer below link : https://success.salesforce.com/answers?id=9063000000045MpAAI
Any ideas what would cause that?
So, we currently have three Case record types where reps can use one for process A, or a different one for process B or a third one for both process A & B.
I want to simplify this for the end user.I took the page layoiut for the A&B processes and made duplicates for working with and created just a page layout for each and then created a picklist.to choose which process the agent wants to use.
Here is the question, do I have to create separate record types each with it's own page layout? or can I call more than on page layout for a single record type?
If I understand correctly, you want to change Case layouts between 1 of 3 layouts, depending on Case details.
To switch the Page Layout for a User, the record type will need to change, so you will need 3 record types.
You can create Workflow Rules to change the record type automatically based on criteria.
Also, you can assign 1 record type as master to a user and avoid the record type selection when creating records.
The record type access controls what record types a user can create, but record level access does not take record types into account, so they will still have access to the record once the record type changes via Workflow.
This link may also be of some help.