---

I am trying to put in a control formula for the date field where a user can only select a date that is on the same day the user is inputing the data or a day that is earlier but the user cannot select the next day or a date that is later. Does anyone try to do this before? If so, I would appreciate some advise on how to code for the formula in the date field. Any help will be highly appreciated. Thanks in advance
SL

---

Hello guys.

I really need some help with this.

What I implemented already
I have a custom object called Candidates which contains a Contact Name. The Contact is the master object and Candidate is the detail object. So this means, when a new Candidate is created form contacts, it brings over the contact name.

/a0M/e?CF00N60000001OnWs={!Account.Name}
&CF00N60000001NTUU={!Contact.Name}
&CF00N60000001NTUU_lkid={!Contact.Id}
&CF00N60000001OnWs_lkid={!Account.Id}
&retURL=%2F{!Contact.Id}
&retURL=%2F{!Account.Id}

My problem
 When I click "New Event" from Candidates, how can I automatically populate the "Name" field which is a standard Event field with the contact that is associated with the Candidate?  I tried doing this with a custom link as I did on top but I can not find the value and lkid for the "Name" field for events when i view page source. Any idea what I can do?   This way, the user doesn't have to search the contact name in the event. If you guys couldprovide information that would be great.

Thanks,

Brian

I have multiple account records with the same account name (same company, different locations with each location being a parent account).  When I try to import these using the SF Import Wizard, it won't create a new record for each parent.  It just creates the first one, then updates that one record with each parent account entry in my CSV, so I end up with one account record with the parent account of the last entry.

If I were to use the insert function of Mr. Hess' excel connector (with "new" as the account ID) will it create all the accounts for me? Or do I have to change all of the account names so they are all unique?

Thanks, and I'll probably be employing the excel connector regardless if it solves this problem without me having to create all unique account names or not.

Cheers,

Jake Butler
www.universitypipeline.com
www.txtblaster.com

Is there a way to specify the desired ordering of fields returned by the query? e.g. I'd like the SF-ID field in in the left-most column of the returned data, to use as a lookup field.

I cannot see a way to do this using the wizard (I guess that would require an additional wizard step) and I'm not sure where to look in the mass of VBA code.

Thanks for any advice you can offer.

I'm really stumped here - I can't find the "sforce_connect.xla" file anywhere - in the blog, on the app exchange, Sourceforge, hell, I even searched on Google for it.  Nowhere to be found.

I know it's supposed to be on Sourceforge somewhere, but I don't know where.  Can someone perhaps provide a link to it?  I mean, I guess I can wait until I get back to work on Monday and get it form our network drive, but well... deadlines, ya know.  :-)  Would be handy to be able to finish up this project before the meeting on Monday morning.  ><

~ Nick

Hi all,

Firstly, im a bit of a noob with regards to apps etc...

Can I transfer existing tabs into new apps? I.e. can I transfer tab 'A' (which references items under tab 'B') into a new app and still have it access all the information and records in tab 'B'? If so, how do I do this?

Thanks in advance for any help!

    I have installed the new Conncet update and it installs with no issues. However, in Outlook none of the Saleforce menu buttons are available. I check under Options but nothing is there.

On my Start menu the Salesforce Intellisync item is there and functions and recognizes my outlook mail account (user/password).

Anyone have any ideas?

Thanks in advance.

On Events, we have picklist options in the Type field that allow someone to mark the appointment as a particular type of sales call ("Sales Call: Face-to-Face" ). If they pick this particular type, we need them to fill out more information. To solve this, I'm trying to say, if the type is = "Sales Call: Face-to-Face" , then description and name fields are required.

Problem is, when I go in to create the formula, Type is not an option. I tried using "Call Type", which is not in the list, but also doesn't throw out a syntax error, the validation just doesn't work. It let's me save and does not show me the error.

AND(ISPICKVAL( CallType, "Sales Call: Face-to-Face" ),
ISNULL( Description ))

Message Edited by AudraNYC on 10-19-200706:12 PM

Message Edited by AudraNYC on 10-19-200706:12 PM

My company has a very cluttered Opportunity page.  We have one type of service that requires a bunch of additional information that is quire different from the general opportunity.  Can we set up some relationship whereby these additional fields are not shown unless the user selects thsi specific 'service' from the main opportunity type picklist?