FileMaker Interface Features
-
Ok, this seems basic, but I'm having trouble figuring out a way to make it work... In a layout that displays Rerservations (only the previously selected one), I would like a portal that displays and allows selection of contacts to be included in the reservation. So far, everything works when joining tables like this: Contacts::ID x SelectedReservation::ID But as the contacts list grows, it became arduous to scroll and search all the time. What I need now is a "Quicksearch" kind of thing... So here is what I tried: In the contacts table: - added a "SearchString" text calculation field that merges information to look for. the calc goes like: Co…
-
-
- 3 replies
- 3.4k views
-
-
I am a newbie with scripting. I have 3 types of records. I want to use a script to show all records and then omit two of the three types of records leaving just the one type I have a database for teaching with pass types. There are 3 pass types General Pass, Nurse Pass, Dress Code Pass. I have a report layout and want to use a script to show all General Passes. To do this, I have to remove the Nurse Pass and Dress Code Pass records from the found set. I have no problem omitting either Nurse Pass or Dress Code, but I cannot get it to omit both. I even wrote a separate script to omit Nurse pass and tried to use then a Perform Find omit records to omit the …
-
- 2 replies
- 1.9k views
-
-
i have database with two privileges "guest and admin" now for the guest only one specified layouts must be visible and remaining layouts must be invisible so that if visible is pressed hes gets and awkward screen with no access he must see only one specified laout . yes we can create layout by duplicating and modifying and startup with that specified layout but i need alternative
-
- 1 reply
- 1k views
-
-
Has anyone managed to get this to work? All I get is "data:text/html,
-
- 2 replies
- 1.7k views
-
-
Hi, I am trying to get the content of a webpage after the page has completely loaded. Is there a way to wait, without the Pause for 2 seconds command, until the content has loaded? This is my current set-up: Loop Pause/Resume [Duration (seconds): 2] Exit Loop If [GLOA("wv";"content") != ""] End Loop Reason being is that this is not 100% fool proof. Some time this fails. Anyone else use something similar?? Many thanks, Jim.
-
- 2 replies
- 1.9k views
-
-
Hi I would like to write a right click menu item so I can send a number to a small executable we use so that our phone system will phone that number…. How do I add a right click menu item ? I am on a mac so the click can activate an apple script which would be fine… Thanks….
-
- 0 replies
- 2.1k views
-
-
When using newer version of filemaker could this be used: http://my.advisor.com/doc/18700 But have any of you here tried something before 8.5 which worked ... what I need is some flashing of an Icon in a gate barcode scanning, for only a short while, which then can be interrupted by a new scanning ... what the client wish is a fading icon - so there won't be any doubt which scanning the flashing belongs to. This happens in a noisy environment so bleeps etc. won't necessarily be heard. What I have thought about was the old David Kaschel applescripted event trigger ... but this is going to be on windows --sd
-
- 0 replies
- 1.2k views
-
-
Hi, I've a value list 1,2,3...9,10. In my layout the field is displayed as a checkbox with numbers 1-10 showing. As these is quite wide, I've changed the box size so I've 2 lines. The numbers are displayed down and then across, ie 1 3 5 7 9 2 4 6 8 10 Is there a setting, to change it to across then down? ie 1 2 3 4 5 6 7 8 9 10 I've managed to do it by changing the order in the value list, but if there is an way of changing the order, I'd love to find out. Thanks, Skip
-
- 3 replies
- 1.4k views
-
-
Hi All, I have a layout/report I'm using for printing. THe first column is a "Record Number". The layout is sorted by a Sub Summary with a page break in between. How am I able to restart the record number count after every page break?
-
-
- 4 replies
- 2.8k views
-
-
Using FM8 Advanced I have a table containing graphics. I have a table containing names. I would like to end up with a container field that combines the graphics and the names. Example: A png of a flower and I want 50 different versions of it, each with one name from the name table. I need to have this become a new png. I could potentially need to do this 1000's of times, so I need to automate somehow. I can't have a layout with the name under the flower and then print that. I need a png file when it's done (1000's of them). Is this something FM could do or do I need to work with graphics software? Any suggestions would be appreciated…
-
- 4 replies
- 3k views
-
-
Just not quite grasping Portal Filtering and Global Storage. Database consists of investigations records. Each record has a case number. Each record has, for ease of explanation, a to do list portal. When a to do item is completed, the completion date is entered in the portal. If it is not completed the date field is empty. I need a separate layout with portal that displays all the case numbers with non completed to do items. Basically show me which date fields are empty. I've checked all the posts for days and I just cant grasp it. I can pick apart an example db pretty well if someone could throw together a very basic one. Thanks.
-
- 19 replies
- 3.8k views
-
-
I have 3 tables listed: 1.State Appts 2.Cert Footprint 3.Qualified Cert Footprint 1. contains fields "state" and "carriers" 2. contains fields "state" and "agent" 3. contains fields "state" and "agent" and "carriers" I have created relationships of each of these to a 4th table which acts as the portal window. I have two portals currently. The relationships for 2 and 3 are based on "agent" so when I select a particular agent in the 4th table I get results showing the states they are licensed in the portal connected to 2. and I get the carriers the agent is appointed with in the portal connected to 3. My challenge is to create a portal that will…
-
- 2 replies
- 1.2k views
-
-
Hi, I am developing a solution in which i have a portal in which i am adding employee names, what i want is that after selecting any employee in portal then the same employee will not added further in the portal.suggest me how can i do this .
-
- 2 replies
- 1.3k views
-
-
Is there a way to group records that are marked by a status field as "Active" together in a portal? For example, I have 5 records 1)Active 2)Active 3)Inactive 4)Active 5)Inactive I would ideally like for all the "Actives" to be together and the same for the "Inactives" in the portal as such. 1)Active 2)Active 4)Active 3)Inactive 5)Inactive I would also like to highlight the "Active" portal rows with one color, and the "Inactive" rows with a different color. Is that possible? Thanks in advance for any help.
-
- 5 replies
- 1.6k views
-
-
On my layout I have two fields that I have changed the field behavior to "Select entire contents of field when entered". My entry procedure has "Insert from Last Visited" for both of these fields as well. If you tab through the layout fields, on an existing record, the entire contents of these fields is selected as you would expect. However when you click on my custom "Enter" button, the cursor goes to the end of the contents of the first field instead of selecting the entire contents. Is there a command or method that I can have the entire contents of this first field highlighted.
-
- 2 replies
- 2.2k views
-
-
We have a calendar that displays entries as rows in Table view. One way users can arrive there is via a GTRR from a related table; in this case, we want to persist the pre-existing found set and sort order in the Table view. This works up to a point. But the selected entry is usually displayed at the bottom of the window. How can we adjust the display so that the record is shown at the top of the window - with the same found set and sort order as before? Or is there a better way to do this avoiding the GTRR step? Many thanks in advance, W.
-
- 5 replies
- 1.3k views
-
-
dateEntered ...Auto enter acct ...1000 ////mother Account last_name ...Smith ////child Clients We create accounts stuffing patients under In a portal, we have a client list of lastnames sorted by date In each acct# has 1 record--the lastname default is "Office" In a portal..i am trying to Exclude records = "Office" Seems simple..
-
- 1 reply
- 1.8k views
-
-
Not sure if this is should fall under layout queries... but here goes.... I have a join table in place that brings together 2 tables. One table is items... the other table is images. I scripted a way for people to link items to images. They can have multiple links, or an image can have multiple items... (the benefit of the join table) That has been working great. But what I need now is a way to denote a primary image. I am a little lost on how to proceed with this. When viewing the images as a single field (not a portal) it will display the top image only. This is fine... but how could I give tell Filemaker, which image should appear on th…
-
- 3 replies
- 1.3k views
-
-
Ok, I could use some suggestions for this. I have a very large repository of information spread out across 3 tables in SQL. In FMP, I have created 3 table occurrences of these sql tables and have defined relationships between the common variables. I am attempting to mirror that database here in Filemaker. on a Daily basis it uses a previous order date to show all of the new orders... I use a portal to display all of the information from the 3 tables that I need on the screen for that day. I wrote a script that will loop through this portal and copy the data to my filemaker table. I set all of the values into local variables... I then switch to my …
-
- 2 replies
- 1.6k views
-
-
I'm creating an orders database to replace the software we currently use and we are trying to keep everything as close to the same as possible for the users as well as ease of importing data. In the old software, we had the option for value lists, but were able to populate multiple fields based on one list For example, we have a field for: line item Qty Price We have a value list on the line item field that is setup as: product;qty;price the ; would be interpreted as a tab and put that data in the next field. For example: valuelist would have widget;1;9.99 that would populate the line item field with widget, the qty field with 1 and the …
-
- 2 replies
- 1.1k views
-
-
I hope that this should be easy. I need to find out if I can have a certain field automatically file in the date format I need. When we open a sort (say today) it goes 00220091112KA This is broken down by 00220 (Our Location number which never changes) 09 (year) 11 (month) 12 (day) K (never changes) A (starting at A and ending on which letter we are on for that night). When I go to put a project into the system I enter the date in the date field 11/12/09 and the project number automatically populates 00220 I would have to fill in the rest of the numbers 091112KA. I would like it when I put in the date it automatically puts 0022091112K Which i would j…
-
- 2 replies
- 1.1k views
-
-
I'm having difficulty with creating a filtered portal on the criterion of age. I am trying to make a portal provide choices filtered by input from the user in fields of LastName, FirstName, Gender, and (DOB or estimated_age). It is actually working to filter by user input, but the age calculation is incorrect because it currently is stored. This is not a big deal for a 50 year old (the estimated age looks up +/- 20%), but is a substantial issue for a 14d old if the calculation is not refreshed for a few weeks. The example file is attached. The user can put in the LastName, FirstName, Gender, and estimated age. The user input is placed into a global field and…
-
- 2 replies
- 1.7k views
-
-
ok, here's what I envision. I can't figure it out but you folks are a lot smarter than I. I would like to have fields on a layout and allow users to select which fields they want to see in a table view. So, if I put 10 fields for choice and a user wanted to see only 3 of them, is there a way for users to indicate which 3 and then have those 3 show up in a table view for sorting and printing? I am using FMDev6. I've seen this kind of thing using javascript and it could be I would need to web enable to get this functionality. just thought I'd ask. thanks todd
-
- 1 reply
- 1.1k views
-
-
I have a new client that requires three reports from my data. One must be legal/landscape, the second is letter/landscape, and the last one is letter/portrait. How do I tell FMP to do three different formats?
-
- 5 replies
- 1.3k views
-
-
The ruler at the top of my layout runs out to 111 inches wide. My print size is set to legal (8.5 x 14 inches) landscape. The white space shows properly in the layout mode but there is this huge area to the right of my work area that I seem to drift out into all the time. Is there a way to resize the overall window so I can't get too lost to the right of my work area?
-
- 4 replies
- 1.6k views
-
-
I have a Table Titled "Job Ticket" I have a Table titled "Delivery Ticket" I have a table sitled "customer information" In the Delivery Ticket Table / Layout, I want to enter the "job ticket" record number into a field, and then have related information off that same "job ticket" fill 3 other fields. for Instance, I enter in the record number in field A in my "delivery ticket." That triggers field B, C and D to automatically fill with information off that same ticket. 1 more time: I enter the record number, the desciption, customer PO price automatically fill in on 3 other fields.
-
- 1 reply
- 1.2k views
-
-
Hi all I have been reading comments blog (http://fmforums.com/forum/userpage.php?uid/21152/) on conditional value lists and find it extremely usefull. All though I dont understand all of the theory behind it I have managed to replicate the 3-tiered valuelist example and the 2-tiered with selfclearing into my own db. My question is now: Can anyone tell/show me how to make a 4-tiered with selfclearing - or is there a maximum of conditional valuelists? (one thing is replicating another thing is inventing ) Thanks in advance Regards Lasse
-
- 0 replies
- 1.4k views
-
-
Hi everyone! Great forum, I've been going through trying to see if someone else had my problem and I've enjoyed a lot of posted samples of databases to nose around in to help get you through. Learning a lot, and at the risk of nerding out on my first post, that's very cool.. -) OK, here's my situation. (If there's a link to this, please post it as I've looked around a lot over the last couple days and can't seem to find it.) Business has multiple 'Skills' they offer and a 'Rate' for those skills. Setting up a Checkbox so for each record you can choose multiple 'Skills'. I was hoping after the checkbox is filled to create a button which auto-fills out multip…
-
- 0 replies
- 1.8k views
-
-
Hi all I have a "calendar" table which includes a date field (there is an entry for every date in a year) It also includes various calculation fields relating to that that date. One of the calc fields is a Short month/year field - ie so that 1/10/2009 would be "Oct 2009" (as would 2/10/2009) I have a conditional value list of the short month names year field (based on going back a calendar year from todays date) BUT because the short month name/year field is a text field it sorts alpha - I would like it to sort in month order and must confess to being a bit stumped I have tried sorting the relationship but that didnt make any difference …
-
- 1 reply
- 1.4k views
-
-
FileMaker Pro v6 I have a list of around 7000 names which I want to place into a drop down list which then lookups up a related account code. I have found that a value list is limited to a maximum number of charachters which is far less than the proposed names list. Is there any workaround.
-
- 1 reply
- 1.2k views
-
-
I'm not sure if this is the right place to be asking this question, but as far as I can manage to figure my problem out, I think I must need to leverage Value Lists. I am doing a genealogy one name study which is source/event based. I know that genealogy dtabases are the deep end, but have managed to work something out to my satisfaction so far. However, I am stuck when I come to sort and finding - I want the database to know that John, Johannes, Jo:, Jhon, Jonothan etc are all exactly the same name. And the same goes for surnames, placenames, counties, occupations, titles etc. I can see how I can make a "Normalise" table create itself, where I am asked f…
-
- 6 replies
- 1.9k views
-
-
Is there a way to duplicate the contents of a tab? I have a series of 12 tabbed layouts that essentially hold the same information but with small variation. I would like to minimize the visual differences between what you see on one tab vs what you see on another. Any ideas how to do this economically?
-
- 1 reply
- 2k views
-
-
I have a Layout based on Table A that has a Summary Total of Loans from that table. I placed that total in the header successfully. I would like to pull in a Summary of Payments from Table B into this Layout. How can this be done?
-
- 12 replies
- 8.5k views
-
-
Since migrating to FM10 tooltips show up very little if at all , mostly not? Have tried deleting and re-formatting & restarting.
-
- 2 replies
- 5.6k views
-
-
Hi, On one of my layouts, I have a text field in which you can search for a last name to see if it is already in the database (e.g., you'd type in "Smith"). If the name exists in the database, all occurrences of the name (Mike Smith, Derek Smith, etc.) show up in the portal below the text field. I want the user to be able to click on each name and be taken to that person's record (in my "contact" layout). Right now, every time you click on a record in the list (if there is more than one name), you are taken to the record that matches the *first*/top name in the portal. (If the list had the following names in the following order--Mike Smith, Derek Smith, Lydia Smit…
-
- 4 replies
- 1.6k views
-
-
I use FMP 8 Advanced. I want to incorporate text and a picture in a Values List. Is this possible and if so how to do it? Or is there an alternative solution? I use this in a template that prints envelopes. Sometimes the company logo needs to go on the envelope and sometimes the name of a person that is in the Values List. Thanks.
-
- 5 replies
- 1.6k views
-
-
I am still new to this, but here's what I am looking to do: I want to have a IWP user go to a layout(portal?) and be able to help custom create a layout that they could then print out for their own use. We have 32 stores that do their own "in-store" flyers and we would like them to be able to create their own using information and pictures from the existing database, and allow them to in put their own pricing. This information would then be displayed in a layout I would build, that would have existing corporate logos, and a bunch of mini layouts setup on that page. So on the entry screen they would have a row of fields: Event Date #1 SKU Sale Pr…
-
- 0 replies
- 978 views
-
-
I am trying to do a sample layout of a product and what I would like is to have a variable "copy block" There are titles above, and pricing etc below, but i have between 1 - 14 lines of copy. I am hoping that if there were just 2 lines of Copy it would pull everything up. This is already a "list field to put in copy. * If I added the other fields to that list calculation in the right places that may work - but How do I do formatting on just those fields independant of the text box they are in? (Colours, fonts , sizes?
-
- 2 replies
- 1.5k views
-
-
Hi. I have a problem i cant work out. Ive stopped Return and Enter moving to the next field, but when i use Enter in this text field it jumps 3 or 4 lines - even Shift Enter. What is causing it to do this please? Greg
-
- 2 replies
- 1.2k views
-
-
Hi All! I have a solution there I want two different outputs: 1. One layout should be visible at the computer monitor. 2. On a TV-monitor a different layout should be visible of the same post. How should I do to get this? -Per
-
- 6 replies
- 1.8k views
-
-
Hi all I have a table called PRODUCTS which contains all of our products the following fields: Type_of_customer: (young, senior, work camp, etc.) Destination: (USA, Italy, El Salvador, etc.) ArrivalDate: (ex. 12-09-2009, 09-10-2009) There a few type of customers, more destinations and plenty of arrival dates. I want to relate this table (PRODUCTS) to another table called CUSTOMERS by using 'type_of_customer' as relation. My question is how to make dynamic valuelists in table CUSTOMER where: 'type_of_customer' limits the choices of 'Destination'. And the 'type_of_customer' combined with 'Destination' limits the choices of 'ArrivalDate' i…
-
- 5 replies
- 1.6k views
-
-
Hi. Im looking to drag and drop data from one contaner field to another - thus moving. When I currently do it, the data is copied. Is there a key combination that does a move, or what formula can I use to then delete the contents of the source field please? Greg
-
- 7 replies
- 1.8k views
-
-
Hi All, Is there a way to create a "Drop-Down" clock similar to the calendar. The idea would that either when you tab into a time field or click on it a digital clock pop-up that lets you select the hour - minutes PM or AM. Thanks RudyM
-
- 2 replies
- 4.3k views
-
-
Have a strange problem with one of my files. All of a sudden, images don't display on layouts. Like graphics I use for buttons, even lines drawn directly on filemaker. I tried to restore the file and it fixed it but then I went to reopen and it went back to the same. Anyone else have this issue?
-
- 6 replies
- 1.7k views
-
-
Hi all, I wonder if anyone out there can help. I am working on a job management system and I have hit a bit of a brick wall in filemaker namely the lack of ability to display portals within portals. In my job management system I have a jobs table, a job stages table and a staff table. For the particular layout where I am having the problem i have created a parent - child - grand child relationship with jobs to job stages to staff. The jobs layout shows job stages associated with the job (as you can see) The problem that I have come up against is that I want to add staff members to the job stages and because there can potentially be more tha…
-
- 1 reply
- 1.2k views
-
-
I need to see if I can do this or not. I have Time Card tab where I can put in the persons time. I have a calendar pull down and select the week begin. It automatically inserts the dates mon-sun. I put it in the sime and it will calculate hours in week, hours left, overtime, and total hours worked. But it I change this all the times I inputted stays. I would like to see if it is possible to when I chang the date it clears out the time I put in for that week but If I select that week again it will show me those time I inputted into all the fields again but only for that week. Any helP? Thanks to everyone and especially to McQueen.
-
- 0 replies
- 1.5k views
-
-
Hi. I dont think Im alone when I find the mouse scroll wheel annoying to scroll through records rather than than up and down the page. I understand that there is a Mac workaround, but what about the PC? Im using FmPro 10 Advanced on Windows XP. Ive tried all sorts of thing. Cheers, Greg
-
- 3 replies
- 3.4k views
-
-
I need a monthly calendar that I can type a persons name into. Nothing special just somethign where I can goto and put Jeremy day off and that would be it. I could have upto 10 people on one day. Just in one month.
-
- 3 replies
- 1.5k views
-
-
Hi--we recently lost our IT person who had created out database. Prior to her leaving, we thought we were able to gather information from a layout where she had placed a portal. I am not familiar with programming, and am now trying to get the data out. Here is my question: She created a portal with date, type, description and other information fields located in a table. When the original fields are full, the fields then appear to copy and create themselves again in another line of the portal. However, they are not seen in the table. I know I sound really ignorant, but where is the data being stored? This information is basically historical data on an individual contact.…
-
- 3 replies
- 1.2k views
-
-
Did not see anything addressing this, so I'll ask. I have a portal that is sorted on one field (Field1). I want to compare the values (dates) in Field2 between the first and second row in the portal and determine which is the earlier date. I don't use portals often enough to know if you can do calculations between fields on different rows. Any and all help is appreciated.
-
- 2 replies
- 1.7k views
-
-
HI i want to know that when i am creating a value list using relationship from another table then what is the use of "include only related values starting from" in this drop down table names are lying.plz tell me what's the use of this option. i m really confused on that part.
-
- 1 reply
- 1.2k views
-
-
I am working on a database for a company that is going to be using FileMaker with touchscreen PCs. Part of what they want is a damask background that they use in their brochures in the background of the touchscreen application I am creating in FileMaker (background gif attached). In html you can set a background to tile so that the page doesn't take a lot of space and so that the background is still the background no matter what size the page is. I am wondering if there is any way to mimic this effect in filemaker. I have a few ideas of how to remedy the problem if I can't find a way to tile the background so that the screen will have the same background no ma…
-
- 4 replies
- 6.4k views
-
-
I'm hoping to improve an interface issue I'm running up against. I've created a portal which shows a checkbox list with a global filter. What I can't seem to do is to make the checkboxes go away completely. Pardon the dopey sample file, but what it is designed to do is: allow the user to select which colors of fruits are to be described in a given bowl from a checkbox list (global value) -> choose what size of fruit we want to describe first -> choose the color of that fruit -> choose one or more fruits that fit the description. If there are no fruits that fit the description, I get the response. With conditional formatting, I am able to make a c…
-
- 2 replies
- 2.2k views
-
-
Hello! I'm trying to create a dynamic layout that changes the number of pages depending on what the user selects. For example, I want the user to start off with one page of general information. This is already done and is normal. I have a field that is default "1" (for 1 page), and I want to be able to change this field to tell filemaker to add more pages because I want to add more information on multiple pages. So if I type in "3" in that field, I want Filemaker to add 2 other pages automatically to the same record (equivalent to dragging the BODY splitter down manually) so I can display other info. Is this possible? thanks!
-
- 1 reply
- 1.1k views
-
-
I am developing an income statement report. I have almost everything working properly except that I need to add additional calculated fields (based on summary fields named Gross Profit and Operating Income). These need to be in specific places on the report. I currently have a simple layout consisting of a leading subsummary based on the GL account category (Revenue, Cost of Sales, etc.)where I display the category name, a subsummary of GL accounts which contains totals of GL transactions, followed by a trailing subsummary based on the GL account category where I display the totals for the category. My problem is that I do not know how to place the two additiona…
-
- 0 replies
- 1k views
-
-
I try to find some solution to change font in all fields in Browse mode but have no success. For several fields Script is OK but for 10 or 20 it's to complicated. I'll be thankful for any idea.
-
- 5 replies
- 1.5k views
-
-
Hi, I know i have seen this in the past but cant find it again. (urggg) A kick to the forum post on this would be appreciated... I have a portal displaying data with a DELETE button for each row. The problem is that the row directly after the last row of data shows the DELETE button, even tho it has no data in the portal row. Only the one extra row has this, the rest are blank as they should be. (see attached picture) I would be great full for a point in the right direction to find the solution to this...it just looks bad right now. Thanks,
-
- 7 replies
- 11.9k views
-
-
Hi. I can’t seem to get the Web Viewer to reload after uploading a file. I am trying to reload a Web Viewer (SuperContainer) and I keep getting Error 5. I named the object “superContainer” and the script step is: Set Web Viewer [ Object Name: "superContainer"; Action: Reload ] It just keeps returning Error 5 (Command is Invalid). The SuperContainer is working just fine and eventually, the item in the Web Viewer does reload but its not instant.
-
- 1 reply
- 2.3k views
-
-
How do I reference a selected check box item in a calculation? For instance, I have a value list with two items, one is "linked" the other is "master" I have another field that I would like to perform a calculation if master is checked, and if only linked is checked, then put in a looked up value. This is probably easy to do, but I can't seem to figure it out. Thanks Darron
-
- 2 replies
- 2.4k views
-
-
I need to create a valueslist that combines the Year field from 2 tables. Financial contains Expense and Income records and Invoice contains Invoice records. Both tables use a transaction date. I have a "Year plus All" defined in both tables, but I need to have a values list that will include the years from both tables. For example, I could have invoices for 2009, but no expenses or income entered and maybe expenses for 2008, but no invoices. I would need both 2008 & 2009 in the valueslist. Thanks.
-
- 1 reply
- 1.3k views
-
-
Hi, I'm trying to generate a letterhead with the data I have. What I have is a field that says 1,2,3 and so on with people's name under them, 1 can have 5 names, 2 can have 3 and so on. The letter head I need to make will say something like: Hi [name field], please remember to take care of [1]. my problem is taking the [1] from the database I already have and change it into some form of text, like change [1] into [Throwing out the Trash]. Any help on this would be great, again I basically want to take the value from a field and generate a corresponding test based on the value. Thanks!
-
- 3 replies
- 1.2k views
-
-
I have a BOM database and I want to be able to press a button and add a stamp to the record that says DISCONTINUED. Does anybody have an idea of how. Thanks a lot!!!
-
- 1 reply
- 876 views
-
-
I have two related drop-down menus. My selection in the first menu affects what I see in the second. Produce Type (fruit, vegetable) Produce Kind (apple, pear, carrot, celery) For example, if I choose "fruit" in the first drop-down, my choices in the second drop-down are apple and pear, so I choose one of those, say, apple. Problem is, I can go back up to the first drop-down list and change my selection to vegetable. Now I've got "vegetable" as a produce type, and "apple" as a produce kind. How can I ensure that if the user changes a selection in the first drop-down, the contents of the second drop-down field are cleared so I'm forced to make another…
-
-
- 10 replies
- 6.2k views
-
-
I would like to know if its possible to create a value list based on the selections made in a check box set, basically it would be a filtered value list eg Field Colour, as checkbox, from valuelist showing 4 colors (red,blue,green,Black) Red x Blue Green x Black I have ticked Red and Green, so for this record I would like a value list just showing red and green My thinking is this should be easy, but i think i may be losing it.
-
- 10 replies
- 1.7k views
-
-
OK, here's my dilemma: I have a Field called "Message" in which I'd like to create 2 drop-down Value List choices: In each message I'd like to have a signature that includes the name address and phone number of sender. How do I get these messages to look like a "letter"? When I hit "return" during the creation of the value list, then I get all separate items in my drop down. Please help!!!!
-
- 3 replies
- 1.2k views
-
-
Hi forum! This must be so easy it must be a no brainer...but Ive now spent 2 hours trying to do it to no avail. I have one Table like this with two fields sortorder and menutext like this 1 -nothing selected- 2 zzz Entry 3 aaa Entry 4 ddd Entry I want to make a value list from the text items, but one that shows in exactly the order above. I need the table so I can add in new menu items easily so I cannot use a straight "fixed value list". I want my Value List to display like this when I click on my field: -nothing selected- zzz Entry aaa Entry ddd Entry it however displays: -nothing selected- aaa Entry ddd E…
-
- 13 replies
- 23.8k views
-
-
OK, I'm working on putting together a subsummary report for my mileage records and what taxes I have to pay for the mileage I drive. I have 99.9% of the report done , but I am having trouble with ONE field. I am trying to subtract one summary field from another to get a result, but all it shows is 0. I have attached a demo version for reference if someone could please tell me what I'm doing wrong, (and/or) better way to put this together. Thank you, Zcast demo.zip
-
- 6 replies
- 1.3k views
-
-
Hi All, I want to generate an email that includes a report either as a PDF or an excel file. I want the script to automatically generate the file name. Current date_Text specific to the file (Username etc). However, when I try to use the script step save a PDF or excel, I get an error message. I think it is how I'm trying to save the file. I use a set variable step to set $Filename to generate the name. I just want to set it to the person's desktop (Win/Mac). Help?
-
- 3 replies
- 1.4k views
-
-
I have catalog of people, each person with a unique ID. The related child table has a field that lists individual physical characteristics for each person (one to many relationship, e.g.: ID#001 has blue eyes, brown hair, tattoo, etc.). Is there a way to have the child field display as check boxes in the parent layout so for each ID I can see all individual characteristics checked off? This would be helpful for searching for a particular person by simpling checking off those characteristics to help find an individual. I know I can create a value list and manually go through each ID and check the appropriate boxes but the database is too large.
-
- 11 replies
- 2.2k views
-
-
Hello, This might sound like a silly question, but is there anyway to completely hide the bottom border where it shows the "browse", the percentage, and the toggle? I see you can 'hide' some of it, but I want it gone so the user does not have the option to toggle at all... Thanks. Vandy
-
- 3 replies
- 1.1k views
-
-
the addition of an 82KB png to my layout is increasing the output pdf file size from 750KB to over 4.5MB!! can any body off any suggestions or solutions?
-
- 5 replies
- 1.9k views
-
-
Hello, I'm trying to follow the guidelines to create a separate file for the UI layer. But I don't know how I should implement the valuelists: I have a table with projects and a table with project statuses. Some of the statuses are marked active. Now I need a valuelist of the projects with statuses defined as active. In the separate UI file, I reference to the projects database, define a relation between the projects and statuses. I've created a table in the UI file (Active projects) with one global field 'active' and define a relationship with Project_status. Now I would like to have a valuelist with the active projects in it. But when I …
-
- 0 replies
- 1.1k views
-
-
Long story short, I have to export data from a related table into a field I can then merge into a word document. Table B - Child Table I concatenate a number of fields together to form one field "display" Table A - Main Table I create a value list of all related items in Table B. In a field I then have Substitute(ValueListItems (Get ( FileName ) ; "DisbursementDescription" ); "¶"; "%|%") This works great. EXCEPT It will de-duplicate which I don't want. It has to include ALL related values irrespective of if the concatenanted data appears more than once in Table B. (as an example of the sort of data being concatenanted.. 12…
-
- 2 replies
- 1.1k views
-
-
I'm trying to define a summary field that summarizes a calculated field that as part of its calculation includes getsummary on another field. I defined the field, but the result are whack! I have attached the fp7 in a zip and a pdf showing the whacky total regular hours calculation. (712.8 and 600.0) Any help would be appreciated. The accounting department is breathing down my neck! Thanks! TimeKeeper.fp7.zip TimeKeeper.pdf
-
- 5 replies
- 2.1k views
-
-
I'm curious to know how other developers go about creating the basic user interface/design for a new project. I have put a lot of time and effort into creating what I consider to be an ideal user interface/design with custom graphics, etc. I was planning on re-using this design for future clients. However, my current client is concerned about their database not looking like others. I realize, that in the end it's the clients decision and I'll give them whatever it is they want, but I'd like to hear if other developers use a "canned" user interface/design, or if you re-design, create new graphics, new color schemes, etc. (by user interface/design, I am ref…
-
- 10 replies
- 1.6k views
-
-
Hi people I've got a large text field that is used for comments in one of my layouts. Around that field I have a border/field container made up of image files (i.e. top-left corner, top-centre, top-right corner ... etc - 8 images in total). I've currently got the text field to slide up, depending on the amount of text within that field. What I need help with is getting the surrounding border images to match the sliding of the text field. When the text field slides up, I need the border images to slide up accordingly. Anyone have any ideas? thanks Cory
-
- 4 replies
- 1.1k views
-
-
My problem is I have a list of records and I want to create basically a alphabetic summery field that I can then us to illuminate a tech's name. I basically have a list view of my records for that day that have the the techs I have assigned to them. I then would like to illuminate a simple label using conditional formatting to indicate that a tech has been put on a list that way no one is forgotten. I have can light 1 to 2 names at a time if you are on the record that contains the name you are looking for but ignores all other tickets. I would like to simply compile a list of all techs in a summery and then use conditional formatting to check and see if the name is …
-
- 8 replies
- 2.6k views
-
-
I am very new to FM, so please be patient with my ignorance. I'm trying to make improvements to a database that I did not build myself. So I am still struggling to understand some of the ways this database works I have records for "members" and each member has multiple location addresses associated with it. The multiple locations are entered into a portal linked to the members by a member ID number. I need to build a script that returns members locations based on an option selected in a drop down menu field that is part of the portal. So for example, a location could be a Store Front, and Office, or a Warehouse. These are the three options in the drop down…
-
- 2 replies
- 1.2k views
-
-
Is there a simple way to display PDF file contents in container fields without first exporting the field?
-
- 1 reply
- 1.3k views
-
-
I have a table with people which can be active or inactive. I managed to populate a value list of the active people using a self-join on a global field set to "active". I need to reuse this value list in other files, multiple times. Is it correct that the value list remains empty unless I recreate the self-join relationship in every file I need to use the value list? Thank you for your feedback!
-
- 4 replies
- 1.3k views
-
-
I wonder how you would make the plugin click in the .jpg shown element? --sd
-
- 0 replies
- 1.4k views
-
-
Is it possible to create a portal that shows fields from related records in three different tables? If so, how? If not, how do I get around the problem? I have a many to many relationship between two tables, with a join table in the middle linking them. I need a portal showing fields from each of the many tables, and one field from the join table. Edit: Problem solved by creating calculation fields in join table to specify the data I need so they are all in one table. Then portal works perfectly. Apologies for bothering the electrons on this board.
-
- 3 replies
- 1.1k views
-
-
I have a complicated layout that works for me but it has a great many container fields. I would like to REuse this process without making over all my scripts and fields and of course it would have different data. I would like to know how to duplicate a layout , its fields, and make it into different table so I don't have to make all the scripts I used over again. Is this possible?and how?
-
- 7 replies
- 1.1k views
-
-
Hello all! I added a picker window to a solution I am working on. This picker window approach was taken directly from the FTS materials (p 6-50 to be exact) Everything works great with one exception. If you are in a field in the portal and click the add button, it adds it - but the portal does not refresh until you click OUT of the portal. The FTS example does not act this way and I cannot see any difference or reason why. My goal is to not have to click out of the portal and once you add an item, it refreshes the portal list to show it. For example, here is my solution in the works - ignore the mess, its still a long way from being done. but cl…
-
- 2 replies
- 1k views
-
-
I have 120 container fields with 120repeats and filemaker will not allow me to put them all in a layout. They are really tiny and they all fit but it will not allow me to put them all there. What is the limit of fields in a layout. It crashes filemaker everytime I try to add all my fields. This is terrible for my database. I can't find the information anywhere.
-
- 5 replies
- 1.2k views
-
-
Simple example of controlling a web viewer with applescript. More advanced operations are possible. Bruce WVClicker.fp7.zip
-
- 10 replies
- 5.1k views
-
-
Hello. I have a largish (30k record) database. One of the fields is an Edit Box set to auto-complete with previously entered values. I'd like to be able to make this a popup list, if possible. My concerns are: 1) optimally, I'd like to be able to retrieve the autocomplete list and populate the value list with it. Possible? 2) I'm concerned about what might happen to the existing records. Not all 30k records are populated in that field (I'm adding information to existing records as I get it). More importantly, I don't want those fields already filled to get messed up by fiddling with the setup. Will I basically have to create a near-duplicate of this field …
-
- 1 reply
- 1.6k views
-
-
I have a list of occupations that I need to be able to select one of. By selecting the occupation it defines a rate that I use to calculate insurance premiums. In the past I have put this rate in a global table so that it can be accessed from client files. In the past this rate was manually changed from time to time. (ie: not governed by an occupation selected on a list.) This time I want the rate to change automatically according to the occupation that is selected. The list could be in a global table which I can access from the client file to set up the rate, but I really dont want the person accessing the client side of the database to have access to the …
-
- 20 replies
- 3.2k views
-
-
How can I setup a field so that you can write to the field which is going to be called diary , so that you can enter notes then it will add that note with a time stamp within the logs but you are not able to remove the notes already there?
-
- 5 replies
- 2.2k views
-
-
Is there a way to delete a portal row, without deleting the related record attached to it?
-
- 3 replies
- 1.2k views
-
-
Hello again everyone. We have a new question that none of our in-house people can figure out. Is it possible to create 42 records at one time in numerical order in a list layout. We have 42 seats in a split class and instead of creating a record for Seat 1 | Hannah Jones | Mrs. Wingfield. We would like to create all 42 seats at one time Seat 1 Seat 2 Seat 3 and then fill in the other data as the seats fill up. Is this possible? Thank you very much, Michelle Logan
-
- 2 replies
- 1.1k views
-
-
I have a drop-down list which users can edit and enter more values but I want to limit them to entering no more than 6 different values. Is there anyway I can limit the value list to having a maximum of 6 seperate values. I want to do this so that if users want to enter more than 6 values then they can pay for a slightly higher priced edition of the database. Any help is very welcome, sorry if I didn't explain very clearly.
-
- 1 reply
- 1.3k views
-
-
I've created a layout displaying a parent record and a portal displaying the child records. I've create another layout, this time displaying the parent record and one child record, I need to create two buttons that will then change the child record displayed, one for up, one for down so as I can cycle through the child records.
-
- 1 reply
- 1k views
-
-
I'm new to this (not even sure if I'm posting in the right forum!), and I have a question about container fields. I'd like my container fields to store only a reference to a file (mostly .pdf archived documents). I can get this to happen, but then when I share the database (right now just using FileMaker; will update to Server soon!), users in an opposite-platform environment cannot open the file. All the .pdf files are stored in a networked location that all computers are able to access. I know that the problem is that the file path is different on Windows and Mac. But what is the script or calculation or whatever that allows me to fix the problem? (I see that 360Wo…
-
- 1 reply
- 943 views
-
-
Hello, I have a DB setup and running and have just started to use it live after much testing and tweaking. I have found a problem, that im not sure ware it come from so not sure how to look at fixing it. My Portal is displaying records that it should not. I have customers, each customer has systems and each system has inspections. The portal shows the inspections done in the past for the system selected for that customer. For some reason (and seems to be random...i cant see logic in it anyway) when in the customer record the portal is showing inspections done for other customers systems. Here are two screen shots which show the portal setup and the …
-
- 1 reply
- 1.3k views
-
-
Hello. I am very new to Filemaker Pro 9. I'm trying to set up my database so that data can only be entered when a new record is created (and only at the moment of creation) or in find mode. In Layout Mode, I have tried Field/Control -> Behavior -> unchecked 'allow field to be entered in browse mode'. This works for allowing entry only in find mode but prevents the entry of data into a new record. Any suggestions/information would be greatly appreciated. Thanks.
-
- 2 replies
- 1.1k views
-
-
I am looking to make a report to count the number of items in a given value list. For example, for each record I need to select a "Problem Classification" from my Problem Classification value list. At the end of each week, I need to generate a report for: a) showing the total number of each problem type selected, defined in the value list for all records showing the total number of each problem type selected, defined in the value list for that given week. I am VERY new to FileMaker (running version 6), can someone please be very specific and help me out?
-
- 1 reply
- 1.4k views
-
-
Not sure if this falls under layouts. But I have a specific layout where I would much rather be able to scroll up and down with my mouse wheel, instead of scrolling through the records. It is a submission page, so the users won't need to scroll through any records... the page is large, and it would make it faster for them if they could scroll up and down. Any ideas?
-
- 0 replies
- 943 views
-
-
These are screen captures of a new problem. Some layouts are developing blank regions. They are cleared if you "wipe them" with the debug window or another app window, or if you drag them beyond the FMP borders and then back in, basically effecting a refresh of sorts. Any thoughts or help? thanks
-
- 1 reply
- 897 views
-
-
This is probably a huge "no duh" question but... When I have a container field with a Reference to a picture in it. If I move the database to another machine or to a USB drive, how do I update the reference path?
-
- 1 reply
- 930 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online