Application Express :: How To Change Grayed Field Font
Nov 7, 2013I need to change the grayed field item font ... ie i need to make disabled item value to be bright to achieve this what i have to do.
View 6 Replies
ADVERTISEMENT
Application Express :: Change Font Size For Item Of Type Display
Jul 13, 2012how to change the font size for an item of type display only ?
View 4 Replies View RelatedForms :: Change A Field Font Size On Runtime?
Nov 29, 2011can we change a field font size on runtime(by something like "SET_ITEM_PROPERTY built-in").(Independent of "Registry" file.)
View 5 Replies View RelatedApplication Express :: Recognize A Change Of A Field Value?
Aug 21, 2012I created a table (software defect details) and an interactive report on it. Users can go to the details form where they can manage many information: STATUS is one of them and they can change it or not.
I would like to send an email when SUBMIT botton is pressed only if field STATUS has changed. How can I detect this? I mean, I wrote a procedure in order to send an email and it works, but it runs always: I cannot set it running only when the content of STATUS_ID has changed.
how to understand if a field value has changed and, if possible what the old values was? I know how to do that by using a trigger (:old.status, :new.status) but I don't when using an APEX procedure.
Application Express :: Change LOV Based On Another Field Value?
Sep 26, 2012I have a need to change the LOV of a page item's select list based on the selection in another page item's select list. So in other words, for a page item that is a select list, I need to use one LOV normally, and a different LOV if the value of a different page item is set to X.
A dynamic action would be useful here (on change where Select List 1 = x), but I don't know how to take the action of changing LOVsfor Select List 2 based on that action.
Application Express :: Update Field On Change For SQL Query
Nov 26, 2012We are using APEX 4.2, 10GR2, RedHat5.
I have a report that comes from SQL Query (updateable report). I'm using the apex_item.text and apex_item.hidden on fields. I'm using a button to submit and after submit process to add some logic that I need.
There could be 1 - 10 records in the report. There is only 1 field that is needed to enter a value, but the value of this field determines the value of another field. I think that I can do this with a submit button and an after submit process where I loop through all the records. I think I have this handled.
This is the question
When the value of that field is changed then the value of another field in the same row changes immediately. All the examples I've seen so far are for a single record and that doesn't work for us.
I guess this is a MRU process but I haven't seen an example where a dynamic action is possible on a Multi Row Update.
Application Express :: Change Form Text Field Label Using Javascript
Oct 22, 2013I have a field that will be providing different info based on document type. I would like to change the field label from javascript in DA.
View 3 Replies View RelatedApplication Express :: Increase Font Size In Interactive Report
Aug 1, 2012I am using apex 4.1. I have this interactive report and i would like to make the text inside the report bigger and bolder. I have seen different examples of using css but none have worked for me. If you have any other way to do this or can give me a detailed way of using css!
View 4 Replies View RelatedApplication Express :: How To Change File Character When Export Application (4.2.1.00.08)
Feb 5, 2013I need to change "File Character" when I export application with Apex 4.2.1.00.08 version, but this option, is not possible. The ComboBox already select with
"Unicode UTF-8]', but I need "ISO-8859-1 - Europa Ocidental",
how can I do change it?
Application Express :: Way To Change Application Builder Theme
Sep 24, 2012Is there a way to change the Application Builder theme? There are themes for applications; how about for the builder itself? I looked but did not see a selection for this.
I'm a Geek thru and thru, I guess, but I think you might have to be xxxx retentive to like all these square boxes. And these old eyes have to squint to focus among the vast sea of gray shades.
Application Express :: Change To Application Process Not Recognized?
Sep 13, 2013I'm trying to make changes to a PL/SQL procedure in an application process and no matter what I do in the PL/SQL text (even removing semi-colons and messing up syntax) no changes register when I call the procedure from a page process. I've also tried creating a new application process with a similar procedure of a different name, and no page processes will allow me to call the procedure, saying that it needs to be declared. APEX 4.1.1
View 1 Replies View RelatedApplication Express :: How To Change Logo URL
Feb 14, 2013How to Change LOGO URL (When I click on logo redirect should go not to home page, but to any page that I want set manually).
View 3 Replies View RelatedApplication Express :: Set Value For Read-only Field?
Sep 22, 2012I have a form that based on a table,
Col1: text field
Col2: text field with Disabled =Yes and Save session state = Yes
I create a dynamic action on Col1 to set value for Col2, when I submit page an error raised: Session state protection violation
visit: [URL]...
My purpose is: Col2 is set value by Col1 via Dynamic action, and is read-only, user cannot modify.
Application Express :: Refresh Tree On Change Of Shuttle
Sep 27, 2012I have a requirement in which on Change event of shuttle, the tree present in another region of the same page should refresh. On refresh, the tree should include the values selected on the right hand side of the shuttle as its nodes.
View 3 Replies View RelatedApplication Express :: Interactive Report Get Where Clause And Change It
Sep 9, 2013If it is possible in Apex 4.2 get interactive report where clause and change it before displaying result e.g. We have an report and for some of columns we should do exact match and for some partial match.And business requirement is that they should not add additional % at the and of search string. It should be added automatically for some fields.
View 4 Replies View RelatedApplication Express :: How To Change Column Type At Runtime In 4.0
Apr 3, 2013I´m newbie as Apex developer using Apex 4.0 with OracleXE 11.2, and now my problem is:
I have a tabular form where one of the columns, when calling the form, is a Display Item, so that you cannot change existing values.
I want, when adding a new row, that column become a Select List (named LOV) based on a query that exclude existing values in other rows already inserted.
Can I change that Display Item to Select List (named LOV) programmatically at runtime? If not, what other options do I have?
Application Express :: 4.2 - Validate Field In Tabular Forms?
May 13, 20131.- i have a product_item field (wich is a lov and user choose one value), so i need to call a function (sending it the selected value product_item) that will return me some data about the product i selected, for example :
if the function return 'A' then
disable the next item on tabular form, lets say quantity
else
enable the next item on tabular form, lets say quantity
end if
2.- i need to determine the result of two items operations:
total := final_quantity - start_quantity
the user will introduce start and final quantity and i will determine the total.
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 :: Default Value Date Picker Field
Nov 21, 2012In a detail tabular form I am referencing a date picker field from the master form as default value.This is the situation in the detail form:
TABULAR FORM
Column Name: FECHAREGISTRO -- the field's name in the detail tabular form
Default Type: Item (application or page item name)
Default: P68_FECHAREGISTRO -- It's a field in the master form and also is Date Picker format
Reference Table Owner: SAMPEDRORIVEROS
Reference Table Name: BITACORAABOGADO
Reference Column Name: FECHAREGISTRO -- It's a date field in the database
At execution time I have the error:
report error:ORA-01790: expression must have same datatype as corresponding expression
I think it is because i must use to_date and to_char in order to change the datatype and i have tried using:
Default: to_date(to_char(:P68_FECHAREGISTRO,'DD-MON-YYYY'),'DD-MON-YYYY')
and in Default Type: PL/SQL Expression or Function but I get a different message at execution time:
report error: ORA-01722: invalid number.
Application Express :: Change Read Only Condition From Always To None On Real Time
Sep 4, 2012Can we change the condition of an item from always to none on the real time ? How ?
View 3 Replies View RelatedApplication Express :: How To Change Column Order In Interactive Report
Oct 18, 2013I am trying to change the column order in an Interactive Report. Run the report as a developer then use the action menu.
However, I am not sure how one can run the the report as a developer. Do you just login and run the page? Then if I do that, I don't see the action menu there. If I go to page attributes "Save Report" tab, I do see the action menu but "Select Columns" only gives me "Report Type", "Report Name" etc as columns. Or we don't have enough privileges to run the report as a developer?
Application Express Listener :: Configuration - How To Change From Port 80 To 8080
May 29, 2013I installed apex and configure the apex listener at port 80 by mistake couldn't pay attention to use port 8080. The installation is complete but the apex is running at URL.... but the login window is invisible on the page. I can just see the name on the tab "Application Express Login" . When i click on the error message at the bottom of the browser, the message says "apex is undefied" line 35.
When I run the server, I get a message "No free port within range 80. How can I change from port 80 to 8080? how to either un-install the listener or change the port 80 to 8080
Application Express :: Change Content-disposition In Email Attachment?
Sep 17, 2013I am using apex_mail (in Apex 4.1) to send emails with an attachment.
v_mail_id := apex_mail.send(
p_to => 'somebody@gmail.com'
...etc...
);
apex_mail.add_attachment( p_mail_id => v_mail_id
,p_attachment => v_image
,p_filename => 'signature.jpg'
,p_mime_type => 'image/jpeg');
Apex creates this as an attachment:
Content-Disposition: attachment;
I would like to change it to inline:
Content-Disposition: inline;
so I can reference it in my email body with <img src="cid:signature.jpg"/>. Well... I hope it is going to be shown inline anyway if I change Content-Disposition.
Currently (with Content-Disposition: attachment;) it works for Outlook, but, for instance, not in Gmail in the browser. Gmail shows the image separately as an attachment.
Is there a way to change the content-disposition with Apex?
I know it is possible to do it with utl_mail, but this is currently not installed in our databases. I need to involve our DBA to set this up, and I don't know if he is willing to do that.
Application Express :: Change Page Template Body To Use 8 Columns Instead Of 12?
Nov 6, 2013Apex Version: 4.2.0.00.27Theme: 25 I have a page that I need to divide by 8 segments, rather than 12 ( I will need to place items and buttons in one of the 8 columns). To begin, I have made a copy of the One Level Tabs - No Sidebar page template. I have tried to edit this template, and played with multiple combinations changing the Grid Layout and Display Points settings, but instead of creating a page that has 8 columns, that span the width of the page, I am just left with blank space. See attached:.[URL] And these are the Page Template Settings:[URL] Is it possible to change the body section of the page template to have 8 columns span the entire width, without the dead space?
View 2 Replies View RelatedApplication Express :: How To Change Column Header Value Dynamically In IR Report
Oct 29, 2012I have created report with the collections. Report query has been changing dynamically but i got problem with report header names and headers names has not been changing dynamically it is always showing like c001,c002....etc so, i have created global item(G_ITEM) in shared components--->Applications items after that I have created process(before headers) and assigning some value to G_ITEM and used &G_ITEM to column headres in IR Report but here &G_ITEM is not showing any value.
How can i achieve dynamic headers names by using *&G_ITEM(global items)*
Application Express :: Tabular Form - Change Column Values Before MRU
Jun 4, 2013I 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?
Application Express :: Setting Source Of Popup Lov Field As SQL Query
Oct 12, 2012I am having a problem with a popup lov. When I click on the "popup icon" I can select a supplier and it is stored in the field. But when I leave the form and return later, it shows the return value instead of the display value. For example: you select "supplier A" from the popup list with ID 12. "Supplier A" is shown in the text field, when you save the form, it stores ID 12 in it. But when you return to the form, it fetches ID 12 and shows "12" in the text field instead of "Supplier A".
I tried setting the "source" of the popup lov field as an SQL query, but that didn't work for me.
Application Express :: How To Update Total - New Value Doesn't Display In Field?
Oct 18, 2012 Let's say that we have an order entry app and the price and quantity items are already populated. We now want to show the user the extended price (the product of the first two items). the extended price would automatically display after both the quantity and price items are entered. I'm assuming that would require some kind of client-side processing. I imagine server-side processing is simpler, so I'll lean in that direction. I'm sure we've all seen web sites that require you to click a button for the order totals to be updated. I'm okay with that approach, but I haven't quite put all of the pieces together. Here's what I came up with.
A region button was added to trigger the updating of the extended price. The button's "Action When Button Clicked" is to submit the page. Under "Page Processing", a process was created to do the calculation with the recipient of the product being a page item. From debug code in the procedure, I can see that the item containing the extended price was, indeed, modified. But the new value doesn't display in the field and the Session window shows that the value of the item didn't change.
I must be missing something. The debug code says the item value was updated. The Session window says it wasn't updated. What gives? What did I do wrong and what needs to be done to correct this?
Application Express :: How To Create A Display Field In Tabular Form
Oct 1, 2012I am stuck at point.
using apex 4.1, created tabular form for inserting values from customer with a simple query
table name : customer
select
USER_ID ,
USERNAME,
PASSWORD,
STATUS,
PRODUCT_ID
from CUSTOMER
I WANT TO FETCH THE NAME OF PRODUCT FROM ANOTHER TABLE NAME PRODUCT_NAME, I WANT THAT WITH TABULAR FORM COULMN OF PRODUCT NAME IS ALSO DISPLAYED, HOW I DID THAT ? JUST WANT TO ADD COLUMN FROM ANOTHER TABLE IN TABULAR FORM.
WHEN I ADD TABLE NAME IN FIRST QUERY IT IS NOT WORKING GIVING ERROR ABOUT NOT JOINING THE TABLE
Application Express :: ReCAPCHA Plug-in Creating 3 Hidden Field
Sep 6, 2012i m using Apex4.1 and data base oracle 11g, browser firefox
i m using recaptcha plugins i had tried it with both way by creating 3 hidden field and and also directly with taking a item based on plugin. URL.....
More specifically, the page has two items for user input (the captcha and a text item) and a Submit button. If the captcha is successful, then the text item will be submitted and redirect to another page. The problem I'm running into is that the text item is always submitted regardless of the captcha.
