We have a field that is required but if left blank on save we want it to autopopulate with the combination of two fields that exist on the form. I'm guessing this can be done in javascript. Any ideas? Thanks
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Yep, lookup fields are a buggere to work with. Picklists are alao unique. Here is what you should do:
To get a value out of a Picklist, don't use DataValue - use SelectedText. Such as:
crmForm.all.fieldname.S
Lookup fields actually store a number of different values in an array. Put another way, they're a pain in the tookas to work with!
The code snippet below will take a lookup value and a picklist value and concatentate them into a third field of time varchar. Substitute your field names in there and I think you'll have what you need.
Don't forget to test to make sure that the field you are putting values into is null before running this most recent script - otherwise you'll overwrite your existing value. Here is revised script to handle that for you as well.
As an aside, you can also update the field in "real time" as the user enters the other two fields. When they come to the field that contains the data, they can either leave it alone or make changes. Submit a second question if you want details on how to do that and I'll update the script accordingly.
Business Accounts
Answer for Membership
by: crm_infoPosted on 2009-02-17 at 14:49:29ID: 23665203
Yep - it's very possible. Exactly how you do this will depend upon the field types (i.e. Picklists and Lookups require some special treatment). For now, I'm assuming that you're going to be merging two text fields together to do this.
I'll summarize the process and attach some code. If you need more details just let me know and I'll send that along.
(1) First of all, you'll need to open the form for the record that you want to update: In the Web version of CRM: Settings | Customization | Customize Entities | Choose the entity you want this customization to work for | Double Click | Click the Forms and Views item on the side-nav | Double Click on the Form.
(2) I'm assuming that the two fields you want to use to create the third field, and the third field itself, are all on the form. If not, then go ahead and add them to the form.
(3) Now you're going to update the OnSave Event: Click Form Properties (right-side of the form, bottom) | Select OnSave and then Edit | Make sure you check the "Event is enabled" Checkbox | use the sample code, below, as a starting point to develop your own code.
(4) Click OK, Click OK again
(5) From here, you can test your code if you like by using the preview button
(6) Once you're satisfied that the form works the way you like, you can click Save and Close, Save and Close again, then, on the list of all entities, click the Publish button.
Your form should now work the way that you want.
WARNING: JavaScript is case sensitive, make sure you have your case correct. Again, depending upon the types of fields that you are grouping together, this may involve more code than I've place below - let me know if it works for you and, if not, let me know the names of the fields you're workign with and the types of fields and I'll try to give you the specific code you'll need to get this working.
Select allOpen in new window