Application Express :: How To Calculate Total Column Dynamically In Tabular Form

May 27, 2013

I am trying to calculating the total column based on two columns, Total=unitprice*no.of items

I wrote this Javascript in page properties>javascrpt>Execute when Page Loads

"$('input[name=f05],input[name=f06]').change( function(){
parent_row = $(this).parents('tr:first');
sal = ( parent_row.find('input[name=f05]').val() == ' ') ? 0 : parseFloat(parent_row.find('input[name=f05]').val() );
comm = ( parent_row.find('input[name=f06]').val() == ' ') ? 0 : parseFloat(parent_row.find('input[name=f06]').val() );
total = sal * comm;
parent_row.find('input[name=f07]').val(total);
});

But its not Giving any result in total column?

View 3 Replies


ADVERTISEMENT

Application Express :: Disable Column In Tabular Form

Dec 28, 2012

How 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 Related

Application Express :: Tabular Form / Column Widths / Percentage

Jun 20, 2013

Oracle Express 4.0 I have set up a Tabular Form. It has 5 columns. I wanted to set 4 of the columns to a width of 15%. 1 column to 40%. I set the appropriate values to style=width: "15%"; and style=width: "40%"; in Column Edit's Element Attributes.  But all columns are displayed equally. If I try the format style="width: 40%" I get what appears to be 40% of the cell width for the text field (not the table width). Can %'s be used on Ellement Attributes?

View 0 Replies View Related

Application Express :: Tabular Form - Change Column Values Before MRU

Jun 4, 2013

I have a problem with Tabular form. Configuration: Oracle 10g, Application Express 4.1.0.00.32.

I have tabular form on simple table. I need to change some column values before MRU. For example: i have column named "UPDATE_DATE" where i need write SYSDATE every time this record was updated. I've created page process, associated with my tabular form.

Process point: On Submit - After Computations and Validations;
Sequence set to 1 (before "ApplyMRU" process - it has sequence 10);
When Button Pressed: Submit;
Execution Scope: For Created and Modified Rows;

Source:

declare
indx varchar2(255);
l_map wwv_flow_global.vc_map;
l_id number;
l_pk number;
begin
[code]........ 
   
But this doesn't work. MRU process writes old values, that was posted from browser. I tried change values by

apex_application.g_f04(:APEX$ROW_NUM) := sysdate;but this also not work.

How can i change values before MRU? Why wwv_flow_tabular_form.set_row_values doesn't change values?

View 5 Replies View Related

Application Express :: How To Fetch Tabular Form Column Value Into Page Items

Sep 7, 2012

I 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

View 12 Replies View Related

Application Express :: Setting Value Of Column Depending On LOV Selection Tabular Form

Mar 7, 2013

We have a master detail form with report that inserts the details in both region/ sub region.

However our requirement is that in sub region we have a LOV to chose the service, and each service has a price. How can we populate the Price column based on the selection of the Service? There are some similar posts but we cannot apply to our form.

Application Express 4.2.1.00.08
Oracle Database 11g Express Edition Release 11.2.0.2.0

View 2 Replies View Related

Application Express :: Compare Entries Of Tabular Form Column Against Lookup Table Or Item

Mar 28, 2013

I use APEX 4.2.0. In Tabular form, I have column of Select list type. This list has too many values and the end user must choose all these values along the tabular form rows. In other words, If the LOV consists of X, Y , Z, The End user should add three rows and choose a unique value for each row.

The problem is : This LOV is supposed to have too many values. What comes to mind is:

1- Whenever the end user picks a value, this value should disappear from the LOV of the second row ? But I have no clue how to do it?
OR
2- Whenever the end use picks a value, I should notify him/her about the remaining values that he should pick . But I have no clue how to do it ?

At the end the purpose is to make the user aware that he still has some rows to add ( values to choose ... )

I simplified the issue in simple example here:

[URL]......

workspace: somefeto
user: test
pwd: test

View 0 Replies View Related

Application Express :: Check Box In Tabular Form 4.1

Sep 14, 2012

How 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 Related

Application Express :: Tabular Form With Updates In 4.1

Dec 5, 2012

This 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?

View 2 Replies View Related

Application Express :: Dynamic Tabular Form

Jul 9, 2012

I 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...

View 2 Replies View Related

Application Express :: Defaulting In Tabular Form

Jun 7, 2012

I 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.

View 1 Replies View Related

Application Express :: 4.2 Tabular Form Number Of Rows Bug?

Oct 25, 2012

When 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 Related

Application Express :: How To Manipulate DML In Apex Form (not Tabular)

Aug 12, 2013

 I 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 Related

Application Express :: Spinbox Plugin For Tabular Form?

Sep 19, 2012

have 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

View 0 Replies View Related

Application Express :: Numeric Field In Tabular Form

Mar 25, 2013

I 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

View 6 Replies View Related

Application Express :: Duplicate Record Into Tabular Form

Oct 23, 2013

I 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 .  

View 1 Replies View Related

