MsqedMan

Hello, im a little stuck. in a DB, I have a field that is a calculation of three other fields, [length], [connector.type], [pairs]. An example in that field might be “100’ G3 15pr” Im trying to do a report that gives me the found count of every value that the calculation field has. Basically, how many “100’ G3 15pr” do I have in my DB Im sure it’s an easy find, but I’m drawing a blank. Is this a simple function I can do in a report, or is it a scripted thing? Can anyone point me in the right direction please? Thank you, Tony

Hello Brent, This does make sense, and I understand it. What I don't think I have a grasp of is how to sum the Quantity.In and the Quantity.Out fields of the related records. How do you summarize the in and out records for item number 12, say? All I can get is the initial stock in number to show up in my summary. If I add or subtract any number it does not reflect in the On.Hand number. Thanks for your help! Tony

I must be brain dead today. I am throwing together a simple inventory program. I need to track how many of each item I have on hand. In one table, I have the items. In another table, I have the stock in/stock out numbers. I am going item by item, if you give out 3 of an item, you stock out 3, if you order 20 more in, you stock in 20. On the Items layout, I have a portal of the Stock In/Stock Out activity. I am looking to put in a summary field that tells me how many of that item I have on hand. In the Stock In/Stock Out table I have fields for Qty.In and Qty.Out. The Qty.Out is a calculated field which just *-1. Can't I just take and make a calculation field which is Sum(Qty.In) + (Qty.Out)? This doesn't seem to be working. And as usual, I'm sure once someone points in a direction, it will come flooding back to my brain. Thank you all for your wisdom, tony

Thank you! It's amazing how a little syntax typing error makes a big difference! I am amazed at the wealth of information on this forum. Tony

Hello, I have read back through the answers already given, but I am still having a hard time scripting this simple task. I am trying to create a PDF document, with the file name being PO:Approval & ".pdf". I am saving that file to a folder on the desktop. In saving the PDF, I can create an email with said file as an attachment, but I have to go back and fill in all the fields of the email. If I try and use the Send Email script step, I can't figure out how to attach the file I just created. It seems that the "Attach File" parameter is looking for a specific file. What am I missing here? Since I want to send both Purchase Orders and Requisitions, I would like to be able to script the email subject accordingly. Thanks for any help, Tony

Thank you! I seem to always be looking at a more difficult way to do things. This is exactly what I was looking for!

I have a database that keeps track of inventory. I have a field [location] that has only 4 options. How do I get a count of the records with each of the 4 options? I would like to put a global on a layout that would tell the user how many of a certain type of product is in each of the 4 locations. Any help would be appreciated! Thank you, Tony

Ok, so I have another question, one which is probably easy and I am just not looking in the right place. I am using a database to track items that are serial numbered. Some of these items are paired with another item, and in the record, there is a field "Paired SN". I am trying to write a script which will go to the Paired SN record. I think it's a Perform Find step, but I may be wrong. Any help would be greatly appreciated! Tony

Aggravatingly easy and simple, I just didn't look in that particular location! Thank you so very much!!!

Yes, that works, but only once. I can get it to do a "1" or a "2", but I can't figure out how to string them together to make "56199" for example. Is there some use of a loop function that I don't understand?

I am working on a database that is mostly mouse based, meaning all boxes are drop down menus or calendars. All input can be done with the mouse. There is one field, Serial Number, that I have to go to the keyboard to enter data. I am wondering if there is a way to enter the numbers into this field using a 10 key pad in the layout. Button "1" would enter a 1, button "2" would enter a 2. Thanks in advance for any help on this!

I never thought to do this with a relationship. This works great. In my layout I could put a portal showing me the tv channel information. How would I continue this, though, to raise a flag if I choose a carrier frequency? Would I continue to use relationships or would that be a validation? This is the gritty part of FMP that I am not very clear on. Thank you for the help so far!!! Tony

Thanks for the help so far, and as I re read my post, I realized it didn't make much sense. I have attached a file that has the TV Channel numbers and info. what I am trying to do in another database is to be able to enter in a random frequency, and have the TV channel field come back with the TV Channel. So, the calculation I'm trying to do is to see if "Frequency" falls in the range stated by "Band.Low" and "Band.High". I would also like a flag to tell me if I entered a frequency that was very close to the "Audio Carrier", "Chroma Carrier", or "Video Carrier". Again, thank you for the help. Tony RFStuff.fp7.zip

I am trying to do an autofill field with a calculation that I just can't seem to fight my way through. I have a field "Frequency" and want to calculate the field "TV Channel" I have all the numbers, but can't come up with the syntax. The calculation is mostly "if is >10 but <19.9, then "1", and "if is >20 but <20.9, then "2". But i have to repeat the if/then statement 69 times, as there are 69 possible TV Channels. Any help on where to start this would be greatly appreciated! Thank you.

I should clarify, the program Cuestation is always running on the machine, it never quits, so perhpas the 'activate' function is inocorrect? I just need Cuestation to return to the top. Like I said before, it works on my laptop, where I wrote the database, but as soon as I put it into a runtime, the AS opens "Simple Text". Still baffled.... Tony

