aguest Posted November 6, 2014 Posted November 6, 2014 Hi, I'm new to Filemaker and I'm working my way through it. I've created a form layout to add data. I've created a script that takes static data from a template table and loads it into specific fields on my layout. When I trigger the script to run from the scripts menu it runs fine and does as I need it to. However, I need it to run automatically when someone creates a new record using an ipad / computer. How do I get this to happen as I can't seem to figure it out and I can't find anything on here that tells me either. Thanks Ann
Wim Decorte Posted November 6, 2014 Posted November 6, 2014 FM has a number of events you use to trigger scripts, but from what you are saying, it does not sound like you would want to do it when a record gets created (because it does not contain any data at that point). You can use onRecordCommit, but then you have to make sure you handle all the scenarios where FM automatically commits (which could happen before the user is ready with the record). So the easiest solution is not to use events and triggers but use a plain old button on the layout that the users can click when they are ready to submit the data.
aguest Posted November 6, 2014 Author Posted November 6, 2014 Hi Wim, I do want it to populate when they create a new record so that they can edit the information (make text bold / italics depending on the observation they are making. These changes are then saved in the record also. I need to make the record in the first place. I've tried adding a button on the layout to create a new record (works fine) but the script (onObjectEnter trigger) doesn't do anything. What is it I'm doing wrong?
comment Posted November 6, 2014 Posted November 6, 2014 There is no OnNewRecord script trigger. Your best option, IMHO, is to script the creation of new records completely and remove the possibility of creating new records manually. Alternatively, you could trigger a script OnRecordLoad and populate the fields only if the record is new - i.e. when Get(RecordOpenState) = 1. But that's wasteful. Another option worthy of consideration is defining the field to auto-enter the default values (requires setting up a relationship between the two tables, though). --- P.S. Users should not record their observation by changing the text formatting. Text formatting is not data and it will be very difficult to process it in any useful way..
Recommended Posts
This topic is 3669 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 accountSign in
Already have an account? Sign in here.
Sign In Now