bp21 wrote:Assuming the database processing is performed using a wizard-generated ARP, use a conditional Computation.
I have a select list called 'Product List' with list of values populated from database. Also, it has one static value 'Other: Specify'. When the user selects 'Other: Specify' option, a textfield below select list becomes visible(default hidden). I cannot tie two items with same database column 'Product_List'. Hence I want to append value of textfield with select list value 'Other: Specify' before storing in database. How can I achieve this? Can anyone help please?
Condition Type: Value of Item in Expression 1 is NOT NULL
'Other: ' || :P1_TEXTFIELD
bp21 wrote:It sounds very, very similar. I would not anticipate any significant difference from the method above.
Thank you for your response. That worked. I have another similar requirement. On selecting a value in first select list, second item changes to select list(default is text field) depending on the value selected. And second select list is like "Product List" only like previous one which has static value "Other: Specify". On selection of "Other: Specify" a textfield appears and that value is concatenated.
Can I have conditional computation based on whether item is shown or hidden at run time and particular value selected in select list?No. Whether an item is shown or hidden in the browser is not known in APEX where conditions are evaluated. The available conditions are listed in the documentation.
:p1_select_list1 = 'FOO' and :p2_select_list2 = 'Other: Specify'
:p2_textfield = :p2_select_list
:p1_select_list='some value1' and :p2_select_list != 'Other: Specify'
:p2_textfield = :p2_select_list || :p3_other_textfield
:p1_select_list='some value1' and :p2_select_list='Other: Specify'
bp21 wrote:There's nothing wrong with using "!=" as an inequality operator, but it would be wrong to use it if you're not evaluating an inequality expression... ;-)
I got it working. There was a small mistake I was doing. I was using wrong comparison operator i.e. !=