Make field editable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2023 04:30 AM
Hi All
I have two requirements.
1. "Last audit date" field should be editable for 3 role that is asset_manager, asset_admin & asset_analyst.
2. Update the "last audit date" with current date when asset is moved from any other state to "In stock".
For the 1st requirement I understood to write an ACL on alm_hardware table. But I have to write it in "Create" operation or "Write" Operation or I have to write it for both the operation. Please suggest.
For the 2nd operation I believe I have to write a BR with below script
current.last_audit_date = gs.nowDateTime();
But again, what should be the condition for the same. Please suggest.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2023 04:49 AM
Hi @Prasnajeet1
1. Yes, Write ACL will work for this requirement.
2. Before BR , on update and the condition will be "State" change to "In stock".
Also , before making this customization ensure there is no OOB functionality exits.
Hope it helps and please mark helpful if it solves the issue.
Thanks,
Pooja Singh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2023 04:57 AM - edited 08-01-2023 05:08 AM
Hi
You have to write the Field level ACL. By field level means , you have the select the field 'Last audit date' while configuring the ACL on write operation.
For condition, use below one. Asset -> 'changes to' -> 'in stock' with 'Before' BR for insertion and updation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2023 05:02 AM
Hi @Prasnajeet1
1)If you want to given role for "last audit field" then apply write acl for this field.
2) For Business rule
Before=>Insert and Update triggers on both time and condition like below
Please check and Mark Helpful and Correct if it really helps you.