ACLs: Allow Users to Add New Records, But Not Edit Specific Field

[jmiskey]

We have a custom table in a scoped application.  And for simplicity sake, let's say we have two groups of that are important to this question: those with an "admin" role, and those with a "telecom" role.

On my custom table, we have a field name "site".  I need to create an ACL on this field such that users with the Telecom role are able to add new records to the table (and can set EVERY field in the table).  However, on existing records, I want to limit it so that only those with an "admin" role can edit the "site" field (so users with the Telecom role CANNOT edit the "site" field on existing records).

Can anyone tell me how I need to constructs my ACL(s) to do this?

Thanks

[jmiskey]

I don't think I follow you.  Are you saying in addition to the new ACL I created, or instead of?  It seems to me that we should be able to do it via ACL.

If I have to use a Client Script, what exactly would that script look like?

[SaiRaviKiran Ak]

In the existing ACL itself check if it is new record or not. To check if it is new record or not you need to get the URL . If that URL has sys_id -1 then you have to make that field editable 

[jmiskey]

I am not sure which of the multiple ACLs you are referring to.  And I do not know how to do what you are suggesting.

[jmiskey]

I don't think I follow you.  Are you saying in addition to the new ACL I created, or instead of?  It seems to me that we should be able to do it via ACL.

If I have to use a Client Script, what exactly would that script look like?

[jmiskey · Accepted solution]

OK, I figured it out.  I had to add a new write ACL on the field in the table, add "Telecom" to the role, and add this to the Script section:

//allow edit ability on this field when creating new records only
answer = false; 
if(current.isNewRecord()){
	answer = true;
}

I knew it had to be something fairly simply, just took a whole to figure it out.