Sign Up

Hey, Dev!
Are you looking for a forum full of active developers to help you?
So if you want to:
➡️ Get answers for your development issues
➡️ Help others
➡️ Write an article
➡️ Get rewarded for your active participation
Then this place is just for you and it is 100% FREE.

Have an account? Sign In


Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

Sorry, you do not have a permission to ask a question, You must login to ask question.

Forgot Password?

Need An Account, Sign Up Here
Sign InSign Up

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • About
Home/Questions/Q 1527
In Process
Mohsin
Mohsin

Mohsin

  • 3 Questions
  • 3 Answers
  • 0 Best Answers
  • 37 Points
View Profile
  • 1
MohsinContributor
Asked: October 1, 20202020-10-01T03:12:12+05:30 2020-10-01T03:12:12+05:30

Set same column value from one column to another column in Oracle Apex interactive grid

  • 1

I created a Editable Interactive grid. My goal is to create a new record and pass a date to one column (i.e. current_date) which automatically use the same date value for other column (i.e. admission_date). How can i achieve that? I am new to Apex and trying to explore different features.

I know this can be done through Dynamic Action (Set Value) but i don't know what i suppose to select 'SET TYPE' drop down.

 

apexig
  • 4
  • 781
  • 0
  • 0
  • Share
    • Share on Facebook
    • Share on Twitter
Answer

    4 Answers

    1. Vinish

      Vinish

      • 1 Question
      • 473 Answers
      • 46 Best Answers
      • 2k Points
      View Profile
      Vinish Legendary
      2020-10-01T08:52:06+05:30Added an answer on October 1, 2020 at 8:52 am

      To copy the one column value to another column in Interactive Grid, create the dynamic action on the source column for change event to set the value of the target column.

      In the following example, I am setting the column LAST_NAME value to the EMAIL column. Below is the screenshot:

      Oracle Apex Dynamic action set value.

      Follow all the steps shown in the above image. It will work as you needed.

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
    2. Mohsin

      Mohsin

      • 3 Questions
      • 3 Answers
      • 0 Best Answers
      • 37 Points
      View Profile
      Mohsin Contributor
      2020-10-01T09:42:43+05:30Added an answer on October 1, 2020 at 9:42 am

      Thank you for your response. What if Email Column is disable. In this case it is not working. Is there any way to assign the same value to a hidden column? Thanks

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
      • Vinish

        Vinish

        • 1 Question
        • 473 Answers
        • 46 Best Answers
        • 2k Points
        View Profile
        Vinish Legendary
        2020-10-01T09:50:07+05:30Replied to answer on October 1, 2020 at 9:50 am

        If the column is hidden, then no need to assign the value from the screen.

        You can simply create a database trigger on before insert to copy the value, for example:

        :new.b_date := :new.a_date;

         

        • 0
        • Share
          Share
          • Share on Facebook
          • Share on Twitter
    3. Mohsin

      Mohsin

      • 3 Questions
      • 3 Answers
      • 0 Best Answers
      • 37 Points
      View Profile
      Mohsin Contributor
      2020-10-01T19:03:03+05:30Added an answer on October 1, 2020 at 7:03 pm

      Can we try through JavaScript Expression (document.getElementById().value). One of my colleague done this my using JavaScript expression but with the page item even though the affected columns are hidden. When i try same with the column name then it is not working. Do you think there is any way to use JavaScript expression with column name?

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter

    You must login to add an answer.

    Forgot Password?

    Sidebar

    Ask Question
    Write a Post
    • Recent
    • Answers
    • Bheem

      How to deploy oracle apex app in oracle SaaS

      • 0 Answers
    • Rameez Tariq

      How to create View with Blob column through DBLINK

      • 0 Answers
    • Huy Nguyen

      Dynamic action on column on Interactive Grid

      • 3 Answers
    • GudDud

      Load PDF into APEX, Edit it and Print it.

      • 0 Answers
    • Huy Nguyen
      Huy Nguyen added an answer Thank you for your good idea. March 5, 2021 at 12:09 pm
    • Vinish
      Vinish added an answer Oh, this will work for only new rows. For existing… March 5, 2021 at 11:22 am
    • Vinish
      Vinish added an answer I think you do not need to create the dynamic… March 5, 2021 at 11:14 am
    • Vinish
      Vinish added an answer Are you converting your CLOB to varchar2 in the report?… March 5, 2021 at 6:56 am
    • Vinish
      Vinish added an answer You can reduce the number of column span for the… March 4, 2021 at 7:53 am

    Recent Blog Posts

    • Vinish

      Oracle Apex - Display External File in Region

    • Vinish

      Oracle PL/SQL Download BLOB File to Disk

    • Vinish

      Oracle Convert External File to BLOB

    • Vinish

      Oracle Apex Calendar Example

    • Vinish

      Oracle Apex - Open Modal Dialog Page Using JavaScript

    Explore

    • Home
    • Blog
    • New Questions
    • Tutorials
      • Oracle
      • Oracle Apex
      • Python
    • Tags
    • Users
    • Badges & Points
    • About

    © 2021 OrclQA.Com. All Rights Reserved. Privacy Policy