Salesforce.com give 5,000 chatter free licenses, it is good for organisation to use Chatter for collaboration as it is free. But, adding hundreds or thousands of user as member into many Chatter group is not fun, if do it manually.
If you are Salesforce admin, here tip to make your life easier :)
You can use Data Loader to mass add member to Chatter group.
1. Open Data Loader and select Insert
2. Select "Show all Salesforce objects"
3. Select "Chatter Group Member"
4. Map "CollaborationGroupId" to Chatter Group Id and MemberId to User Id
Done, easy...?
Pages
Monday, February 25, 2013
Saturday, February 16, 2013
Chatter: can user delete feed or comment?
Sometimes we need to delete feed or comment post to Chatter, but can user (read: not system administrator) delete it?
Yes, you can delete posts and comments that you made in these areas: on the Chatter feed on your profile, on records you own, and on posts and comments you’ve made in other feeds. Deleted posts or comments will disappear and you can’t restore it (from Recycle Bin). Users with the Modify All Data permission or Moderate Chatter permission can delete all posts and comments.
Here a quick summary:
But, if you are group owner of a group, you can do more things within the group:
Extra: use @username to show your post on user feed, even that people is not following you, the followers of that user will see that feed as well.
Yes, you can delete posts and comments that you made in these areas: on the Chatter feed on your profile, on records you own, and on posts and comments you’ve made in other feeds. Deleted posts or comments will disappear and you can’t restore it (from Recycle Bin). Users with the Modify All Data permission or Moderate Chatter permission can delete all posts and comments.
Here a quick summary:
- User can delete their own post or comment
- User can delete other people post to their feed
- User cannot delete other people feed
But, if you are group owner of a group, you can do more things within the group:
- User can edit group setting
- User can edit group information
- User can edit group description
- User can delete people comment to group
- User cannot delete feed on group change
Extra: use @username to show your post on user feed, even that people is not following you, the followers of that user will see that feed as well.
Friday, February 1, 2013
Salesforce: batch upload Quota in Forecasts (Customizable)
For those using Customizable Forecast, admin can use Apex Data Loader to mass create or update it Quota field in REVENUEFORECAST object.
Here fields you need to take care when create new quota: "OWNERID","CURRENCYISOCODE","QUOTA","STARTDATE"
To run report on quota, select "Customizable Forecasting: Forecast Summary" in report type, then it is similar with any other Salesforce on the configuration.
Here fields you need to take care when create new quota: "OWNERID","CURRENCYISOCODE","QUOTA","STARTDATE"
- OWNERID, this refer to quota for particular user (sales rep) on specific quarter.
- CURRENCYISOCODE, the currency set for particular record (if you enable multi-currency in your org).
- QUOTA, the amount of quota set for particular record.
- STARTDATE, would be first date for corresponding quarter, example: 1/1/2013, 4/1/2013, 7/1/2013. But my instances, I am not sure why, I have to put start date 1 quarter after the correct quarter, example: for Q1 2013, I need to put as 1/4/2013, after it created, it will show as 1/1/2013 in query. Anyone has this issue? - This has been resolved, it caused by Time Zone setting in Data Loader, see this blog.
- CLOSED, this field is summary of won amount owned by a user in particular quarter, it is not updated-able.
To run report on quota, select "Customizable Forecasting: Forecast Summary" in report type, then it is similar with any other Salesforce on the configuration.
Monday, January 28, 2013
Salesforce login parameter
As normal user, we access Salesforce.com from web browser https://login.salesforce.com to access production instance or https://test.salesforce.com to access sandbox instance (if you have any).
But, some organisations need to access Salesforce directly from another application (and not implemented SSO), we can add username and password include as login parameters to direct login to Salesforce, here we go:
https://www.salesforce.com/login.jsp?un=user@email.com&pw=secret
The same applied for sandbox:
But, some organisations need to access Salesforce directly from another application (and not implemented SSO), we can add username and password include as login parameters to direct login to Salesforce, here we go:
https://www.salesforce.com/login.jsp?un=user@email.com&pw=secret
The same applied for sandbox:
https://test.salesforce.com/login.jsp?un=user@email.com&pw=secret
You also can redirect user to a specific record, such as: account, contact or report:
https://test.salesforce.com/login.jsp?un=user@email.com&pw=secret&startURL=/00190000005lXMZ
NOTE: Since your password is in the URL, everyone could see it, so be cautious.
NOTE: Since your password is in the URL, everyone could see it, so be cautious.
Salesforce Searchable Field
As Salesforce admin, sometimes we confuse when user come to us and ask, why a record not return in search result when I search Phone Number or Email or a custom picklist field.
Here is the guide on searchable field types in using Salesforce global search:
When user search for a value, for records contained that value, global search result will include those records, even field contained for the search value is exist in a field that are not visible for that user, because of field-level security setting. Ideally, if user cannot see the value on that field, it should be not search-able for that particular user, vote for this Idea, currently it have only 160 point (9/9/15).
However, not all standard field is searchable, example: for Account only following fields are searchable:
For complete searchable fields by object, see this reference below.
Reference:
Here is the guide on searchable field types in using Salesforce global search:
- All custom auto-number fields and custom fields that are set as an external ID field (you don't need to enter leading zeros.)
- All custom fields type: email and phone
- All custom fields type: text, text area, long text area, and rich text area
When user search for a value, for records contained that value, global search result will include those records, even field contained for the search value is exist in a field that are not visible for that user, because of field-level security setting. Ideally, if user cannot see the value on that field, it should be not search-able for that particular user, vote for this Idea, currently it have only 160 point (9/9/15).
However, not all standard field is searchable, example: for Account only following fields are searchable:
- Account Name
- Account Name (Local)
- Account Number
- Account Site
- Billing Address
- Description
- D-U-N-S Number (This field is only available to organizations that use Data.com Prospector)
- Fax
- Phone
- Shipping Address
- Ticker Symbol
- Website
- All custom auto-number fields and custom fields that are set as an external ID (You don't need to enter leading zeros.)
- All custom fields of type text, text area, long text area, rich text area, email, and phone
For complete searchable fields by object, see this reference below.
Reference:
Salesforce converted currency in report
In Salesforce, there is a field type "currency", for example, Amount in Opportunity, and we can also create custom fields with the data type of currency.
If you enable multi-currency in your Salesforce instance, and if the record currency is not in your user currency, you will see your user currency show in parenthesis after the amount.
In the report, you will find the (converted) fields for each currency field. You can add it to the report like another normal field. But, you cannot add the converted field as a report filter (as of now).
Solution: use original currency as a filter and add currency code. Example: USD 300, SGD 500, JPY 10,000 and etc.
If you enable multi-currency in your Salesforce instance, and if the record currency is not in your user currency, you will see your user currency show in parenthesis after the amount.
In the report, you will find the (converted) fields for each currency field. You can add it to the report like another normal field. But, you cannot add the converted field as a report filter (as of now).
Solution: use original currency as a filter and add currency code. Example: USD 300, SGD 500, JPY 10,000 and etc.
Subscribe to:
Posts (Atom)