Hello List, I put together a very small complaint logging DB that sits on the desktop of a machine that is running only one other program. I have written a script which commits the record, and then runs an Applescript to switch to the other application. In Developer 7, the applescript is as follows Tell application "Finder" Tell application "Cuestation" to Activate End Tell The script works fine on my machine, but when I put the runtime on the other computer, instead of opening "Cuestation" it opens Simple Text. So, I wrote the script in Script Editor on the other computer and compiled it, and it asked where Cuestation was. I told it, and the script runs fine on it's own. So my question is this, how do I get the runtime script to call up Cuestation? Thanks for any input, Tony

Sorry about that. Perhaps try this... Clocks1.fp7.zip

Hello Fenton, I am sorry it took so long to get back with this, but my real job gets in the way sometimes!!! Anyway, I put together a very small file. I think where I am confused is the 'join table' I have to do more reading. All my work so far in FMPro has been relatively simple by the standards posed here, but I am still learning a bunch! So, what I want to do here is to choose the time, and have a clock represent the chosen time. Man, why can't I wrap my head around this? Thank you for your time, T

Fenton, Now I am concerned that the answer is a lot easier than first expected, and I am digging too deeply here. Let me see if I can explain my project this way. Each record in a table called 'Cues' has a field 'title', and for some reason, 16 fields called clock.1, clock.2, etc and 16 fields called time.1, time.2, etc. I would like to, in a pull down menu in time.1, choose '3PM' and have an analogue clock picture show the hands of the clock at 3 and 12 in clock.1. I would do this for all 16 occurences in each record. I have, in another table w/ 2 fields, 'time' and 'clock.face.graphic'. The field 'time' creates the pull down menu. I have a relationship between 'time' on the first table, and 'time' on the graphics table. I can get this to work one time by putting the graphics::clock.face.graphic on the first layout, but any subsequent repetitions of that will show the same 3 pm. Now I am wondering if container fields are even needed in this application. Thoughts? Thank you for your input thus far! (I love filemaker pro!!!) T

Hey Fenton, Ok, so this is where I was last night when I was working on this. Here is the situation. I am training sound board operators on a new show. The console will have up to 16 faders in each cue. I am calling each cue a record. So what I am trying to do, is by inputing a number, which is one of eleven possibilites, this will show a graphic representation of where the fader would be on the real console. I am using the Graphics table only as a storage place for the 11 possible fader positions, but in the operating table, I have 16 fader positions or slots. I think I am looking for a calculation to fill in the appropriate graphic, no? something like, if fader.1.level = 0, then graphic #9. I just need to do this 16 times on each record. I have never posted an example here before, I may try and do that. It may help try and explain what I am doing. If I can figure this out, I have another project which will use the same type of system. And the learning is tremendous!!! thanks, Fenton...

OK, I'm confusing myself now. I need to pick, from a popup list, a number, which needs to place, into a container field, a graphic that I have already determined. There are 11 numeric choices, corresponding to 11 graphics. I need to repeat this 16 times in my layout. As I posted before, I have a table, with 11 records, each with 2 fields, "Graphics::Fader.Position" and "Graphics::Fader.Position.graphic" The latter is a container with a simple drawing in it, the former is a number. What am I missing here?

I may have solved my own problem... silly me, looking too deeply for the answer. All I had to do was change the field to "graphics::fader.position.graphic" and it does what I wanted it to do. But, if anyone else wants to chime in and tell me a better or cooler way, I am all about learning more about FMP. One can never know too much!!! Thanks, T

I am trying to put together a training program, and need help in getting container fields to respond properly. I have a field "fader.1.level" which is a pop up list, and a global container "fader.1.position" I also have a table with the two fields "fader.position" and "fader.position.graphic", from which to pull the graphics. I have added the relationship "fader.1.level" --> "Graphics::fader.position", and the popup list is in fact the list of "Graphics::fader.position" I would like the user to choose the "fader.1.level" from the pop up list, and have the fader position be shown for them. I am just stumped how to do this, as this is further down into FMP than I have ever been. Thank you for this fabulous resource! T

I am trying to make a few templates that I can cut and paste into new databases. What I have done is creat a NOTES table, where it has a few fields to personalize the global fields in the solution. Is there a way to have the user (or me) input into a field the starting number in an auto filled, serialized field without having to go into the properties of the difined field? For example, I would like to fill in a field in NOTES named Starting Serial Number, and have the field Computer.Info::ID NUMBER start serializing based on the value of NOTES::Starting Serial Number Does that make any sense? Thank you in advance for any help with this!

Probably another silly question, but.... here's the scenario A technician is filling out the trouble report, and needs to create a requisition for parts. He hits the "New Req" buttion, which sets a global with the form # he is currently in, and auto sets that information in the new req form. After the Req form is filled in, he commits it for approval which sets a global with the req # and returns to the trouble report he was in. When he returns to the trouble report, I would like the po req # he just created to autofill back into the trouble form. I can figure out how to do this if the technician is always on the last or first record, but I am stuck if he is in some other record. All of the sorts and finds I've tried ask for a record number, and I can't figure out how to use the global field as a serch criteria. Any help would be greatly appreciated!