You need to sign in to do that
Don't have an account?
Freytag
Text(Picklist) encounters Error
Hey there,
i´m just building a small clone app.
Ok no problem to do this through the URL BUT:
i just cant get the picklist values...
If i use Text() to get the value i get this error:
Incorrect parameter for function TEXT(). Expected Number, Date, DateTime, received Picklist
Our sandbox is on tapp0 running winter 10. I have really no idea what the problem is...
Can you please help me? I have a related problem. See the formula below: Complete and incomplete are picklist values. How can I use Text(picklist) here and get rid of ISPICKVAL? This formula is not compiling as it is too large. Using text will reduce the size. Please help.
ISPICKVAL(S1__c,"Complete")||ISPICKVAL(S1__c,"Incomplete")&&ISPICKVAL(S2__c,"Complete")||ISPICKVAL(S2__c,"Incomplete")&&ISPICKVAL(S3__c,"Complete")||ISPICKVAL(S3__c,"Incomplete")&&ISPICKVAL(S4__c,"Complete")||ISPICKVAL(S4__c,"Incomplete")&&ISPICKVAL(S5__c,"Complete")||ISPICKVAL(S5__c,"Incomplete")&&ISPICKVAL(S6__c,"Complete")||ISPICKVAL(S6__c,"Incomplete")&&ISPICKVAL(S7__c,"Complete")||ISPICKVAL(S7__c,"Incomplete")&&ISPICKVAL(S8__c,"Complete")||ISPICKVAL(S8__c,"Incomplete")&&ISPICKVAL(S9__c,"Complete")||ISPICKVAL(S9__c,"Incomplete")&&ISPICKVAL(S10__c,"Complete")||ISPICKVAL(S10__c,"Incomplete")&&ISPICKVAL(S11__c,"Complete")||ISPICKVAL(S11__c,"Incomplete")&&ISPICKVAL(S12__c,"Complete")||ISPICKVAL(S12__c,"Incomplete")&&ISPICKVAL(S13__c,"Complete")||ISPICKVAL(S13__c,"Incomplete")&&ISPICKVAL(S14__c,"Complete")||ISPICKVAL(S14__c,"Incomplete")&&ISPICKVAL(S15__c,"Complete")||ISPICKVAL(S15__c,"Incomplete")&&ISPICKVAL(S16__c,"Complete")||ISPICKVAL(S16__c,"Incomplete")&&ISPICKVAL(S17__c,"Complete")||ISPICKVAL(S17__c,"Incomplete")&&ISPICKVAL(S18__c,"Complete")||ISPICKVAL(S18__c,"Incomplete")&&ISPICKVAL(S19__c,"Complete")||ISPICKVAL(S19__c,"Incomplete")&&ISPICKVAL(S20__c,"Complete")||ISPICKVAL(S20__c,"Incomplete")&&ISPICKVAL(S21__c,"Complete")||ISPICKVAL(S21__c,"Incomplete")&&ISPICKVAL(S22__c,"Complete")||ISPICKVAL(S22__c,"Incomplete")&&ISPICKVAL(S23__c,"Complete")||ISPICKVAL(S23__c,"Incomplete")&&ISPICKVAL(S24__c,"Complete")||ISPICKVAL(S24__c,"Incomplete")&&ISPICKVAL(S25__c,"Complete")||ISPICKVAL(S25__c,"Incomplete")&&ISPICKVAL(S26__c,"Complete")||ISPICKVAL(S26__c,"Incomplete")&&ISPICKVAL(S27__c,"Complete")||ISPICKVAL(S27__c,"Incomplete")&&ISPICKVAL(S28__c,"Complete")||ISPICKVAL(S28__c,"Incomplete")&&ISPICKVAL(S29__c,"Complete")||ISPICKVAL(S29__c,"Incomplete")&&ISPICKVAL(S30__c,"Complete")||ISPICKVAL(S30__c,"Incomplete")&&ISPICKVAL(S31__c,"Complete")||ISPICKVAL(S31__c,"Incomplete")&&ISPICKVAL(S32__c,"Complete")||ISPICKVAL(S32__c,"Incomplete")&&ISPICKVAL(S33__c,"Complete")||ISPICKVAL(S33__c,"Incomplete")&&ISPICKVAL(S34__c,"Complete")||ISPICKVAL(S34__c,"Incomplete")&&ISPICKVAL(S35__c,"Complete")||ISPICKVAL(S35__c,"Incomplete")&&ISPICKVAL(S36__c,"Complete")||ISPICKVAL(S36__c,"Incomplete")&&ISPICKVAL(S37__c,"Complete")||ISPICKVAL(S37__c,"Incomplete")&&ISPICKVAL(S38__c,"Complete")||ISPICKVAL(S38__c,"Incomplete")&&ISPICKVAL(S39__c,"Complete")||ISPICKVAL(S39__c,"Incomplete")&&ISPICKVAL(S40__c,"Complete")||ISPICKVAL(S40__c,"Incomplete")&&ISPICKVAL(S41__c,"Complete")||ISPICKVAL(S41__c,"Incomplete")&&ISPICKVAL(S42__c,"Complete")||ISPICKVAL(S42__c,"Incomplete")&&ISPICKVAL(S43__c,"Complete")||ISPICKVAL(S43__c,"Incomplete")&&ISPICKVAL(S44__c,"Complete")||ISPICKVAL(S44__c,"Incomplete")&&ISPICKVAL(S45__c,"Complete")||ISPICKVAL(S45__c,"Incomplete")&&ISPICKVAL(S46__c,"Complete")||ISPICKVAL(S46__c,"Incomplete")&&ISPICKVAL(S47__c,"Complete")||ISPICKVAL(S47__c,"Incomplete")
All Answers
You cannot access picklist value directly like that!
You have to use ISPICKVAL() function.
Cool_D
Actually, you now pass a picklist to TEXT to return the result of a picklist. ISPICKVAL will only check what the value is. In terms of the error you are getting, what type of data do you store in your picklist?
Best,
Sati
Where are you using the TEXT(Picklist) function?
You can use it in validation rules, formula fields, and field updates!
Cool_D
Hey,
i'm trying to use the TEXT(Picklist) function in a custom Link creation.
As a sub function in URLFOR().
Is there any other way to get a picklist value for a custom URL?
I don't think you can use TEXT(Picklist) funtion in URLFOR() as this function is not available anywhere apart from the one's I mentioned in my post above!
Can you give an example of what you are trying to do? Are you writing an S-Control?
Cool_D
Hey Cool_Devloper,
thanks for your time!
{!URLFOR($Action.Task.NewTask, Task.Id, [
/*Subject */
"tsk5"=Task.Subject,
....
....
], true)}
This is a custom button created for aktivities.
No S-Control.
I´m just trying to open up the create task window with the informatin of an already created task to manualy clone the task.
Can you please help me? I have a related problem. See the formula below: Complete and incomplete are picklist values. How can I use Text(picklist) here and get rid of ISPICKVAL? This formula is not compiling as it is too large. Using text will reduce the size. Please help.
ISPICKVAL(S1__c,"Complete")||ISPICKVAL(S1__c,"Incomplete")&&ISPICKVAL(S2__c,"Complete")||ISPICKVAL(S2__c,"Incomplete")&&ISPICKVAL(S3__c,"Complete")||ISPICKVAL(S3__c,"Incomplete")&&ISPICKVAL(S4__c,"Complete")||ISPICKVAL(S4__c,"Incomplete")&&ISPICKVAL(S5__c,"Complete")||ISPICKVAL(S5__c,"Incomplete")&&ISPICKVAL(S6__c,"Complete")||ISPICKVAL(S6__c,"Incomplete")&&ISPICKVAL(S7__c,"Complete")||ISPICKVAL(S7__c,"Incomplete")&&ISPICKVAL(S8__c,"Complete")||ISPICKVAL(S8__c,"Incomplete")&&ISPICKVAL(S9__c,"Complete")||ISPICKVAL(S9__c,"Incomplete")&&ISPICKVAL(S10__c,"Complete")||ISPICKVAL(S10__c,"Incomplete")&&ISPICKVAL(S11__c,"Complete")||ISPICKVAL(S11__c,"Incomplete")&&ISPICKVAL(S12__c,"Complete")||ISPICKVAL(S12__c,"Incomplete")&&ISPICKVAL(S13__c,"Complete")||ISPICKVAL(S13__c,"Incomplete")&&ISPICKVAL(S14__c,"Complete")||ISPICKVAL(S14__c,"Incomplete")&&ISPICKVAL(S15__c,"Complete")||ISPICKVAL(S15__c,"Incomplete")&&ISPICKVAL(S16__c,"Complete")||ISPICKVAL(S16__c,"Incomplete")&&ISPICKVAL(S17__c,"Complete")||ISPICKVAL(S17__c,"Incomplete")&&ISPICKVAL(S18__c,"Complete")||ISPICKVAL(S18__c,"Incomplete")&&ISPICKVAL(S19__c,"Complete")||ISPICKVAL(S19__c,"Incomplete")&&ISPICKVAL(S20__c,"Complete")||ISPICKVAL(S20__c,"Incomplete")&&ISPICKVAL(S21__c,"Complete")||ISPICKVAL(S21__c,"Incomplete")&&ISPICKVAL(S22__c,"Complete")||ISPICKVAL(S22__c,"Incomplete")&&ISPICKVAL(S23__c,"Complete")||ISPICKVAL(S23__c,"Incomplete")&&ISPICKVAL(S24__c,"Complete")||ISPICKVAL(S24__c,"Incomplete")&&ISPICKVAL(S25__c,"Complete")||ISPICKVAL(S25__c,"Incomplete")&&ISPICKVAL(S26__c,"Complete")||ISPICKVAL(S26__c,"Incomplete")&&ISPICKVAL(S27__c,"Complete")||ISPICKVAL(S27__c,"Incomplete")&&ISPICKVAL(S28__c,"Complete")||ISPICKVAL(S28__c,"Incomplete")&&ISPICKVAL(S29__c,"Complete")||ISPICKVAL(S29__c,"Incomplete")&&ISPICKVAL(S30__c,"Complete")||ISPICKVAL(S30__c,"Incomplete")&&ISPICKVAL(S31__c,"Complete")||ISPICKVAL(S31__c,"Incomplete")&&ISPICKVAL(S32__c,"Complete")||ISPICKVAL(S32__c,"Incomplete")&&ISPICKVAL(S33__c,"Complete")||ISPICKVAL(S33__c,"Incomplete")&&ISPICKVAL(S34__c,"Complete")||ISPICKVAL(S34__c,"Incomplete")&&ISPICKVAL(S35__c,"Complete")||ISPICKVAL(S35__c,"Incomplete")&&ISPICKVAL(S36__c,"Complete")||ISPICKVAL(S36__c,"Incomplete")&&ISPICKVAL(S37__c,"Complete")||ISPICKVAL(S37__c,"Incomplete")&&ISPICKVAL(S38__c,"Complete")||ISPICKVAL(S38__c,"Incomplete")&&ISPICKVAL(S39__c,"Complete")||ISPICKVAL(S39__c,"Incomplete")&&ISPICKVAL(S40__c,"Complete")||ISPICKVAL(S40__c,"Incomplete")&&ISPICKVAL(S41__c,"Complete")||ISPICKVAL(S41__c,"Incomplete")&&ISPICKVAL(S42__c,"Complete")||ISPICKVAL(S42__c,"Incomplete")&&ISPICKVAL(S43__c,"Complete")||ISPICKVAL(S43__c,"Incomplete")&&ISPICKVAL(S44__c,"Complete")||ISPICKVAL(S44__c,"Incomplete")&&ISPICKVAL(S45__c,"Complete")||ISPICKVAL(S45__c,"Incomplete")&&ISPICKVAL(S46__c,"Complete")||ISPICKVAL(S46__c,"Incomplete")&&ISPICKVAL(S47__c,"Complete")||ISPICKVAL(S47__c,"Incomplete")