[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 672
  • Last Modified:

Where can I set the updateable property for a form item?

I wish to set the update allowed property for one of the form  items on my form to false  (code item) if  the value of another form item (type) is 'F' when the values are loaded from the record into the form. Where should I write this trigger? Would it be at the post-query block level ?
0
geeta_m9
Asked:
geeta_m9
  • 2
  • 2
1 Solution
 
riazpkCommented:
POST Query:

If BLOCK_NAME.item1  = 'F' then
SET_ITEM_INSTANCE_PROPERTY('BLOCK_NAME.ITEM_NAME',     SYSTEM.TRIGGER_RECORD,UPDATE_ALLOWED ,property_false);
END IF;


I supposed you want to set updateable property of BLOCK_NAME.ITEM_NAME on the basis of value of item BLOCK_NAME.item1. You will have to replace items names and block name.
0
 
riazpkCommented:
A minor correction:

SYSTEM.TRIGGER_RECORD

should be

:SYSTEM.TRIGGER_RECORD
0
 
geeta_m9Author Commented:
What is the difference between set_item_property and set_item_instance_property? I tried using set_item_property in the post query trigger but it didn't work. i.e. it was still allowing update of the item. However, when I placed the set_item_property in the when-new-record-instance trigger, then it worked. I also set one of the form item's update_not_allowed property to false at the pre-form level as I do not want any user to enter a value in that form item. It works for records with values in it but  it will not work for new records, i.e. for a new (blank) record. How can I set update_not_allowed for that item for a new record?
0
 
geeta_m9Author Commented:
Never mind about the last part. I forgot I can set the property for the item in the property palette to insert and update not allowed.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now