Jump to content
Sign in to follow this  
Steve S

Find/Edit fields

Recommended Posts

On a layout I want the user to be able to see the data in the field, search the fields, but not able to enter/edit the field in browse mode.

I now have a layout setup where the user can view the information and search the fields, but they can edit the text. If I select the 'do not allow entry into field' option, the user cannot search that field anymore as they can no longer enter it.

I cannot make these field strict as I need to be able to edit them in other layouts. Nor can I setup a 'search layout' in find mode, as I need them to be able to browse through the records before and after searches.

I'm sorry if this is a beginner type question, but I'm new to this FM stuff.. learning as I go.

Share this post


Link to post
Share on other sites

Here's a nice technique

Lets say your basic field is called "basicfield"

Now creat a new calculation field called "calcfield"

The calulation is calcfierld = basicfield.

Now you can use the calcfield for find requests, but users can't modify it because its a calculation.

Share this post


Link to post
Share on other sites

Very clever Mark.. Very clever.

thanks alot.

Now a question for another forum perhaps, but with all these additional fields should I be having concerns? Does it matter? I ask because I have now about doubled the amout of feilds in my DB.

Share this post


Link to post
Share on other sites

Without knowing how many fields you have, I'd guess that until you get above 1000 you'll won't have problems. At that point, it may indicate the need to split the file up, but more for maintenance than the fact that FM can't handle it.

Share this post


Link to post
Share on other sites

This simple technique saves the bother of creating calculated fields and keeping track of whether you are using the original field or the calculated field on a layout. The script is easily copied and modified for any field.

Assign the following script to the field ???

If[status(CurrentMode)=1]

Go to Field [FIELDa]

Exit Script

EndIf

Enter Find Mode []

Go to Field [FIELDa]

You should also ensure that this field is excluded from your tab order or the user could tab into the field and then edit / delete.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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