Application Express :: Refreshing Tabular Form On Closing Modal Page?
Nov 14, 2013I am not able to refresh tabular form region on close of the modal page.
View 6 Replies
ADVERTISEMENT
Application Express :: Refreshing Main Page After Closing Skillbuilder Popup?
Aug 17, 2012I need to refresh my main page after closing the popup page displayed by skillbuilder plugin
apex 4.1.0/Oracle 11g Ent.
Application Express :: Auto-Close Modal Page When Nothing Is Changed In The Form
Jul 15, 2012I am using Skilllbuilders modal page 2.0 to edit the form. Sometimes, the end user clicks on the edit link to trigger the modal page and sees the form , but he/she could not do any changes. Thus, when clicking Apply Changes button, we will be redirected to the page 102 ( the empty page ). How can I get around and make the page 102 to close automatically in case I am redirected to it ?
I put this in a JavaScript a dynamic action to be fired as page loads:
$(document).apex_modal_page('close');but nothing happen.
Application Express :: How To Individually Process Each Row Of Tabular Form On Page
Nov 19, 2012I have to create a tabular form, in which I have each row having an address information in it. I need to individually geocode each of these addresses and process it from the page (I have a web service to do the geocoding) .
How can I process each row of a tabular form individually from a page?
Application Express :: Displaying All Records In A Tabular Form On Single Page
Aug 27, 2010After setting up a data entry page,The logic in my page requires that all the records in my tabular form should be displayed .The tabular form is based on a collection, and the user selects rows through a checkbox.Any reload of the page due to pagination will break the logic, as some calculation and display events occur during page load, based on the previous page.
I need to display about 25 rows.I have changed the report attribute to display 50 rows, but it displays rows only up to the bottom of the screen, i.e. 11 rows.
Unfortunately I only just added some new rows and saw this behaviour else I would not have gone that way, as I expected APEX to display all rows if required.
Application Express :: How To Fetch Tabular Form Column Value Into Page Items
Sep 7, 2012I have created tabular form. I have set LOV for one column. Here my requirement is when i select the value from lov then it will fetch that value into page item.
I am using apex 4.1
Application Express :: Can Open Page 306 As Modal Window But Page Closes Immediately
Nov 13, 2012i have a html button. With the following attributes: onclick="return false" class="upd_description" A dynamic Action is listening on this button.
Event: Click
Selection-Type: jQuery Selector
JQuery Selector: .upd_description
static_URL: f?p=&APP_ID.:306:&SESSION.::&DEBUG.:306:P306_SER_SK:&P305_SER_SK.
as defined in my button attributes.
Button and dynamic action are on page 305. I can now open Page 306 as modal window but the page will close immediately.
Application Express :: Skillbuilders Modal Page - End Open Event?
Apr 24, 2013I'm using Skillbuilders Modal Page 2.0.0. plugin on Apex 4.2, and I can't seem to get the event End Open to work. stumbled upon this thread Skillbuilder Modal Page - Dynamic Title; nothing happens even if I set an alert to pop up on End Open
View 7 Replies View RelatedApplication Express :: Pass Value From Report On Skillbuilder Modal Page
Nov 29, 2012I am using the skillbuilder modal dialog. I have a report that displays in the modal. I want to pass a value from the report back to the page that called the modal and then close the modal. I have tried several different things, but I have not been successful.
View 2 Replies View RelatedApplication Express :: Fetch Row With / Without Refreshing Whole Page?
May 29, 2013I would like to create a process that allows me to move from record to record without refreshing a whole page. Specifically, I'd like to use a tree object that allows the user to select items and then have the details for that item show up on the right side of the page. Is there a way to do this without doing a complete page refresh?
So far I've tried two different on-demand processes:
- first I created an "Automatic Row Fetch", but I read on the board that this actually won't work as an on-demand process;
- I also tried a PL/SQL process that sets the various variables (e.g. ":P7_NAME") based on a query. This updated the session state, but it didn't refresh the fields on the page. Is there a way to trigger this refresh?
Application Express :: Execute JavaScript After Update And Submit In Skillbuilders Modal Page
May 13, 2013I'm editing, say, list of my employees in a tabular form opened in Skillbuilders Modal Page. I have to execute same javascript code after the changes in the tabular form have been submitted.
I've tried using a Dynamic Action fired on Page Load, but that gets executed before the update is completed.
Application Express :: Skillbuilders Modal Dialog - Condition For Parent Page Dialog?
Sep 26, 2012When using this awesome plugin, I have a dynamic action on my calling page that deals with the selection from the dialog.
It uses
Select type:DOM Object
DOM Object: document
Condition: javascript expression
($v('P110_PROD_SEARCH') == 'BLAH')
where the js expression is making sure I run the correct dynamic action, particularly when I have a few buttons on the page invoking different variations of the modal dialog.
My first action is some javascript that interrogates the value of this.data.modalPageCloseValue this facilitates me make decisions in later actions on whether to run some pl/sql, for instance.
potential APEX bug (Display item with HTML affected by dynamic action and since we can't put conditions on actions - I was wondering if I could incorporate something into my dynamic action condition to stop the entire dynamic action from executing if modalPageCloseValue is null - but it seems to be out of scope?
Application Express :: Check Box In Tabular Form 4.1
Sep 14, 2012How i can use check box in tabular form . working with 4.1 and am using simple check box (display as) .it creating the check box. how i can set value yes or no into it?
View 1 Replies View RelatedApplication Express :: Tabular Form With Updates In 4.1
Dec 5, 2012This problem went away for me in 4.2, but I am limited to 4.1 in production. The problem is this: I have three editable columns in my Tabular Form
1) I make a change to column 3 and press submit. The values in columns 1 & 2 (that were not changed) are overwritten with null during the update (submit). Column 3 is saved correctly.
I deleted my tabular form and re-created it thinking that I may have trashed something. But it appears that is the way it works. How do I prevent the unchanged editable columns from being overwritten with nulls?
Application Express :: Dynamic Tabular Form
Jul 9, 2012I have one table that holds a list of People...
Another that holds Classifications
Another that holds Sub Classifications (linked to the Classification table)
Table(*Person*)
PersonID, PersonName
Table(*Classifications*)
ClassID, ClassName
Table(*SubClass*)
SubClassID, SubClassName
I need a form that will allow me to put Classifications and Sub Classifications against a Person. I want to be able to add new Classifications and SubClass Values which are dynamical added to the form...
I have a table that holds other data and links the People to the Assessment
Table(*Person2Assessment*)
AssessmentID, PersonID, Date, AssessorName, Notes
I have a table to hold the Values of the Assessment...
Table(*AssessmentValues*)
AValuesID, AssessmentID, ClassID, SubClassID
-----------------------------------------------------------------
A typical person may look like:
e.g.
Person1(Fred)
Class1(Programming C++)
SubClass1a(Expert)
Class2(Language)
SunClass2a(English-speaking)
Class3(Location)
SubClass3e(India)
-----------------------------------------------------------------
Now I have the data tables but how to create the table and save the values for the Assessment Values in one table the dynamically adds values based on the different classifications available...
Application Express :: Defaulting In Tabular Form
Jun 7, 2012I got stuck in trying to add a simple fixed number (e.g. -1) to a field in case the database-fields is still null.
I supposed I could use report attributes > column attributes tabular form attributes, and then use Default Type and Default but nothing seems to work.
Application Express :: 4.2 Tabular Form Number Of Rows Bug?
Oct 25, 2012When I build simple tabular form in APEX 4.2 it displayed 10 rows per page by default. When I changed that number in Number of Rows field to 15 nothing happens. Again only 10 rows per page were displayed. Next field on the right to Number of Rows is Number of Rows (Item). Tabular form works as expected when I use this field and define number of rows with hidden page item. So workaround issue (bug?) is easy. Is this some kind of bug or I miss something obvious?
View 1 Replies View RelatedApplication Express :: How To Manipulate DML In Apex Form (not Tabular)
Aug 12, 2013I have one question I made a report and form in wizard with 1 table (Ex : EMP) and want to make a INSERT/UPDATE/DELETE process based on PL/SQL API. I think, mixing APEX_APPLICATION and APEX_ITEM pl/sql api can solve this question but not sure.... I have known the tabular form processing with PL/SQL via Oracle APEX book, but cannot find any samples on simple form processing.
View 5 Replies View RelatedApplication Express :: Spinbox Plugin For Tabular Form?
Sep 19, 2012have a spinbox plugin for tabular forms? I saw a plugin on jquery but I could not download it.
APEX 4.1
Oracle 10g Rel 2 DB
Application Express :: Numeric Field In Tabular Form
Mar 25, 2013I am using APEX 4.1 and Oracle 10g XE.
I want to restrict 3 digits after decimal in tabular form. Only three or less than three digits should be allowed after decimal and should be stopped automatically.
e.g. 34.543
Application Express :: Disable Column In Tabular Form
Dec 28, 2012How i can disable column in tabular form.working with 4.1 and i have wizard based tabular form.If i have entered value in one column second column should disable and vice versa?
View 5 Replies View RelatedApplication Express :: Duplicate Record Into Tabular Form
Oct 23, 2013I have created tabular form using
SQLselect"LINE_ID","LINE_ID" LINE_ID_DISPLAY,"ALLOCATION_ID","SERVICE_ID","CATEGORY_CODE"from "HOTEL_ALLOCATION_DTL"WHERE SERVICE_ID=:P6_SERVICE_ID
here line_id is primary key .here i don't want to enter duplicate category code when i submit rows.Here Allocation_id and service_id would be same for particular service_id .How can i create validation to enter duplicate category code .
Application Express :: Updating Fields On A Tabular Form
Oct 1, 2012I have an application where I'm trying to match skillset supply to skillset demand. We have resources and we have work for resources to do. Resources possess a set of skills. Work requires a set of skills. Skillsets are described by three fields: Domain, Target, Skill. So, we are able to capture the supply of skills in a table:
RSRC_ID (FK to Resource table)
DOMAIN
TARGET
SKILL
PROFICIENCY (this is the skill level 1 to 5)
The relationship of resources to skill supply is 1 to many. Conversely, work demands skills, and so we capture skill demand in a table:
WORK_ID (FK to Work table)
DOMAIN
TARGET
SKILL.
The relationship of work to skill demand is 1 to many also.
Users assign skills to resources using a master-detail form. It works fine
Users assign skills needed to work also using a master-detail form, and it works fine as well
A view then joins the skillset supply to skillset demand so that assignments can be made only where supply and demand match. This view is used in the LOV below.
I am using a mapping table to capture assignments of work to resources or resources to work. It is a many to many mapping of work and resources with matching skillsets, and it looks like this:
RSRC_ID
WORK_ID
DOMAIN (
TARGET ( These are the skillsets where demand equals supply and are derived from the view and presented in the LOV )
SKILL (I've created master-detail forms for the two types of assignments. An LOV in the detail form will present qualified resources or eligible work and then return the appropriate RSRC_ID or WORK_ID, but I must also populate the other three fields (DOMAIN, TARGET and SKILL) before I can insert or update the record. Here's the LOV from the form where resources are assigned to work:
SELECT sed.domain||'.'||
sed.target||'.'||
sed.skill||'/'||
sed.skill_prof||' '||
r.first_name||' '||
r.last_name "d",
r.rsrc_id "r"
FROM ri_resource r, ri_skill_supply_eq_demand sed
WHERE r.rsrc_id = sed.rsrc_id
AND sed.work_id = :P18_WORK_ID
order by 1It is not enough to just match the work to the resource, we must record for what skillset they are matched. I can't seem to see an easy way to populate the three other fields in the tabular form using data that I can retrieve with the LOV.
Application Express :: Maximum Rows On Tabular Form?
Sep 27, 2012I have a tabular form (report) multi-record. It display only the records 1-15 with pagination to the other pages. When I set the field 'Number of Rows' to 100, it still displays record 1-15 only. I just want to see the complete dataset on one page, without pagination. (There is a filter on it so there will never be more than 100 records displayed)
View 4 Replies View RelatedApplication Express :: Tabular Form Row Background Colour?
Jan 29, 2013I have created a tabular form and have changed some row background colours by using the Column Template sectiom in the report template
i.e
<td #ALIGNMENT# headers="#COLUMN_HEADER#" class="t16data" style="background-color:#FFFF33">#COLUMN_VALUE#</td>
with '#ASSIGNMENT_ID#' = 99 as the condition
This changes the colour but when I move the mouse over the row it removes the colour.
Application Express :: Javascript Function For Tabular Form Changes?
Apr 12, 2013I have a tabular form with a few columns. THey are ID, date1, date2 and task_name. The task_name is a drop down list of tasks. Upon selecting a specific task, I want the date1 and/or date2 columns to become read only (voided out) so users cannot enter in data. I am working with a tabular form, so I figured I need a javascript function to handle the logic and to call the function in the html elements of the column in the apex environment. This will need to happen dynamically (on click) before the page is submitted. I am more lost/confused on syntax. I know I will need to know the actual column name (coo1, coo2, something like that) of my columns that I will be refering to when I use javascript.
View 2 Replies View RelatedApplication Express :: Unable To Delete Row(s) From Tabular Form?
Jan 28, 2013I created report with row selector, when I select one row I get tabular form regarding to the selected row from report. I can insert and update data from tabular form, but I have problem with deleting them. Error I get is
ORA-01403: no data found (Row 207589)
My tabular form is created by wizard and primary key is managed by database rowid, I use apex 4.1 an 10g database.
Application Express :: Tabular Form Delete Row Functionality
Aug 29, 2013I have a wizard created tabular form, adding a row is easy using addRow() function, is there a way that I can delete the row from it? Let's say I have added a row and not submitted the form, but now I want to delete just that row from the form, how can I do that?
View 1 Replies View RelatedApplication Express :: Deselecting All Checkboxes In Tabular Form
Nov 8, 2012I am using Apex 4.2 with Oracle 11g
I have a requirement where I need to create a tabular form with a check box column. I created one using Apex_item.checkbox() function.
I have a button, when clicked it has to deselect all the checkboxes. I know I can use javascript onclick function and call a javascript. But I dont know how to use the javascript for a tabular form.
Application Express :: Save Before Exit Tabular Form
Feb 21, 2013I have seen the Skill builder plugin for Save Before Exit, and it looks great.
Unfortunately, my project is using apex 3.2.
Is there a recommended way to achieve this for a tabular for in apex 3.2.