Script Workspace and Script Triggers

Filemaker novice with a serious problem. I have auto-enter five digit serial numbers. I need to create a script that appends dash 1, dash 2, and so on... Ex: 89632, 89632-1, 89632-2... I'm completely stumped. Any help would be greatly appreciated. Many thanks in advance.

:confused: I would like to script the unique value validation rather then using the check box on the options for a field. I have a new screen and I want the first thing that is done when you press the accept button to be a validation that the value entered is unique. Is there a way of doing this? I've searched, but haven't found any instructions for doing something like this. Any help that could be offered would be great. Sarah

I am a new member struggling with the following problem. I want to search on two fields and I’m using the ‘constrain found’ set to do this. However it is not working. Can you help? The script is as follows. Enter Find Mode[] Set Field [Customer::User;Get(Accountname)] Perform Find [] Constrain Found Set [] Enter Find Mode [] Set Field [Customer::DateCreated; Get(CurrentDate)] Perform Find [] The above script returns the records by CurrentDate, but not CurrentDate and User. I would appreciate your thoughts.

I have a text field that automatically calculates a path to the image based on other fields. Lets say the text in this field is this: "filewin:/I:/jobs/241304/T1.gif" Which is a valid image if I put I:jobs241304T1.gif into My Computer it comes right up. I have another field on my form of type Calculation, which gets that path, and returns it as a Container. This works well. I get a shortcut to the image on my form which if I double-click on it will open the image up. But how can I get filemaker to put the image onto the form, not link it.

Is there any way to bypass the startup script to get into the application. I accidentally put in an if statement using the current user but upon launching the application all I get is a prompt for a password. I think I may be hosed. (filemaker 5.5)

I've set up [Prev] and [Next] buttons to move through records in a layout. When the user is at the first record I would like the [Prev] button to turn gray (not disappear) and be non-clickable. Same for the [Next] button when user is at last record. Is this possible? Thx.

I'm loving the Script Variables introduced in FM8. Although I've used only "local variables" so far, I see some powerful benefits of "global variables." But there is a nagging issue about how Global Script Variables behave in a multiuser environment.... Are Global Script Variables discrete to the user ... similar in principle to how global fields operate? Or, are Global Script Variables concurrently shared by all users? I suppose it comes down to this ... if two users run the same script, does User2 "inherit" the Global Script Variables set by User1, or are the Global Script Variables "sequestered" to their respective sessions?

I'm new to the forum, and am frustrated to no end. For quite some time now, I've struggled with this problem. First, here is my script: Go to layout ["School Finder"] Enter Find Mode [Pause] Perform Find [ ] Go to Layout ["Rating Entry"] Perform Script [sort by Inst Code/Name"] Here is the way it works. After clicking the button that starts the script, it goes to a layout with radio buttons by school names. The user clicks a radio button then clicks continue, and it takes you to another layout with just those records that contain that school and then sorts. My problem is that when more than one school has the same name with a variation, it fi…

Does anyone out there know how to write a script that would lock the user out of a data base after they created let's say 50 records? I have a DB I would like to publish as a "Demo" on my website, let the user "try before they buy". After they reach the set number of records it requires a password to iunlock to nuse full functionality. IF anyone can help it would be a huge help. Thanks, Steve

In my database I have a basic contact mangement in one table and an invoice in a related table. Currently I go to the invoice form and select my customers name from a drop down menu. How do I right a script that will copy the information from a field in the contact management, open a new Invoice and insert that information in the appropriate field? Any help would be appreciated. Russ Douglass

In FM8 you can attacha script to a button, then tab to the button and hit Enter to activate it. I am looking for a way to have a script take the user to one of these buttons. Easy to end a script with a go to field, but there is no go to button command that I know of. Any work arounds? The idea is to be able to activate a button via keyboard "Enter" as the next user step after a script runs.... without any mouse involvement. (These folks like their keyboards)

I've recently encountered a bizarre problem in my FileMaker 6, and it is frustrating me to no end. Before this week, I have never experienced an annoyance quite like this. There are four files involved with this scenario, but only one is causing the problem: Master, Schedules, ScheduleLines, and Conversations. The Master file's main purpose to be a GUI. A Schedule is an outline of guests to meet on a particular day, and so each ScheduleLine holds the ContactID and the topic they are suppose to discuss (I suppose you could regard the Lines as individual appointments). The Conversations table logs all the talks with the PR people; that is, all the conversations that le…

Hello, I have created a VERY simple database to learn with. It has 3 fields rec_id, name, age. I have created a button that deletes the record. Where can i modify this script from? I understand this is a pretty simple script but i am just starting learning ... Thanks, RF

Is there an easy way to specify all of the fields on a page? For example, IsEmpty{allfields?) Thanks, Sara

Hi all, wonder if you can help me. I'm trying to create a calculation field which compares similar records in a table, and I think a self-join relationship should do it, but can't figure it out! Specifics: There is a record for each exhibition visit. Exhibitions are annual (e.g. Exhibition X 2004, Exhibition X 2005, Exhibition Y 2003, Exhibition Y 2005 etc). Where someone has visited the exhibition in the previous year I want to display the difference in price he/she paid for that year. In other words: Ticket Price Exhib X 2005 - Ticket price Exhib 2004. Can I do this via a self-join relationship? I've tried relating a second occurance of the table via exhi…

Is there a way to replicate the Insert Text script step to be executed from a layout different than where tha target field is? I want to select a button on one layout and have two things happen...first, populate a field with specific text. I can do that with the Set Field step. Then I want to add a two digit code to a field on a different layout that will provide a summary or overview of the items selected. Because a record could contain 1 - 30 items selected, I don't want to replace text, but append it to the end of the list in the "summary / overview" field. Insert Text would work, but not from a different layout. Any great ideas for the idiot in search of his vill…

Hi all: Is there a way to check the user mode (ie Browse, Find, etc.)? I've never had a need for this before, and I'm surprised it's not there. Perhaps I'm not looking in the right place. I just assumed it would be a Get() function. Thanks in advance -Stanley

I have a problem with my clients database! I tried to create a script (& assign it to a button) that it will gather the records of the persons that their nameday (date field = dd/mm) & birthday (date field = dd/mm/yyyy) is in the current date. What I need is to make Filemaker export this found records list in 1 Excel file. I managed to do this, but the found set of each searching is overwriting the previous excel file exported. What I need is to export them all in 1 excel file with 2 worksheets (namedays, birthdays). How is this possible?

Hello friends, I have a silly request...that i cannot figure out for the life of me. I have a Radio Button field with 5 choices. When adding a New Record, i would like the Radio Button to Default to choice #1. How do i do that? Please be specific, as i am somewhat iof a beginner. Thanks guys

In my script, I'm using Freeze Window before I go to a layout which is my form letter and then printing it. The problem is, the form letter briefly shows on the screen. I thought Freeze Window would hide this layout in my script. Any ideas?

Is it at all possible to request a password to allow a script to continue. i.e. I am in layout 1 and press a button that will send me to layout 2. I must be authorised to do this and not just relying on the Get(accountname) calculation. As it is not always guaranteed that the person who logs on is the person who is using the PC at the time.... Is it possible to pull up a list of users available then select the user and then the correct password? I am trying to avoid having to log off and on to enable the correct account name to be used during scripts. Can anyone see what I am trying to do?

Hi, I need to update records without a specified field name. Field names and values for each will be passed over from the previous screen, and this script needs to update the records depending on the field name and its value. Please let me know how to do that. Cyont

I need to be able to open files stored in containers. Has anyone figured out how to automate this yet? If I export the field contents, it does know the file name because it comes up in the save dialog box with the documents full name in it, so when a script is written to do this with no dialog, why doesn't it know the file name? I tried to specify "temp" when setting the script, but that doesn't work because the extension is lost, so the open option doesn't work because it has no application assigned to a file with no extension. So, is this a bug/oversight on FileMaker's part, or has someone figured out how to get around this? (Maybe a variable that holds the name…

Hi people! I'm new to FMaker scripting & I have found a few troubles in my works = I try to create a manual clients DBase. 1. I have created a data field in a table representing the date of birth of my clients (full view dd/mm/yyyy). I tried to create a script that it will do an automatic search inside this field & show me the records of the clients that have their birthday today. I tried "perform find" step, but I cannot find a way to make the "day birth" field equal to the current date. If I enter "//", it will search for the year also, thing that I want to avoid (I just need the current date for day & month, NOT year). …

Hi, This may be a calculation rather that a script requirement? Basically I need to change either the background colour or the text colour based upon a choice of Yes or No. So if a field = "Yes" then I want to change the background to say red(or the text) and if the field = "No" then I want to have the field change to say Green! I thought of having a container with a graphic colour saying yes and a graphic colour saying no and setting the field with the necessary colour but I need to use the words Yes or No and I can't do this using a container. I need to "Get Graphic Colour" somehow? Can anyone help?

I would like to be able to set a script to export to a file name based on a particular field (username using the get function). Is this possible?

I want to make a layout with fields labeled A through K. I have that done, and now here is where what I want gets a little strange. I want to pull up a number 1-4 randomly in field A, in feild be random 1-2, field C 1, field D, E, F, G with random numbers 1-4, field H 1-2, Field I 1-23, and so on. Now, I don't know where to begin doing this, I was hoping that this was possible and someone out there knows how to accomplish it.

Hello, How do you get Filemaker 8 pro to give you a diolog box that would say something like 'Are you sure you want to delete this record' when a user clicks delete? This is for a database thats hosted using IWP? Thanks

using the email script, has anyone been able to create rich text for the body copy using calculation?

A simple but baffling script bug in FM 8 Advanced: In a found set, Data Viewer reports that the last record is Record 1, and the first 3 records are all Record 0. That doesn’t make sense in any universe. This is the sequence of single-step scripts I execute, and what Data Viewer displays. Go to Record/Request/Page [Last] Data Viewer shows Get(RecordNumber) = 1 Go to Record/Request/Page [First] Data Viewer shows Get(RecordNumber) = 0 Go to Record/Request/Page [Next] Data Viewer shows Get(RecordNumber) = 0 Go to Record/Request/Page [Next] Data Viewer shows Get(RecordNumber) = 0 That’s right. Data Viewer says the first record in the found se…

In the FM7 the script step go to related records doesn't work like it did in FM5. Any one out there able to explain the differences and what the requirements are for it to show related records on current window.

Previously with FM5 my script would be Freeze window Go to layout PrintThis Page set up (without dialog) Print (with dialog to define which tray to use...) Go to original layout and the user would not see the layout change but with FM7 the dialog for print step stops at the layout for printing making it visible to the user. How can I make the printing step seamless in FM7 but still keep the dialog for the user? Thanks all.

I am trying to create a mailing list with emails from different contacts. I have a table where every record is a mailing list. It has a portal with the contacts I want for each specific mailing list. I need a script that merges all the emails from every portal row separated by coma, and pastes that on another field to be used for sending the emails. I assumed that a script would be the best solution, unless there is another easier way.

Hello! Attached is the current interface I'm creating. [account name:test password:test] I would like to be able to search the database by selecting three cities, counties, zip codes, etc. Currently, one may choose multiple descriptions and an employee size range. But I'm not sure how to construct a script that will search the database based on the specified parameters [ie. selecting 3 possible cities, counties, zip codes]. When I try to search by more than one city, county, or zip code, it finds no matching results even though there are records under these specifications. I appreciate the help! Any tips on how to improve this is also greatly appreciated. …

I have a single field that is setup to assign a specific number R-06-0001 when a record is created. What I am trying to do is that if one of two buttons are pressed after information is placed into that record that the number change to either a CRNA-06-0001 or ME-06-0001. Can this be done?

I have a field named Current_Call. I would like to be able to move the contents of that field into a repeating field Call_History within the same record. How does one determine the next empty cell in a repeating field in order to script the proper Set Field step? Thanks!

Is it possible to write a script that changes the title of the window to the name of the layout without having to assign said script to every button on every layout? Conceptually, I am thinking of something that monitors what layout is being viewed and says "Ok, you've switched to layout X. Let me set the window title to X." Assigning such a script, manually, to every button that takes the user to a different layout is going to be like reading War & Peace in this instance, and is thus something I would like to avoid. Thanks for reading!

I couldn't find any info on this in searches, I apologize if this topic has been discussed before. I have a file that manages job sites for an elevator company...What I need to try and do is create a button that adds a field to a layout. Unfortunately I am the only person using the db that is familiar with FM so asking people to create a new field in layout mode isn't really practical. For example- I have 10 fields labeled "Passenger Car1" - "Passenger Car10", However 10 maybe more than enough fields for a project, or not nearly enough for others. I dont mind displaying 10 fields for the projects that have less than 10 Cars, but I need to write something tha…

I am really stumped on how to write a script to do this or even if it is possible to do. Please note that the only funtion this layout has is to provide a tab-delimited text file to automate data publishing in Adobe Indesign. I have an employee database with a field "Department" It contains various Department names. See Employees.fp7 So I was thinking of a script that loops and adds a new record each time the "Department" field changes and puts the loop number into the "PositonNumber" field and the Department name in the "DepartmentBanner" field then finally ends up sorted by "PositionNumber" ascending. See Picture 3.pdf Picture_3.pdf Employees…

How do I add CRLFs (carriage return & line feed) to the text of an email using the 'send email' script step? Currently the text is lumped into a continuous paragraph, regardless of CRLFs in the original text.

My FMPro 6 dbase has 1,237 records. The field exists in each record. I want to add a new field, titled , and then automate the population of the new field with text based on the code in the existing field. Example: The field is populated with the codes EE, NA, CO, and AD. I want the new field , which is empty, to display "Engineering" for all records with the code EE or NA in the field ....and to display "Chemistry" for all records with the code CO, AD in the field. Would a Loop script, or making the new field a calculation field, or would something else be the most appropriate/efficient, and what might it look like? I'm sooooo stuck. Hope …

I have a loop script problem in FMP 6 Dev. The Status field indicates whether or not a client has paid (either "paid" or "current"). In order to bill just the "current" records for a particular client, I have the following script to eliminate the"paid" records: Loop go to record/request/page [first] If (status="paid") omit record Go to record/requestpage [next, exit after last] End if End loop If I have multiple "paid" records and only 1 "current" record, the script works OK. Howver, with musltiple "paid" and multiple "current" records, the script hangs and I have to manually end the loop. What am I doing wrong?

Hi, Is there a way to set a script to automatically email indivduals at a certain time to do a particular task?

How can I create a script that will allow me to move one record at a time to another db? I would like to create a button that would sent the active file to a clone db.Thanks for the help.

Can someone show me how to do incrementation? There is a file with the field "name" and the field "number of times" in it. When "Tom" is entered into the file the first time, the number 1 would appear in the "number of times" field. When "Tom" is entered again into the file (as a separate record), the "number of times" change to 2. I want to be able to not have a second record, but instead have one record with the 'number of times' as 2. Thanks.

I am trying to create a script that will determine the number of months there are between any two given dates.

Hi all, Happy New Year! I have a membership database with various layouts that contain the following fields: Union Start Contribution Amount A The Contribution field is a pop-up list containing the following contributions/membership fee list: Adult - £1.50 per week Juvenile - £1.11 per week Retired - £2.50 per mth Student - £10.00 per year Unemployed - £2.50 per month What i need to be able to achieve is to have the 'Amount A' field automatically work out the Contributions paid from the date in the 'Union Start' field upto the present date. For reference: Adult = £1.50 pw Juvenile = £1.11 pw Retired = £0.58 (58pence)…

My database has a number field for users to search for a particular amount. I made it default as less than or equal in the find script. Set Field[number field, "<=" & number field] But a user wants to do other find operators, e.g. >=. Is it possible to use Case in the script if a user enters a operator in the field, the default operator will be overidden?

Help I need to script a button to do a "find" without the use of the ststus area.(and show all records after it completes the find) I've worked all day on this & I know its easy to do but my mind is fried I think. Pleas can someone help me out?

Having trouble calculating a table of dates. I have two columns. One is to calculate 12 days from start date and the other 15 days. Catch is that the calculated dates must skip non-business days. Federal holidays are a given and then there are exception dates that I can make non-business days. Please help! I need this ASAP or I'll have to do it by hand. Thanks! Date_List_2005.zip

I've made a script to export a file every 30th seconds of the minute base upon Status field. If there's a new record added, the status will mark as "NO". If the new record/records are exported, it the status will mark as "YES". There's a trick to this inorder the script to work is that I must have a dummy record that always says "NO" because if the script found nothing it will pause and say no record found. Here is how the script goes, Loop Show All Records If[seconds(Get(CurrenTime)))=30] Perform Script ["Enter Find Mode"] {which looks for records with the "NO" status } If[Get(FoundCount) > 1] Perform Script["Export Dow…

This has proven to be a real mind bender for me. I thought I had a solution but it doesn't work, and figuring it out seems to be above my skill set. So....I throw myself to the mercy of the list for assistance. I have a DB where my client wants to be able to view the contens of prior records as they relate to a new record, based on a match between the clients "customers name" and a "design number" that belongs to that customer. So when a customers name is entered in the "Name" Field, and a number is entered in the "Design Number" Field a realtaionship shows the resulting occurences. That is easily done trough a portal. The next part though is where i…

So I used the "Business Productivity Kit" as a basis for designing a solution for tracking items from Purchasing into Inventory and then into Sales. Each are set up as separate files, with relationships defined between the "Product Code" fields in each file. In "Inventory" there is one record for each unique Product Code, containing information about the product (including the quantity currently in stock). In "Purchasing" and "Sales", the Product Code field is repeating, to accommodate purchases and sales of multiple products. I have an "Update Inventory" button in these two databases which is supposed to step through the repeating field, and for each repetition updat…

I have a field that shows the current time. But it only shows it if you click on a command button that refreshes the active field that holds the "Insert current time" I need a clock that is continously running, or use the "Insert current time" or timestamp. Here is what I need to do. When a user looks up an employee and finds them, I want the time to be inserted in a field showing the exact time the employee was found in the database. The time has to be in that person's file. Can this be done automatically or do I have to have a command button that the user will have to click to put a timestamp on that file?

I discovered that if I copy and paste multiple scripts within the same file that are linked, when I rename them, any copied scripts update to the new file names. Example, I copied New Client and Update Client, and pasted them in the same file. New Client has a script step that runs Update Client. Added 1on1 to the end of both scripts. New client now calls Update Client 1on1 instead of the original file. I was TOTALLY excited when I saw this. Anyone else seen this before? Am I simply way behind the times here? Later!

I have a database in FM 7 that has 3 related tables. The main file has basic info such as patient#, age, gender, etc. I have created the associated tables with a relationship using patient#. The 3 related tables are info from 3 visits to the office for pre-op, post-op and 3 month followup. On the main data entry layout where we gather the basic info mentioned above I have 3 buttons that call the other 3 layouts for data entry into the associated tables. I want to enter the data in the main layout and then click a button to load the second data entry layout but to check for the patient# in the new table and pull the data in if it exists and to create a new recor…

Can someone help me create a script to find all of these special characters !,@,#,$,%,^,&,*,(,),_,+) This field must only be Alphanumeric. Once a serial scan in, I need a script to check if any of those characters exist and prompt in a window. Thanks, -TDo

hi, i am a doctor and i m creating a db for my pt's and i have a field named (race)and i define to it multiple value list as (white, black,..), i want in seperate table in a new field to list all the names of patient that all white, and in other field to list list all the names of patient that all black, so on plz help me, i stucked here for 2 days appreciate that

I m new in FM, and I m a Doctor and i want to do a data base of my patients in my clinic, so i prepared a table with primary key is the medical file number and i create records of my patients and i want to know that if the the patient came back to my clinic and i put his medical file number, how all his previous data as name and age and address automaticaly reenter in his new record?

Is it possible to automatically generate a filename using Script Parameters or another script step? I have a co-worker that prints a found set of records each week. Each record has to be created as a separate .pdf. I have created a script that accomplishes this but it would save her time if the filenames could be automatically created using existing field data. Thanks.

Can someone please tell me why this script (see below) doesn't work? What it is supposed to do is print the first record in a set, change layouts, go to the next record, then print the remaining records in the set from the new layout, and exit after last record in found set. To me, this script seems like it should work, but it does not : . It changes layouts as it is supposed to, but it does not seem to perform the loop as it just keeps continually printing the "first" record and never exits the loop. (Thank goodness for Acrobat!) Go to Layout ["sales Order Page 1 of X" (Sales Order)] Print Setup [Restore;No Dialog] Print [Restore;No Dialog] Go t…

I have a script that prints a layout without a dialog. But a print progress dialog still shows up (printing 1 of 10, 2 of 10, 3 of 10, etc.) and there is a Cancel button the user can click on to abort the job. How can I trap for the user clicking the Cancel button from this dialog? Thanks.

The FileMaker runtime I've created takes a while to load. In addition, a blank window shows up about 5 seconds before the layout inside the window decides to make its appearance. How can I make some kind of "Loading...please wait" message appear *immediately* to reassure the user that all is well? The message would need to disappear, of course, once the layout pops into view. Thanks.

Ok...here we go. I have been working on filemaker for about a year...but it is self taught and I am at a road block... I'm an artist in a managment position that isn't going well. I am trying to take an already created report and sorted by range then each range is sorted alphabetically. The field that I am having problems with is a sub-summary in a report. Let me try to explain better. I have contributors that give money a few times a year. I can create a report for a "found" set of time. The report that I have adds the total moneys for that time and gives me a total. So each person is listed only once with the total amount for the "found" set of time…

One of our developers wrote a script for running reports on employee production statistics for a project management database we are developing in FM8. The way the script works now is that when a report is run, a script runs a number of secondary scripts, each one a copy made for an employee to find their entries in a time log. Here's an example of a couple of lines from the script: >Paste [select; PD Employee Report::Month Year] >Insert Text [select; PD Employee Report::Employee ID; "XXX XXXX"] This goes on for all field entries for employee XXX XXXX. The results from the secondary scripts for each employee are then compiled by the first script into a n…

I have a a portal showing records from Table 2. The portal is in a layout linked to Table 1. There is a button in the portal which activates a script to create or update a record in Table 3. I have a script which creates a new related record, or only updates some fields if it finds there is already a related record. What I can't work out is how to check when there is no record from Table 2 showing through the portal. In other words, if a user presses the button by mistake when there is no record showing in a particular portal row. I'm sure there is a very obvious function to do this, but I'm dammed if I can find it...

I have a field called Activity. The field is formatted with a pop up menu containing 4 choices. The 4 choices coincide with layout names. What I would like to happen is: Upon data entry, the user selects "papers" from the pop up menu, he will then be directed/rerouted to the "papers" layout. If the user selects "presentations", he will be directed/rerouted to the "presentations" layout, etc. I have downloaded the EventScript plug in but I cannot figure out how to make it work. Anyone? :

I need an "IM" utility within my solution. I have the ability to create projects for various users and I want to use an IM to notify them of changes to their schedule. Does anyone one have any examples of how to make this work?

I've had alot of trouble getting a compound IF function to work... in fact, I've never gotten one to work. Here's my latest effort. Can't figure out what I'm doing wrong. This occurs in the middle of a long calculation that concatinates a bunch of stuff into a giant global text field. Everything works, except the lines "OR" in them. These work in the case of whatever condition I put first, but not what I put second. The example is supposed to put " " in the field whenever LocCurrentRez::Apartment contains either nothing or "n/a" As it is, it will put " " in the field for "n/a" but not for "". So I'm guessing that there is something wrong w/…

I've written a FMP8 database to track requested vacation and personal days. I have a screen that the end user would use to put a request in and then when they accept it an e-mail is generated to the manager saying there is a request that they need to review. After they accept or deny the request it sends another e-mail back to the end user. The problem I've run into is this needs to be web based, but I can't get the send mail parts of the script to work through the web. Is send mail a script step that is supported by the web interface?

I'm a newbie to FMP when it comes to using Scripts and Calculations. I'm trying to do the following. Lets say I have 3 records with the following data in the field Record# FieldData 1 A 2 B 3 C The final result is I would like to have a field that contains all the data records from the file with commas separating the data within them. So the data within this field would look like this. A,B,C I've looked though the other posts and it appears I'm going to need to use a global field and a loop script. I've played with it some and have not been successful. Any help would be greatly appeciated.

Hi all, So today I would like to add a little reminder ability on to me orders, say a check box that would give me a calendar box to then set a due date or something. And then once the date is reached a message or something comes up to tell a user the order has hit its due date. Is this possible? How would you do it if you had to? thanks

I have a bunch of differently named PDF files, each corresponding to a record in an FMP 7 database (Mac) called "testinglinks". For each record, in addition to providing data relating to the corresponding PDF file, I want to be able to open that particular uniquely named PDF file via a scripted button based on the field containing the PDF file's unique filename. The name of that field is "testinglinks:imagefile". I have tried using a calculated Send Event utilizing the PDF default application Preview to no avail, even after playing with pathnames ad naseum. I have also made a rough attempt using lots of variations on a calculated AppleScript, again meeting fa…

This may have been asked before, but I'm having trouble coming up with the proper search terms to find it, if it has. Anyway my question is pretty basic: I'd like to generate a list of random dates when the user requests it and enters those dates into the proper table. My set up is like this: I've got a client table. Each client in the table can have multiple dates associated with it. So, the clientID is a foreign key in a one-to-many relationship with dates. I'd like the dates table populated with the foreign key (obviously) and the random dates. Any ideas? I'm running FM 7, if that matters. (Please remember that I'm a newbie. )

I've created a container field and attached a button to this field. When I click on the button it activates a script. The first item in the script is to set field [a text field] Get(activefieldname). When you click on the field button it does not recognize this as the active field. I have a work-around by having the field button perform set field and manually entering the data. I have another button which activates the remaining parts of the script. Is there a way to get around the two step process?

Can this be done? I have tried variations all afternoon with no success. I want a table that has one record for each user only – the record being created when the user account is opened and deleted when the account is closed. Each user can only see his or her record. The table, and respective records, are to open when the application starts and the user logs on. The idea being that the layout will act as a ‘main menu’ with various buttons for scripts etc plus a text fields in which the user can add notes & reminders – which will only be accessible to them and part of the ‘larger’ application. It looks like it should be possible but I have had no luck…

Hi, I need some help... I want to make a diary report that show's all new records entered today (by example). I have a layout that user can make new records and in this layout there's a button called "Diary Report". When the Administrator press this button, it opens other layout called Diary Report. I need a script that shows all records entered "today" and link in this button. Thanks a lot!!!

I need a script to select a primary key value on one layout, and paste it into a join record on another, in a field that is a pop-up menu. In context one table is for Presenters, another books Presenters to take adverts, whilst a final layout details each advert. Rather than have to search through hundreds of Presenters on the join record, I want to use a button on the presenters page to open a booking record and paste the name in. I'm sure there is a simple answer to this on but can't find and answer on the forum. Advise appreciated.

Hi, I'm trying to make a script that copies the content of about 30 consecutive fields from the previous record into the same field on the current record. My current solution is to, one by one, go to previous record copy field x go to next record paste field x This makes for a long, tedious and inefficient script that takes a long time to execute. Is there a better way? Thanks Andrew

Has anyone come up with a good way to pass parameters to scripts in FM8? I have been using the trick where you do this inside the script Let( Evaluate(GetScriptParameter), X ) for each variable, and you call the script with the following syntax: X="foo" ; Y="bar"; Z="foobar" However, there are some things I don't like about this way of doing it. 1. Documentation -- what's the best way to show that a Script has parameters? I find myself having to open the script to double-check I have the parameters named properly. 2. Syntax / Ease of use -- creating the calling parameter string is ugly, lots of escaped-quotes inside quotes, i.e. to ma…

Hi, I want to copy the content of all the repetitions of a repeating field into a repeating field from another table. Can this be done with a simple script step or do I have to use 14 instances (one for each repetition) of the "Set Field" script step?

When I open up the dialog box to generate or edit a script I am presented with the options of: VIEW: All by Category VIEW: All by Name By default this option is set to: All by Category, but invariably I select: All by Name and then I start the scrolling process. Is there a way to set the default to: All by Name? Or, is there any way to get to the script step quicker than scrolling from A to Z? This isn't a major problem but it is an irritation. Any ideas? Jarvis

Do you have to put 'Allow User Abort [Off]' and 'Set Error Capture [On]' atop every script? I want these settings to be in effect throughout my app, with every script. I believe they are the system default settings. But after looking at various script examples and doing some tests myself, it seems you may have to keep reissuing them? Can anyone clarify? Thx.

It is possible to make a script that can hide any layout from layouts menu if any user log into File Maker and show all layouts if Administrator log in?

Hello everyone! I was wondering if someone could help me out in regards to using the "Send Event" script step for creating NEW Folders with names taken from a script variable? I've seen this done on Windows, but not on the Mac OS X platform. I can't use Applescript because I can't pass my script variable to the actual applescript. This is a really simple solution because there are no space in filenames and the NEW folders I'd like to create are just a series of 7 numbers. However, the problem I'm havingis that I can't figure out what the unix commands are to create my folder (mkdir and the path is about all I have going for me). If someone can help me out with this …

how is it possible that a script only works 45% of the time, when its a seemingly flawless script, why would it work with an iput of 1, but not an imput of 4 what could cause such inconsistancy < that doean't even begin to describe how i feel right now

Hi, I am puzzling over the new Script parameter functions. I wish to have one script that functions across multiple tables, which uses SET FIELD in whatever the current table is. I know that I need to somehow pass Get(LayoutTableName) into it, but cannot figure out how to do so. Could anyone advise? I know it is a basic concept, but I am missing something. : many thanks! julia

I have a series of layouts that are letters and a main page that people can enter the contact information and request a specific letter. I could like to create a script to go to each letter layout find all that have the REQUEST DATE equal to the current date and print the records found. If no records are found then move to the next letter. Any suggestions on how to do this? Thanks

Hi all, Since I gleaned so much useful info from the terrific responses from forum members in my Local Vs. Global Variables topic, I was hoping to gain some more knowledge on the topic of repetitions in script variables. Basically what I'd like to know is if anyone is using this feature, and why. Are repetitions of variables any more (or less) useful than repetitions of fields? I was actually a bit surprised to see repetitions as an option when FM8 introduced script variables, considering the already limited use of field repetitions by many experienced developers. After I "discovered" field repetitions and went through the "wow, look how you can write an ent…

Obviously this can be done very easily manually, but I cant figure out how to script it and I am wondering if anyone has an idea I can borrow from shamelessly. I am trying to automate a script that shows receivables on open orders/invoices for balances open 0-30 days, 31 - 60 days 61 through 90 days and 90+. My main problem is I can't figure out how to do a "range" find in a script. Any help would be greatly appreciated. Thanks, Steve

Don't know what I've done this time but ... I have a script to print receipts to .pdf and then email them. It all works beautifully except for one minor glitch. When scripted, I get a message along the lines of "Cannot create the file on this disk. Make more space, use a different name, use a different disk ...." It worked fine when I saved the file to a fixed location. Now I want to save it in the same folder as the database and it doesn't. The command to save as a pdf works fine when done manually. My path in the save as pdf is - file:SH_Event/Receipt.pdf Any (polite) suggestions would be most welcome.

I would like to create a script to alert and prevent errors when amount A is greater than amount B. If possible, the script will not allow user to proceed without making the necessary correction to amount A. How can I do this ?

Hello there. I have what is probably a simple question and it seems a scripting question, but perhaps there is a better place to post it - if so, let me know. I have a large tab separated file with the first row being the field names. There are just under 3000 fields in the data. Each of the fields needs to be set to numeric but when I import the file, all the fields come in "text". Is there a way to automate the change in field type using a script rather than having me go through each field and change the value? Thanks in advance for your help. Josh

imagine iCal or other calendar apps: i can create an event and set it to repeat every week, every other week, 1st saturday of each month, etc. now, is something similar in filemaker? i've got 400 clients that typically stick to a schedule... say, a house cleaning business... the majority of those clients have a consistent schedule: weekly, monthly, etc. as i have it now each appointment is set manually but if i could script some sort of automatic record creation and repeat it based on some sort of date based pattern? this seems like it would be a very complicated set of scripts and calculations... i'm not sure how possible it would be??

I am trying to create a script that when a button is pressed a corresponding pdf file is opened from a shared drive on the network. I can't seem to find any script command for opening files (other than opening other filemaker files). Is it even possible to open up a file on a shared drive from filemaker?

Hi all, I've been using script variables in place of the majority of global fields I used in solutions developed prior to FM8. Recently I noticed that every time I've replaced a global field with a script variable, I've made the variable global also...which leads me to the question... Is there ever a time when a local variable is superior to a global one? I believe I have a good understanding of how each one behaves but I've yet to figure out why one would use a local variable over a global one. Thanks in advance!

Hello everyone, I am not sure if this is the right forum but I am lost. :-( I want to use FileMaker to create a form for some staff to fill out at the school that I work at. They deal with the naughty kids and the staff need to keep an eye on them and not spend too much time entering data at the computer. I planned out a list type form in my mind and would like to know how to implement it. First, I have a database with student IDs, First Name, Last Name, Room Number, and Grade. Second, I want to keep track of students getting in trouble and for what reasons.Using popup menus with our schools discipline codes. Third, I want the…

Our employees send requests for task numbers to be added into our timesheet software so they can bill for time spent on a project. Our previous method for doing this was very inefficient. Someone would make a request using and Outlook Form. Because not all requests get approved, it would be sent to the team admin to review. She would forward it to accounting. Accounting would add the task to timesheets and print a sheet at the end of the day with a list of what was added that day. Accounting would take the list to the team admin. She would sift back through her e-mails to find the requests that were set up and manually enter all of the data into FileMaker…

Hello, I have a layout with many fields and I was wondering if there was a command in the scriptmaker that would clear them all at once, instead of having to choose clear in the scriptmaker for each individual field... Thanks for any help!!

Hi all, I'm about to start developing a project in FM8 that's very similar to a project I already developed in FM7. In my original project I relied heavily on global fields in a set of scripts for parsing EXIF metadata from JPEGs. I'd like to replace all of the many occurrences of those global fields with script variables. Is there any way to do a find & replace in a script? Here's an example of what I'd like to do: Script currently says- Set Field [shutterSpeed; Left (gMetaData; 11) & Middle (gMetaData; 14;20)] I want script to say- Set Field [shutterSpeed; Left ($$MetaData; 11) & Middle ($MetaData; 14;20)] The above a huge oversim…