Script Workspace and Script Triggers

Hi folks, sorry to bother y'all with such a dumb ass question, but how can I determine which button (out of the max 3 possible) was clicked by the user in the standard Message Box. So what test should I do after the Show Message statement? (probaly material of lesson 1 for the absolute beginner, but I guess I missed that lesson) tnx Hank

I want to perform a find and if the result of the find is "no records found", then have the program ask a question "Do you want to do another find?" and have the option of picking "yes" or "no" for the answer and depending on the answer perform a script. Is this possible?

I need to schedule students in to special ED classes according to their level and subject. I have a list of times for which special ED classes may meet. For each student I have a List of time slots during which the students are unavalible. I Know I will need to sort the students by level and subject. What I am wondering about is if there is a way to filter out the unavailable times and sort by the availible times so that a group of students with the same level and subject may be put in a class together. Thank you very much for takin the time to read this.

Hi folks, I can't remember for the life of me how to script this: I want to have a calculated field that DYNAMICALLY marks only repeating duplicate records, not the first occurance of the dup. For innstance: Case(Count(SelfJoin::ID)>1, 1, "") This will mark all of the dups with 1, but I want to mark only the repeating ones. I'm aware of the script that does that, but I need to do this with calculated field as it must be dynamic. Thanks for the advice B

Hi all, I'm stuck with this validation script, triggered from a set of global fields for a new entry in my Master Company/Contact db. This would be an updated version of "My check dupes and messages" (see Sample section), where a set of error messages (not the ShowMessage nor plug-ins) - are appearing when the user clicks the proceed button and there are problems (first alert) - are changing at the fly on screen when the user fills back the necessary fields after the first alert. There are currently 4 results to the error messages calc : calc =1 : some fields are missing calc =2 : there is one dupe calc =3 : there is more than one dupe calc =4 : N…

I need to copy the values from one repeating field to another. The script I wrote looks like this: [color:"#666666"] Set Field ["Field_A","GetRepetition(Field_B; 1)"] Set Field ["Field_A"-2,"GetRepetition(Field_B; 2)"] Set Field ["Field_A"-3,"GetRepetition(Field_B; 3)"] Set Field ["Field_A"-4,"GetRepetition(Field_B; 4)"] Pretty obvious, however in Field_A only the first value appears, repetitions 2-4 don't show up. I'm using FM Dev 6.0v3. Is this misbehaviour known as bug? To solve this issue I'm currently copying the value into a global text field first: [color:"#666666"] Set Field ["gBuffer","GetRepetition(F…

I have a file in which people can store sentences, phrases and paragraphs. I would like to have a system in which they can select a stored paragraph with "xx" and "yy" instead of first name and his/her and have it change, for example, "xx" for first name; "yy" for "his/her" and so on then paste the updated paragraph into another field. I cannot remember how you make FileMaker search word by word within a text block and replace when it finds and then continues with he search, but I have seen this done. Any ideas?

In an inventory and invoicing system, I have an invoice with a complex validation script, which is activated by clicking an "add item" button on the invoice This script first checks that data exists in all needed fields, then: -- determines if the number is for a part or a vehicle -- if a vehicle, checks the Vehicles database for a valid number -- checks the Vehicles database to assure that the vehicle remains unsold If the number applied was a part number, the script : --checks a 13,000-record parts database to determine that a valid number has been entered, -- checks that the re-order point has not been reached --checks that the quantity ord…

Is it necessary to put a pause in a filemaker script which calls this applescript? It loops through all records setting the image to the path. set image_path_var to cell "ImagePath" of current record set cell "SKETCH" of current record to file image_path_var

I'm wondering if there is a way to script a layout clear. A way that would allow a clearing of all of the fields in a layout that doesn't require you to write clear field A, clear field B, etc. Better yet, a script that would start on a specific field and tab clear, tab clear. I have and am writing clears this way. It's a major pain especially with big layouts.

Hello world: Anybody able to point me in the direction of how I can re-direct a user to a certain layout based on their machine name? I would like to do this in the open script as to avoid a login. (for the time being) Managers, Production, Sales, and us Techies, share the same data but have different uses for it. Thanks so much for ANY feedback. Cheers and Beers Andrew

I have two layouts in the same database. One is miscellaneous and the other is data entry. Miscellaneous has a field call misc_desc and data entry has a field called data_desc. Now as it stands when I print out an invoice only the information in the data entry field data_desc is printed. But now I want to say that if the layout miscellaneous has information in the misc_desc print that information out on the invoice, but if the layout data entry has information in the field data_desc print that field out on the invoice. Both layouts would never have information in their fields at the same time, its either going to be one or the other. Is this possible to do and if…

When a record is in use by someone else and I try to access it, I believe I get error 301. It will tell me which terminal, if I have them named, is currently parked in that record. If I have Set Error Capture On in a script, then trap for that error, I no longer get the station name. Is there a way to get this? Haven't found a way yet. Thanks Roger Maxwell

Hey everyone! Here's the scoop. I'm re-writting the databases here at work...and I'm wanting to create a button that takes them to a list view or a form view...simple enough...but here's the catch. If they are in a LIST view already...I want the button to be FORM view button...and vise versa with just ONE button. So that if they are looking at a list view and want to go back to the form view they can just click that button and it takes them there. That the button changes to list or form view pending on which view they are currently in. Is that possible...and if so...how do I write or do that? Thanks for all your help! Jami

I have a layout and at the header I want to display the total number of records. Everytime I go to this layout I want to show the number of records. What is the best way to do this? Do I need to create a field and each time I go to this layout, run a script with SetField ["totalrecs", "Status(CurrentRecordCount)"]? Is there a way to update the field without the need to set it all the time. i.e it updates itself...it possible Thanks.

Hello again, I'm wanting to impliment arrows at the top of the database much like you use them in a web browser. Not to go from file to file like you would use the rolodex on the left...but basically to take you back to the last layout or entry you were in or vice versa going forward. Is that even possible? And again if so...how in the heck do ya do it? Thanks again for all your help and your time! Jami

i want to make and if statement that says IF CURRENT MESSAGE SAYS "NO RECORDS MATCH THIS REQUEST" PERFROM SCRIPT "CustomerInfoConverter" what function can i use?

Can someone let me know how you can instruct a Script to set the field value for a Perform Find within two global dates? In the SetField script step I can't seem to enter for instance g_last_date...g_first_date Thanks in advance.

How can I write a script that will, when I click a certain button that is the last field in the record it will copy all the information in the record insert it into the beginning of a new different database file delete the old database record that was copied and the new placement of the information copied not be modifiable, allowing me to carry on with the new database file input and showing me all the information from the copied database and not be able to modify the copied file once it is inserted into the beginning of the new database file of a different type. Is this possible? Any input would be greatly appreciated Josh

hi! I would like to perform a search with a script that looks in all fields and shows only the record corresponding to the searh condition. e.g: I have search field and if I write a number in it the script searches all the fields and retrievs only the record that is holding this number. so, how do I do it?

Hi - I have a set of records that I want to delete automatically on a certain (user defined) date. I was thinking of running a script against today's date, and if the current date and the deletion date match, have the record deleted. My problem is that this database runs continuously and is almost never shut down (which is how I think the Today and Status(CurrentDate) functions get updated). Is there a script that I can run that every 24 hours will update the current date? Thanks in advance Scott

