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.
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)
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.
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.
P.S. The language/text on the layout is Danish, although shouldn't be considered an issue for understanding my problem.
By Yogi Bear
We have a simple Filemaker solution which tracks stock we order from suppliers (Item ID (unique Key), Description, Category, Invoice, Serial Number, Date, etc) which we used to track stock and print labels from. (Table: Stock Items)
I would like to make an improvement to this by adding a stock take functionality. As we barcode the items and print the Item ID I would like someone to be able to walk around the shop and scan each barcode and then we can generate reports from there. The barcode scanner is setup to add a carriage return at the end of the scan to move on to the next line.
I have setup a table called "Stocktake". We just want to enter the Item ID and then other fields can be looked up. (see attached screenshot).
The issue I have is that I struggle for FM to create new records. What I have setup is created a script which makes a new record, and sets the focus to the field Stocktake:Item_id
- New Record/Request
- Go to Field [Stocktake::Item_ID]
I have then added a trigger to the Item_ID field which on "OnObjectSave" runs this script.
I have two problems:
1. If I type in a stocknumber the record is entered into the table, the script runs (can check it using tools), a new record is created but when the script finishes the focus is not on the Item_ID field. In fact there is no field that has focus applied. However, if I manually click on "New Record", or manually run the script the focus is on the field Item_ID for entry for the next item.
2. I notice that the record only is recorded if I press "Enter" on my numeric keypad. If I press "Enter" on the main keyboard it will not save the record. I am aware that on a Mac these keys are treated differently. What do I need to configure here? The scanner we use for barcodes has been configured to add a carriage return but this appears to be the same one as the main enter key and does not enter records.
I must just be doing something simple wrong. If anyone could give me some guidance it would be greatly appreciated.
Platform is Filemaker 12 Advanced running on Windows.
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?