Application Express :: Updating Fields On A Tabular Form

Oct 1, 2012

I 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.

View 1 Replies View Related

Application Express :: Maximum Rows On Tabular Form?

Sep 27, 2012

I 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 Related

Application Express :: Tabular Form Row Background Colour?

Jan 29, 2013

I 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.

View 3 Replies View Related

Application Express :: Javascript Function For Tabular Form Changes?

Apr 12, 2013

I 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 Related

Application Express :: Unable To Delete Row(s) From Tabular Form?

Jan 28, 2013

I 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.

View 3 Replies View Related

Application Express :: Tabular Form Delete Row Functionality

Aug 29, 2013

I 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 Related

Application Express :: Deselecting All Checkboxes In Tabular Form

Nov 8, 2012

I 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.

View 0 Replies View Related

Application Express :: Save Before Exit Tabular Form

Feb 21, 2013

I 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.

View 4 Replies View Related

Application Express :: 4.1.1 - Tabular Form Updated Row Message

Oct 31, 2012

In my Application I have a tabular form and they other I edited 1 row & 1 entry and clicked on the update button. The message on the top says:

16 rows updated, 0 rows inserted (the standard message).

I do not have any page processes before or after applyMRU and its one of those freaky one-off issue that I can't reproduce again. Update 1 row and shows 15 updates.

Here are some info regarding my tabular form:

8 columns, pagination enabled for 20+ rows, no insert or delete functionailty, just updates.

View 0 Replies View Related

Application Express :: Calling A Procedure From A Tabular Form

Apr 30, 2013

I am new to APEX (well all of Oracle really so only have limited knowledge of PL/SQL etc too) but have created a couple of simple applications via wizards. One of these has a tabular form which works fine for updating records for the table that the form was built over but I need a way to write a record to a second (audit) table as well.

My form is used for cycle counting of items in a location. It originally shows the quantities of all the items in a location and allows the user to make corrections by updating any incorrect quantities to the correct value (this would then update the quantity column in the main table). It then needs to calculate the difference between the old and new value and write this as a record to an audit file (might be a positive or negative number).

do I call a procedure once (on submitting the page) and get the procedure to loop through the changed records writing to my audit file OR do I call my procedure once per changed record on the tabular form, if so how do I know what parameters to pass to the procedure?

I have tried researching this online but can find no easy to follow examples. All examples of code I have seen for tabular forms refer to fields referenced by apex_application.g_f01 or f02 etc - how do you know what items on the page these relate to?

View 3 Replies View Related

Application Express :: Tabular Form Select List Validation

Aug 30, 2012

I use apex 4.1..I have a tabular form a select like this

select
"STRATEGYID",
"STRATEGYID" STRATEGYID_DISPLAY,
"STRATEGYNAME",
"ISAVTIVE",
"STRATEGYSTARTYEAR",
"STRATEGYSTOPTYEAR",
"STRATEGYTYPEID"
from "#OWNER#"."STRATEGY"
where ISAVTIVE = 1STRATEGYSTARTYEAR and STRATEGYSTOPTYEAR as a Select List contain a value of year

I select from LOV like this
select y l, y v
from (select extract(year from sysdate) + rownum - 1y from dual connect by rownum <= 51)and

I have to Validate STRATEGYSTARTYEAR must Less than STRATEGYSTOPTYEAR

View 4 Replies View Related

Application Express :: Tabular Form - When Row Updated / Add User ID And Timestamp To Row

Apr 30, 2013

I have a simple tabular form based on a four element table: the primary key (seq #), title, Updated_by, Updated_timestamp.I would like to populate the updated_by and Updated_timestamp fields when a user either updates or adds to the table.On other forms, I use a calculation to update the page_ item in the page_processing section of APEX. However, in the tabular form, I am not sure where I might update these two fields.

View 2 Replies View Related

Application Express :: How To Determine Which Tabular Form Check Box(es) Are Checked

Oct 1, 2012

I'd like to determine (from code defined in a button definition) which check box(es) on a Tabular Form are checked. Assuming only one check box is checked, I want to obtain one of the values in that row for further processing. How to interrogate the Tabular Form to find out which box is checked?

View 9 Replies View Related

Application Express :: Unable To Bind Error In Tabular Form

Jul 5, 2013

I have an application which includes a certain page with a tabular form.After I copied this to a second schema, Apex threw an error

'Unable to bind ':126_ENG_PROJ_ID' 

It took me quite a while before I found out that one of my fields in that tabular form has a Popup Key LOV.The SQL for the LOV was: 

select dv, rv from (select loop_short dv, cmpnt_id rv from SPI_MAIN_TAG where eng_proj_id in (:P126_ENG_PROJ_ID, -:P126_ENG_PROJ_ID) ) order by dv

 Turned out that the view SPI_MAIN_TAG didn't exist in the second schema.Apex error message would have been more clear, like a simple 'Table or view does not exist' error, where possible even with the table name.I had Debug turned on, but in the debug window there was no reference to above SQL,

View 0 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved