CODEWITHSUNDEEP
oracle-apex
Blob
Blob

Reputation: 541

Making a row read only in a tabular form

I have a tabular form which users will update on a yearly basis for their targets. Each product will have three rows: a row showing sales (last year), a row showing sales_target (sales man will enter) and a manager figure (what the manager expects the sales man should sell). The user should only be able to view sales from last year and the managers figure, and be able to enter into sales_targets. I know how to make columns readable but stuck on how to make a row readable if its not manager figure and sales.

There was some javascript that i could maybe use from another post however that is for a column rather than a row, could something similiar maybe used? Link here

I have made a demo here:

Link:apex.oracle.com
workspace: apps2
user: user
password: DynamicAction2
application name: Application 71656 Read only Rows for Tabular Form

Upvotes: 0

Views: 2924

Answers (1)

NoGotnu
NoGotnu

Reputation: 346

Yes, something similar can be used (execute this on page load):

$('#TAB_REP').find('td[headers="TYPE"]:contains(manager figure)').siblings('td').children('input').attr('disabled', 'disabled');

where TAB_REP is static ID of your report.

I have try to use more simple way - by defining attribute of the column, but in tabular report, apex dosn't replace #COLUMN# strings. Hope this is not a bug.

P.S. I've changed your demo.

Upvotes: 2

Related Questions