Obviously I'm about a year late with my reply - I didn't realize anyone had posted a question. We use the haversine formula as a criteria within a saved search. Since the formula is rather complex, we wrote an application that takes geocodes city names then takes the coordinates and generates a formula. Users can then copy…

We've used the Google Maps API along with a user event script to automatically geocode each client's shipping address whenever their record is saved. This allows us to send targeted marketing emails to all clients within a given distance of any city. A search that uses the Haversine finds all clients within X miles and we…

That seems really strange to me - I cannot get the results to sort descending by total. Are you on verison 2011.2? Perhaps after our account upgrades this weekend this problem will be resolved. As of right now, I can confirm that by following the steps in my previous post I get an unsorted result set back. It looks like…

I did try making a summary report - we still have the same sorting issue. I tested this with a new summary report using the steps below: 1) Reports > New Report 2) Sales 3) Metric: Transaction Total (Revenue) Summary (selected) Component: Client/Job Field: Name (Grouped) 4) Run Report 5) Change Date Range to this year 6)…

We would like to modify the subscription center to include a short survey asking why the user is unsubscribing. This is valuable information to helping us improve our marketing emails. Ideally we would like to be able to customize the subscription center similar to the way you create custom HTML forms for records (make a…

We are experiencing the same issue. We were able to work around it by assigning the role permission for Setup > Override Period Restrictions. I plan to contact support about this issue, I would prefer not to have my shipping staff overriding closed periods.

We are experiencing the same issue, however it seems to only affect shipping methods that use the "Limit to Sites" setting. Once this is removed the shipping method works again. Unfortunately, we have multiple websites and are not able to remove this setting other than to test. EDIT: Upon further testing, the error only…

Try using 'nlrole' instead. Thanks that worked perfectly.

I am trying to do the same thing. What was the code you used? I added the Lock Record action with the following parameters: Trigger On: Before Record Load Condition (Custom Formula): {nlrole}!=36 Where 36 is the internal ID of the role that should have access to this record. All other roles will see a locked record. It…