tag:blogger.com,1999:blog-1561253375800464394.post7737579857128028949..comments2024-03-13T11:59:19.468+01:00Comments on Denes Kubicek ApEx BLOG: APEX Tabular Form - Instant UpdateDenes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.comBlogger21125tag:blogger.com,1999:blog-1561253375800464394.post-3481110550680021452015-04-10T11:51:27.195+02:002015-04-10T11:51:27.195+02:00I am developing an app that captures the every day...I am developing an app that captures the every day resource utilization of a person in a team.<br /><br />I completed every thing and stuck up at a point i.e<br /><br />Please find the below image<br />1.jpg<br />As shown in the above image I created a Tabular form for this where month is a drop down list and year is a text box, the days 1,2,3,....31 are text boxes to capture utilized time.<br /><br />My requirement is to make the days greyed out and lock (not to allow the user to enter data) for the days which are not in that month.<br /><br />ex: when Month : Feb then 29,30,31 : greyed out and locked<br />I have searched in many websites for the solution, But I couldn't get one. Please help me<br /><br /><br />for full details plz refer <br /><br />https://community.oracle.com/thread/3698459adityatatavartyhttps://www.blogger.com/profile/03084612677931702924noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-69098860036291707982015-04-10T11:49:00.218+02:002015-04-10T11:49:00.218+02:00This comment has been removed by the author.adityatatavartyhttps://www.blogger.com/profile/03084612677931702924noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-78345833673679758432015-01-12T23:42:06.161+01:002015-01-12T23:42:06.161+01:00Hi Denes,
Thanks for blogging about this, it is re...Hi Denes,<br />Thanks for blogging about this, it is really helpful. I have your example working, but then have added a "Simple Checkbox" to the mix. It doesn't seem that the JQuery Selector on the dynamic action can pick up the change in value. Any advice to get a "Simple Checkbox" working with your example? or is it just not going to happen?<br /><br />Thank You in advance.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-47893298038088431322014-11-21T15:15:14.784+01:002014-11-21T15:15:14.784+01:00I think I have found a kludge solution.. It involv...I think I have found a kludge solution.. It involves adding a step to my dynamic action that I use to add a new row to the form. I had to make an adjustment to inset the row RIGHT after the row the user clicked on. After that I am running a refresh which is the culprit that is sending my report back to page 1.<br /><br />What I going to do is, add a javascript call that is similar to the pagination scheme I am using, with the pagination set to re-paginate the page I was on before the refresh, thus it will send me back to whence I came..<br /><br />A klude, but considering in time this will be ported over to Jari's routine using an interactive report as a tabular form.. (Just need the time to code the cascading lov solution that he introduced for the lov's on this page)<br /><br />Thank you,<br /><br />Tony Miller<br />LuvMuffin Software<br />Ruckersville, VAAPEX Developer In the USAhttps://www.blogger.com/profile/06746962787261032815noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-17667628830865336752014-11-21T07:50:37.730+01:002014-11-21T07:50:37.730+01:00That is an interesting question though. In my exam...That is an interesting question though. In my example it jumps to the page 1. In the classic solution it stays on the current page since there is no report refresh. Eventually I could make it working as you describe but it could be quite time consuming and a lot of work. Currently not possible for me to have a look at it. Means, you will need to do it yourself.<br /><br />Regards,<br /><br />DenesDenes Kubicekhttps://www.blogger.com/profile/01962373591521960882noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-44004501790417581482014-11-20T15:34:34.253+01:002014-11-20T15:34:34.253+01:00Quick question, when you implement this, have you ...Quick question, when you implement this, have you tried adding pagination to your tabular form? <br /><br />Why I am asking is, we have a similar page in an application, and when we add rows to the collection, the pagination resets to page 1.<br /><br />What we want is to stay on the page that we inserted a row..<br /><br />APEX Developer In the USAhttps://www.blogger.com/profile/06746962787261032815noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-80632328518301890812014-10-14T23:04:55.784+02:002014-10-14T23:04:55.784+02:00hi Denes
On Step 7 the below code is incorrect
$(&...hi Denes<br />On Step 7 the below code is incorrect<br />$('#'+'f01_'+$('#P294_ID').val().substring(4)).val();<br /><br />In order to obtain the rownum we can <br />$('#P294_ID').substring(4) and not <br />$('#P294_ID').val().substring(4)<br /><br />Thus the correct jQuery will be <br />$('#'+'f01_'+$('#P294_ID').substring(4)).val();<br /><br />https://apex.oracle.com/pls/apex/f?p=31517:294:13209892118709:::::Promeethttps://www.blogger.com/profile/06218780551283028731noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-10698440954292223572014-07-10T14:37:43.072+02:002014-07-10T14:37:43.072+02:00Hi Denes,
On the change event is the region refre...Hi Denes, <br />On the change event is the region refreshed. In APEX 4.0 is the cursor just not focused anymore. I would expect that if the user the "Tab" has clicked that the cursor would be in the next input field. But if he used the mouse, I would expect the cursor to be in that field.<br />Thanks,<br />MirelaMirelanoreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-48422283079045055282014-07-02T15:47:24.656+02:002014-07-02T15:47:24.656+02:00So, how do you know what the user wants? Where exa...So, how do you know what the user wants? Where exactly do you want to focus the cursor?<br /><br />Denes KubicekDenes Kubicekhttps://www.blogger.com/profile/01962373591521960882noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-82974724328241792662014-06-30T16:22:31.560+02:002014-06-30T16:22:31.560+02:00Hi Denes,
As usual one good solution from you. On...Hi Denes,<br /><br />As usual one good solution from you. One question: I'm using APEX 4.0 (I know... not my choice) and I notice that after update and refresh I lose the focus. I can manually set the focus on the next element, but it is not always the user's will. Your application works fine, so any suggestions?mirelanoreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-6609310357736882482014-06-05T18:05:38.941+02:002014-06-05T18:05:38.941+02:00This comment has been removed by the author.mrpelehttps://www.blogger.com/profile/07282472958482366643noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-9768920187264197592014-06-04T21:12:16.661+02:002014-06-04T21:12:16.661+02:00There was an error in the code I posted. I did the...There was an error in the code I posted. I did the correction and you should read it again. The right code is<br /><br />id="#SEQ_ID#" class="delete"<br /><br />Regards,<br /><br />Denes KubicekDenes Kubicekhttps://www.blogger.com/profile/01962373591521960882noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-70729448348243125452014-06-04T11:52:16.417+02:002014-06-04T11:52:16.417+02:00Hi Denes,
I have a problem. The problem is that de...Hi Denes,<br />I have a problem. The problem is that delete link is not triggering dynamic action although it have set its link attributes as 'id="9" class="delete"'.<br />So i am confused about 15 and 16 th steps in your code. Can you check these steps? mrpelehttps://www.blogger.com/profile/07282472958482366643noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-67652459386430375742014-04-09T19:46:45.111+02:002014-04-09T19:46:45.111+02:00Gabriel,
isn't that something like this:
DEC...Gabriel,<br /><br />isn't that something like this:<br /><br />DECLARE<br /> v_error VARCHAR2 (4000);<br />BEGIN<br /> IF apex_application.g_f01.COUNT = 0<br /> THEN<br /> v_error := 'No records selected.';<br /> END IF;<br /><br /> RETURN v_error;<br />END;<br /><br />?<br /><br />DenesDenes Kubicekhttps://www.blogger.com/profile/01962373591521960882noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-49423518594228017692014-04-07T20:04:52.233+02:002014-04-07T20:04:52.233+02:00Hello Denes.
My question will be a bit strange. I ...Hello Denes.<br />My question will be a bit strange. I have a select list from which the user can select a value. Based on that value a tabular form appear showing records that are compatible with the selected value. I need to check if any of the records from tab form is selected when user press submit button. If no selection is made then the user should get an error. How do i do that? <br />Thank you.<br />GabrielAnonymoushttps://www.blogger.com/profile/15125041712218041842noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-24513688470668723992013-11-29T08:07:40.354+01:002013-11-29T08:07:40.354+01:00Why don't you create an example? I will try to...Why don't you create an example? I will try to debug.<br /><br />Regards,<br /><br />DenesDenes Kubicekhttps://www.blogger.com/profile/01962373591521960882noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-90546940187926573342013-11-26T16:42:14.652+01:002013-11-26T16:42:14.652+01:00Hi Denes,
I'm facing a problem in APEX. Please...Hi Denes,<br />I'm facing a problem in APEX. Please see if you can help. I have posted this in your blog as well.<br /><br />I have a manual tabular report, with two editable fields(a select list and a text box) and all other columns are apex_item.display_and_save.<br /><br />On change of the editable fields, these display-only columns's value need to change.[They are being calculated from database functions].<br /><br />Problem is: When I am setting the values on change of the 2 fields, I am doing so through javascript, using getElementById. But when I am trying to insert these values in database in a Save process, I am doing so through APEX_APPLICATION.G_Fxx (i). And the values are diffrent. APEX_APPLICATION.G_Fxx (i) has the default value stored, while getElementById gives the span id which stores the new value. I want to insert the new value into the table. How can I do this?<br /><br />I'm not sure if I can use collections here, since in the 'value' attribute of APEX_ITEM.DISPLAY_AND_SAVE, I am calling a database function, which brings the default value for the report column. So I can't put a collection member in there.<br /><br />Your help will be much appreciated. Thanks!Donanoreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-47044706576126324452013-11-25T12:00:27.132+01:002013-11-25T12:00:27.132+01:00Hi,
I am using APEX_ITEM.TEXT in the tabular repo...Hi,<br /><br />I am using APEX_ITEM.TEXT in the tabular report. It needs to have a default value(This value is obtained by calling a database function.) Later, when user edits the value in the textbox, I need to retain it after page submit. Can you please help?DS123noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-14901727990501477932013-10-25T15:27:52.384+02:002013-10-25T15:27:52.384+02:00A popup key lov will need two arrays. Also, the id...A popup key lov will need two arrays. Also, the id will start for the first row differently than for a normal select list. I think you can make it work for popup but you need some modifications.<br /><br />Regards,<br /><br />DenesDenes Kubicekhttps://www.blogger.com/profile/01962373591521960882noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-37770294222358426642013-10-25T15:01:02.067+02:002013-10-25T15:01:02.067+02:00Hi Denes, I have done lots of tabular forms in APE...Hi Denes, I have done lots of tabular forms in APEX with different documented approaches. I plan on adopting your approach (page 294 in demo app) for my next project but cannot get this to work with pop-up LOV. It errors out on the set value DA. I am using APEX 4.2.0. Is there a work around or is this a bug in APEX?dlsykeshttps://www.blogger.com/profile/07226742080496022606noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-34857126138785123752013-05-20T15:09:17.017+02:002013-05-20T15:09:17.017+02:00I have nice plugins (DA and Process) for this but ...I have nice plugins (DA and Process) for this but never had time to publish them. Hope I'll manage to do this soon... :)Marko Goričkihttps://www.blogger.com/profile/00170426101592251779noreply@blogger.com