Jump to content
Sign in to follow this  

conditional locking field and record?

Recommended Posts

This forum has helped me greatly. I am trying to find a simple solution to my problem and thanks in advance for all your help.

I am working on a time sheet database where employees can input their time spent on different tasks. On one layout, I have a portal for them to input their time. I created part of the first two records for them to input LUNCH or BREAK. So the first record is for LUNCH only and they need to add time they spend on LUNCH and the second record is BREAK only. For the rest of the portal, they can adding different tasks from a drop down list, like WEB CHECKING, EDITING, and add time spent on that task. I want the first 2 records for LUNCH and BREAK only. Is there any way I can lock the task type for the first 2 records (but they need be able to add time) and let users pick the task type in the rest of the portal?

Thank you.

Share this post

Link to post
Share on other sites

How about putting a button on top of the description field.

The button would first check the portal row number. Then take the appropriate action.

if( getWindowMode = 1 //Find mode

goto Desc field

Else if( get portal row = 1 or get portal row = 2

exit script


Goto Desc Field

End if


Share this post

Link to post
Share on other sites

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
Sign in to follow this  


Important Information

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