Skip to content Skip to main navigation Skip to footer

Example formula that pulls google doc ID out of the full URL

An example formula that gets the google doc id out of the full URL (in this case the field with the full google doc URL is called Proposal_Link__c but you would use the API name of custom field you  created):
MID( Proposal_Link__c, find(‘/d/’,Proposal_Link__c)+3, find(‘/edit’,Proposal_Link__c) – find(‘/d/’,Proposal_Link__c)-3)