Hi.. Because this is a scripting issue I posted it here although it refers to printing.. We have a folder on my windows machine whick we call "pdf_files." We store pdf files there. We stored the path and pdf file name in a text field in fm.(ex: c:pdf_filestest.pdf) We then used the send message (print document) using the field value. This has been working fine for ages for us.. Recently we moved our pdf files out to the web. so the new path is now (http://www.oururl.com/pdf/test1.pdf) Now the print command does not work. It seems you cannot use a URL as a path in send message. We can use the open url command to open the file in acrobat and then print in…

I have the issue that users stay in records for lengthy amounts of time (which with FM server caused problems). I created a script connected to a "done" button which would exit the reocrd request... They compalined about having to hit a "process" button for each transaction... Is there a way to: script without a button (so that when a users tabs out of a field) that I can make it "required" and force them to stay in this filed and make an entry... and after this entry is made that it automatically exits them out of the record... all without the i,pression that they are clicking a button... thanks

Hi, Is there any way to run FM scripts automatically at certain times of a day? To be more specific, we want to import data from a text file which is updated continuously. we want to have a process running to check the text file once every hour and import new records into FM. The OS is Windows NT. Thanks in advance.

Hi everyone, I'm running FM Pro 5.5v2 Developer under Mac OS 10.2.4 developing a cross platform CD. I've done cross platform disks in the past, but this is the first time I've created a cross platform Windows / Mac OS X CD. The main application is complete, however, in the past I've created a small starter app which autoruns on the CD. This takes the user through some help screens and gives them options to download latest versions of such stuff like Quicktime from Web sites etc using buttons. The final screen allows them to install the main app onto their hard disk. This is where I'm having the problem. The Windows version works fine. In the script I use an If s…

I'm having some difficulty writing my applescript in a field. I keep having an error of "This text does not end in a quotation mark (") or is longer than 253 characters." Can anyone help me understand to properly write the applescript in a field, particularly the proper logic of when to open and close quotation marks. Below is my applescript: (it renames a file that was originally exported using export/xsl) newsletter_refnum is the field that contains the unique reference number in the database. set postname to """ & newsletter_refnum & """ tell application ""Finder"" try set NLfilename to ""NL"" & postname as string set folderPath to (…

I'd like to have a button that would select a specific text field, then select and set all contents of that field to a specified font and size. How might this be done? Thanks, kent m

pressing enter will not continue a script for me. So i made a message box pop up and when enter is pressed, "OK" is clicked. Can i make the result of OK being clicked continue the script?

i want to run a script that will seache the"OrderDate" field for "in Process" but i cant figure out how to do it. i need to find all those orders and delete them. Thanks for any help.

I want to make a message box pop up and ask the user for an order number, they will input a number and press enter, then it will ask them for any more, if they leave it blank it will continue to the next step or they can put in more numbers and the script will use those numbers for later. Also, where is a good place to read up filemaker script basics. Thanks for any help.

why the hell does my 'send mail' script step always end up displaying Send Mail [No dialog, "<Field missing>"] ? i keep reselecting the subject field (which is definitely not missing), and sometimes it displays, sometimes it won't when i open the script. most of the time it doesn't.

Hi there, I want to load a Script in Scriptmaker without clicking a button to activate. (So want to load a layout and On-load activate the script)Is it possible?

Hi. I have a note pad field in which short paragraphs are added at the top to record most recent activity. Is it possible to have a script, attached to a button, that will insert two blank lines at the top of the field to prepare for entry of the next paragraph? Seems like inserting 2 returns would do it - if so, how do you indicate a return?

I have two database files: authors and quotes. They are related on authorID. In the quotes file I have created a button that takes me to the author's file and displays additional information on the author of that quote. Now I want to create another button in the author's file that takes me back to the quote I was originally viewing in the quotes file. How do I script the button to get me back? Do I have to set up another relationship? Thanks Scott

I currently have a script; Copy [AutoGroup] Go to Layout [DataEntry] Enter Find Mode Paste [AutoGroup] Perform Find [Replace Found Set] Enter Browse Mode My problem is this. If the name is "Smith Dealerships". I get "Smith Dealerships", Chad Smith Dealerships, Smith Brothers Dealerships etc.. How can I rewrite the script to only pull, in this case "Smith Dealerships"? The find selection is made from a pick list, so the name entered is always correct. Thanks for your help, B. Zilla

Hi FM-Workers, In a networked system (20 users with a FM v6 application with FM-server v5, in a all Mac configuration) the users want to select the appropriate library for spelling checking. Once set, the user is returned to the root when he wants to select another language. How can I set the filepath of the Select Library function in such a way that the path is remembered after reopening of the application? Are these settings stored in the Host' or in the Clients system (my logic says it must be in the clients-!)? Thnx, hope you can help! Paul

I am currently developing a databse for my school which will track children's academic progress from Kindy to Yr 6. I have got a front page which I want to allow people to work with a specific type of record eg Year 3 or Year 6 or 3J or 6A Each of the examples is a field within each record and I need a script which will allow teachers to work with a cohort of children they choose. Is it possible :?:: Many thanx Poida

There is a "client belongs to rep" field in our client database that cannot be modifed except by the sales manager. However, when sales reps create new accounts / records, they need to add their rep name. How can I do this with a script? Regards, EMC

I have several data fields with for every data field a related notes field (both text). There is a layout with all the data fields with behind every field a button to the notes field. Problem: I do not want to make a new layout for every note field, but one general layout which shows (depending on the data field) the related note field. My solution: Behind every data field a button with a script which takes the notes field and puts it in a global field that's being displayed in the notes layout. Problem 1: I have to write another script for every data field that writes the data entered in the global field back to the correct notes field. Anybody knows…

I have 2 fields salary and fee. I would like a button when clicked will take the number from salary field multiplied by 12.5% and the result entered in the fee field. THANKS

I have a list view, and one of the fields ("title") is a button that will take you to a detailed record. Someone in my company complains that sometimes when he clicks on the title, it takes him to a completely different record (and he insists he's clicking in the right place, and this has been verified by others here). Does anyone know what might cause this glitch?

Hi there, I'm a newbie with Scriptmaker so maybe some of you can help me with this problem: I have to make a script which IMPORTS RECORDS (dbf), then COMPARES the records with records in another database. Then IF they are the same DO NOTHING, ELSE REPLACE them. (everytime i have to import a whole new database, so i have to check every record every day). Is there a way to do this in Scriptmaker, IF yes...how? Thanks, Dennis

This forum is a fountain of knowledge as it allows us to pick each others brains and bounce ideas of each other and I have learnt a lot of new commands from what people post. I am not a newbie to Filemaker by any stretch of the imagination, I feel that I have a very good knowledge of what I need BUT there are many commands within Filemaker that I am not sure what they do. [color:"red"] Is there a document a place or anywear that tells people what each command will allow you to do??? [color:"red"] I feel that something like this would be a fountain of knowledge for newbies and people that have limited expierence of Filemaker. I feel that a document lik…

Am trying to have the email addresses for my 'Users' table auto create per the format that this customer uses. Of course everyone does things differently! I created radio buttons for these options: 1. <firstname><lastname> 2. <lastname><firstname> 3. <firstinitial><lastname> 4. <firstname> 5. <lastname> 6. <initials> Am not sure where to start on the If/Then script. Want the applicable result of the radio button selection to pull the appropriate format of the name fields & append them to the customer's &"@"&<domain name>. The result of course will be their proper email add…

I dont know if this is the right place for this post and I apologise if it is. I am trying to create a report that shows the first and last name from a record that meet certain criteria from a value list eg Books Returned Not Returned.........Returned........Unknown <--------- these are the values Peter................Bill............Raymond Christine............Ray.............Bruce Natasha..............Jessica Fred Kaye Is it possible Many thanx Poida

Aloha All I am trying to create a validation so that duplicate records are not entered. I have a lunch order database. Each child can order once per month. I want to create a validation that when a second record is entered for a student in the same month a message warns the data entry person. Any suggestions Thanks in advance

I need to setup a login for an application. The login is not so much from a security perspective but more from the point of view of determining which user is using the database. The login name will then be inserted into various database records created by the user. The username needs to be common across many related databases. I was hoping to use the "User name" field in the application preferences. However I can't find a way of editing this field via a script.

If I have a buyer that purchased an item and then printed out an invoice. Each invoice will have it's own unique ID, once an invoice is printed a date printed is stamped on the invoice. The same buyer comes back again and wants another item. The buyer ID is the same so the previous item purchased will also show up as the items are related by buyer ID. Now I have two invoices to choose from, both have a unique ID number but one has been printed with a date stamp on it and the other has not. How would I write a script stating that I only want the item that has not yet been printed to print? I think it should be something to the fact: "compare records if buyer …

Hello, everyone! This is a simple question but the answer would help me a lot: How can I add month by month? In a Loop script I need to add the next month to the next record in a set of 30 records. I tried Date(Month((invoice_date)+ 1), Day(invoice_date), Year(invoice_date)) but it didn't work. The year also wasn't affected. I'll appreciate if you can give me a hand. Thanks.

Once data has been entered in a field, I would like to restrict entry into this field except for one specific person. How can I do this? I am aware that I can write a script that checks the user and permits edit based on who it is but how do make the script run when they enter into the field?

I am a new user to FileMaker Pro 5. I am using a PC. My supervisor wants to be able to place controls on certain fields. Just wondering if anyone could assist me. Thanks!

Is there a way to "Lock" a field and not allow entry unless conditions are met.. For example. I have a layout with check boxes and a dropdown menu next to them. I only want the dropdown menu available if certain checkboxes are checked... thanks

I have encountered a very strange phenomenon in my DB: Sub-Scripts that used to run fine are being ignored. It is like my programming is starting to disintegrate. Did anyone of you encounter this problem. I am using FM 5.5 and 6 as well as FM Server 5.5. I tried all combination with the same effect.

Alright I still can't figure it out!!! I have a list layout which has all of the jobs for a specific day (each record has job# company name, due dates etc.). I want to be able to split this layout so that this list is on one side. The user would then scroll the list and select the appropriate record out of the list. On the other side of the layout is a calendar and other modifiable fields. The user could edit these modifiable fields (but not the fields in the listed records). This would allow the user to remain in the same layout to apply data to common fields by slecting multiple records one at a time how do I do this... I have no experience with portals...is …

I thought I posted this here, but apparently I was mistaken. Here's what I wish to do and here's how I assume it has to be done, but I lack the skills in scripting to make it so. I have a field named phone1. When the date is entered into Phone1, it is also part of the date that results in text_address. Text_address should append the "@" symbol and strip away any formatting of that number for emailing. According to the value that is chosen from a pop-up menu, mobile.att.net, messages.nextel.com, etc is appended to @ in that field value. That's part one of the task. Secondly, I wish to have a button which will take all of those addresses and put t…

How can I set a global value rather a repetition number in a Set Field script? For example: Set Field["File2::Field1"-global value,"expression"] (this syntax is not valid) rather Set Field["File2::Field1"-3,"expression"]

Hello, I would like to ask your help on how to make an About Script? I have a DB and I plan to make it a runtime solution using Filemaker Developer Tool. One of the question in making a runtime solution it that the developer tool ask me if I have an About Script? I appreciate any help for a sample code on About Script. TY

I have a FM app that has a button which will delete a record. However, instead of deleting this record I want to be able to push this record to a new db and delete the record from the original file..... specifically... I have a scheduling app with a delivery schedule which lists due date and time. Once the job is delivered the user "deletes" the job from the db to keep the size down... I want to be to track on-time deliveries so I created another database with additional fields such as "actual delivery date. Is there a way to add a script step that will "export" the data one record at a time to the new file.. I was thinking of creating a global calc to "paste" i…

Does anyone know if there is a way to tell if someone clicks on the Cancel button during a script in the Print Setup dialog box? I have been able to capture the Cancel clicked in the Print dialog box. Can't seem to do it with the Print Setup dialog box.

I am trying to omit some records that are classed as stolen or BER (Beyond Economical Repair) before I do a stocktake for my school. Can anyone help me with this code as it is driving me crazy Go To Layout ["Notes"] Go To Field ["Status"] If ["Status = "BER" or "Stolen"] Omit Record Go to Record/Request/Page[Exit after last, Next] Loop End Loop End If Many Thanx Poida

hello People! I am compleatly new to scripting deal = I know nothing ! Here is what I am trying to do: - Sort records based on field called "UPS Date" based on logic that the content of it is either empty or > than CurrentDay I "attempted" to write it out but no cigar ----------------------------------- Go to Layout ["Waiting List"] Enter Find Mode[] Go to Field ["UPS date"] Insert Text [select,"UPs date",">CurrentDate"] Pefrom Find[Restore,Repleace Found Set] --------------------------------------------------------this is it as I said I really dont know anything about scripts but that they are "nice"....if someone could help that woul…

OK, maybe I'm just tired, but the following script steps ... Show Custom Dialog ["Go to record","Enter a record #","gNumA"] If [gNumA > 0 and gNumA <=Status(CurrentFoundCount)] Go to Record/Request/Page["gNumA"] End If (gNumA is a global number field) ... don't work. I don't get brought to the record specified. It's as if it's not registering the change to the field's value. I checked, and Go to Record by field value works fine by itself. The IF statement passes (I stuck a pause just after it and sure enough, it paused). IS there something I'm missing about the Show custom Dialog script step? Shouldn't Show Custom Dialog change the value …

Hi Geeks I have a script that checks ID Cards when members check in. They swipe their id card and the script searches for their record. I want to display a message on screen for 3 seconds but I don't want the member hits Enter or Return on the keyboard to clear the message. I know about the "Pause/Resume Script. Is there a way to display a message without having to click OK or Return on the keyboard? Bikeman 17

Hi there. I am using FMPro 5 on Windows and Mac (with web interface in mind). I have created a relational contacts database. It has three databases: jobs, companies and contacts. The contacts database has lookups to the other databases in order to associate a contact with a job and a company. A contact may be associated with a number of jobs so I created 10 job lookup fields. In order to search through these I concatenated the selections with a space using the & operator into a text field (eg Job numbers 1027 899 456 etc). If you then do a 'contains' search on this field you would search accross the string. This works OK except if the contact works on an 11t…

I am working on a database for my father that has a main menu system that needs to open specific files with the use of buttons. How in FileMaker would I get it to do this, would I need to use a script. If so how would I go about writing it. thanks for any help

I am trying to write a script that will replace a text string within a certain field with an extended ASCI character. In this case, after migrating from a Mac enviroment to a PC environment, the original pie and delta symbols got converted to underscores and AE symbols. I have a script that will do a global find and replace, however I cannot get pie and delta symbols to insert from the calculation. It just returns P and D, respectively. The pie and delta symbols are shift+P and shift+D in the symbol font, but I know that script maker doesn't return formatted text unless copied and pasted. Anyone know any tricks around this? The field that needs these symbols, co…

How do i use a script to set printer options such as, portrait landscape, or current record, records being browsed, etc B)

I have three fields: [date to text] (Date)"3/1/2003" [text field] (number code) of "01" [calculation field] (Session Number) = (Date) + (Number Code) Is there a way that a user can enter the (Date) from a value list and enter the (number code) manually, run a script that says something to the fact that if the date is "3/1/2003" and number code is "01" that the field (Session Number)would be "31200301". Then whenever the date field shows the date of "3/1/2003" the (number code) is automatically entered with "01" and the session number would automatically populate with "31200301".

Another question i have is how to display back a selection of information. I want to write a script that will let me view results that only lie between __ and __ what would this script look like?

I found this thread, but it didn't really seem to answer my questions: http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB15&Number=59835&Forum=All_Forums&Words=Date%20Range&Match=Entire%20Phrase&Searchpage=0&Limit=25&Old=1week&Main=59364&Search=true#Post59835 I have a 'contact' file that summarized a lot of the information from many different files. I have a casenote layout in my contact file that has a portal with a reverse sort showing the most recent casenote made. I have a button up top that's for 'view/print range'. A popup comes up that prompts them for a start date and end date, both these are stored in …

I wish to send a mass email to clients so that each email recipient receives a PDF containing their unique information - each PDF is different for each client. I've stored these PDF's in a container field for each client record. I was hoping that I could merely specify the defined container field in the Message Field Value in the Send Mail script. The result: a blank message. Any assistance would be appreciated. Thanks, Mike

I currently have a script: Go To Layout [Multi Promotions] Enter Find Mode Go to Field [ProductDiscount] Insert Text [ProductDiscount]

Here's another question... I have an address field that contains info that often has a carriage return (for the suite or floor #). I want to split this address field at the carraige returns into an Address1, Address2 and possibly Address3 fields. One of our mailing houses is unable to read the carraige return for some reason and they end up printing a little box on our mailing labels where the return is supposed to be. Lame huh? Or maybe our system is lame for not splitting up the address field? Is there any way to do this within FM? I'm praying to the FileMaker god at this very moment... chewy

Hi, I want to pull multiple repetitions from several repeating fields and put them into new tables/files that will be more conducive to relational DB design. I want to take each repetition along with the UserID, for the field and put them into a new table... So I'm going from this repeating field table layout: ID RepeatingFieldValues 10 Value1 Value2 Value3 Value4 20 Value5 Value8 Value1 30 Value3 To something that should look like this: ID Value 10 Value1 10 Value2 10 Value3 10 Value4 20 Value5 20 …

Hi All, I am trying to migrate a 260 field ONE FILE DB to a newly designed db with many related files. I want to write a script to migrate the data and create the appropriate related records. THE EASIEST way would be to use a script step that created portal records. But it seems to me like i need to run an external script for each related file which sucks big time. Am i missing something? Can i create portal records from a parent file script?? I am trying to avoid using multiple globals and external scripts for every single related record. Basically i want to create new Portal record, set portal fields.. from the parent.. rw

Does anyone know an easy way for me to create a script that will change all the data in one data field? For example, say i have something in some of the fields that says 1, but i want all the things that say 1 to be number1, how would i do this using scriptmaker?

I'm not sure if this is a scripting question or a global field/portal question (or simply a popup or repeating field). I have a script which performs a find for all jobs on a peice of equipment. I want these records to listed in a menu with a scroll bar. Next to this menu I want to have a additonal fields such as "date to be completed" etc. The user could then select the record from the list and enter the data associated with record in the fields next to it without having to go to another layout... thanks

I am building my first database, and I am stumped when it comes to scripting. I am trying to build a script that will help me schedule printing jobs. These jobs usually reoccur at specific intervals (i.e. daily, weekly, monthly, etc

I have a validation problem, could someone help me out? I have one field where the person clicks in the combo box if the value is true (for example I have children : X) If they checked the combo box, I want another field to appear (for example : Number of children). But if the combo box has not been clicked, I don't want the field to appear. Or in the worse case scenario, the field Number of children could always be there but editable only if the user clicked in the combo box "I have children". Thank you very much for your help!

I currently have a row of check boxes each representing a task. (I.e. fold, trim, box etc.) When a user clicks on these boxes and exits the record a calculation field is filled with the first letter of all valid check boxes. It works fine...however... Is there a way to have a row of buttons instead where the user would click on the button (trim, box, fold) and the first letter would popluate a field. The user could click on multiple buttons and the first letter of all clicked buttons would fill the field. Conversely, if the user clicks a second time on one of the buttons, it would remove the letter from the calc field.. make sense? thanks

I have an invoice, but I believe I have it setup all wrong. First part - Header: I have the header reading company information. Second part - Body: Showing info from the payment screen. Third part - Footer: I have totals and a paragraph explaining the invoice rules. In the footer, I have related fields that has 4 repeated fields that show the payment history. If I try to use a Summary part, then I loose the payment history. The problem that I'm having is that when I do a find on the Buyer ID_NO and go to the invoice that all the records show up but they are all under the first Inventory ID_NO instead of their own individual Inventory ID_NO. I'm sure that th…

I'm having problems with a script I have. In my 'significant other' file, I allow the users to enter/edit significant other information. I have an 'ok' button which takes them back to a layout in another file. It also runs a script to go to the perpetrator master file. The script in the perpetrator master file is supposed to delete all the related records (related to the significant other file based on a field called Case ID). After it deletes the records, it goes back to the perp master file and enters the new information if the 'Perpetrator' field in the significant other file is set to something other than 'N/A'. I'm doing this because anytime someone would…

I have a database and in this databases I have a record of products. Each product has a type. The type can be of different value, i.e. camera, storage, etc. I want to be able to get all the different types and place them in a pulldown menu such that when they hit the button "go to type" it will go to a specific layout. The product records are created by importing a product listing which has a a part number, type, price and some notes. Is there a way to create a pulldown menu in a layour based on the unique product types found in the product db. Right now I have a button for each product type which unfortunately if there is a new product listed in the file, i…

I have sales twice a month and each sale I assign temporary buyers numbers. There are some buyers though that do have permanent numbers. After each sale I need to wipe out all the buyer numbers except those that are permanent. I was thinking that I would need a script that says: go to field (buyer NO) omit records that have permanent buyer field with "X". perform Clear all Is this correct or am I not even on the right path?

I defined a button that is attached to a script and in the the script is a "Perform AppleScript". I wanted to know how how to check the status of an the AppleScript after it has finished running. Is there a way to check the status i.e. (Status(CurrentAppleScript)) or something. Thanks.

I've created a script that imports a Juno addrbook.nv file and exports it in MS-Outlook Express address book format. The script performs 8 sub scripts the 3rd script of which isn't working when performed from the main script but works great if I run each script individually. The script not working looks like this: Go to record [first] Replace [No dialog, "RecordID", "Serial numbers"] Any ideas?

I'm not at all sure this is the right place for this post, but I think it's a good guess...:-) I have a client who prints label on Avery 5160 sheets (3 columns of 10 labels each). There are many situations where they will print only 9 labels, for example, which leaves 21 of them wasted. They save the sheet and put it in the printer the other direction the next time if they are printing fewer than 21, but they still end up with a lot of wasted labels, which bothers them more than me, but... :-) Anyway, my idea is to write a script that would do something like this: --create enough empty records to equal the number of "missing" labels (in the previous hypotheti…

Hope some of the smart people here can help with my newbie question. I'm trying to imagine a "show all records within date range" script that does not use 'start' and 'end' date fields but is run off an adjacent value list popup menu of each month of the year. A user could choose JUNE 2003 from the popup, for instance, and then hit the script button which would show all records from that month in the destination layout. Can't quite see how to insert the month into the script (Told you I was a newbie). Thanks all for any help.

is it possible to place the cursor (insertion point) in a given position inside a text field ? if I use "Select Field" or "go to field" the cursor is always placed at the end of the text. Thanks in advance for any suggestion..

I post this here, because it has more to do with scripting than with exporting. I have a persons database Each entry has a "details?" field with "yes" or "no" value. I need to export this database to a tab delimited txt file for other sources but for the entries with "details?"="no" i don't want to include some fields in this export. say i have 10 fields for each entry for the "yes" entries i need to export all 10 of them, for the "no" entries I only need to export 3 of them. but there should be a space instead (so this exported file can be imported in excel) I don't have a clue where to start I hope this is a little clear

Happy Monday folks! Rather than using the field definition, I would like to validate a field using a script because some users will validate it and some will not. The validation should be from a value list created by a field in a related file. I understand the IF business etc. I am just missing the calculation for the IF. Thank you so much in advance, Kay

I accidently put a "close" command in a script I wrote so now every time I launch the file it opens and closes on me. I would like to know if there is anything I can do to fix this or chalk this up as a dumb mistake and start over. TIA Kerry

I do not understand looping scripts very well and I want a fairly easy script to go to each record and perform a script on each record. I think this would take a looping script, but I'm not sure. I believe the script would be something like this: Enter Browse Mode Show all Records Perform Script (Script) Go to Record (Next) End Loop Could someone let me know if this is correct or not? Thank you.

I need a script that will ask the user for what sale date are you looking for and let the user enter the sale date then find the records that match that sale date. Is this possible?

Hi all, I've just finished making a new Registration/membership database for a science fiction convention.. Now, I've just found out that there is a mailing list that has the name and address of all of the former attendees. Since around 75% of the people who are going to attend the convention this year are probably in that mailing list, I was wondering if it would be possible to write a script that would allow the user to do the following: From the registrationDB -- type in a persons name, search the MaillingListDB and return a list of matches, let the user pick out the correct one (if there is one) and copy the address fields onto a new recored in m…

I have been reviewing the calendar samples need to understand about dynamic buttons. If I have a layout with a calendar where I can click on a specific date, is there a way to use these button to fill various date fields with different dates... for example... I have start date and end date fields on a layout and a calendar in the upper corner. Can a user click in the start date field then on the calendar button, that date would populate into the start date... then the user clciks in the end date, then on the same calendar, but a different date, and that date populated the end date.. Maybe there is a different but equal way to accomplish? thanks c

I have two different database files I am working on. Is there a way to combine layouts, fields and scripts from these DBs into one (i.e. copy paste, drag drop, etc.).. If not, is the only way simple reentering all fileds, scripts by hand? thanks

I have a date field which is a dropdown menu with dates for a month. Is there a way to change this field per record? I want to be able to add text "Date not selected" to the date field when a date has not been selected and "job done" when a button is selected to change this inof. I thought about having a transparent field over the top which would clear the date field and set text to a text filed over the top. This would work, but I cannot figure out how to clear the text field when a user actually selects a date from the popup menu... any thoughts?

I have an email script that is working fine as far as sending the email. But in the body of the message within the script, there are 2 shortcoming that I

Hello, I have a portal that shows only 10 records out of 100, after filtering the mother database. In order to add,(or substract) values of a field in this portal, is it necessary a script or is there another way to do it? In other words how do I add up the values from a field in a portal? Thank you Pablomac