Figure 1 Figure 2 Figure 3 Hi guys! I would like to ask is it possible to update a field in another table using a form in Oracle? So my situation is like this: This is an equipment borrowing system. I have created a report and a form for my first table Record (figure 1 and 2), which saves the record of people borrowing the equipment. At the same time, what I wanted to do is when an equipment is being borrowed away, the availability will change from 'Y' to 'N' (figure 3) , and all these will happen when I click the 'Apply Change' button in Figure 2. May I ask if it is possible to do so? thankyou so much as this homework is super important for me!!
Hi Vinish and Team, We are using Forms 22.214.171.124 on Linux Platform. Here is what we have a requirement of the new column highlighted by me in the attached image. We have added the Exposure Time Diff column and exposed in Data Block and in respective Canvas. You can see that the first row of this column will always be blank and then the second row will be the exposure time of the second row minus the exposure time of the first row (2.25 – 2.00), and the same moving down the rest of the rows. Please help with the best approach to meet this requirement. Thanks, Babu N
Hi, I have a button "Select All" and it has a true dynamic cation "JS Function" to select all the records on the interactive Grid. apex.region("payment_info").widget().interactiveGrid("getViews", "grid").view$.grid("selectAll"); This function only selects the record on the page I am currently focusing on. I want to select all the records from all the pages in that Interactive Grid. Thanks in advance.
Hi team, How can I create an update button on an interactive report? I have a request to allow users to update their missing information to the database. I followed the below link and thought there could be something similar for the update button also. https://www.foxinfotech.in/2019/10/create-delete-row-button-for-interactive-report-in-oracle-apex.html . Thank you
Hi Team, In Oracle apex in report section we have an option subscription, by which user can customize report grid and create schedule to receive that report through email as per schedule.I have 2 question related to subscription Instead of .htm format can user get the report in .csv format using subscription. Now a days users are getting blank report in email, however same report I am able to get using download option. Please let me know if you require more details
Good day I have a page with two region, one static, with an item to search and a submit button and the other one, a classic report. Every time I search and return to the page, the sql from the report executes with the previous search, hence delaying the loading of the page. I tried adding a clear session state in a process before header and it clears the page but it fires every time I click submit and does not return any records. Please help