ORACLE APEX - 设置按钮以填充文本字段 [英] ORACLE APEX - Set up a Button to populate a textfield

问题描述

我有一个按钮，我想使用名为 P7_INPUT 的输入文本字段并将其除以 (/) 2000 并弹出它进入P7_OUTPUT

I have a button which I would like to take the Input text field called P7_INPUT and Divide (/) it by 2000 and pop it into the P7_OUTPUT

用户在 P7_INPUT 字段中输入 say 3000 并按下按钮，然后在 P7_OUTPUT 中将显示 1.5

Users enters say 3000 into P7_INPUT field and pressed the Button then in the P7_OUTPUT is will show the value of 1.5

推荐答案

右键单击 :P7_INPUT 并选择创建动态操作.设置以下属性:

Right-click on the :P7_INPUT and select Create Dynamic Action. Set the following properties:

Event: Key Release
Selection Type: Items(s)
Item: P7_INPUT

右键单击动态操作并选择创建 TRUE 操作.设置以下属性:

Right-click the dynamic action and select either Create TRUE Action. Set the following properties:

Action: Set Value
Set Type: PL/SQL expression 
PL/SQL expression : NVL(:P7_INPUT,0) / 2000
Items to Submit: P7_INPUT
Affected Elements > Selection Type: Item(s)
Affected Elements > Item(s): P7_OUTPUT

这篇关于ORACLE APEX - 设置按钮以填充文本字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！