i have created a drop-down field and i mapped with dynamically updated data connection. There is a condition of drop-down field like if user select present ID then ok else if they select Others then another blank field will appear. now i have two column ID (Drop-down) and new ID (Test Field) and i created a new calculated column (Application ID) to display correct ID (AS they select ID or New ID). Calculated fomula is =IF(ID<>"Any Others",ID,[New ID]). After submit the request under Application ID it showing "Others" instead of That ID in drop down field. If i changed formula =IF(ID<>"Others",ID,[New ID]) then that "Others" option convert into "0".
Any lead appreciated.Thanks