Jump to content

Edit fields when it is not empty


This topic is 6098 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello, folks

We would like to allow the user ability to modify field if it is empty but not if it is filled.

Assuming "vendor" field is filled and "vendorID" is empty. We would like to not allow the user to modify the "vendor" field since it is already has the data, but allow the user to modify "vendorID" field since it is empty.

Isempty(vendor) or Isempty(vendorID) doesn't work as we expected . What function should we looking at?

Thank you for your advice,

Link to comment
Share on other sites

Well, there are a few approaches and I believe your logic might need clarifying but let's try it on for size ...

I would remove both fields from tab order so User must click into the field to change it. And, since you must test the field contents, you'll need to attach a script (and not a Specify Button step) to each field. I am assuming you don't want the value removed because it is the ONLY value which might be used to relate this record to another table. This is spooky design, ie, there should ALWAYS be a VendorID and the name should never be trusted. However, life doesn't always come to us in neat packages and this might be data which is imported and out of your control when it comes in.

See attached ...

record 1 will allow entering value in VendorID (which is empty) but not removing Vendor name

record 2 will allow entering value in Vendor (which is empty) but not removing VendorID

record 3 will allow removing a value from EITHER* field but if you try to then remove the other value, it will not let you. So you can change either value.

Again, the logic is concerning. I would stop a User from EVER changing or deleting the VendorID. But what if someone mistypes and needs to change the name? Again, I don't understand your process or why Users are typing into either field.

EditFields.zip

Link to comment
Share on other sites

This topic is 6098 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.