FileMaker Interface Features
-
OK, so I've figured out how to change text and field attributes, but how do I change the fill color of a simple rectangle object? The Conditional.. dialog says "dynamically change a layouts object's formatting..." Is a rectangle not considered a layout object? The Conditional.. menu item is grayed out when the rectangle is selected. All I want to do is if a field value is "Yellow" change the rectangle to yellow... I'm sure there's something I'm not seeing... Does anyone know if there's any good documentation on conditional formating yet? It's hard to find much on it!?! Thanks Dave
-
- 5 replies
- 2.3k views
-
-
Hi guys, I haven't quite figured this out yet, but I want to add one button to find mode that will return the user to the full record set. What is the best way to do this? I don't really want to create a completely separate layout if I can avoid that. I thought maybe some kind of conditional formatting? Cheers Chris
-
- 3 replies
- 1.4k views
-
-
When dragging a new field into a layout, what determines the size of the field, font, attributes, etc???...I can't seem to get this to change from the current HUGE fields that are created..I know it's a simply solution but can't find in Help or anywhere else...
-
- 3 replies
- 1.2k views
-
-
We have several databases that are all interconnected. On them it seems that if we get to many layouts we have a problem where we can not manualy move to the layout using the drop down on the left side of the screen. On a couple we have over 200 layouts 1 has over 350! If I have to get to layout 100 I have to type the number in while in layout mode. I can often get to the first 50 or so layouts without any problem. It seems to be after 75 or so that when I select the layout I get sent to the last layout. Anyone have any idea if this is a bug or what. I can provide any info needed.
-
- 2 replies
- 1.2k views
-
-
Hi Guys, I've been poking around in templates and google and what not trying to figure this one out but I just can't seem to get it right. I have a text box for entering first name and last name with a light grey label so that users enter text in the right spot. However, once they enter text, you can still see the label through it! Is there a better way to do this? either a way to make the box background go white when there is text in it or a different way to label *inside* a text box that will automatically disappear when there is text and reappear when there is none (but preferably not thing that will be entered in to the DB when the record is saved if a sp…
-
- 13 replies
- 2.3k views
-
-
I have setup a SQL Database on my server and I have an ODBC connection to it. I can make forms and manipulate data with no problem. My issue is, when I try to make a value list from fields that are on the SQL Database, all the tables are grayed out. WTF? If I create a new table in my Filemaker Application, it shows up as ready to use for a value list. Is this one thing that Filemaker cannot do with SQL Server yet?
-
- 5 replies
- 3.8k views
-
-
Hey, I am trying to make a database for my real estate contracts, and I am trying to create a menu like the one shown here, any help? Proforms_Shot.pdf
-
- 6 replies
- 1.9k views
-
-
[color:red]<> Hi Everyone: I have a database with related tables. Table 1 contains the "Master Record" and table 2 contains the "Sales Records". The Master Record table has a Primary Layout with a Portal that displays records in the related Sales Records table. The relationship is pkOrdNum = fkOrdNum. This way I can have an infinite number of sales lines for any given order. The problem is I can can not seem to build a report that shows order history the way I would like. The Sales record database might have hundreds (or thousands) of records to account for all of the Order Lines. What I would like is a report that changes raw data th…
-
- 0 replies
- 1.3k views
-
-
Hi Folks! I've been using FileMaker for, well, decades. However, most of my creations have been simple flat databases. Now, for our small newspaper, I've created a FileMaker 8.5 database with three tables: - Advertisers (listing advertiser number, name, address, et al) - Ads (one record for each ad run by an advertiser) - Payments (one record for each payment made by an advertiser) Conceptually, what's the best way to combine this data into a end-of-month invoice? Thanks! Dave
-
- 14 replies
- 2.2k views
-
-
Hey everybody. I have a list of employee records. Because of the way that our payroll system is set up, each employee has 9 records in this table. The table consists of the Employee ID, their name, an earnings code(that is used by our payroll system), and a number(the amount of time in this earnings code) - to name a few. When looking at this list, it is sorted so that all the records associated with an employee are grouped together. What I would like to do is color the groups of records, similar to alternating the backgrounds of a portal row or list view. I can color them no problem, but what I can't figure out is how to tell my calculation that the last …
-
- 3 replies
- 1.5k views
-
-
I need some pointers. My shop sells gelato. There are 80 possible flavours. I am creating a db which tracks production and inventory. I created a list with all flavours, and then every day the worker can check the flavours they produce. I have a field which then counts total number created, time taken etc. But I also want two more things. I want to generate a report at the end of the week, of the number of each flavour created. And, I also want to track inventory levels of each flavour, preferable displayed in a table so the worker coming on can at a glance see what is left of what flavour and what needs to be made. So, is there some decent way to convert my simple …
-
- 1 reply
- 1.1k views
-
-
Hi, I have a text calculation that looks like this: "This is to confirm that Mr. "& First Name&" "&Last Name&", has worked at this Company since "&Date of Hire&" as "&Title&". And receives a basic salary of $ "& Salary The problem I am having is not being able to format the both the Date field "Date of Hire" and the number field "Salary" inside this text caculation. I would like the "Salary" number with 0 decimils and thousands separator ",".
-
- 2 replies
- 1.4k views
-
-
Hi there. I am very new to filemaker, making the move from Access. I have a very simple question. I have a field with a value list and I want to have a default value that automatically populates the field unless another option is selected. I am sure this is very easy but just floundering a bit with new software. John
-
- 2 replies
- 1.3k views
-
-
Hi Guys, I have a filemaker DB that tracks a list of our vendors and have a second table that tracks each of their satellite offices in each region (predominately for accounting and so on). I want to display these office names (based on the name given in the regions settings) in the tab name for each switching between them and then display a final tab (that moves to the end at all times) that says something like "Add New Office" Is this even possible or do I need to use some other way to display these? It is possible for a vendor to have unlimited satellite offices, so I was trying to use something that didn't involve loads of forms. If there are other ideas,…
-
- 7 replies
- 2.5k views
-
-
This is probably simple for old hands, but the problem is this - 1 table with 3 fields: Member (repeating text field), Department (text field), and Item (calculation). Item = if ( Member ≠ ""; Member ; Department ). Each Department includes multiple members. (separate records) Each Member belongs to a variety of departments. I want ONE portal to show: Members if Item = Department (taking values from a relationship) and ... Departments if Item = member (taking values from the CURRENT record) I have no trouble making Members show in the portal when Item = Department with a self-join relationship ... but can't figure out how ALSO to make the D…
-
- 0 replies
- 1.2k views
-
-
I have a drop down list with a few items in it. How do I make it so that users can only use the drop down list and not type in data? Mark
-
- 2 replies
- 1.4k views
-
-
I have a database called volunteer and a field named "interest" (which volunteers can show what they would be interested in doing) The interest field is set up as a check box field with a value list of: recovery packs fundraising ect ect.... What I want is a report that will show "Recovery" with the list of volunteers that have signed up to do recovery, then list packs and so on and so on. Recovery susie smith tommy jones Packs billy thomas Fundraising name name I tried to set this up using a layout with a leading summary and sorting on interest but the list is showing the interest every time with one person. …
-
- 3 replies
- 1.3k views
-
-
Hello, first of all, i would like to say hello to everyone because this is my first post on this forum. i have made a toggle sort button, so when i click on it it sort Ascending and when i click back on it it sort Descending, my problem is that i would like to change the button text or image when i click on it, so clicking the button would toggle between a upward arrow and a downward arrow. Any help would be greatly appreciated. thank you. ps: pardon my english, its not my first language.
-
- 6 replies
- 2.1k views
-
-
Hi. I'm sure the answer to this this is SO simple but as a newbie I'm struggling. In summary, it's about how I can select from a portal to enter a value in a new record. I have a time/billing database. One table is 'Jobs' (ie projects) and another is Time (where I record time spent on the project). When I spend time on a job I create a new record in time, using the right job number. The tables are of course linked. I have a drop down list that allows me to choose the job number when I make an entry in Time. At first, this worked fine but as the number of jobs increases I have to scroll thru an increasingly long list of jobs. It seems there is no way to sort the …
-
- 1 reply
- 1.1k views
-
-
I can't figure this one out easily... I have a repeating field, say it's for people's names and has 5 repetitions. I want to display them on a layout as a Merge Field... My question has to do with commas, and periods... If I type: <>, <>, <>, <>, <>. This method will work, but if I only had two names entered in the original field, it would look like this: John Smith, Jane Doe,,,. My question is how to I get it to display the correct grammar, so to speak. I don't know if there's an easy way or if some sort of calculations need to be devised. Any help or suggestions or demos? Thanks!
-
- 6 replies
- 2.5k views
-
-
Hi I have a selector field that is not in the tab order and I made it un-enterable as well. I named the field object "SelectorField". The field is a button that basically ends in a go to object script step that sends the user to the SelectorField object. Problem is it doesn't open the value list, it just puts a black border around the field. Anyone know how to make the value list pop open? I don't want to use go to field because I want to use this script on many screens. (when is Filemaker going to give us go to field name by calculation!!!:)
-
- 1 reply
- 1.5k views
-
-
I'm creating a database which is analyzing some data from surveys created in another 3rd party product. I'd like to add a nifty pie chart to the results of each record in FMP 8.5 advanced. I've googled and found a couple of solutions -- none of which are intuitive. Surely it can't be as hard as i"M makiing it... Jeff
-
- 3 replies
- 1.1k views
-
-
Hi All, I have a layout that allows a user to select the invoices they want to pay, this layout also has a running total, with a restart after each change in the vendor name - telling them the total amount due for all invoices for a given vendor. What I want is to set the final amoount to a BOLD font or just display the summary over the vendor and not the running total - any ideas?
-
- 0 replies
- 896 views
-
-
I apologize in advance if this is a trivial question, but I can't figure it out and I've read all the other threads on the topic; I'm hoping someone can tell me what I'm doing wrong. I have a small database that's used by a healthcare provider to keep track of clients and treatments. It contains two main tables: "Client Info" and "Treatments". On the main layout for "Treatments", there is a drop-down menu that allows the user to select a client that the treatment relates to. This works pretty well, except that there are several hundred clients in the "Client Info" table and only 30-40 are active. We want to limit the contents of the drop-down list to only active cli…
-
- 2 replies
- 1.5k views
-
-
Okay you probably popped in here thinking this question was going to be easy...trust me I searched for an hour on here before I posted. Couldn't find an answer. Here's the deal, I don't want to use the empty portal row. I want more control. I had been using a scripted "new row" button that went to the child layout, created a record, came back to the original layout, and went to a designated "New Row" portal but when I do this the record is committed. I'd like to take advantage of the layout feature where it prompts to save the record or makes you click a button to commit the record. If I go to the other layout I have to save the record before I return. I do…
-
- 8 replies
- 8.5k views
-
-
Hi, since FM9 release, i use conditional formatting, and i need a function how to get format of that special field, is there any possibility to get it? For example: I have a field, which when is empty, its background-color id red and when its not, bg color is white. I want to give to Tooltip string advice - when it is red - "Field required!" and when is white - "OK" , or some other strings, but i need to get somehow the bgcolor of field, is it possible somehow? Or is there any plugin to get it? Thanks a lot. Matěj
-
- 2 replies
- 1.4k views
-
-
Lables have attached themselves to the tabs of the tab control and everytime I try click them in layout mode to delete them the tab control changes to the page to the one I clicked.How do I delete these lables? How they got stuck: I have a layout with lables and fields on the top 3rd of the page and a Tab control on the bottom. I dragged the tab control to high (over the fields and lables at the top)and when I moved the tab control back down all the lables on top stuck to the tab control??? Does this always happen in FM? Any help would be much appreciated, Thanks
-
- 1 reply
- 979 views
-
-
I am new to FileMaker, but not new to development or databases (15-20 years). I have books and do extensive research before asking questions, that is if I am not under a time constraint. I appreciate any assistance with the following: I have a report that I have scripted to run. I show a dialog and filter by a date. This is successful. 1. I want to show a dialog and filter by a date range? 2. I want to display the date range back to the user on the report? Thanks for any help, Lewis Howell
-
- 5 replies
- 1.3k views
-
-
Just a quick question on container color. I had a container red to match the background then changed the background to yellow and changed the container color again to match it. But now when I click the container (it goes to a related record) the container goes to the old color when it clicked....it's not a huge deal just annoying. thanks for any sugestions!
-
- 1 reply
- 985 views
-
-
I want to run scripts when I move between tab panels on a layout (including sub-tab panels). What the simplest way of doing this? When adding buttons over the tab header FP acts as though they are not being seen.
-
- 5 replies
- 2.5k views
-
-
Hi, I have the following problem. I have created two tables, one is "clients", one is "projects" - fairly simple. now, I have had the projects table before and now created "clients" after. I have linked the two through "client Id' and if I create a "project ID" field in clients, it shows one of the old project ID numbers. Now I created a portal to show all the projects that one client has. this portal, however only shows projects/ project ID's that are created after setting up the portal and not the ones that have been created a long time ago... a projects ID field however shows these older ID numbers. this makes me think that I have set up the right relationship but…
-
- 9 replies
- 1.4k views
-
-
I have been working with 3 different databases to develop different parts of a larger combined database. A) . How can I move scripts from database from DB # 1 and #2 into the the bigger database #3? :. How can I move existing Layouts from #1 and #2 into the bigger database #3? I realize that i will have to relink the fields to the new database but i was wondering if there was a way to pull them over so idid not have to rebuild the layouts from scratch.
-
- 1 reply
- 1.2k views
-
-
On my estimate/invoice page that list all past and current estimates, the company name 2 line get cut off -- curious how I fix that? Also, on this page, it's sorting by invoice number. I changed it to sort by date, but that wont stick. I've examined this is layout view, and there does not seem to be a lot of flexibitly or room to move any fields there. (I'm a bit novice) thanks!
-
- 4 replies
- 1.2k views
-
-
I am not sure if this can be done or not, and I didn't see anything after searching for a topic on it, so I thought I'd ask! Is it possible to have a selection on value list, after selecting it (there are only 3) then navigate you to a particular field on the layout? I would want to keep the selection in the value list, but afterwards, jump to a different field. I've tried this with success using a scripted button next to the value list, but wondered if would work in one step. Any help is appreciated, thanks! Karen
-
- 1 reply
- 1.2k views
-
-
I have a main table called Service I have a related table called Containers There is a value list in Service to choose a container for the service call. There are 2 fields within the containers table which the service value field relates to. 1) Container type ( A or B ) 2) Available, which is a calculated field. I only want containers of a particular type and that are available to show up in the value list. I'm at a loss as to how to go about doing this. Filemaker seems to let me use related values for the first field, but will only show values from the second field, which doesn't cut it, because it still shows unavailable containers on the popup…
-
- 1 reply
- 1.2k views
-
-
I have a value list where I have about 10 different options to choose from. For example, there might be SALE, RESET, DEMO, etc.... I would like to be able to display on a report page how many SALE, how many RESET and how many DEMO have occurred. Any ideas on how to accomplish this?
-
- 1 reply
- 1k views
-
-
I have a layout with header, body, trailing grand summary, and footer. The body has 6 fields, it is not showing all the records it should. I get just one record. I thought I had a relationship issue but I put a portal in the header and it shows all of the records correctly. I am also using sliding/printing so I can print this list view out. Any thoughts why list view gives me just one record but portal shows all the records? I am scrolling and the header and footer stays put. Printing provides the same results.
-
- 4 replies
- 1.4k views
-
-
Hello, I would like to print mailing labels for a simple table that includes addresses. However, some records should receive the mailing and some should not. I have created a field with a yes/no radio button that lets me know whether someone should receive the mailing or not. How do I create a new label layout that only prints labels for records with "yes" in that field? Thanks, Benjer
-
- 3 replies
- 1.1k views
-
-
Hello Sometimes when I copy text from somewhere else. It is too big and maybe bright yellow text. I can go to the format window and select the text and change it all to 10 point arial black . But is there a way to automatically do this. Thanks Dave
-
- 1 reply
- 950 views
-
-
The content of the value lists are field based. I have 3 vl in the same database, all of which behave similarly, namely I can see only the first 200 items of the list. Can anyone tell me why this happens? Thank you.
-
- 4 replies
- 1.3k views
-
-
I am trying to access a directory through a web viewer. When I set the path for the web viewer to: file:///users/mycomputer/ All I get is file is directory Can anyone tell me how I can get this to work on a mac. Cheers Darren
-
- 2 replies
- 1.8k views
-
-
Hello I was looking to use one of the websites to view random web pages in the filemaker web browser. I would like to know if anyone has found a way through filemaker to generate a random website and a script to extract the url of it. should you choose to remember that web site. Thanks
-
- 0 replies
- 2.6k views
-
-
I am looking to implement an audit trail in my database, but I want it to be different from the standard audit trails I have seen. I need help and would greatly appreciate some assistance. Typically an audit trail is a text field with a calulation that copies changed data from other fields, concactenates those data, and appends it to previously stored data in the audit trail field. It might store data from several fields and tack on a timestamp. I don't want to store a concatenation of several fields in one audit trail field. I want to write changed data to *respective fields* in another table altogether. For example, I have a table of students. Each st…
-
- 3 replies
- 4.1k views
-
-
Here's another example of a larger species of a problem that keeps coming up: I don't quite 'get' how Filemaker prioritizes and applies text formatting. here I have a simple text box for "Title" - set for black 14 pt. Times. Simple enough. But for some reason, when I use this field as a 'Merge Field' to display the title in a heading on a colored background along with some other text, it refuses to display the assigned formatting. So, in Layout mode, I have a text block That reads: <>Value List for <> It's all in 24 pt WHITE text -- and everything appears that way in Browse mode except for the Title data! it works for the Archive Name, bu…
-
- 4 replies
- 53.6k views
-
-
hello, is it possible to lock filemakers window size? im talking about the entire application.. and also disable the maximize and minimize button of the layout and application windows? and in the layout out window dissable the close button... and finally disable the zoom buttons? any help would be greatly appreciated
-
- 3 replies
- 1.4k views
-
-
Hi, I'm Jorge from Argentina, and I have a little question. I have a portal, and when I write 2 or more lines into the same row, it hides all the lines but the first one... Is there any way to avoid hidding? I mean, like Microsoft Office Word's tables, in which as you write, the row's height increase? Here I attach 2 pics to clarify my problem. Thanks a lot. You're amazing. B)
-
- 4 replies
- 1.1k views
-
-
I am generating a PDF from records in the found set. My layout has header, body, and footer parts. The page size is 11" x 15" with .5" margins on all sides. (Custom page size) The header is 1", the footer is .5"; both containing text. Is there a way to have the body records equally spaced, with a rule above and below, to fill the 12.5" available space? (There will never be more than 20 records in the body space.) Initially, I measured the size (in points) of a record including leading and created a "space" field that was placed above and below the data. Using a Case statement to count the number of records, I attempted to format the point size of the space field…
-
- 3 replies
- 1.2k views
-
-
I've got a user on a PC that uses her mouse's scroll wheel to go from record to record. For various reasons this is a problem. Is there a way to disable that?
-
- 3 replies
- 2k views
-
-
I have a purchase order report that the user can print. Right now the report just shows grand totals at the bottom of the last page. This works nicely if there are only a few line items and the report can print on one page. However if the report spans multiple pages it would be nice to have a subtotal of each page at the bottom. Is there a way to put a subtotal at the bottom of each page of a report?
-
- 0 replies
- 914 views
-
-
Does anyone know a map program that will accept address data from FileMaker to locate address on a map? Or is there a way to import maps from a mapping program (street finder) into a FM data base?
-
- 3 replies
- 2.4k views
-
-
I have a layout I copied that when you view in browse or preview, the related (detail) records show the same records for every row. For example, say there are 10 detail rows for the main header row (linked in a relationship). Instead of showing 10 rows, one per detail line, i get 10 rows of the first detail line. This is killing me but I'm sure it's something simple. Thanks in advance
-
- 1 reply
- 987 views
-
-
I have three files, one main file and two sub files (company A, company . The two sub files contain company name and position lists for each. In the main file I want to do the following: if I choose company A from a pop-up menu then I want to see the position list of that company, otherwise if I choose company B, I want to see the postion list of that company. How can I do this...any ideas? If this seems unclear, then go to "www.cars.com". What I want to do is similar. If you choose Chevrolet in the "Make" pop-up menu, then you get only the Chevrolet models in the "Model" Pop-up menu. If you choose "BMW", you only get BMW models in the "Model" pop-up list.
-
- 1 reply
- 989 views
-
-
Reports much slower on some computers of similar specs. 3 level sort is 5 times as fast on a slower computer. What could cause this, a badly fragmented disk?
-
- 0 replies
- 852 views
-
-
I have three files, one main file and two sub files (company A, company . The two sub files contain company name and position lists for each. In the main file I want to do the following: if I choose company A from a pop-up menu then I want to see the position list of that company, otherwise if I choose company B, I want to see the postion list of that company. How can I do this...any ideas? If this seems unclear, then go to "www.cars.com". What I want to do is similar. If you choose Chevrolet in the "Make" pop-up menu, then you get only the Chevrolet models in the "Model" Pop-up menu. If you choose "BMW", you only get BMW models in the "Model" pop-up list.
-
- 1 reply
- 984 views
-
-
Hi, Is it possible to have a page in a layout that always displays as the last page in the printed report. A map for example. Or NB phone numbers. I tried using Trailing Grand Total but you can't seem to go over the page borders. The info I need to put in is more than one page long. Thanks
-
- 2 replies
- 943 views
-
-
Help, I have to retrofit an old application that has an invoice layout. In it, I have the master information, that I can load into variables no problem. But when I go to the portal, and try and set the variable data, it keeps using the first records data, even though I use a "select" option with the "Go to Portal Row [select; No dialog; $CurrentPortalRowNum + 1]. $CurrentPortalRowNum is set at the beginning of the loop. I know I'm on the correct portal row because in the debugger, the select highlights it properly. Further, using the data viewer, the $CurrentPortalRowNum is incrementing as required. I use the Go to Portal with a calculated number because the "…
-
- 2 replies
- 1.1k views
-
-
Hello, is there a script out there that would delete more than one portal row at a time? i.e. if someone checks the box "delete" for a particular row(s) it would delete all of those portal rows at once, instead of it having being done one at a time as it is now.
-
- 1 reply
- 1.7k views
-
-
Hi I am creating an invoice with a repeating field. How do I insert a "next page" into a multi page invoice. I tried putting text in the footer but it puts "next page" on all of the pages.
-
- 5 replies
- 1.2k views
-
-
I am trying to create a report that has the fields from a record from one database and then selected fields from another database in the body. Actually in the header, I am describing a situation and in the body the individuals from another database to document their responses to the situation that is listed in the header. The two files are not related. Bottom line, I want to document the situation with a description, date, etc. and then print a listing of the situation and a list of the individuals with phone numbers, etc. so I can call them apprise them of the situation. So far I haven't figured out how to do this. Anyone have any ideas?
-
- 2 replies
- 904 views
-
-
This would solve a problem I'm having with a layout the customer wants to see. I have a "ticket" layout which shows a number of child records (pages) for each ticket record. There are about 3 portals with exactly the same table occurrence relationship each on a different tab of a tab object. My customers use fmp 8 so no object naming. I am trying to find a more effective way to have portals show the correct page without the risk of one showing page 3 whilst the other is still showing page 1. I have scriped nav buttons which essentially go to a field on each tab and then move to the portal row number which works, but looks "clunky" especially on slower computers. …
-
- 2 replies
- 1.4k views
-
-
I am using tables to create my value list. When I put in a new value in the list in a particular order. When I pull down the list it sorted the list and takes them out of order. I then added a field to group them in a particular order but it will show in the pull down if I sort them by the group. Is there a work around. Thanks in advance.
-
- 15 replies
- 1.7k views
-
-
I'm trying to add a summary or sub-summary (not sure which is appropriate) to a report. I want the sub summary to show a count of different items selected in a drop down list box. What I've tried to do is create a summary field of the drop down list which is a "count of" the field I want to summarize. Then place that summary field in the sub summary layout part. But when I view the report it's just giving me a count of all records in the found set instead of showing me the breakdown. For example the field I want to summarize has 5 statuses "sold", "lost", "bidding" and so on ... On the report I want to see: Sold: ## Records Lost: ## Records Biddi…
-
- 0 replies
- 943 views
-
-
Hi, I want to have a screen where a user sees two lists of clients, one list is called "include" and the other "exclude". Each client record has a field called include, which is set to 1 or 0. The parent record contains a two global number fields, equalling 1 and 0. These drive the portal relationship. (I know you can do with just one global field and have equal or not equal... but I did it this way for clarity). Clicking a button on either portal switches the value of the include field. I want to have the record jump from one portal to the other as soon as the button is clicked. Currently I can't do this without manually clicking on the background of the paren…
-
- 2 replies
- 2.3k views
-
-
I have 3 fields that contain Name, phone, fax; each field has 6 iterations. Field 1 is a drop down list to allow selection of name. I am trying to get fields 2 & 3 to follow the drop down list for the correct phone and fax no to the invoice. I have just about tried everything to get it to work. Any ideas? TIA
-
- 1 reply
- 1.2k views
-
-
I have a DB that i have selected a font size of 10 for the fields When i add a new field, i choose the same font, the same size, but it appears so much smaller? I need to change it to size 18 to get it to look like my other previously made fields. Obviously this affects my layout and the field size.. Any help? THanks!
-
- 5 replies
- 1.6k views
-
-
Hi, I have developed a solution on a Mac and it is accessed by both Mac and windows versions of FMP. When moving from one file to another file (ie windows) it works fine on the Mac, however, on windows the newly opened file tends to open within the existing file/window and not full screen as scripted. This is driving my crazy. Is there something obvious that I am missing, or do I have to add the full screen script step into every navigational script to get it to look like the Mac does? Please any help will do....
-
- 3 replies
- 3k views
-
-
I'm wondering if it is possible to execute a script in FM9a after a link is pressed in the web viewer? On the same note, is it possible to execute a JavaScript command in the web viewer without user interaction? In this case it is a search button that needs to be pressed. I prefer to do these tasks without a plug-in, but will resort to one in required. Any help is much appreciated, thanks!
-
- 1 reply
- 1.4k views
-
-
hi, Can I set dimensions of a layout or of the workspace to a certain desktop resolution e.g. 800x600, 1024x768? Cheers, Dan :)
-
- 5 replies
- 1.5k views
-
-
Is it the way in fp9 to create every second row in portal to be in different color using conditional formating? Don�t like to use Alternate background fill because portal is filtered and have different number of rows from record to record. Thanks Zagino
-
- 4 replies
- 1.6k views
-
-
I am sure there is a way, but searching has not produced the answer. : How does one resize columns in the "define database" dialogue box, - tables, fields, relationships- so that the resize (stretching, or whatever it is called) 'sticks' and is used the next time I open the define database dialogue box?
-
- 2 replies
- 1.6k views
-
-
I have a FM relational database program I developed over the last year to summarize and report on company activity. We are a small railroad and I use this to update our records on a daily basis with car movement and revenue data. The program has been working very well for over a year. However, all of a sudden the data import performance has markedly slowed during the daily data import. What used to take about 90 seconds now takes almost 5 minutes. During the import process I can see the record count "slider" on the left incrementing one by one as it moves through the records. It never used to do that. It seemed to occur when the number of records in the "cars" …
-
- 7 replies
- 1.9k views
-
-
I am a novice trying to get on my feet. I would like to build a history db for screen only with a list of events on the right (two fields: year and fact). No brain killer... On the left, however, when an event is clicked on the right, I would like that a description of the chosen fact appear like a large note. I could do this, one above the other: the fact description in the header and the list of events in the body. But I would prefer a screen presentation, horizontal, with a list on one side and the description (the whole card in fact) on the other side. Is this possible with FileMaker?
-
- 1 reply
- 827 views
-
-
In access I used groups, In FM it appears to be called a leading summary. How do you insers a group/leading summary into an existing report? I have been able to create a report using grouping, this isn't a problem, I can't figure out how to insert groups into an existing report. Thanks Saddle Tramp
-
- 2 replies
- 1k views
-
-
I am trying to design a layout that will involve billing specific companies on a daily basis for a period of a month at a time. I would like to be able to open a specific company record and have all the dates for one month show up on my layout so that I can add to the billing field each day. I do not want to have to create a new record for each specific day. In other words,for example, I would like to see every day in November show up in a record so that I may place a billing amount next to that day, without having to create a totally new record for each day. I could then generate a summary report at the end of the month for each company. Thanks
-
- 0 replies
- 852 views
-
-
I need to create a report that shows by month how many inquiries were received in each month. Not quite sure how to approach this?
-
- 1 reply
- 833 views
-
-
Is there a way to make the cursor bigger in only FMP apps? Sometimes the little thin line is tough to see and I don't want to ask users to change their computer settings.
-
- 0 replies
- 888 views
-
-
I have a Products table (Key - Product ID), a Product Attributes table (Keys - Product ID, Attribute ID) and an Attributes table (Keys - Attribute ID, Attribute Group ID). My first Table Occurence from the Products table to the Attributes table goes via the Product Attribute table. I have created a new Table Occurence using the relationship from Products Field 1 (calculation field - number) to the Attribute Group ID (number field) in the Attributes table in order to get "filtered" records (e.g. those available based on this Table Occurence)and want to attach a value list to Products Field 2 (number field). I have defined the Value List to use values from th…
-
- 11 replies
- 2.2k views
-
-
Hi, I have got customers where each customer can have many divisions and in each divsion customer can have many contacts. I have attached the zip file for the purpose. When the application is run you will be able to see 2 customer records. My problem is when i click on Add New contact it displays the contact layout but in the division drop down it does not show the divisions for that particular customer. Even if i select the Division it does not display the name of the division in the text box. Could anyone can have a look and point me in right direction. I desperately need to get this sorted out. Thanking you in advance. Mitesh Jackie…
-
- 3 replies
- 1.1k views
-
-
I think I'm over thinking things here. So I need help. In tableA that has 2 fields Name, Status In tableB, I have 2 fields. The first field has a value list that shows ALL TableA:Name. I want the 2nd field to show TableA:Name where Status = "Active" How do I do that? Thanks in Advance.
-
- 4 replies
- 1.8k views
-
-
Hello! My boss wants me to create a new form in Filemaker but I’ve never used it before. I have spent the last couple days researching Filemaker but I have not been able to figure it out a solution that does what he wants. I have been able to figure out how relationships and value lists work but not how to populate a new value list from several items in the same field and display each with its own radial button. Let’s say that I have a Table called Cameras. Inside that table I have a field named Stock. That field has all the possible tape stock for that particular camera like: Camera: Sony Blah Stock: Tape1, Tape2, Tape3 Camera: Panasonic Bla…
-
- 2 replies
- 943 views
-
-
I am building a restaurant's reservation system as a VTC 'term project' for our family restaurant. I published 2 posts on this topic in 'relationships' and I will add this one in 'portals' and one in 'layouts'. Basically, I used John Mark Osborne's Calendar tutorial in order to build our 'DAYS' table. Then I created a 'TABLES' table (of the restaurant), a CLIENTS table and a RESERVATIONS table. I was able to create a quick reservation 'list' layout on a daily basis, and also add a calculation field to JMO's monthly calendar portals to show the total reservs count for any given day. Where I fail, is when I try to create a daily 'floor plan', where I would see the…
-
- 4 replies
- 1.6k views
-
-
I'm creating a script that will send an email getting data from a particular record. As the primary user for this uses Thunderbird, I'm doing this with a open url mailto: script. There are a couple instances where I am trying to insert data from a checkbox set, however instead of there being a carriage return at the end of each option, it just runs them together. For example Option1Option2Option3 Instead of Option1 Option2 Option3 It works fine if I use the regular send mail function, but I can't get it working with the open url function. Thanks! Matt
-
- 0 replies
- 945 views
-
-
Can someone explain this procedure to me. I always use lookups. This is the post number Post#268523 I don't understand how the fields are stacked and what scripts are used to make this happen. When you click in the client field to add a new record the field arrow appears and it will not in any attempt I make. I copied and pasted the fields and it still would not do what the client field would do Can someone explain this step by step? Thanks in advance
-
- 5 replies
- 1k views
-
-
Hi to all reading... Well I'm pottering along with my own solution for invoicing and managing my business accounts ok here. I'm wondering if I could have some help with creating an Account Statement Report for my clients, which depending on the client, is either issued monthly or quarterly. The bit I'm stuck on is how to incorporate credits / deposits / overpayments into a running total. On the onset of a contract, I always request a deposit (usually negotiated with the client before commencement, and is not a static figure or percentage), I then work that deposit off! Eventually their account reconciles and they begin paying an hourly rate. So.…
-
- 1 reply
- 1.1k views
-
-
I've got a contacts table and a viewer table. How can I display 2 different records from the contacts table onto the viewer. ie one address for billing and another address for shipping? I've searched and apparently nesting portals won't work. Aside from having exact duplicate contacts tables or copying the field info back and forth what are my options? Thanks.
-
- 9 replies
- 1.6k views
-
-
I have two tables, table A with a one to many relationship to table B. Table B has 3 fields per record that describe the item. One field is "Category", the second field is "SubCategory1" and the third field is "SubCategory2". In a layout for Table A I want to build a series of 3 value lists that drill down to the item in table B and report in a portal. The top level value list would populate with the Category data, the second level value list would then populate with filtered data based on the category data. The third value list would populate with filtered data based on the subcategory1 value and thereby showing me the records in a portal that meet all these criteria…
-
- 7 replies
- 2.8k views
-
-
A search for "contents of portal" or "portal contents" in this forum didn't find anything so I'm hoping someone out there will answer this for me. Is it possible to use a tooltip to display the contents of a portal? I have an event registration db in which the registered participants show up in a portal. Is it possible to have a tooltip on a related layout show the contents of that portal e.g. the persons who have so far registered for an event? Please say yes... Abbe
-
- 4 replies
- 3.4k views
-
-
Its hard to explain without a visual so I included the beginnings of my db. I am working on the LAYOUT 4 I have a food table and the items are put into categories. On the Form, I want to choose 1 item from my category drop down, then only show the food items in that category.... any suggestions or can someone show me how they would do this?
-
- 1 reply
- 1.1k views
-
-
I'm a newbie trying to duplicate a MS Access database. I have a Company layout with the usual fields and at the bottom a row of four tabs (Contact History, Contact Names, Ticklers, Quotes) related to the current Company. I have two portals on the Quotes tab, Quote Header and Quote Detail. One Header field relates to a Company field (both company name) and the Header field Number relates to the Detail field Number. Problem is that all the Detail records for the Company show up in the Detail portal. I want to show only Detail records for the current/active Header record. I don't know how to make that happen -- any help would be greatly appreciated. Loren
-
- 2 replies
- 1.2k views
-
-
Hello, I've created a dependent value list. I've toggled the "include other item" option. When I include a new item it doesn't add itself to the value list. I've tried a dozen things, but can't get it to work. Can somebody help me please? thanks
-
- 4 replies
- 1.8k views
-
-
Hi all I want to extract information from the web viewer. Stock prices to be exact. Following info from previous posts I've used GetLayoutObjectAttribute ("Webviewer" ; "Content") to put the content into a calc field (text). I was hoping to find and extract the numbers I wanted with another calc. like a filter or something. Any suggestions for how to get the 58.29 out of this... ......'>CBA 58.290 and into my field? Thanks, Phil
-
- 4 replies
- 2.1k views
-
-
How does one get the Sub Summary to appear on subsequent pages when the records one particular category spans more than one page?
-
- 4 replies
- 2.8k views
-
-
Any ideas on scrolling the web viewer content from buttons on the layout? I would like to suppress the web viewer scroll bars via CSS, and have layout buttons that perform page-up/page-down on the target viewer. Thanks
-
- 0 replies
- 1.4k views
-
-
I have a problem with a field maintaining the font size. I have a layout (sales) where I input address information, and the fields are all font size 12. On another layout (label), I have fields that are size 10, as I am printing labels. I can't make the label layout keep the font size 10 - most of the time the font size stays at 12. This usually is due to me pasting information into the fields that are font size 12. Is there a way to tell the field to maintain the font size that I want the layout to have? The font issue also happens when I paste information into a field. If I paste Helvetica size 12 into a Verdana size 12, it keeps the Helvetica fon…
-
- 4 replies
- 1.4k views
-
-
Hi, I'm having a problem with graphics shown on a Mac. The solution was converted successfully from Windows-FM6 to Mac-FM8, but the graphics do not display on the Mac. How can you set the 'store compatible graphics' option with Windows-FM8 ? I don't see an option like that when inserting picture. Any help ?
-
- 0 replies
- 873 views
-
-
Is it possible to change the default behavior of the mouse wheel. Rather than changing to the previous/next record I would prefer it to scroll the active portal, window, field etc. In my solution this would be much more useful. This would obviously not apply to you one mouse buttoned people :
-
- 0 replies
- 1k views
-
-
Hello, I am hoping that someone has an idea of what I could do to circumvent this problem: I open a document (excel or word) in the webviewer. If during the same session I want to delete the file, it tells me that the file is locked or in use (even if I am no longer looking at the file, the webviewer has been refreshed with another file or it is blank). If I check in task manager, it shows me that excel is running (it's not in my taskbar). It looks like the file stays "in use" even if I exit FileMaker: the only way I found to unlock the file was to log off or end the Excel process in task manager... I thought that I should write a routine that "flags" …
-
- 0 replies
- 1.4k views
-
-
Hi everyone I wish to get some data back from a URL...The URL is in the form of a "submission string" and I have correctly formatted the query string parameters to bring back data. The returned data only consists of two lines of text in CSV format - the first being a header. The second is 4 very short fields. On a layout I have a web viewer object named wvmileage If i use a "custom url" ("http" etc as above) it does indeed return the text file into the viewer and if I then (in a script) set variable: $temp = GetLayoutObjectAttribute("wvMileage";"content") then $temp correctly returns the content of text file. So far so good. BUT …
-
- 2 replies
- 1.6k views
-
-
Hi, I'm a newbie and just beginning to learn about scripting in FM. I have about 63 fields that I would like to use a value list to pull up, so that we don't need to scroll through them all to find the one we need. Basically, would like one field that contains the value list, and the one next to it would then populate with the field requested. Are there any suggestions?
-
- 20 replies
- 3.1k views
-
-
Hello everybody! I have what I think is a very basic question. 1). The database is to organise my contacts by what "status" they are. 2). It has one table. There is a field called STATUS, which can have one of three values: COLD, WARM, or DEAD. 3). I want to see a screen that looks like this: == COLD John Doe Jane Smith WARM Bill Bloggs == In SQL terms, I'd run two queries (GET_COLD, which would find all records where the status = COLD, and GET_WARM). Then I'd display the output of each one alternately. But I have absolutely no idea how to achieve this in FM. I'm sure it's basic: can anybody help? Sorry if this is a stu…
-
- 1 reply
- 1.1k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online