FileMaker Interface Features
-
Layout A is to show hours per job (from Database A) and revenue per job (from related Database B)summarized by employee. Summaries work fine for hours but only show last entry for the revenue from the related data base for each employee...FM8.0
-
- 0 replies
- 1.1k views
-
-
Hey all, not sure if this is the correct forum for asking this but i figured since this is all about building layouts it might be the place. I am very interested in buying a wacom tablet for my office. I am not the graphic artist or anything. I am simply looking for a way to sketch out and layout graphics quickly and easily. And since I use my mouse with my right hand, but i am left-handed at writing, I could easily use both at the same time. Does anyone know how handy (no pun intended!) wacom tablets are with making layouts in filemaker pro? Is it worth my time? What models would you recommend? Thanks All! - Mike
-
- 1 reply
- 1.2k views
-
-
Is there a way to have the value lists for say different depatments limit the list to that account login. I have a large company with multiple programs so if someone in Health logs in under health I want only the health related divisions to show in the division drop down list, same with other departments... Can it be done? Thanks
-
- 2 replies
- 1.1k views
-
-
This is an extreme newbie question: I'm making a simple database for my home library and was wondering how to create a field consisting of a checkbox that would place a webding or Zapf dingbat type checkmark within the box when clicked by the user. Checking the box would indicate that a book had been read. I would then add the pages of the book in that record to a grand total of pages read for all books in the database. Thanks in advance, Tom Carlson
-
- 6 replies
- 1.6k views
-
-
Hello. I'm using FM 8.5 on Windows. I've inserted a leading sub-summary in a report and I can see it in Browse mode but it doesn't appear in Preview mode. Also, the page breaks don't work. Why is that? Details: I have an Artists table and Artwork table. An artist can have multiple artworks. I want to print a catalog that shows all the artwork for each artist, and do a page break between each artist. I've tried both leading and trailing sub-summaries (on the Artist ID field) but neither one shows the Artist fields that I place in the section, and the page breaks don't work. I've tried layouts where the Artist is the main table and also where Artwork…
-
- 4 replies
- 1.3k views
-
-
Can't figure this out; inserting record number symbol doesn't work, because I need the numbers to re-start sequentially after every subsummary break. You'd think this would be a built-in feature? Is it not? I have a feeling that this one's right under my nose, lol... Thx! J
-
- 16 replies
- 3.3k views
-
-
I realise I am being really stupid here but.... I have a form layout based on a table and a list layout based on the same table. One of the fields is the staff assigned to this record. These staff names are the same as the account names used when logging into filemaker. I have created a button to go from the form layout to the list layout but I only want the user to see their own records. So the script on the button does the following things: 1. It puts the current account name of the logged on user into a global field 2. It opens the list layout 3. It performs a find where the account name global field is the same as the staff name field. but I can not wo…
-
- 3 replies
- 1.7k views
-
-
Hi, I've just started using Filemaker and have modified the starter-kit business kit to suit my needs. I now have sales invoice totals, dates and invoice ref. numbers going back to 2001 for 500 customers. I would like to show the annual sales totals for each customer and for each year on a new layout tab but I can't see how to extract this information into a calculation or summary field. Can anybody give me some clues on how to proceed? :)
-
- 2 replies
- 1.4k views
-
-
In a dialog box it's possible to format the text input as asterisks. I can't seem to find a way to do this with a standard text field. Is this possible easily or is there scripting involved? Thanks, Mel
-
- 1 reply
- 1.3k views
-
-
Objective: I'm trying to generate a report which will automatically generate a sequential 'number' for each record in the found set. For example: I have a database of students which contains both active and inactive students. Each school quarter, I need to create a list showing just the active students enrolled. The printed list looks like a simple spreadsheet with the fist column (# field) displaying the students number in the list. e.g., the first student record shown would display "1", the second "2", and so on... ============================= # Student Name --- ------------ 1 Adams, Patick 2 Davis, Myla 3 Jackson, Kendal 4 Smith, Chad ============…
-
- 3 replies
- 1.3k views
-
-
In a layout called JOBS, I want to put the following fields inside a portal: salespersonOne (related field, pop-up menu) salespersonTwo (related field, pop-up menu) product jobStatus Because there can be either one or two salespersons per job, I'm using a separate table (tSalespeople, related by recordID) to store the salesperson data. Back in the JOBS layout portal, it's no problem selecting salespersonOne from a pop-up menu; a new related record in tSalespeople is automatically created, and his/her name then appears in the portal. My confusion comes with salespersonTwo: Since I obviously can't put a portal inside a portal, how can I create (or cha…
-
- 4 replies
- 1.6k views
-
-
I was looking in the forum but could not find a good answer. How can I format a field automatically without style. If I copy info from a website that is formated and I paste it into Fm it pastes the style. How can I format the field to it does not paste the style? Thanks TMAS
-
- 4 replies
- 2k views
-
-
I am trying to have a Value List be auto-generated based on data entered in another field. This is my problem: I am making an Employee database for which each employee has a job title which is selected from a Value List (for example Account Manager). I also have a Contacts (or Companies) database and an Account Manager is assigned to each of those Contacts. I would like to assign the Account Manager from a Value List but I would like this Value List be generated based on whether an employee is assigned as an Account Manager (or not) so as new employees are added (or terminated) and assigned as Account Managers the Value List in Contacts will update. I hope I e…
-
- 5 replies
- 1.8k views
-
-
Can anyone tell me if it's possible to have a checkbox automatically check a value(s) based on a lookup?
-
- 5 replies
- 1.9k views
-
-
Hello I am having trouble trying to get a value list to sort a list of names from a calculated field. In short, I have a value list that looks up a list of names in a seperate table. The field the value list consults is a calculation that creates a full name from adjacent christian and surname fields. In the value list table, I need to log the CONTACT_ID associated with each contact, and I use this value list to show both the CONTACT_ID and the calculated name. All is well as long as I sort the value list fields on the CONTACT_ID which is not very practical, as I have list of ID numbers with an associated list of names that are not alphabetically ordered. I want is…
-
- 2 replies
- 1k views
-
-
Hi, I was on YouTube tonight and just for giggles I typed in Filemaker and there was a video for a company. I noticed that in the main title bar of the FM program (not the open layout window) there was the company name…I did a search on Google for the company and they had a demo of the program and I downloaded it. Now in the download not only is there a company name but a company icon. Here is a shot of the program as you can see the logo is in the program bar of the FM program and not the open window (which is shown below the main bar). I think I saw the same thing in one of the Nightwing demos but I cant find that one. How do you get a na…
-
- 4 replies
- 1.7k views
-
-
Hello, I have a Report that the user can access via the Layout dropdown. Is there a way to execute a script when the user goes to this Layout by selecting from the drop down menu (I know I can create a button on another layout that would execute a script and take the user to that Layout but this is not what I want to do). thanks,
-
- 6 replies
- 1.6k views
-
-
Hi there I have a large database with in excess of 70 layouts. When I go to select a layout there is only one column shown with the necessity to scroll down to find the required layout, especially as the last one generated sits at the bottom. I know it is possible to re-order these but it seems that the one that I want is always off the page. Is there any way in which the layouts can be made to display over more than one column. Thanks
-
- 2 replies
- 1.2k views
-
-
I've created a multi-multi relalionship through a join portal. There are 3 tables: Patient Patientairway Airway The meaning is to select 1 or more airway devices and add them to the patientairway table. I tried to do this through by making a portal for the airway devices to have a list to pick from. Then using a script to add them to the patientairway portal. The problem is to get to the portals populated. Does somebody have a solution for this or an easier way? Thanks portal.fp7.zip
-
- 6 replies
- 1.6k views
-
-
Has anyone any ideas? I am trying to get a Relationship and ValueList to work which is conditional (nested) on two or more input fields. When I create a Relationship name between my LOOKUP and RESULTS tables I can AND one, two or more fields = fields which works if both input cells have a value, but I also need to offer a skip (blank cell) – in other words if the second or more field is not selected then the previous default lookup value remains. The normal order of selection is COMPANY, ID_OPTION, LOCATION1. Select dropdown value in COMPANY; result = default list (ID_OPTIONS) AND = default list (LOCATION1) Select value in ID_OPTION, or leave blank = dr…
-
- 1 reply
- 935 views
-
-
I have a Tab controlled by lets say Project"TV0509" This project number is linked and input in the tab from the main layout. Now, the portal is linked to the tab by the Above project number with a Mix# added in the tab layout. So lets say the Portal is linked to the tab by "TV05091" then When I want to add another mix to the tab I start a new record and name it mix 2 which would change the "TV05091" to "TV05092" now my totals change in the tab accordingly but,the problem is, The portal line items still show mix1 and mix2 at the same time in the list. How can mix 2 show in the portal when the tab is in mix one. There is no logical connections between the two? To my logic w…
-
- 14 replies
- 2.5k views
-
-
Ok, Need to create a layout that similar as to what is in the attachment. The problem is that I would like to show records from two different sources in the body. The body would have three fields from each table. What I am running into is that it seems that if there are 5 records from table 1 and 10 records from table 2, it only shows 5 records from each. Any Ideas? Thanks Fred Actually, I just looked again and found that it actually shows all the found records in table 1 and the same number of records in table 2 but the data in the table two records is only the first record shown the same number of times as the number of records in table 1. V…
-
- 11 replies
- 2k views
-
-
Morning All, Long time reader - 1st time poster! We're sending out a lot of thank you letters which detail the kind of package a customer has signed up for. These have been set up as 'merge' letters which take the address, name, date etc from the database - all is working fine. The problem I have is that some people subscribe to say 2 of the 5 items we offer, some subscribe to 5 of the five things we offers. I wanted to add a section in the database so that our admin girls can have a set of checkboxes: 1. Does supplier have this X 2. Does supplier have this X 3. Does supplier have this Y Etc, etc. If the checkbox is ticked, the form lette…
-
- 3 replies
- 1.8k views
-
-
I have a file that relates customers to products. Products ordered show on the customer table in a portal. Is there a way to copy a customers product list from Day#1 to Day#2, since customers often repeat their product choices. Copy the portal contents of Day#1 to Day#2? Any help is appreciated!
-
- 26 replies
- 5.2k views
-
-
Safari 3.1 introduces a lot of new features; and FileMaker Webviwer is based on the underlying Webkit technology of Safari. I am wondering what this means to WebViwer. Faster javascript; OK, faster javascript. But this document: http://images.apple.com/safari/docs/Safari_Product_Overview.pdf Describes HTML5; CSS3 Fonts; CSS Animation; Off line Storage; etc. How does that affect us, what new things can we do?
-
- 1 reply
- 1.7k views
-
-
I would like to be able to "publish" a set of daily summary reports once per day and have them viewable throughout the day (i.e., not try to reproduce them during the day, since starting information may have changed). I'm doing this from a runtime, so using a PDF is out (I do know about some of the third-party freeware, but I'm striving for an all-FM solution). So, I've been considering how this might be accomplished with xml and the Web Viewer. My only experience with xml is exporting text using an xslt style sheet. As I understand it, the Web Viewer would require that the report contents be wrapped in xml. Would anyone happen to know of an example -- or a somet…
-
- 20 replies
- 4.5k views
-
-
Hi, I'm fairly new at this ball game. I'm running a database from a Mac os X.3 system, with 5 client machines all on various versions of os X. I have about 26,000 records on the database, most of which contain a graphic. A few days ago Filemaker 7 Pro started to crash whenever I added a new image to a record and I cannot understand why. I thought it may be the hard drive on the server, but there is plenty of room on it. Thoughts? It'd help me muchly.
-
- 0 replies
- 917 views
-
-
I have a question about setting a foreign key via a Drop-down control. I’m new to FileMaker (using FMP 9 Advanced), though have considerable experience building apps with PHP and MySQL. I am working on an application for tracking computers and other assets in schools. The hierarchical tables are: States, School Districts, Schools, Departments, Rooms, Computers. The tables have one-to-many relationships. Each table has an explicit key field called Record_ID (Number, Auto-enter Serial) which is related to a foreign key field (Number). In the layout where the user will enter a new child record, I want to supply a Drop-down menu for selecting the prope…
-
- 4 replies
- 1.5k views
-
-
Any one have issues with grouping objects to a tab panel? Whenever I try to group a single object (in this case a near-empty text box with conditional formatting), I end up grouping all objects on the panel to each other. If I group objects to the panel and then add new objects to the panel they become part of the group. Any one else have experience with this?
-
- 2 replies
- 2k views
-
-
I have a text report layout in which the length of the text varies from report to report. The length of the report is long enough to accommodate my estimate of the longest possible report. I have set slide up and shorten size of field, however, it still prints blank report pages at the end. Is there anyway to eliminate extra pages? Does the fact that there is a header and footer force the pages to print?
-
- 2 replies
- 1.3k views
-
-
Kind of a long question, hope this is the best catagory to post under. I am working on a label printing estimating /quotation database solution. Part of the solution involves calculating how many labels will fit on a sheet and drawing a simple sketch of the label layout. example: sheet size 8"x12", label size 3"x4" (These sizes will chage with each new quotation.) For the sake of this example I will say there is no space between labels and we can print right to the edge of the sheet. First we determine how to orient the label on the sheet to get the best yield. If we orient the 3" side of the label to come out of the 12" edge of the sheet we can…
-
- 2 replies
- 1.7k views
-
-
Problem with Sales Report I have a report by Sales Rep generated by a script with GTRR from Sales Rep table to Sales table. My problem arises when a Sales Rep didn't generate any sales in the month. There is no sales records in the Sales table therefore his name does not appear in the Report (it's a columnar report sorted by Sales Rep with subsummary). Is there a way to show a Parent record (Sales Rep Name) in the report although it has no related record (no sales).
-
- 2 replies
- 1.5k views
-
-
Long time FileMaker user, first time trying to create a portal... Need: Show up to four picture or movie clips in one database from a separate media database that has one picture or movie clip in a single container field in each record with it's own ID number. Have: Media database with single picture or movie clip in a container field in each record with a unique media ID number : How do I get the one database to show various pictures from the media database by entering the media ID numbers… I can supply the two database files if needed. Thank you in advance for any help…
-
- 3 replies
- 1.3k views
-
-
I am using a scripted button to create a new portal record which then takes the user to a specified field in that portal--ready to enter their data. Everthing worked dandy in FM6. (I am working on the newly converted files in FM8.5) I understand the use of a commit record script step and have used it to instantly refresh the portal. However, when the new portal record is created and comitted, up pops a validation error message. The old version (sans commit) put them into the field, let them enter data, and properly triggered the validation when they attempted to leave the record. The new version prematurely triggers the validation through the commit recor…
-
- 3 replies
- 2k views
-
-
I don't know if I am explaining this correctly but this is what I want to do. I have a value list on a layout. The user can select a person's name from the value list. I have another layout with the person's name, address and phone number. I would like to put a button next to the field where they selected the name that would take them to the layout with the contact information. I can't seem to create a script that does that. The button just goes to the contact layout showing the first record, not the record of the name I selected. How can I do that? thx.
-
- 1 reply
- 986 views
-
-
I am wondering if there is a way to add to a layout the found set (record _ of _? I know I can add the record number with @@. For example I would like to show record 3 of 27. When the used has performed a find. I know it shows on the status area but I have that hidden from my users on this layout. Thanks, Cmack
-
- 2 replies
- 1.2k views
-
-
I have created ten tabs with names such as Bldg, Veh, Supp for an inventory db that I have developed. When the tab is selected, I use a script to set a global variable to the tab name. This variable is then used in a Find routine to sort and find all records associated with that name. For seven of the tabs everything works fine. For the other three, they fail to pass the variable (the variable is blank). The short script which sets the global variable and calls the find routine were all duplicated from the same script. Most of them work but three don't. Any ideas on how to troubleshoot this? I'm very new to FM. It looks like: Set Variable [$$Va…
-
- 6 replies
- 2.7k views
-
-
Is there a way to have a tooltip show the current number of entries displayed by a portal? The closest I've been able to come is to hover over the last row (when selected) and display Get(PortalRowNumber). Thanks in advance for any help.
-
-
- 2 replies
- 5.8k views
-
-
I'm adding custom menu sets as an afterthought. As I understand it, here's what FM gives us to manage menu sets: 1. I define a "Default Menu Set" for the file in the Define>Custom Menu Sets dialog. 2. For each layout, I select a Menu Set; either the Default Menu Set or one of my custom ones. 3. I can programatically change menu sets with the Install Menu Set script step. For the solution I'm retrofitting this to, I want there to be two user modes: basic, and expert. For Basic, I want a single, highly restricted menu set to be in place. For the Expert, I want the complete Filemaker set. (There's an authentication script that establishes which cat…
-
- 4 replies
- 2.2k views
-
-
I am using the function GetLayoutObjectAttribute ( "wv" ; "content" ) to try to parse info out of a webpage. However when I use this function the resulting html code appears a bit differently compared to when you simply do a copy paste out of the html source tab in Netscape Composer. Basically a lot (but not all) of the carriage returns are missing. Example below. NETSCAPE Cast �(Cast overview, first billed only) FILEMAKER FIELD Cast �(Cast overview, first billed only)
-
- 3 replies
- 1.4k views
-
-
Hello, and thanks in advance for any assitance. Fair warning, as a noob I may be missing the obvious. (I have tried to find an answer for this.) Here's the problem: I'm working on a project where my client provides quotes, but not all quotes become jobs. In addition to the Quote Number which is indexed and applies to every record (no issue there), he wants an indexed Job Number assigned only to those quotes that are accepted as jobs. This means that he wants an indexed sequence that falls in order of record, but has the ability to skip records without skipping numbers. I think that I may need a field returning true (radio button?) that then prompts a search for t…
-
- 1 reply
- 945 views
-
-
I currently have a layout for printing letters, now I'd like to print all records in a current foundset, but if I select this in my printer properties, the body contains all letters continuous (without a page break), even if I add a page break in the body (part setup), it still does the same. In my layout I have a header, body and initial summary. Does anyone know how to do this please?
-
- 3 replies
- 1.3k views
-
-
Ok , here goes.. I have a database with a product table (which holds retail price, description ect) and a Sales invoice table. I have a field in Sales invoice called 'confirmed discount' which the user enters an amount. I have a tool tip set on the 'confirmed discount' field witch displays a list of products up that retail up to the value of the 'confirmed discount' amount using a List command with a relationship that only shows the relevant product descriptions - this works great. I have just added a 'Product image' field to my Product table that holds an image of the product. In my sales invoice table I have a layout that is a letter that I send my customers. O…
-
- 4 replies
- 1.2k views
-
-
What are the odds of this: I am creating a layout for labels, and in the "Specify Label Layout" dialog, it asks for the specific label size code of the labels I have purchased, in orderto automatically generate the correct measurements. In the dropdown there are numerous label codes, seemingly every one possible EXCEPT the one I have. They are all Avery ...., series numbers going from up from 4000, with other ones. I have L7159. After 6000, it skips to 8000. What the So I will probably now have to laboriously nudge things around manually until it's right? With this label situation, every step there is some problem, I swear it's harder than putting …
-
- 6 replies
- 3k views
-
-
I need to pull a list of files from a folder for a value list. two problems: If I copy and past the filenames from the folder to the value list, they don't sort properly - how to fix? secondly, it would be wonderful if the value list could just look to the folder to grab the names, so that it would be updated as the folder changes - is that possible?
-
- 8 replies
- 3.2k views
-
-
I am creating a db for educators. They have to deal with state standards - large lists of everything a kid needs to know. he structure of the standards is: grade-subject-strand-standard-benchmark. I want to create a series of value lists that narrow down their choices, i.e., they choose language arts and the strands dropdown value list is reduced to "reading, writing, listening/speaking". When they chose a standards show up as a radio button value list (only those related to strands). When they check a standard, all the related benchmarks show up in a nicely formatted table below. i have set up the db using separate table and everything is properly related. Can …
-
- 1 reply
- 1.1k views
-
-
Hello, I'm have multiple inventory items (records) in a portal and they have prices, but I would like to add something outside the portal in the same layout to total up the multiple inventory prices. How would I got about this? I have attached a picture to show what I'm doing.
-
- 2 replies
- 1.3k views
-
-
How can I alphabetize a value list? I have a client who wants to keep adding to a value list as she goes but needs it to be sorted A-Z afterwards. Thanks, Erik
-
- 7 replies
- 2.7k views
-
-
Hello. I am a newbie who has, I presume, a simple question. My db has a value list with a list of over 600 projects from another table. To avoid having all the projecs listed, I wish to limit the list to last 6 months via the creation date field in the projects table. I presume this is possible ... my question is how?
-
- 2 replies
- 1.1k views
-
-
Is there a way to build a checkbox field/value list that will give you the option of typing more data next to the checkbox? For example: @ will represent the checkbox in the value list - the bold name is the item next to the checkbox and the numbers are what I need to type if that item is checked. These numbers will be specific to the record. @ UIL 123-456-789 @ VBODA 234-567-891 @ NYSSMA 345-678-912 So if "Amazing Grace"(a record) was accepted at VBODA, I would want to type in the cat. number they give me for that chart. And if "Sonata"(a record) was also accepted at VBODA, it'd have its own number, yet both marked for VBODA. The way I set…
-
- 5 replies
- 1.5k views
-
-
Hi, Is it possible to show a PART of the page in the web viewer? for example in this link I would like to show only the news box on the left.. possible?
-
- 15 replies
- 2.7k views
-
-
I've got a script that creates printed reports from multiple database tables. What I am attempting to do is to produce sequential page numbering so that the first page of the first report is 1 and if that report is 3 pages long, the first page of the second report would be 4 and so on. I've tried the Global variable suggestion that was posted for the Page x of xx solution but it isn't working. Where I would normally place the page number, I'm using Get ( Page Number ) + $$gv_page_number where $$gv_page_number is supposed to be a running total of the number of pages printed so far. It appears to be incrementing correctly, but the Global field which has the calc…
-
- 5 replies
- 3.2k views
-
-
Hey Guys, This may be the stupid newbie question of the month, but I have one report I'd like to do in landscape layout but the rest of the database is portrait and I can't seem to be able to do this? Everytime I change the orientation in that report it changes the whole database. Is it possible...and how? Thanks! -Phil
-
- 2 replies
- 1.1k views
-
-
Hello All! I have a bit of an issue I can't recall when it started but it bugs the crap out of me! After YEARS of agonizing pain dealing with windows 2000. We FINALLY got new computers (rebuilt) with fresh clean copies of windows XP pro. My computer is running a Pentium 4 2.8ghz processor (32bit) with 2gigs of ram. (Dell Dimension 3000 motherboard) - I have 3 monitors hooked up to it with the use of an ATI Radeon 7000 dual pci video card. I run diskeeper 10 to keep the drive defraged for optimal performance. I am a huge memory freak i always watch my resource usage. Anyway, Whenever i am working on layouts in Filemaker, I notice considerable lag when making…
-
- 4 replies
- 1.2k views
-
-
I have a pdf guide that I would like to place on the help menu as an option. I have looked, but cannot find a way to lauch a file from a new menu entry. Can someone walk this newbie through step by step? I would appreciate it very much. Thanks all!
-
- 1 reply
- 1.3k views
-
-
Hello everyone, I am trying to display a button with script when the value of input is EMAIL in type field. I want to click that button to set as primary email. The button will not show up if value is not EMAIL. Is this possible to do? Please help. Thanks in advance!
-
- 4 replies
- 1.5k views
-
-
-------------------------------------------------------------------------------- Hey guys I have a report layout that sorts my records by company and a search layout with global fields for users to enter a date range for the report. I was wondering if anyone had any ideas about how I could make a pop-up menu with each company and depending on which company the user selects, only that company is shown in the report (I also want it to be possible for the user to shift click multiple companies). Also I want each company in the report to start on a new page and to have the company's name and date range in the header so it would read something like: Sasaz…
-
- 1 reply
- 1k views
-
-
Recently I changed the graphic (gif) for several buttons. Normally, there is no problem. But when I downloaded the changes to my client on their PC the button displays a message that the graphic is missing and they see the button blank with that message displayed. The buttons work fine, but this has never happened before. The only buttons affected are the ones I changed in that day. I have made many changes before but this has never happened. Anyone know what is going on or what should I do. I use the FM9 advanced to program and my client has FM9 Pro installed in all their user PC's. I have updated all to 9.0v3 and also the FM Server is updated. WOW, I am truly puzz…
-
- 1 reply
- 1k views
-
-
Hi, I'm building a solution that has a primarily dark background, with light-colored text (yellow, white etc.). When I enter an edit field or pop-up menu to make changes or make a selection, the background reverts to white, which is a crazy difficult color to edit white text against... Anyone have any idea if that's something I can change? Many thanks
-
- 5 replies
- 2.3k views
-
-
I can find the contents of a field repetition using the Get Repetition function. What I would like to do is be able to do the reverse and find the repetition number given the contents of the repetition. Is this possible?
-
- 2 replies
- 1k views
-
-
In FM9 I am passing a filemaker field to do a search on IMDB.com via a web viewer. Each time I commit the record with a new request, Safari is popping up (over Filemaker) with the same web page. Why is this happening and is there any way to prevent this?
-
- 2 replies
- 1.3k views
-
-
Hi! I'm trying to use Google's embedded maps feature with FileMaker to integrate a small map to a database using Web Viewer. That map works if I simply copy/paste its URL from Google, but as soon as I try to alter the URL (to point to a different address in my database, for example) I receive the "forbidden" error from Google. None of my addresses show the pound (#) sign that GMaps seems to hate. I tried pasting the URL from Google in my browser (it works) and changing the street address to something different (it fails). Do I need the API to do this?
-
- 1 reply
- 1.6k views
-
-
Student Table StudentID Grade Classes Table ClassID Grade Enrollment Cap Time Student|Class Table StudentID ClassID I want students to enroll for a summer school class. When they enter their StudentID and Grade, I want a portal to Student|Class configure with a value list of available Classes for the student to enroll in. That value list should be filtered by Grade. Easy enough. But it should further be filtered by enrollment Cap, so if the class is full it no longer appears in the Value List (haven't figure this out yet). Also, each student can select 2 classes. If they pick a class that runs from 8:00 - 9:30 AM, their 2…
-
- 2 replies
- 1.2k views
-
-
I have a layout that contains many levels of nested tab panels. The top level of tab panel is set by get object prior to displaying the window. I want to make sure that the user does not click on (or see) any other tab on this panel. to that end I have made the width of the tab panels very small and covered them over with a field that does not allow input. This, however, does not assure that the user cannot click in the tab area and just happen to select another tab, even through the masking field. Is there any better way to protect these tabs?
-
- 9 replies
- 2.7k views
-
-
Hello, I've posted here before but the answers I got made me realize that I am too much of a novice to screw around with trying to put 4 different tables that I have (Clients, Invoices, Appointments and Daytimer) in the same table. My question is this: Is there a way to use some kind of tab method in order to make each table appear every time i click on a different tab in a "master" table? Please, being a novice, I would appreciate an easy answer. Thanks:)))
-
- 30 replies
- 3.9k views
-
-
I have two fields that are formated as popup lists. One is called Category and the other is called Sub-Category. Is there a way to have a different value list popup in the sub-category field for each item in the Category popup. I am using filemaker 5.5. Thanks in advance for the help.
-
- 1 reply
- 1.3k views
-
-
I am trying to figure out how to transfer data from one portal, to a different one. its for a todo list i have as a portal, when its completed they click the delete button, and i want it to transfer that data to a journal. on the todo list i have date, contact, info, and notes. i thought i had a solution, which was when you click the delete button, it performs a series of copy and pastes into the journals notes section. but i soon found out that it failed because it wouldnt take all the data from the correct row in the portal.. anyhelp would be appreciated!
-
- 1 reply
- 1.1k views
-
-
I have created a drop down list of fields from one table, courses, that creates fields in another table, tutoring, but for some reason its only listing one of the courses from the other table no matter what I change the course id number to in the tutoring table. What I want it to do is change the course name in the course name field everytime I change the course id in the tutoring portal. The course name in the tutoring table is a calculation. course_name in tutoring = Courses::course_name. I have included a screenshot of the layout.
-
- 1 reply
- 1.3k views
-
-
I am new to FMP, so my first project was a little frightening lol. I am an amatuer magician and decided to make a database for the effects I know and study - and approach it as a FMP project as if I were designing it for someone else. I was wondering if anyone would be willing to take a quick look at it and see if there are areas where I did things blatantly wrong, or violated any "unspoken rules of fmp"? I would really like to become better versed in FMP and even go for the cert eventually. I have attached the fp7 file and welcome any advice. magicvault.zip
-
- 8 replies
- 1.5k views
-
-
Hi, I'm having a problem when I insert a picture in a layout. On my computer, the picture shows, but on the users computers they only see a square with the word Image in it. Can someone help me with this issue? Here's a printscreen from my computer: Here's a printscreen from an employe's computer: Thanx!
-
- 2 replies
- 1.5k views
-
-
I have a simple form with boxes on it. they are drawn with the box tool, and are not fields. WHen i proof it, its fine, but after i transfer it onto my other work computers, a little box appears. It has the letters "obj" in it, and appears in the same spot around some of the boxes, not all of them. I went to my copy to check, and did not see it, i went into layout mode, and still saw nothing. I'm thinking something is happening when i Transfer it from computer to computer. any help? I'll try to attach a screen shot of it next time i transfer my files, which should be soon
-
- 0 replies
- 1k views
-
-
I'm trying to produce a printout of an invoice. The makeup of the data is a single record for the invoice header (i.e. customer information and subtotal, taxes, shipping, and total) and 1 to many records in the invoice detail. On the entry screen I am using a portal with no limit to the number of rows which can be printed. Based on print sizes that have been selected, if there are less than 20 item lines on the invoice, I can print it all on one page. However if there are more than 20 item lines I need to break to multiple pages. If that is the case, I want to leave the subtotal, taxes, shipping, and total fields empty on the first page, and have them printed o…
-
- 1 reply
- 1.2k views
-
-
Hello every one, I have this problem with my portal, hoping that you can shed some light. one of the field in my portal is displaying twice, first line and second line, and if I try to delete the second line, then the content of the first line also got deleted. I tried to recreated the portal but the same thing happened. Hope that I have explained myself clearly. Thanks for the help. Michael T
-
- 4 replies
- 1.2k views
-
-
Hello. I'm using FM 9 and need some help with check boxes and radio buttons. I've created a very basic, simple flat-file database for my movie collection. There are three sets of checkboxes, each linked to the GENRE field. (Some movies belong in more than one genre, hence the use of checkboxes instead of radio buttons.) I'm trying to create a fourth checkbox set, also linked to GENRE, but this one will have only the OTHER field. There are two problems: 1. Whenever I click one or more checkboxes in the other checkbox sets, the OTHER checkbox is automatically marked. I don't want this. 2. When the entry box for the OTHER checkbox…
-
- 5 replies
- 1.2k views
-
-
When creating a stand alone runtime, I am having trouble showing which mode a user is in - for example, if a user clicks FIND, and types a search, the record set is then limited to that find - if a user forgets and scrolls through the records thinking it is the entire list, they do not get all the data. How can I show that Find mode is enabled - I was thinking if I could somehow visually show it... with buttons to clear the find and also go back to normal browse/edit.: I looked over the FMP examples included with the software, but they all have the same problem I am seeing - no visual representation of FIND - except for the status bar, which I am hiding in the …
-
- 14 replies
- 2.4k views
-
-
I have a table displayed in one window as a list view of multiple records. I have a second window displaying one record of the same table in a detailed form view which is adjacent to the first window. I would like the two views to remain synched so that as I navigate around, the form view always shows the data that matches the current record in the list view. How can I achieve this?
-
- 2 replies
- 1.1k views
-
-
So, thanks to the help of Comment, I was able to take the records I had stupidly made with repeating fields, and populated a new table by dividing out the repetitions as separate records. I am back to my original layout, where I am going to strip out the repeating fields and replace with a portal. Of course, I tested the portal before finalizing the layout. However, in the portal, it only shows the first record. So, for example, in the repeating fields, I have 4 repetitions. In the new table I created by copying & importing the records, I have 4 separate records, 1 per repetition. However, on the portal, it only shows the first of the four. I have the portal se…
-
- 1 reply
- 891 views
-
-
I am trying to change the way the table looks like when you change the view. There are 3 view options, for, list, table. When you go to view as a table, you get a list that displays your contacts, items, ect. I want to make that look more clean, but when i go to layout mode, i cannot seem to find out how to edit that"View as Table" View. Any help?
-
- 10 replies
- 1.5k views
-
-
I have a portal that is sorted based on a one-digit field that, occasionally, can contain an Exception Code (A, B, C, etc.). The portal uses a "custom order based on value list" to place the entries with Exception Codes (6 different ones) at the bottom, like footnotes. Any entry with a blank sorts to the middle of the pack. The value list is 1, 2, 3, ... 9, , A, B, C, D, E, F This has worked great, so far. But now I'm faced with having to support decimal fractions instead of just integers. The following is an example of what I now need the portal to look like: 1.11 1.74 2.01 2.42 A B D So my question is: is there a way to define a cu…
-
- 4 replies
- 1.7k views
-
-
A couple of Questions. When Custom Menus are on, my Copy and Paste commands cease to function properly. When either one is used, a "square" character is inserted that replaces the text being copied or pasted. Question 2 - What are the Black dots that now appear to the left of the customized Menu options that are displayed? Thanks for the replies
-
- 1 reply
- 1.6k views
-
-
Hi my dear repliers!!! You always have an answer for all the things I can't find... I learn a lot with you and then I "teach" my friends : ... all thanks to you guys (and girls). Here I have a question: Can I set a button to "undo changes"? I mean: I accidentally change some information and I don't know what I changed... is there any way to undo changes? to restore the information which accidentally has been changed? I can't realize the way... thankssssss for reading! Jogito : PS: I don't really know if this post is well-situated,
-
- 11 replies
- 2.4k views
-
-
Hello, I'm using FM 9 and have a question about forms. Quite simply, I'd like to have two forms in a simple, flat-file database. The reason why I want two forms is because I don't want all of the data to be in one form. The second form will contain lengthy text, and graphic images, that may otherwise make one form cumbersome and unwieldy to deal with. So, I'd like to have a "primary" form and a "secondary" form, if possible. As of right now, after reading FileMaker Pro's documentation, and after browsing through a FileMaker Pro book I got from the library ([color:red]FileMaker Pro - The Missing Manual), I haven't quite figured out how to do this…or if…
-
- 8 replies
- 1.5k views
-
-
In my database , I have a value list (viewed as checkboxes) and a field that holds the username that selected a value in that value list . I would like to to stop anyone but the original modifier from selecting a different value in the list but I am not sure how to achieve this. Any help would be greatly appreciated. Thanks
-
- 1 reply
- 1.2k views
-
-
Hi, I am completely new to Filemaker, and need some help. I searched the forums, but its hard for me to understand some of the things you discuss here. So as easy as possible please My database calls for the following structure: Payment type collected = *Hourly Rate *Set Fee If "Set Fee" then i would like the following to appear in new fields next to "Set Fee": *Amount *Payment activity (Track dates, and payment amounts that were made on those dates) subtracting from the total "Amount" entered If its "Hourly Rate" then it should just be left as that in the dropdown menu, with no request for further info. The main question is really: H…
-
- 1 reply
- 1.8k views
-
-
I have 8 fields, one is starting mileage and the others are ending mileage 1-7. I need to find the total miles driven on that trip however if I use this code: Ending Odometer7 - Ending Odometer6 - Ending Odometer5 - Ending Odometer4 - Ending Odometer3 - Ending Odometer2 - Ending Odometer1 - Beginning Odometer I get some wacked out number IE: starting out with 157018 and ending odometer1 157066 and the rest 0, I get 314,084. Now if I place the code "Begining Odometer" in the front of the code I get, -48. So frustrated, I tried this code, Beginning Odometer - Ending Odometer1 - Ending Odometer2 - Ending Odometer3 - Ending Odometer4 - Ending Odometer5 - Ending Odo…
-
- 2 replies
- 875 views
-
-
I am not sure where to look for this scenario as I am brain dead again today... I have a table, copied it in relationships and made the relationship "date = date" allow adding in both. Now I added the portal in the layout. Now when I need to add a line in the portal, I start typing in the fields in the portal and a new line should appear, and it does, however, it also creates a whole new record rather than just making the fields in the portal hold the data. I end up with 2 records, but only want one record with the multi line data in the portal. It is a time sheet, so if I do 3 jobs, I want them to show on 3 portal lines not 3 records as well as portal lines. Where a…
-
- 2 replies
- 1.2k views
-
-
How do I make so if field "A" has data in it, then field "B" will show up, but if field "A" is blank, then so is field "B"? Field "B" is a global. Thanks
-
- 7 replies
- 1.8k views
-
-
There has to be a simple answer to this question, though I've looked and looked. Basically, I don't want the option to add a new record through the menu item. I only want to add a new record via a script because of the nature of what needs to be entered into that new record. It appears that my only option is to use a plugin called secureFM but that's really overkill for me and I can't justify the $155 cost to disable one menu item. I'm not distributing any solutions to anyone. This is only for my use and those who access my machine to use the file. Is there any way to do this without shelling out big bucks? If it were a $10-20 investment I could handle that, but no way ca…
-
- 12 replies
- 2.4k views
-
-
I just ran in to a strange problem when exporting data from a field to a text file. The problem is that the "line feed" or "carrige return" (don't realy know the difference) character ends up as a little square instead of a line break when I open the file in Notepad. I'm trying to create a HTML file, and it's quite messed up and hard to read. Anyone had this problem, and solved it?
-
- 0 replies
- 978 views
-
-
Hello all, I'm new to FMP, but not to db programming, and am having a hard time doing something that's pretty easy in other programs. I've read the "User's Guide", but that's decidedly elementary; I've searched, but I guess I need to get the hang of the jargon. It's an artwork database, in which depicted characters depicted could conceivably show up in hundreds of artworks. Because of this, I put those names in one table, and created another table for the artwork/character relationships. The db schematic for the relevant tables & fields: Artwork - ID (auto-serial) Global Characters - ID (auto-serial) - Name (text) Record Characters …
-
- 4 replies
- 1.3k views
-
-
I am making a Contacts database consisting of: 1. Contacts: People's names and contact details (just phone and email) plus the company they work for. 2. Companies: Address, phone, website and a portal showing people who work for this company (related to the 'Contacts' table). I'm trying to do two things but failing spectacularly. 1. On the 'Companies' table (with the portal) I have a button for people to add a new 'Contact'. It's just a script that goes to the 'Contacts' layout and makes a new record. However I want it to set the field on the 'Contacts' table to show the company name from which I clicked the 'Add Contact' button. Does that makes sense? …
-
- 8 replies
- 1.6k views
-
-
I am building a generic report. The report is generated from a script on the recent found set. I would like to incorporate the search criteria in the report. How can I get the search criteria for the last found set?
-
- 2 replies
- 1.1k views
-
-
Hello everyone; I am relatively inexperienced in FileMaker and running a very old version (5.5). The database I am working with was set up to help run a school event at the museum I work for. Students and chaperones get free t-shirts, and the mechanism for these at present is a field "shirt size" with checkboxes for each size (Youth S, M, L, Adult S, M, L, etc.) At present, the record layout is for each school, who can have multiple students; each "student lastname" + "student firstname" listing is followed by a series of 9 checkboxes, 1 for each size, and we put a check in the size shirt that each person needs. There are fields at the bottom of the record tha…
-
- 1 reply
- 2.5k views
-
-
One of FileMaker's simplest tools is the page number symbol, but I'm having an unexpected problem with it: I have placed a p.## text object in the footer. Am browsing 3 pages' worth of records in List View. In Preview Mode, the page number symbol correctly shows p.1. However when the report is printed, p.0 is printed on the first page, p.1 on the second, etc. Obviously I'm making a dumb mistake somewhere, but can't figure out what it is. Suggestions greatly appreciated.
-
- 2 replies
- 907 views
-
-
I'm finally at the point where I am going to "Attempt" to set up a meaningful and useful help file for my application. In analyzing my app I believe there will be approx. 90 buttons, layouts, etc. that will require some type of explanation. I have used Tool Tips to explain what each button does, but, I thought a more complete explanation would be helpful. So, to my questions, does anyone have any suggestions as to how to properly set up a Help File System? Is there any documentation available? Are there any example files that I could look at? TIA for all your assistance and suggestions. Al
-
- 1 reply
- 833 views
-
-
I have read post after post prior to posting this so hopefully I can prevent from being flamed. I have a portal setup to display sub items. It works great. Now I am trying to filter out all the rows that have a quantity (field quantity) of zero. I tried a table with the field in it and then set a relationship to my portal records quantity but it does not do anything. I also tried putting a field in the related (parent) table and then putting it in the relationship. Well it works except it will only allow me you enter in the portal quantity field the value that is in the parent record (I am sure that has to do with the relationship forcing the value) Does anyone kn…
-
- 10 replies
- 1.6k views
-
-
I am trying to write a script where duplicate dates in a portal are deleted. For example I have a database of people and related table of Attendance dates. Sometimes through an automated process, duplicated dates might get entered in a person's record in the portal. Is there a way to have a script that automatically finds those duplicates in the portal for that one person and deletes the duplicate dates? This could be a sub-script that is incorporated with the script that records the attendance in that portal field. Thank you.
-
- 5 replies
- 2k views
-
-
Hi all!!! Maybe you know if it is possible to set a "conditional tooltip", I mean, a tooltip that appears only if there is more than 120 characters, for example... Thanks a lot for asking and thinking!!! Jorge
-
- 5 replies
- 4.7k views
-
-
I'm doing my best to 'professionalize' my designs, trying to hearken to the advice I gleaned from the White Paper for Novices, so it's time for me to shed the Status Area in my layouts. This is probably a really simple question, but how do I find the information for the Records counts -- total # of records / Records in Found Set, and the Current Record number? It seems like these would probably be gotten from some Caluculation functions -- and put in, maybe global fields? I've poked around and can't seem to find what I need. THanks Albert
-
- 3 replies
- 1.3k views
-
-
is it possible to implement KML functions in the web viewer .... Gdirections / get distance & get duration so as to return distance & time values for use in calculated minimum service call rate $$ i believe the actual directions and map are optional
-
- 0 replies
- 1.7k views
-
Recently Browsing 0
- No registered users viewing this page.