FileMaker Interface Features
-
What's going on here? I have created some text and icon items on this layout. Everytime I go into Browse mode, they move?? Take a look in the upper right corner of my screen shots (I grayed out the rest). Why do items move from layout mode to browse mode? I have checked all formats I can and none of them seem to be any different from each other. I've grouped and ungrouped, I've tried the "lock" from the menu and nothing works. It is as if some of it wants to stay right justified and knocks off the others and moves them over. Any thoughts? Jim
-
- 2 replies
- 1.1k views
-
-
I've only been using FileMaker for a few days. They handed me a huge FileMaker 10 manual and i got through about chapter 4, before they handed me over this database to work on. A large part of my trouble stems from the fact that I'm not sure how the database is supposed to be or work. The guy who was working on it before me I think made some changes he thought they wanted, but didn't finish those changes, so gave me a non-working database in a halfway finished state. If it were an already working database, at least I could see what buttons were doing and such, right now I have buttons that do nothing, and I'm not sure if they are supposed to have a script attache…
-
- 5 replies
- 2.1k views
-
-
I could need some help. I am designing a layout in which every employee writes down his/her work on jobs. I have a portal for the entries for the chosen day, another one with some details of the job currently entered and a third one with all entries for the current job. For helping the supervision of the entries (for the employee and for the team leader), I want to create a fourth portal with 7 lines, one for each day of the week. I could then show the sums for that day. What solution is suitable? I would prefer the monday being always on the top line of that portal, therefor esunday being the last. Thank you for your valued help
-
- 0 replies
- 1.1k views
-
-
I'm trying to have my textbox highlight a row of fields based on what the field's value is. The pseudo-code I'm trying to accomplish: If FieldA ≤ 12.5 AND FieldA ≥ 9.55, highlight Green. If FieldA ≤ 9.5 AND FieldA ≥ 6.55, highlight Grey. If FieldA ≤ 6.5, highlight Yellow. Since it is a Textbox, I have to use "Formula Is" and this is the calculation I have but doesn't work. Formula is Case ( FieldA ≤ 12.5 and FieldA ≥ 9.55; "Green";) What am I doing wrong? Thanks for your help!
-
- 3 replies
- 1.9k views
-
-
When you define a layout to not autosave data, if the user clicks outside a field they get a dialog box asking them to Save/Cancel/Discard. I want to prevent that dialog and trap it so I can put up a custom dialog or force them to hit my Save/Cancel button. Is that possible?
-
- 2 replies
- 1.3k views
-
-
I what to import two related layouts (one holds data used by the other) from one DB in to a second DB. Can this be done and have them being fully functional (scripts, drop-down menu, etc.) in the second DB? If so the next question is of course, how? Look forward.
-
- 4 replies
- 1.2k views
-
-
I do not know how this is done but I have seen a few examples of peoples databases where there layout has a color on the background --- this is not a object you can select... its part of the pats (ie body etc...) Does anyone know how to do this... The default is white theirs is Black... Thank you
-
- 4 replies
- 2k views
-
-
I cannot seem to be able to have a layout in table view, and also be able to have a logo or button in the header to display. If i have the layout in List view the header items are visible, yet in table view the field names are the only item allowed above the layout body. How do i have items displayed in the header whilst in table view?
-
- 2 replies
- 1.3k views
-
-
Expected behaviour: From the setup in the first 3 screenshots, the header part should be decreasing in size in the 4th screenshot. Am I missing something?
-
- 5 replies
- 1.4k views
-
-
I'm using FM 8.0Pro. When I try to create a portal it displays and prints as a table instead of adding a line as you enter data. Any ideas
-
- 3 replies
- 1.5k views
-
-
Hello, I want to import a CSV file downloaded by a Web Viewer in a script. How can I determinate the file path and the file name? This will be a multi-user solution with Mac clients.
-
- 3 replies
- 1.8k views
-
-
I would like the DB to open in the same layout and in List View. In FMP (I seem to remember) you did set the opening layout from the document preferences. In 11 I do not seem to find this feature. Is there a way of doing this? Help seems to offer no help.
-
- 4 replies
- 1.1k views
-
-
I want my script to select the contents of the web object & copy and paste the contents in a field. then I have a calculation based on I have the script go to the object, but will not select all. Seems like it should be simple. What am I missing? Thanks, Caroline
-
- 4 replies
- 6.3k views
-
-
Not sure how it's done but I have seen this before. Instead of having a smiple checkbox that displays only an "x" they have replaced it with a image of a check in a container.... I cannot figure how tis is done... Con someone show me a simple example so I may put it in my database... Thank you
-
- 27 replies
- 4.9k views
-
-
I have so many different layouts that I can't see them all in the list when I click on the layout dropdown on the toolbar. I'm using windows. On my mac I think there is an arrow that allows me to scroll through them all the way to the bottom. Is there a preference setting or something I need to set in order to be able to see all of them?
-
- 5 replies
- 1.5k views
-
-
I have a notes section on a personnel management file. This notes table will allow me to write some quick things about a conversation i have with different people when i have it so i can remember what i last talked about with them. I currently am using a portal that displays all the notes I have on each contact sorted by date in descending order. I want to set something up so that when I am on a contact only the dates are displayed for each note that had been entered for that person and when i click on the date that specific note shows up in an area right next to the date. So in other words if I have a list of dates and I click on a date the note entered on that date for …
-
- 2 replies
- 1k views
-
-
Hi guys.. I'm trying to make a portal that shows only matching records based on details someone has entered into address fields in an enquiry... So we have; Surname Firstname Address line 1 City County Postcode .. I want the user to be able to enter any info they have into the available fields and the portal automatically filter accordingly Am I going to have to make a long case statement along the lines of: Case( if(not isempty(address line1) and isempty("the other fields"); patterncount(address line 1; address line 1 related field ); if(not isempty(address line1) and not isempty(town) and isempty("the other fields"); patter…
-
- 7 replies
- 2.1k views
-
-
Hi I need to develop a simple dictionary (NOT a Filemaker Dictionary) that have the word and the explanation of that word. That's it. All in Browse mode. The idea is to click on the list of words and appears automatically the explanation. This database have three fields: Word, ID, Explanation. The problem is that need to list 20 records (of thousands) of the Field Word with portal (or other way) with scroll bars and when do a click on any word then must appears the explanation in other field as I mention above. I try to create a relationship of the ID itself to get the chance to use portals but don't works... (It works in other FM databases made it by me) The onl…
-
- 15 replies
- 2.2k views
-
-
I have two DB's related via P & F key Id fields. Within the Budget DB I have a pull down field defined to use the Payee::Payee field data to populate the field in the pull down within the Budget DB. This appears to function fine except whenever I add a new record with in the Budget DB selecting one of the data values from the related Payee DB it also adds a new record to the Payee DB? I am attempting to use the data values from the Payee DB and be able to add new records in the Budget DB either using an existing Payee::Payee data value or adding a new one from within the Budget DB.. I am not sure what I am doing wrong with this? Please Advis…
-
- 1 reply
- 1.2k views
-
-
Is there a way to conditional format and Field so a user can not enter information. I have a checkbox=1 I would like the corresponding date field to be able to be accessed otherwise no access. Can this be done by conditional format? Thank you
-
- 3 replies
- 1.9k views
-
-
i made drop down list with apple ball cat. when i select apple from list it must show tool tip its fruit when i select ball it should show it is used in cricket how to do it
-
- 4 replies
- 5.4k views
-
-
Is there any way to add formatting to a tool tip? I'd like to be able to highlight a word in a different colour or by making it bold. Thanks Brian
-
- 3 replies
- 5.2k views
-
-
Hi, I have a number field that I'm giong to change the text color if the value is in a certain range. I don't know how to use the TextColor function in my script.. this wouldn't work- SetField(household::days; textcolor(255;0;0)) What should it be? Thanks!
-
- 4 replies
- 3k views
-
-
hi all. i hope this is the right forum to post this in. please point me in the right direction if possible. i have created a small database for a projection booth that tracks what movies/prints are playing in certain auditoriums, etc. it also keeps track of problems that happen and i've included a log in the database. the log entries are displayed through a portal for that particular day. i want to include a "flag" button for each entry, but i'm unsure on how to make the button highlight the particular portal row that needs to be flagged. highlighting the row isn't necessarily the only way to "flag" entries, but it's one option. perhaps it changes the color of the te…
-
- 7 replies
- 2.5k views
-
-
Hi Everyone, Apologies if this has been covered before, I searched first, but couldn't find the information I needed. I am running FileMaker Server 11 (I had to upgrade to 11, so that the new FileMaker ODBC Driver for PC would work with my solution) and my clients are mainly 8.5 and 9 Mac. I have pulldown menus in my solution which are a selection of products. There are 700-odd items in this menu, and the sales people are accustomed to typing a few letters in order to skip down to the product they are looking for. As near as I can tell, this behaviour has been removed in FMP 10 and 11. This is kind of a big problem for me, as we cannot live without th…
-
- 7 replies
- 1.9k views
-
-
Is there a way to change the settings so that the scroll button on the mouse actually scrolls down the page in a layout instead of advancing record numbers?
-
- 8 replies
- 2.2k views
-
-
I have a DB with multiple tables that will store similar items, such as, Cars, Trucks, Vans, SUVs, etc. We'll calls this "Categories". I want to have a popup list that allows them to select the Category and then change the layout to suite that type of vehicle. I thought I could create a table called "Categories" and then a table for each type of vehicle. I then created a table occurrence called "Cars" where the Cars table is linked to the Categories by a key field. Since I need to add records to the Cars table, but not to the Categories table. The Categories table has one record for each type of vehicle and I created a value list based on the rec…
-
- 2 replies
- 1.2k views
-
-
Hi, been a while since I posted last, and I seem to have gotten stupider, as I can't figure out what seems like a fairly easy problem. Working in FileMaker 9 (yes, I know, but still...) I have a table of companies, a table of attribute types (say A, B, C, and D) and a link table of the attributes for each company. I created a portal that will display the attributes for a company, and the user can add a new attribute by clicking on the first field in a new portal row, then selecting the attribute type from a popup menu. This is all straightforward, but I'm trying to restrict the values displayed in the popup menu so that it will only show those attributes t…
-
- 2 replies
- 1.3k views
-
-
I'm quite a newbie with Custom Menus, is it possible to automatically set custom menus to a given privilege set under certain layouts? All that without scripting? If scripting is needed what is the best practice?
-
- 2 replies
- 2.2k views
-
-
Can you stop the web viewer from loading a new screen every time you switch a record. I have database on employee training and I have to interact with a website that oversees our training progress and what not. Every time I switch records the web viewer reloads and I have to log in again. So can the web viewer interact as a stand alone web viewer or will it always refresh with new records being loaded? Thanks in advance...
-
- 0 replies
- 1.5k views
-
-
Hello , I am working with web-viewer and i have to show all location markers from source location to destination location using Google maps. for example-if i have to show all the major cities between new york to Washington on Google maps it just showing me at A as a source and B as a Destination but i want to indicate all major cities between both of them.
-
- 4 replies
- 3.3k views
-
-
Hi, I have: two tables, A the data file containing the records & B the options file. On Table B 1. drop down list-Companies 2. 2nd drop down with the items. The second list depends on the company chosen from first list. This works fine. I need to then have the cost of the particular item chosen automatically appear in the field for "Cost". Does anyone know how to describe how to do this? M
-
- 2 replies
- 1.7k views
-
-
Hello, I've been trying to figure out a way for the web viewer to "auto click" on the first link which comes up using google or wikipedia. I have a database of dvd movies and I want the web viewer to display the wikipedia page for the movie in question. My search query contains the title, the release year, and the word "film". Using wikipedia as the search engine it goes directly to the page about 30% of the time. The rest of the time it shows a list of articles. -- The article I want displayed is always the first one listed. Is there a web viewer function to automatically click the top link on the returned list? I find that if I do the search on …
-
- 0 replies
- 2.1k views
-
-
In my student database I am using looked up values - but sometimes the looked up value changes - if a student moves to a new address. my question is if I change the looked up value all the records change their data - how can I keep the old data on the old records and only put new data ( new looked up value) on newly created records ie since the date the student moved. should I be using looked up vaLue at all?? thank you for your help
-
- 1 reply
- 1.2k views
-
-
We have a table we call Carriers (basically vendors we use). We used to enter info about their insurance info etc manually into filemaker. Now we can look up the information we need on our carriers via the web. Basically we type in something called the MC# and it tells us if the carrier has everything up to date. I put the web viewer on the layout, used the custom address: http://li-public.fmcsa.dot.gov/LIVIEW/pkg_carrquery.prc_carrlist Now I want the MC# that's in my database to be transferred into the the field on the website. That way as we go from record to record we can see if the carriers have their info up to date. Is this possible? Perhaps with a …
-
- 5 replies
- 4.6k views
-
-
Hi Using Filemaker Pro 11 Advanced on Mac OS X want to make a simple autoresize field (autoheight) in Browse mode showing all the content without scroolbars and can't do it using autoresize. Only get a fixed field's height that hide data when browse and want to see all the content. For instances I want to resolve this: if the field have 2 inches of height then data more than 2 inches are hidden. Solution: If data have 3 inches of height then want an auto-adjust to 3 inches, if the next record is 2 inches of height then want to auto-adjust the field's height to 2 inches and so on. Browsing all the records want to see all the data with autoheight in the field. Can d…
-
- 2 replies
- 2.2k views
-
-
Hi. I have a database that works very well but I need to add a Quotes capability to the system. The problem is that I don't want the Quotes "page" to affect the inventory OnHand number. The OnHand field runs without a problem but I don't know how to render the QtySold inactive (That makes up, in part, the OnHand field) when a quote "page" is created using the same info as per an invoice. (Quoting capability is needed as doing a quote is a big deal to my customer and retyping the info to convert a quote into an invoice is simply not viable. Any help on this would be terrific. TIA Bob Moran
-
- 2 replies
- 1.4k views
-
-
I have a data entry layout with a field showing a custom value list as checkboxes. I have a find layout with the value list as a popup menu. Performing a find using the popup menu works OK for some, but not all items in the custom value list. Anyone got any ideas?
-
- 5 replies
- 1.4k views
-
-
Hi everyone, I'm developing an invoicing solution and have run into a bit of a problem. In my customers layout i want to see both the invoices and the line items related to that invoice. My thinking is to create a portal that displays all of the customers related invoice records and, based on the selection made by the user, have a second portal populate with the invoices related line items. I've created a script that sets a global text field to the primary key of the selected invoice, the next step is to filter the second portal based on that field, something like this: LINEITEMS::_kf_invoices_id = CUSTOMERS::xinvoice_id obviously this isn't worki…
-
- 2 replies
- 1.8k views
-
-
But there is! I have a DB on a small drive. My DB is 864 KB. The disk is 20 MB, and 18.3 MB is available. Every time I try to make a change to the DB FMP tells me to make space on the disk in order to be able to make changes. Is this a bug? Does it need tons of space to make invisible files to safe? If I copy the DB to an other disk it has no problems. Copy it back and the problem is back. Me puzzled, any thoughts?
-
- 4 replies
- 1.2k views
-
-
I think this is a value list question but I cant seem to make it work. My main table is called "customer" My second table is called "phonenumbers" In the customer layout, I list the phone numbers in a portal. Each customer has 1 to 6 phone numbers. I want to load those phone numbers in 1 variable (separated by a CR) in a script. The variable is called $AllNumbers. Can someone help me with the syntax?
-
- 2 replies
- 1k views
-
-
Hi, I’d like to have some value lists that are based on a previously selected value. ie. Car Manufacturer (Select Audi from value List) Model (A6 Avant) This is selected from a list of models unique to Audi. Engine Size (3.0tdi) Again this is based on the fact that the previous selections have narrowed the engine options down to those only available on an Audi A6. Does anyone know how to achieve this type of value list in filemaker. I tried to do it on found sets but no luck so far.
-
- 1 reply
- 1.2k views
-
-
Hi Everyone, After hours of searching I'm begging for some help here. Many years ago I built databases using MySQL and recently I tried to get back into it but I was lost. I decided to try out Filemaker and building the tables and forms has been pretty straight forward. However, I'm not getting the relationships at all! I have a table called 'people' and a table called 'roles'. I've also got a table called 'assignments' where I would like to give various roles to people and vice versa. I can't figure out how to do it! It seems that this should be very simple. In my searching I found this link to a document entitled White Paper for FMP Novices. In it is a …
-
- 1 reply
- 887 views
-
-
I just imported a layout from FMP 8. Behind the layout I had a colored square as background Colour. It refused to import, and I try to create a new background colour but it does not show. If I create it in the header it only shows there, but as soon as it overlaps it goes away. If I put it in the body it it dos not show in the header etc. So question is how to create a background colour that runs in header, footer, body?
-
- 9 replies
- 1.5k views
-
-
This is a little hard to explain. I change a starter solution database layout by adding some fields in the table and check boxes on the layout. now in browse mode when i click on of the check boxes all of the ones i added highlight black. and you can't read them. i been playing with it for some hours now and cant figure it out.
-
- 2 replies
- 990 views
-
-
Hey I'm having trouble figure this out.... Say I have a layout for table A with a portal to table B. How can I write a script to navigate from record 3 in table B to the layout for table A and have it automatically got to a specific field in the portal row of record 3. When ever I "Got to Layout A" then "Go to Field" of the portal, it just selects the first portal row, but I want it to select which ever portal row relates to the record I came from in table B. Make sense?
-
- 3 replies
- 1.3k views
-
-
-
Hello all First of all hello to all, new here and new to Filemaker (as you will understand lol) I would like to ask for an idea on how to make something to work and if its possible.. it might be a bit complicated (or atleast to me it is) Ok, here's my problem.. I have 3 tabs, on first tab i want to display a text field RANK1 (will get to this). On second tab i have a checkbox (Box1) of 5 values (Val1, Val2, Val3, Val4, Val5) and on 3th tab i have a portal in which i will write some things. What i want to do is, based on how many lines i have on portal to autocheck Val5. Also some of the Val's will be hand checked.. When all 5 Val's are checked i want to s…
-
- 3 replies
- 1.4k views
-
-
I was wondering if anyone could help me figure out how to get pdfs held on an external hard drive to show up in a web viewer. At present I have references held in container fields to the pdfs, and I have found a solution to showing the pdfs if they are held on my own computer, but it says: "The requested URL is not found on this server" when they are on the external drive. I'm a newcomer to this, and have found references here and there to this being a problem, but have not understood whether this is a filepath problem or something far greater. Ideally I'd love to find a solution that would enable people viewing the database on iwp to review the …
-
- 2 replies
- 1.7k views
-
-
I have a report layout which is based on a table QuoteLines. In the header I want to print the primary contact (and other details about the contact) for the 'job', but each job can have multiple contacts (only one has the field 'Primary' set to 'Yes'). Basic structure: Quote Lines -> Jobs -> JobContacts -> Contacts In JobContacts (the join table) I have the 'primary contact' field. As previously mentioned the layout is based on 'Quote Lines'. I thought I could simply change to the JobContacts layout, filter out all but the one record that is primary and then head back to the report layout but this doesn't seem to work (the first related contac…
-
- 1 reply
- 1.1k views
-
-
I am trying to alert our staff when a project change they are working on has been marked to show what budgets will be affected but still has $0 for the budget amount. I'm going to need to use this alert in other calculations so I can't use conditional formatting alone. A user (any user) will create a record and check values in a field called disciplines_affected. disciplines_affected has a checkbox value list with six values(all values have to remain - the values selected also denote sets of sheets in the drawing package) ARCH SPEC STRUCT MECH ELEC PLUMB ARCH & SPEC affect the Architectural Budget STRUCT affects the Structural Budget M…
-
- 5 replies
- 1.5k views
-
-
Hello, Sorry if i categorized my problem in wrong category.Today i have downloaded 1 application made by using Filemaker . In that application when i move my cursor of mouse on any image or button in which any script is attached .....then automatically bright grey rectangle appears behind of that button/image.I dont understand how its showing because till in filemaker 11 there is not any mouse trigger launched.not is it possible by conditional formatting. Have anybody any idea ? For more info please click on below link and download the application "Download Moneyworks Demo". http://www.evopac.com.my/filemaker.htm
-
- 2 replies
- 3k views
-
-
Hi I am a newby with a basic lawnmowing database. I have to be able to drag and drop records to reorder at will. Is there any way that I can do this thanks Col
-
- 2 replies
- 1.6k views
-
-
Please Please Help! I have 2 tables, Ingredients and products. The product layout has fields for line items,1. formulas1, formulas2, etc.-which is a drop down menu to select the ingredients from related to the field manufacturer. Works fine. 2. manufacturer list drop down menu related to the formulas list from the table ingredients. Also works fine. 3. I need to capture the cost per gram in the related table Ingredients for the field cost per gram in products table. The value would depend on the formula selected in each line item. I don't know if I need to use GetNthRecord, create some kind of If formula? The value list with related tables doesn't seem to work.…
-
- 3 replies
- 1.2k views
-
-
I have created a single table (will add more) with fields such as 'food' 'household' 'insurance' etc. About 30 fields to track expenses. I have entered in a years worth of data and now trying to report it. each record is identified by payee and date, and than a payee might be divided into several fields. I would like any ideas on how best to present the data. I have played around with summary fields and parts, but by no means a master. Appreciate advice or a point in the right direction! Thanks, Michael
-
- 3 replies
- 1.8k views
-
-
I'm not sure if a Portal is what I need here as I have never actually used one... Basically I am making my own money management system, what I'm stuck on is how to handle transactions with multiple categories... Each transaction will have it's own record in table or list view (might do form view if it will work) but some transactions may have multiple categories, so I would almost need multiple records within a record with a calculation to add up the total... I will have no way of knowing how many different categories might be on any 1 transaction, and most transactions will only have 1 category... Help!
-
- 16 replies
- 2.2k views
-
-
Opps, I was working on a custom menu set, and I must have changed something I shouldn't, now the only menu that is accessible is "records". I can't even get in in advanced to edit the menu sets. How can I get past this and put things back to normal?
-
- 2 replies
- 1.9k views
-
-
I have a client request to create a layout that includes a series of about 5 to 6 portals. Each portal may display anywhere from 1 to 6 records. I can define all portals with the max records of 6, but the client would like to have the portals evenly spaced top to bottom, so that a portal with 2 records, for example, would have the next portal appear directly below, not with spacing for potential of 6 records. More akin to dynamic stacking, or like a portal of portals, the way you would have summary reports of dynamic length depending on the record count. I had thought about just creating it via a summary report instead of portals, but the other requirement is …
-
- 6 replies
- 4.2k views
-
-
Hello, I need to add some sort of mail functionality to a filemaker view, where I can freely enter a message. I seem to requite an "Edit Box" for this, but that is always coupled with a database field. Is there a way to add some sort of input box without a database coupling? Thanks in advance, kind regards, Maarten
-
- 1 reply
- 1.2k views
-
-
New to fm, I have table of manufacturers with,manufacturer A, B, C, D, etc. Other tables for each manufacturer with items specific to each manufacturer. Let's say at least 2 manufacturers named A & B for simplicity. Each item has two names, English & Chinese, thus 2 fields. I need to create a layout with field manufacturer drop down menu where selection of A will bring up only items from manufacturer A in next field items with both the English and Chinese. If B is selected than only items from B should display in field items. Please help with detailed info for a newbie. The only thing I know how to do is create the drop down menu.
-
- 2 replies
- 2.5k views
-
-
field item =case( company name="appple"; ipod; company name="microsoft"os:) when i entered into browse mode its working fine when i click on apple item is changing to ipod but when i change it to microsoft item is still ipod o not changing to os, i have to delete record or add new record why or what happening not understanding the problem plz help me
-
- 5 replies
- 1.5k views
-
-
I have what seems to be a pretty simple task, but for the life of me, can't figure out how to do this. I'm using horizontal portals in a layout to display the records in the table in individual rows. Each row is in its own portal with the specific record defined in the portal setup. There are two groups of records and they each have a "type" the sets them apart. There are only six records in each group. I have already created the summary fields for totalling all records. I just can't seem to create totals for each group. I need to total/summarize the balance of each group in a row beneath the respective group. And this is all in one single page layou…
-
- 3 replies
- 1.4k views
-
-
I am a new FM user and have been spending hours trying to figure out how to define a Drop Down field to show a list of data. I'm sure this question has been asked before. I've been referring to the FM Help as well as a FM for Dummies and FM 10 (the missing manual) even though I am using FM Pro 11. When I try to create a new Value List from the Manage Value List dialog box, the choices are: 1. Use values from field. 2. Use value list from another file. 3. Use custom values. I can't choose #1 because the data I want to populate my database field is not in this original file. It's in another one. I can't choose #2 because when I do choose my second f7p…
-
- 2 replies
- 1.2k views
-
-
Hi! We have a problem wich we can not figure out. Our company is organized through through a system of lists with tasks, projects, responsabilities and so on. We want to migrate from a simple system in Excel to Filemaker. Here is an example of what the "master project list" looks like: NR PROJECT________________________DIVISION :::::::::::::::::::::::::::::::::::::::::::::::: 1. Install new lamp in office_________Janitors 2. Prepare monthly staff meeting____CEO 3. Decide on which candidate to hire_CEO 4. Move archive to new location______Janitors This is a very simplified version but it serves as a good example. The master list shown a…
-
- 2 replies
- 1k views
-
-
I am looking for an easy way to copy data from a web viewer. If I right click on the WV and choose [select All], Then a soft right click and choose [Copy] I can then paste it and parse out the content I want to use. I need a way to automate this because there are a thousand records. I tried GetLayoutObjectAttribut( "webviewer" ; "source" ) this only grabs the website address , which I already know , it's in the web viewer. I also tried GetLayoutObjectAttribut( "webviewer" ; "content" ) Which returns html. Which makes parsing a real P.I.A. Anyone got any ideas on hoe to automate this?
-
- 8 replies
- 8.2k views
-
-
I have created a custom menu set. When I attempt to use it, the book icon and slider bar in the task bar area are dimmed when in the custom menu mode. I thought these two things could work together. The manual and help topics say nothing about this subject. What am I doing wrong ?
-
- 1 reply
- 1.9k views
-
-
Hello. I have a portal that shows a number of records from another table. That table also includes several summary fields (that are not shown in the portal) that are used elsewhere in my layout. It seems that sometimes the summary fields do not update when I change data in the portal. If I click in blank space on the layout (i.e., not in the portal and not in any field) then the summary fields are jolted to their correct values. If I click in other fields, however, this does not happen. I can also get them to update by doing a GoToField call (w/o designating an actual field), but this has the ugly repercussion of causing the whole portal to flash. So... …
-
- 16 replies
- 6k views
-
-
When you select a color from the windows color picker for fill, line or text, the interface is the same as it probably has been since filemaker 4. Has anyone created a plugin with a better interface?
-
- 2 replies
- 4k views
-
-
I work at a university and have a database with student information. Some of the students have different levels of scholarship awards that they use at different times in their collegiate career. The student information (name, demographic info, major, etc.) is in one table. I created a new table for the scholarship awards and linked it through the student's serial number in my database. All the award winners start out with an award amount ($5,500) that they can use whenever they are ready to work on their projects. I created a new layout with the student's information coming from the first table, and then a portal with fields for the project money. The…
-
- 13 replies
- 2.4k views
-
-
I'm using the web viewer to 'get' xml data. I can't use the Import script step since FM does not negotiate a secure connection when doing xml imports. So what I need to do is something like 'getastext(). Can that be done? How?
-
- 1 reply
- 1.9k views
-
-
I have a text field that I am typing text into. There are probably 5 or 6 paragraphs of information. Every once in a while, when I hit the return key to add a new field, it thinks that I am done entering text. I do NOT have the enter or return key enable to advance to the next field. When I click back in the field to trying and add more text, every time I hit the return key it saves the text and will not allow me to add more text to it. Occasionally, I've been able to hold down the shift, ctrl, or command key and been able to enter a return and then enter more text, but now I've come to the point where I can't no matter what I try. Is there a fix for…
-
- 2 replies
- 1.2k views
-
-
I have a drop down list that uses a value list that uses values from first field "Employees::id" and second field "Employees::name" Showing values only from second field. I would like to be able to add an additional selection to this drop down for "-All-". Can anyone tell me how I can do this?
-
- 11 replies
- 3k views
-
-
Installing a client using FMSA 11 on a MacMini as server, 4 stations 3 running win7 with FM11 latest update, with one xp also latest FM11. In layout mode on any of the Win 7 work stations, if you select a layout, that layout may or may not be selected, appears random as to which layout may be selected. We group layouts in folders, so this may be an issue with folders, but no time to investigate further. Any of our Mac's running advanced FM11 on OSX10.6 have no problems, neither does the one WinXp station. Only way to select these layouts is to go to them in browse and then go to layout mode. Anyone know if this is a reported issue?
-
- 0 replies
- 999 views
-
-
Hi, This forum has been awesome at solving all my issues. In my database I have a picture as the background with all the fields above. They are all set to have no fill. When I click into any field to enter data, all the fields fill in solid, obscuring the picture behind them. Is there a way to keep fields transparent during data entry? Thanks a bunch for all the help so far.
-
- 4 replies
- 2k views
-
-
i made a 2 value list (a,b,c)/(apple,ball,cat) ---- i made 2 tables with field name (short) in one table and feild (long) in other table , when i am in table 1 and if i select item (a) from table1 it should automatically change the corresponding valuelist item to (apple) in table2 is it possible can any one help me please , does the two tables should be related plz someone help in simple method
-
- 3 replies
- 1.3k views
-
-
I've had a search, but am not sure exactly what search terms to use for my problem.I'm sure this will not be the first time it's come up, and the answer may be glaringly obvious. I have a photo database. In my layout there is a large central copy of the photo surrounded by relevant details - date, place, notes, people in the photo. There is also a portal which shows related photos in that set. On the other side there is a portal which shows all photos arranged by date. Scroll up and down to select the photograph you want to see, click on the portal thumbnail and that record is gone to. My problem is that there are over 800 photographs, and every time …
-
- 6 replies
- 1.8k views
-
-
Hi, I have reviewed hundreds of posts and tried numerous things and still can't get this to work. I could use some help in finding a simple solution. I'm developing a property database (real estate) that has at least two areas where I will need a 3-level conditional value list. One is for selecting the zoning district, based on the city, which is based in turn on the county. When I enter a property record, I want to be able to select the county from a drop down, then go to a city drop down that will show the cities within the selected county, then a third that will show the zoning districts in that city. The other is the same concept, for property …
-
- 13 replies
- 7.6k views
-
-
what are portals , what is there use can anyone explain in simple language completely about portals
-
- 1 reply
- 1k views
-
-
Hello: I am trying to create a customized roster in FB. I need it to have the following fields in my FMDB: 1) Official Logo 2) First Name 3) MI 4) Last 5) Credentials 6) Company 7) Address 8) City 9) State 10) Zip 11) Phone 12) Phone Type 13) Phone 2 14) Phone 2 Type 15) email 16) Committees served 17) Term expiration Thank you!
-
- 2 replies
- 1.4k views
-
-
is there anyway to import and exporting custom menu from database to other
-
- 3 replies
- 1.7k views
-
-
FM Pro 11, Snow Leopard I created a sub-summary report and in the leading sub-summary area I am trying to display a field from a related table. In Form view, the field displays fine. When I click on the icon for list view, the field won't display at all. I'm going crazy trying to figure this out.
-
- 5 replies
- 1.4k views
-
-
Hi, I need to pass multiple values from a dropdown list (text, 20 repetitions) on ESTIMATE layout to another dropdown list (text, 20 repetitions) on BOOKING layout. On ESTIMATE layout I compile list of equipements (with relative prices) a customer requested then create PDF file from it and send it to the customer via email. Once the estimate was accepted by him/her I reopen the ESTIMATE layout, click on button created by me which opens BOOKING layout, creates a new record and pastes values from REQUESTED EQUIPEMENTS dropdown list to an editbox field. This works well but... What I really want/need is the values to be pasted into a dropdown list (text, 20…
-
- 3 replies
- 1.7k views
-
-
I use new windows to do calculations and finds on my database to avoid errors. Now I am finding that this is taking a lot of time. Is there a way to open a new window and have it open hidden?
-
- 7 replies
- 1.5k views
-
-
Hi, I am trying to create a form view layout with a top and left section that remain in place when users scroll through the form. I have the top information in a header part but I guess this is irrelevant when I am in form view... Can I create background objects or groups that will be static when the rest of the form scrolls? Thanks for any suggestions! rori
-
- 9 replies
- 3.2k views
-
-
I have a form that uses conditional formatting. I would like to print the form exactly the same, but without the conditional formatting alterations. Is it possible to print without conditional formatting? Thanks, Fed
-
- 1 reply
- 2k views
-
-
Hi. I was wondering if I could get some help. I'm not sure what I've done wrong. On the clients page of my database, there is a table labelled service info. I am unable to select or fill in information for community respite provider and I'm not sure why. I've attached the database. The login is Admin and there is no password. If someone can tell me how to stop getting that to pop up each time it's opened too that would help. I've removed all the account names that I had put on there at first but yet it still pops that login screen up. Thanks in advance for any help you can give. Respite_Clone_1.zip
-
- 1 reply
- 1.1k views
-
-
I recently upgraded from 8.5 to version 11. I like most of the improvements, but I have found that the drop-down list functions differently then before. Before, the drop-down "window" would resize to fit the displayed field. Now, the "window" only displays a portion of the data, followed by "..." Is this the new way the drop-down list functions, and if so does anyone know of a way to increase the displayed number of characters. Thanks, Bill
-
- 6 replies
- 1.7k views
-
-
-
I'm trying to indicate rating of the quality or importance of the record by having a field called rating, and ideally, i want it to be a five-star rating system like in Bento. Is there an easy way to do this? If not, I'd rather make it some graphical representation rather than entering an integer value. Please let me know if star or some other things can be used in FMP, and if not, what people do about it? Thanks
-
- 11 replies
- 8.2k views
-
-
I've searched for this topic in the forum and nothing came up. It may be a simple answer, but I'm a novice user and can't figure it out. Here's my problem. I'm collecting financial information on a monthly basis, where each month has two records. All I want to do is display the 12 month-end records for a given year in separate columns. The data is located in a table called Net Worth Statement. I'm creating a report based on this table called Balance Sheet Summary, which is where I want to display the columns. I discovered while searching the Knowledge Base that I can create a horizontal portal by selecting only one row per portal and then duplicating …
-
- 34 replies
- 6.8k views
-
-
Anyone with advice on how to successfully, and consistently use Tenone Signature Capture on the multitouch or iphone/ipad to pop the signature right into a filemaker container field? I have had variable success with this. It will work for weeks and then just stop working with no explanation. Sometimes it will work fine and then on the next attempt fail and repeat failing to put the image into the container field.
-
- 1 reply
- 2.5k views
-
-
I've got very similar portals on two layouts. Each has 2 or 3 fields on a single line, and then a little icon at the end of the row for triggering a "Delete" script. Everythign works fine. But on one layout, if there are no related records to display, the portal looks totally blank -- just a box with 7 lines of empty rows, no lines where the fields go. . . . while on the other layout, with no related records, the layout displays a first row as though "ready to go" with empty fields visible and the delete button visible. I can't figure what I've done in the one that I didn't do in the other! I prefer to have the fields/button visible. Can someone ex…
-
- 2 replies
- 1.1k views
-
-
I'm trying to create a portal filter to omit or include zero quantity stock lines in a related stock table that contains a quantity field. I have created a global filter field in my main table but I'm just not sure how to build the relationship to my stock table to get the filer to work. Thank You Anthony
-
- 5 replies
- 1.6k views
-
-
im building a database to record my data on all my pet reptiles and i have a lout that records medical information, on this layout is a field with value yes or no, which tells me if the animal is currently under medical attention. im trying to conditionally format this so when the animal is under medical attention it would show either a image or a text label on the main records screen over the animals photo saying something like "Medical Alert" and is the dropdown box is selected to "No" then the image or text label doesnt show. is this possible in filemaker 11?
-
- 3 replies
- 1.9k views
-
-
How might one disable user from using scroll button ... for me it changes the record find but doesn't cause my layout to change..
-
- 1 reply
- 1.3k views
-
-
We are currently building a system that needs fields to appear on (or disappear from) a data entry layout based on the contents of another fields. So, if a check box is checked a few other fields will appear for the operator to fill in that are relevant to that check box. I'm wondering if anyone has any clever ideas for doing this. Barring other suggestions we will likely use a portal to display the ancillary fields or conceal them. (I think this is a John Mark Osborne trick.) This will mean a lot of relationships (clutter to the ER graph) to accomplish this. Conditional formatting won't work because of pull down menus on some of the ancillary fields. A…
-
- 3 replies
- 1.3k views
-
-
Hello, I am in a small freight business, and working to automate dispatching, reducing steps and paper. I have a list of Companies in one table (hundreds of them) - fields are all the normal stuff, name, address, city, state, zip, email, phone, fax, etc. These companies can be either a) shipper, receiver c) billing party. on one shipment they could be a shipper on another shipment they could be the receiver. I have another table called Shipments, which has fields for shipper (address, phone, fax, etc.), receiver (ph, fx, addr), billing party (ph, fx, addr). My goal is to only have 3 pull down lists to provide quick selection of the shipper, re…
-
- 9 replies
- 1.7k views
-
-
One thing that drives me nuts an burns hours of my time is my bafflement with the behavior of lines and edges and alignments when placing fields in portals. For instance, if I have three text boxes in a row, I can play with borders and spacing between them to get various "looks" when displayed -- but if I put a little non-field graphic at the end of the row (for instance a Delete button in the form of an icon) the lower edge never wants to line up neatly with the field boxes -- I fiddle with embossing, various border colors (grey, black, none), slight re-sizing . . . and eventually stumble into a solution by doing something kludgey like adding an extra little line wi…
-
- 4 replies
- 1.4k views
-
-
I created a value list for "Employee Full Names". The list is taken from the Employee table and from the field name_full. In a layout for a table called "notes" I have a field called name_full and am made it a drop down field from value list "Employee Full Names". For some reason it only shows 1 name. What am I missing?
-
- 1 reply
- 1k views
-
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online