Hello, Please help me figure out how I can format text in an Interactive Grid plain text field. I do have a column fetched from a table in an Interactive Grid column. The column in a table is a varchar2 type and has the text of up to 1000 characters. Now the requirement of an Interactive Grid is, that I want to display it in a bullet format if it has multiple sentences separated by '.' Example: Actual: Suzy provides the monthly financial reporting based on provided figures. The shareholders of the store have changed effective November 2021. How I want: Suzy provides the monthly financial reporting based on figures. The shareholders of the store have changed effective November 2021. Note: I have tried the solution by adding "replace(comments, '.', '<br>') comments" in select query in an interactive grid but it isn't working. Many Thanks, Bansari

Hello, Please help me figure out how I can format text in a classic report plain text field. I do have a column fetched from a table in a classic report column. The column in a table is a varchar2 type and has the text of up to 1000 characters. Now the requirement of a classic report is, that I want to display it in a bullet format if it has multiple sentences separated by '.' Example: Actual: Suzy provides the monthly financial reporting based on provided figures. The shareholders of the store have changed effective November 2021. How I want: - Suzy provides the monthly financial reporting based on figures. - The shareholders of the store have changed effective November 2021. Note: Not necessary that bullets should be displayed with '-' but the purpose is only to separate the sentences so the user can read it sentence by sentence and not by paragraph. Many Thanks, Bansari

Hello everyone, I want to apply validation to check whether duplicate values are there or not using SQL query on a SAVE button. But it's running everytime when it's not required. So, is there any way I can put a condition on validation that it will only run when I change the APEX item otherwise skip running the validation? Appreciate the answer as soon as possible. Thank you! Bansari

How can I apply the validation rule on read-only items? Example: I want to apply the validation rule with pl/sql boolean return on 2 APEX items where both APEX items are AutoNumeric(plug-in) read-only fields. Thanks, Bansari

Hello, Hope you all are doing well. I want to ask how can I submit the page again after checking the validation when I'm having "Enable duplicate page submissions" page-level attribute set to "NO" As I mentioned attribute for duplicate page submission set to NO and have a validation which is checking APEX item(SALES) "Zero or NULL". So, let say when I have SALES as 0 and I'm clicking SUBMIT button then it shows me the validation error which I have set. And after inputting some amount in SALES, when I try to SUBMIT it again it is showing me error "This page was already submitted and can not be re-submitted." How can I overcome it and have the ability to submit it after correcting validation error and having duplicate page submissions set as 'NO'? Thanks in Advance!

Hello, I'm using below function to have arithmetic ability on lose focus event for apex item (Example: input: 10000+10000 and output will be 20,000) function fnc_arithmeticAbility(apexitem) { if (($v(apexitem)).match(/(\d)(?=(\d{3})+(?!\d))/g, '$1,')) { var value; value = eval($v(apexitem)); $s(apexitem, Number(value).toFixed(0).replace(/(\d)(?=(\d{3})+(?!\d))/g, '$1,')); } else if($v(apexitem).match(/[-+/*]+/g)) { if(!(($v(apexitem)).match(/(\d)(?=(\d{3})+(?!\d))/g, '$1,'))) { var value; value = eval($v(apexitem)); $s(apexitem, Number(value).toFixed(0).replace(/(\d)(?=(\d{3})+(?!\d))/g, '$1,')); ...

Hello, I do have 4 dynamic action on a button(It sets multiple APEX items from database based on input-approx. 30 display only items) and sometimes it gives output for set value in APEX items and sometimes I can see(for 1/2 second I can say) value when I click button and then it disappears. So not sure whether it's taking value but due to many set value actions it is happening or anything else it's causing. Note: It happens only few times. 'Fire on Initialization' set to 'No' Thanks in Advance!

For example: I’m having an item :P1_SALES And I want to enter 1000+2000-1000 And it will give me 2,000 on the same item :P1_SALES Note I’m using a plug-in(AutoNumeric) for my input format