Jump to content
dav1089

New record/request doesn't put cursor in first field

Recommended Posts

Hello,

I want to create a script trigger which opens a layout based on account name ,create new record and put cursor in first field of the new record

Now, I was able to direct user to specific layout and also created new record using New Record/Request function but somehow it doesn't put cursor in the first field , instead it selects whole record .

Note: I also have script triggers attached to first and second field which runs on exiting the fields. (I don't think they affect anyways , but just mentioned to give idea)

Share this post


Link to post
Share on other sites

Did you try a script step to go the field in order to select the first field in the first record?

Share this post


Link to post
Share on other sites

This is quite confusing.

1 hour ago, dav1089 said:

I want to create a script trigger which opens a layout based on account name ,create new record and put cursor in first field of the new record

A script trigger does none of these things. A script trigger triggers a script - and the script does the actions mentioned.

 

1 hour ago, dav1089 said:

I was able to direct user to specific layout and also created new record using New Record/Request function but somehow it doesn't put cursor in the first field , instead it selects whole record .

There is no such thing as "selects whole record" - only one field can be active at a time. After creating a new record, the cursor goes automatically to the first field in the layout's tab order. If you don't see it there, then either you don't have any fields in the layout's tab order, or you have something extra going on that takes the cursor out of that field.

Edited by comment

Share this post


Link to post
Share on other sites
1 hour ago, dav1089 said:

instead it selects whole record

Screen Shot 2016-06-06 at 3.56.43 PM.png

When script runs, it just highlights the whole record instead of putting cursor in first field

In Layout Mode:

Screen Shot 2016-06-06 at 4.00.14 PM.png

 

My Script Steps: (This script is triggered "OnFirstWindowOpen" Trigger)

Screen Shot 2016-06-06 at 4.01.18 PM.png

 

Edited by dav1089

Share this post


Link to post
Share on other sites

Have you looked at the Go To Field script step?

Share this post


Link to post
Share on other sites
2 minutes ago, webko said:

 

Have you looked at the Go To Field script step?

 

Yes , I tried that already ...

Share this post


Link to post
Share on other sites

And that field allows data entry?

Share this post


Link to post
Share on other sites

 

16 hours ago, webko said:

And that field allows data entry?

Yes it does, it's a foreign key text field, you see in above image the first line of record which has "NONDKT" value, but when script ran it added new record but didn't put cursor in the first field

Share this post


Link to post
Share on other sites

Well, my experience differs from yours then - the following definitely works for me:

 

Screen Shot 2016-06-08 at 8.08.46 am.png

Share this post


Link to post
Share on other sites

 

18 minutes ago, webko said:

Well, my experience differs from yours then - the following definitely works for me:

This works fine when I don't put the new record script step on firstwindowopen trigger and put it on onlayoutenter ...

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

  • Similar Content

    • By Scott Pon
      Environment: FM13 with FM13 Server, mix of Windows 7 and 10.
      Is there a way to set a script trigger on if this portal row is new? IE, a script to run if this new child/portal record is new.  
      We have a parent record, and portal to Children records.  The children records have 2 fields: Profile Name and Process type.  Our user would like to enter a new child record (profile name and process type).  if the process type already exists, we will need to archive the existing record (matching the profile type).  There is more bI want to start with this first.
      I see script triggers to the layout "OnRecordCommit", but no similar script trigger for portals.  Any ideas on how to handle this?  Or am I going to have to add a button to go to another screen to accomplish this?
      Thanks.  I hope i gave enough info for you to help me.
       
    • By CRexen
      Hello everyone
       
      I am currently working on a database, which HR-Managers can access via WebDirect using login-information, to accede or resign their employees.
       
      I have made 6 possible option types for the HR-employees to enter data into, set by an unique ID, but with the use of the same fields.
       
      So...
       
      X fields with option type 1 (Accede)
      Y fields with option type 2 (Resign)
      Z fields with option type 3 (Maternity leave / leave)
      .. Etc. 6 option types in total.
       
      Now, based on my project description, a couple of the fields will have to be validated / not empty, which the HR-manager is prompted to enter before the record can be committed.
       
      Now, I am aware of FileMaker has it's own Field Validation, but I think the built in feature is bonkers..... (Sorry FileMaker..) 
       
      Therefore I was thinking of making a script to each of the different fields, which needs validation, and is this even a good solution
       
      Question one; how do I do this, the most easily? Is it possible?
      I have 8 required fields for validation, fields are global.
       
      Fields such as; Company Name, HR-manager name, HR-manager e-mail, employee SSN, employee name, employee surname etc. 
       
      I don't want the scripts to interfere with the other option types ( X, Y, Z ) which each is set by an unique ID, as well as fields, although the fields used in these option types are from the same table.
       
      Please see attached images of my setup.
       
      Hope you can help me, for the best possible solution.
      If you need more information, let me know.
       
      /Cheers
       
      P.S. The language/text on the layout is Danish, although shouldn't be considered an issue for understanding my problem.



    • By Dana G
      Purpose:  To capture the contents of a field before it is changed.  Compare the before to the after.  Highlight the after and screen capture then export.
       
      I can't get past the first sentence and it's getting frustrating because it seems extremely simple.
       
      1 Field:  OnDeck_t (text)  -  The OnDeck_t field data = On
      2 Field:  OnDeck_before (Where I want to capture the OnDeck_t before it's changed)
       
      I have an OnObjectEnter script trigger on the OnDeck_t field that runs this script:
      Set Field By Name [substitute (Get (ActiveFieldName); "_t"; "_Before"); Get (ActiveFieldContents)]
       
      If I do this it works fine.  (But I don't want it hard coded.  I will be using it for all the fields on the layout):
      Set Field [OnDeck_before; Get (ActiveFieldContents)]
       
       
      I have divided the Substitute (Get (ActiveFieldName); "_t"; "_Before") and Get (ActiveFieldContents) into separate lines in Data Viewer and both return expected results.  Why doesn't it work when it's part of a 'Set Field by Name' script step?
       
      Thanks.
    • By scoony
      Hi,
       
      I'm new to the forum so apologies if I have put this question in the wrong section.
       
      What I am attempting to do: I want to create a 'home page' that each consultant sees when the database opens on an iPad. The home page should have two pop-up menus, Client and the other Contact. For context, each Client with have multiple Contacts (generally employees and contractors) The consultants in the office want to be able to navigate to a Client they select from the pop-up menu on the 'home page'. The same process applies to the Contact pop-up menu. 
       
      Many thanks if anyone has ideas how to achieve this. 
    • By Alex117
      Greetings,
       
      I have a global field that is acting as a search bar to perform a find with the data stored in it. I have set an OnObjectKeystroke script trigger to the field to activate a script if the user presses the enter key while inside the field. Since most users are used to hitting enter on their keyboards to perform a search and it's much quicker, I've adopted this method as opposed to a search button. 
       
      I would like to prompt the user with a warning dialog if they press enter while inside the search field, but happen to leave the field empty. The custom dialog would tell them to type some search criteria in, instead of leaving the field empty to avoid performing a blank search.
       
      So far most of the script I came up with works, but for some reason it gets stuck in a loop during the last simple steps and I can't get out of it.
       
      I'm trying to have the following occur:
       
      - Exit the search field, and make it lose the focus.
      - Show a custom dialog telling the user of the error and prompting them to press "OK".
      - Upon pressing OK, enter the search field again and bring it into focus to set the cursor in the field so that the user can retype a correct value.
       
      The default FileMaker field validation that is found in the field's Options settings performs something very similar to what I described above. I'm trying to achieve a similar effect, but using a script instead to have more custom control and flexibility with the warning dialogs.
       
      Any help much appreciated.
      Custom validation - Search field.fmp12.zip
  • Who Viewed the Topic

    2 members have viewed this topic:
    zhgchen  Carsten 
×

Important Information

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