FileMaker Interface Features
-
can anyone help me with this? i want to use data from a record to be a title on a layout for other data. i hope that makes some sense
-
- 8 replies
- 1.5k views
-
-
I'm not sure that this can be done with conditional formatting, but I couldn't think of what a better approach would be. Basically, I just want to get my fields to show their own names when they're empty, i.e. the First Name field will contain the words "First Name" until you enter something into it. This seems like something pretty basic, I apologize for the newb question if it's answered in the help - as I say, I'm just not sure what to look under. Thanks in advance!
-
- 7 replies
- 2k views
-
-
Hi all, I want users to be able to send written "communications" (e-mails and letters) to contacts within the database. Such communication frequently includes indented/bulleted/numbered text. I have succeeded with HTML emails (using a plug-in) but I want the user to have the choice of sending as a letter (or indeed a plain text e-mail) My problem is how to deal with indented and/or numbered lists At the moment: The "body text" is entered into a field called "body text" When the user wants a list to appear the enter the text "list1" (they can enter up to 10 lists eg by entering list2 list3 etc) The "lists" are entered into an additio…
-
- 1 reply
- 1k views
-
-
I run my application via FileMaker's Instant Web Publishing. When you click on a portal record with a lot of information from within FMP the portal record extends down so you can read the entire field easily. Not so with IWP: portal rows don't extend down if they contain a lot of information. With Internet Explorer I can enter a portal row and can scroll to the far right end of the row in order to read all of the information that that field. With Foxfire that can't be done. You can only read what you see on the screen and you can't scroll. So I want to display the information from a field in the active portal row in a separate large text box with wrapping so that t…
-
- 2 replies
- 1.4k views
-
-
I am creating a timesheet database where employees can input time they spend on each project everyday. I use a portal and each row is actually data from another table called timesheet element. proj. Mon. Tue. Wed. Thur. Fri. Proj. Total A 20 30 20 200 20 350 B 100 100 10 C 200 Day Total Proj. Total is a calculation field in timesheet element. It recalculate every time I click away from a cell so it always shows the updated number of time spent on a specific project, which is what I want. Day total is a summary field from timesheet element and it does not work as I wanted. My questions are; …
-
- 4 replies
- 1.3k views
-
-
When i duplicate a record it will not duplicate a field with a Menu Popup. Is there a way it copies all fields? I failed to mention one of the Popup Menue Fields is a second field value, the first field is a Serial number. T
-
- 12 replies
- 2.6k views
-
-
I'd like to build a value list that is based on fields containing dates. If the date in the field is a date in the future I want it in my value list. If the date is in the past I do not want it in my value list. What are the possible solutions?
-
- 1 reply
- 1.1k views
-
-
Is there a way of hiding buttons in a script? I would like to have a script run that loads a layout and if it finds data, the create new timecard button would be hidden. If it doesn't find data, it is shown? JL
-
- 2 replies
- 1.3k views
-
-
Hi everyone, I posted a similar question earlier, the response I got contained good recommendations but I do not understand most of it, so I thought I would repost. My problem is common, simple to many I'm sure, but try as I may - I couldn't figure it out. I have a drop-down list with values, I want these values to auto-fill at least five fields with various records through look-up. : Main table = "Employees" Field 1 = "OCCCode" (OCCCode is a drop-down list with values) Value List = "OCCCode" Field 2 = "JOB TITLES" (Job Titles contain records) Field 3 = "STATE" (Is another drop down list. I want "STATE" to show related re…
-
- 10 replies
- 2.5k views
-
-
I am probably asking for something that cannot be done, but does anyone how to get a field that is completely void of color? I am attempting to create a drop down list that appears like a number in a box, so that the user knows which order to choose the items in. I know that I can simply put them side by side, but it would work and look better one on top of the other. Thanks.
-
- 2 replies
- 1.2k views
-
-
Hi all, Our student database has 7 digit student numbers. The first two digits represent the year eg. In the number 9876555, 98 represents the year 1998. In the number 0129292, 01 represents the year 2001. Now I need to include the 19 or 20 (ie the full year) to these existing numbers so that: 9876555 becomes 199876555 0129292 becomes 200129292 How do I do this?
-
- 4 replies
- 1.6k views
-
-
I have been running some spellchecks on my largest database. Since it is quite specialised I have added many words to the User Dictionary. Today I am trying to add words in the usual way by pressing the 'Learn' button in the spellcheck dialog box and I'm getting a "Cannot add word to User Dictionary" error box. Is it full? Can it be increased? Is there something else I should be doing? Many thanks in advance
-
- 2 replies
- 1.7k views
-
-
[color:brown]Set variable [ $Portalrow; Value:Get( PortalRowNumber )] Go To related record[ bla, bla Go to Portal Row[select; $Portalrow ] Seems straight forward. My logic: Where was I?, change to different record, move to the row in the portal where all this started of. Doesn´t work as expected! Does work if I leave out the step [color:brown]Go To related record[ bla, bla. The variable contains the correct value (i.e. 34) but the [color:brown]Go To related record[ bla, bla seems to reset the rowcount to 1. So I get an error since I am trying to reach a row > 1. Any ideas?
-
- 15 replies
- 2.1k views
-
-
Hi folks. I'm stumped, and could use your help. Sorry if it's a dumb question, but... how can I make scripts and calculations use the various separate lines of data in a checkbox field? I've got 3 big Filemaker books, and none of them address how you can actually separate out the data from checkbox fields so you can use it. (maybe because it's so obvious, and I'm just missing it). Here's the context: I have patients, about whom I have to write reports. I have to write back to the doctor who referred the patient to me, and also send copies to other doctors who are involved in the patient's care. When composing the report, it seems an ideal situation to…
-
- 10 replies
- 9.7k views
-
-
Webviewer screenshot not WYSIWYG? Filemaker 9 prints the layout as viewed in the server but when viewed over the web the screenshot graphics and text are larger than the original and loose a lot in the translation. The layout doesn't fit the page when viewed on the web and unintended text wraps (etc) occur. Any useful suggestions?
-
- 0 replies
- 1.4k views
-
-
I'm trying to simply copy a field's entry to the clipboard. I've tried a bunch of different ways, but none of them work because the field who's contents I want to copy are not displayed on my layout! I've got a calculation field set up which calculates a filename (to be pasted by the user) based on the entries in two name fields and an ID field. This calculated field does not show on my layout. The calculation works fine - the entry it's calculating is correct. I've set up a simple script to copy the contents of this field, but it only works if that field is showing on the layout. If the field isn't showing, what it copies is really odd - it appears that it's copying…
-
- 7 replies
- 1.8k views
-
-
I have a database that shows a portal on an encounter that lists all the medications a person is taking. It is linked through a join table to the visit table and the visit table is set by the date seen. Is there a way to show the portal and data associated with it of a previous date for the same person on the date of their current visit. When I create new file for a new date then the join information is no longer visible. Most often patient medicines remain the same so seeing the previous list will allow me to know what they're taking and also set up a simple Portal Dupe to transfer last visits med list to the new visit.
-
- 4 replies
- 1.6k views
-
-
here is an odd one I have a list of items in a portal. I have a num field on the main layout I would like a conditional format calculation to highlight the number of rows (top down) based on the value in a number field.
-
- 1 reply
- 1.7k views
-
-
I guess I should have been clearer in my last posting. I have a field named "OCC Title" this contains the job position titles. "OCC Title" is a drop-down list, with values from a record that I imported from excel. I have another field named "OCC Code", this is the field for Occupational Codes. Then I have these fields called "States", "Average Salary", "Entry Salary", and "Maximum Salary". What I wish to happen is this: 1) I wish to see the "OCC Codes" automatically filled every time a value within the drop-down field "OCC Title" is selected. 2) I wish to see the fields "Average Salary", "Entry Salary", and "Maximum Salary" auto…
-
- 2 replies
- 1.4k views
-
-
Hey guys just wondering if you could help me out, i am trying to identify relationships between three tables; the relationships can either be 1-1, 1- ∞, or ∞-∞ I have identified the primary keys as well but am not sure they are correct, the only relationships i think exist are between years of experience in the pay info table with years of experience in the staff info table, along with scheduled week in the staff info table with week # in the scheduled table please look at the tables in the attachment and help me out!? thanks! tables.pdf
-
- 1 reply
- 1.1k views
-
-
Ok 2 files, acq.fp7 and photo.fp7. I built a relationship serial = serial for each file. Now when the serials match, the image should show up in the portal...right...not so. I get nothing. other portals work just fine, except this one. Any advice? (click the upper left corner of acq and password is blank, Admin is user)to get filemaker menu's MIADS.zip
-
- 4 replies
- 1.3k views
-
-
Portals only show up in the vertical position, but is there a way to make them show in the horizontal for a slide show of images?
-
- 3 replies
- 1.4k views
-
-
Greetings, I have a table with a number of fields, some with text calculations that can be appended with user input. If the user cuts and pastes from, oh let's say a webpage with a different font, the new font and it's size are pasted in the field. Is there a way to automatically conform all input to the font set in the field? Thanks for any help.
-
- 4 replies
- 1.7k views
-
-
I have a webviewer that points to a specific folder on my local drive for each record. Those folders in turn contain subfolders with various PDF files in them - once I went to one of the subfolders, I cannot 'browse' back, since the right click does not give me the 'back' option. Is there a way to maneuver around in a folder structure?
-
- 2 replies
- 1.5k views
-
-
Newb question here. I have a solution that uses multiple layouts that are printed - That single page print out is the end result, and it is all the user requires. Works OK. One problem I have is that sometimes the data in a field is too long, cutting off part of the data for that line (each line is essentially its own field). I could reduce the font size on all layouts, but that is not desired when the data is shorter. I would like to be able to allow the user to reduce the font size - or change the font entirely - for that one field if necessary. I am not opposed to adding scripts and buttons to accomplish this, but am clueless where to start. Any ideas? …
-
- 1 reply
- 1.1k views
-
-
I have three panels, each displays a portal, each sorted differently. A script moves to another layout, performs a calc, and returns to the tab panel. Using object name, I can get it to return to the correct panel. But each time it rescrolls to the top of the portal, even though I store the portal row and use go to portal row on return If I do not use go to object name, it goes to the default panel and to the correct portal row. What I want is for the user to return to the panel and row that he starts from. What am I doing wrong?
-
- 1 reply
- 1.8k views
-
-
I am really confused over a certain aspect of Value Lists!! I have a field that contains a value list of customer company names and a field that contains a value list of supplier company names. I want to be able to perform a search for all companies whether supplier or customer so I wanted to combine both lists so when a user did a search a drop down list would appear showing all companies. This looks simple enough as in the 'Specify Fields for Value List' window you can 'Use values from first field' and 'Also display values from second field', yet when I select the second field option only the values from the first field are shown! Even the description at the top of the …
-
- 14 replies
- 2k views
-
-
Hi All Looking for some newbie help here. I'm trying to figure out how to deal with "nested" data... That probably didn't make sense because I have yet to see the term 'nested' used in databasing, so I'll try to explain... I'll put this example out there: in a table for cars, I've got a field called "car maker" (can you see where this is going?) So attributes of a field for car maker would be Chevy, Ford, Honda But under each make are several models: Chevy -silverado -lumina -cavalier Ford -Focus -Crown Vic Honda -Accord -Element etc etc.... So I can see how this would be set up in the table - a field for make, another field for …
-
- 2 replies
- 2.2k views
-
-
Is it possible to get FileMaker to pop up a file selection window when a user clicks on a layout field? In other words, operate in the same manner FileMaker uses when prompting for an export destination file. (see attached diagram) The field I have is not connected with any scripted process. It's purpose is to provide text for a report. Now, the user is having to type into the field and typos are difficult to notice. It would be much easier to click on a selection. Any help will be appreciated.
-
- 2 replies
- 1.7k views
-
-
Ok, so I'm a noob at FileMaker Pro 9, but my company has asked me to set up a client db with it. I've come a long way, but now I can't figure out how to make a field type that I need. Here's what I'm needing: I'm looking for a field that can hold: 1. Dates 2. Notes that correspond with the dates 3. A scroll bar that will show me all the dates/notes that belong together. Dates should be to the left, notes to the right. I need clear lines between each individual date/note, as it would confuse coworkers otherwise. I've purchased a book, looked through fm.com's forums, and not found a way to do this field type yet. Anyone able to help me? Thanks!
-
- 17 replies
- 1.9k views
-
-
I am creating a music cataloging database and I'm trying to copy data into a portaled field if there is data in another field. I would like to do this without a script, but I am am not having any success. I've attached the file to this post. Thanks in advance for your help! Sam Music_Collection_Test_Solution.fp7.zip
-
- 13 replies
- 2.1k views
-
-
Hi all need a small push in the correct direction. I have a simple data base to track my trucks. Date : Ticket # : Material : Supplier : Source : Pit : Tonne : Unit : Truck Co : Truck # : Customer : Contract Nov21.001..........A.............Abc...........There.....1......20.........ton.......xxx............25............Him...........Hers Each line below my headers is a record, all records can be found and sorted by any of the above fields single or multiple criteria. I also have a date range find script with my 2 date input fields set to global. My first report works well, find the data in the above layout, got to report 1 layout sort and print. Repor…
-
- 0 replies
- 1.4k views
-
-
I have a simple data entry form made up of edit boses, drop downs and pop ups depending on the source data. My issue is that whilst I can tab between edit boxes and drop down menus, when I enter the pop up menus it doesn't seem to take the focus. I therefore have to revert to my mouse to select an item from the list. Any ideas?
-
- 3 replies
- 1.2k views
-
-
I have what I guess is a fairly simple issue. I am a recent convert to Filemaker having used MS Access in the past. What I am stuck with is how to filter records. I have a list of transactions and a calculated field which works out which month they were conducted in. In access I would have set up a drop down menu which would populate from that months field. I would then have a button which would take the value selected from that and return the found records. In filemaker I don’t seem to be able to set up a drop down (or pop up) menu like this. As soon as I try to select a value from the month field, it tells me that I cant change the value since its a calculated…
-
- 4 replies
- 1k views
-
-
Is it possible to highlight the active row in list view using conditional formatting? Thanks! James www.james-mc.com
-
- 41 replies
- 14.7k views
-
-
Hi, I'm creating labels. I have 3 text fields : prefix base suffix I have a calculation field with text as a result that goes like this: prefix & " - " & base & " - " & suffix I want the result to be : prefix - base - suffix So I used the conditional format : value comprised between - and - but I do not obtain the desired result. Any suggestions? Thanks PS this is a liberal translation of the Filemaker commands as my software is french. If you need further explainations, please let me know.
-
- 9 replies
- 2.2k views
-
-
Hey everyone. I put a filtered portal on a layout; in the global filter field the user can key in his search term and gets a list of appropriate records. Works great. Two questions: 1. I’d like to make it possible for the user to show all records. The only thing I can imagine at the moment is to put a separate button next to the filter field attached to a script like „show records from the not filtered table“ (= the one that is the basis for the self-join). 2. To make it possible for a user to key in just the first few letters of a record’s title (truncated, like in find mode), I set up my relational key to the filter field like Left ( Title ; 1 ) &…
-
- 2 replies
- 5.7k views
-
-
I am trying to develop a value list to populate a drop down menu that would incorporate a list of layouts or field names in the current file. The purpose is to map data out of a table that was generated from a raw import. First I would like to have the user select which layout shows the imported data, and then map a few of the key fields in that layout to the permanent data structure of the solution. Then the import will be processed by some scripts. So I need one dropdown (value list) where the user makes an initial layout selection, and a second value list that populates dropdowns using the value selected for the target layout in the first dropdown. I th…
-
- 1 reply
- 1.3k views
-
-
Hey, I put a drop-down value list on my layout, showing only the values of the second field. (The first field with its ugly the serial number I want to hide.) Unfortunately, in the actual field where the chosen value is I have the first value only, the description only shows up in the list. Does anybody know how to make the second value appear in the field? Furthermore: Is there a good way to have a drop-down list and avoid at the same time that the user can enter own values? Thanks, : Mike
-
- 2 replies
- 2.1k views
-
-
This is my first attempt at learning filemaker. I am enjoying its features, but have ventured upon some difficulty. I have ten fields with drop down lists that have the same value lists: Admit, Deny, Unknown. Sometimes the fields are not used in the document, so the way I currently have it set up is that you do not select any thing for the field if you do not intend to use it. In the layout mode for the document I am attempting to automoate. I inserted merge fields for all of the ten field in descending order down the page. After the ten fields, I have more information that I would like to type. The problem that I am running into is that if I do not se…
-
- 6 replies
- 1.6k views
-
-
Hi everyone, I wasn't sure where to post this but here goes. I have a solution that has a job table and a Job line item table and a unit table. I have a portal for the line item table on the job screen. when I enter a unit code, it populates the description, price and unit of measure from the unit table based on lookups. That works fine, but I also need it to populate a region field based on a lookup from the job file. It does not populate on the first line just every line after that. I assume it has something to do with the relationship not being committed in time to look up the first line but I am not sure. Is there a way to insure that this will o…
-
- 6 replies
- 1.6k views
-
-
Hi, I have been using filemaker for a few weeks and I see the potential it has. I have been working on a project that includes massive data collection. As a end product, I would like to display data in a certain format grouped by two fields. The report also has sub-summaries for each grouping and a Grad Summary. I could manage to display the reports in the software, but when I try the same through a web browser, it only shows one record, which, when changed to a list view shows more records but only for one category withing the group. Is there a trick to generate and display records through a web browser and if possible be able to save them as a PDF? Would appreciate…
-
- 2 replies
- 1.4k views
-
-
Hi All, I'm a newbie and will be the first to admit I know nothing! I've got a letter to INSTRUCTORS in which I have information about all STUDENT workers working for each instructor for a particular semester. I finally figured out that I could use a sub-summary to list all the students and their info in the letter and put the closing of the letter in a Grand Trailing Part. However, there is a gap between the info in the Sub-Summary and Grand Trailing. I tried the sliding thing, but it only works with fields and not PARTS. Is there a way to shrink the PART area? Thanks for your help Amy
-
- 8 replies
- 1.3k views
-
-
Hi, I have a question about multiple fields in a record/Layout. I have one layout that consists of 200 records. In those records i have about 50 fields. Now i want to make a layout which searches for typical entries in those fields and put them in another field. How do i do this?? grtz
-
- 2 replies
- 1k views
-
-
Hi all, not sure if I am in the correct forum or not to ask a few questions about building a report. Can someone point me to the correct sub, thank you. Sean
-
- 2 replies
- 941 views
-
-
Firstly, apologies if this has been asked before. I’ve searched but it’s difficult to know what to search under! I have a basic question about layouts. I have a number of fields that require a Boolean answer. I have set them up as Numbers and to format as Boolean. However, I cannot work out the best way to allow the user to enter a Boolean value. At present I have a simple edit box where they enter 0 or 1 (hardly user friendly!) I have tried a popup or radio buttons using a value list (Yes/No) but can’t see how I can get it to translate that response to a 0,1 result. It seems to translate everything from ther as not 1 (or false). I guess one approach is to …
-
- 3 replies
- 1.1k views
-
-
Have an issue where I have a portal on a tab. I have alternating colors active. When you go to enter in a field in the portal the field changes to the background color of the layout. If you change the field so it doesn't show through, it stays white all the time and the alternate color does not show up. I even tried putting a white square or box behind the tab which didn't help. Any ideas?
-
- 1 reply
- 2.1k views
-
-
I have multiple portals in a single layout. The script step "Go To Portal Row [Last]" doesn't work. It seems like the script doesn't know which portal to target, so it just targets the first one it comes to. Is there a way to get that script step to act on the correct portal in FMP Advanced 8?
-
- 7 replies
- 1.6k views
-
-
I'm having a problem. I access some of my applications via my fm server. When they open I always get a minimized screen rather than a full screen. Can't seem to find the setting to avoid that. Any help? Mike
-
- 2 replies
- 1.5k views
-
-
Hi, I am new on FM and I have accomplish in setting up a layout but I haven't manage to activate the Web Link and Inserting a picture for each contact. All my contacts has website, is there a way to just click on it and get connected right away? Inserting the picture I have done to the layout itself but when viewing it shows on all my contacts. I want to be able to put a picture on each of my contacts. Is that possible? thanks
-
- 1 reply
- 1.1k views
-
-
We have a timecard invoice that *almost* correctly summarizes the total hours against multiple hourly billable rates ($/hrs). Explanation: / Say there are two billable rates, a = a $/hr. and b = b $/hr., and the data input is a chronological listing of six entries with those two billable rates: a, b, a, a, b, & b. / The invoice that is presently created summarizes the six entries like this: a, b, 2a, & 2b / What we want is the invoice to summarize it as 3a & 3b. The "a, b, 2a, & 2b" currently appears on our invoice in the Part, "Sub-summary by billable rate/hour (Trailing)" with the following Merge fields and text in the layout: "…
-
- 13 replies
- 1.9k views
-
-
I cannot believe I cannot find it.... where do I specify the text that is displayed on the windows title bar?
-
- 3 replies
- 1.3k views
-
-
Is there a way in FMP 8.5, or plug-in's that anyone knows of to make the fields change color when the mouse rolls-over the specific field. I would like the simple effect of a yellow or pink color.
-
- 1 reply
- 1.7k views
-
-
Hello guys, is there a way to use an image as a button? I mean I would like to trigger a script once a image is clicked. Thanks and have a good 1! Sig
-
- 2 replies
- 3k views
-
-
Need some help. Setup: Welcome_page::State_Name x States_page::State_Name I have a portal on the welcome page that list or counts all of the records in the database for each state. The relationship between the two tables is not (equals but Does not Equal) This way it shows all the states not just one state. California 10 New York 9 Etc... This works Perfect... THE PROBLEM: I would like to make this portal list only the records through a certain time period (a range of dates). For all States. This would be Easy if the date I wanted to sort was on the States table but it is not it is on a different table not associated wit…
-
- 19 replies
- 2.1k views
-
-
Not too sure where the best forum is for this, so I'll put it in here. What I want to achieve is a virtual directory listing of everything in on a hard drive that is browsable in a fairly good looking interface. Currently we archive lots of projects on to hard drives and put them in storage, and from time to time we need to find things on them, so at the moment we have a filemaker database of the top level directory listing of each drive in a simple text box and then various other fields with information about what is on each drive. So the step up from this seems to me to be a complete virtual directory listing of each drive, I'm not sure whether this is be…
-
- 1 reply
- 991 views
-
-
I'm new to the group and FMPro so thank you for taking the time to be helpful. I have a table of actions that our staff do day in/out. I'd like that table, which has no relationship to any other table, on a layout so we can scroll through it and then when we see the action we need, click on it and it'll insert itself into a large note field. Currently the portal doesn't show any records. I know this must be so "elementary my dear Watson". Thanks, W
-
- 2 replies
- 974 views
-
-
I am trying to check a checkbox in a value list for a found set, but can't find an automated way to do it. Anyone able to help me? or do you need more information? thanks
-
- 6 replies
- 1.2k views
-
-
:o I copied a Layout that had a ton of client fields on it, then deleted everything I didn't need for the new task. Visually, It looks like I need it - just the handful of target fields. However, When I go to EXPORT RECORDS or Save Records as Excel, it looks like it still thinks it has the original's entire field set, plus 'copies' of some of the fields. For example: Running EXPORT RECORDS, The 'Specify Field Order for Export" dialog lists the correct Current Layout name (It should have about 20 fields). It shows the entire field set from the original. When the output dumps out, I am getting duplicates of certain fields and the displays as [color…
-
- 1 reply
- 844 views
-
-
I recently started using FileMaker to organize my notes. I've created a customized form that I like a lot. The one thing I can't figure out how to get around is that whenever I bring in text from other parts of my computer, I have to adjust the font and size individually. I would love to create a button so that I could select the new text in the form, click the button once, and have it all uniform in terms of size and font. Is this possible? Help please!
-
- 4 replies
- 907 views
-
-
Hi! I have a table consisting of steps to perform service functions (Step1, Step2, Step3, Description, Expected Result). For many entries, Step1 and Step 2 will not change per record but will by Step3. I am not certain I need to display in groups based solely on Step3 or a combination of Step1|Step2|Step3. I know this can be done in reports, but I need to enter data for each record n these groups, so I would like to see if it can be done in list view. Other than calculating a group ID, is there a better way to go about this? Thanks in advance for your consideration!
-
- 1 reply
- 1.2k views
-
-
I work at a DOE Facility that have 100's of FMP 6 databases. We have a "menu" database that consist of a series of buttons (a button for each database) on several screens. We are in the process of converting to FMP9. I am looking for ideas of a new format of our menu database. The current one has too many buttons and can be confusing to the user. Any input or screenshots would be appreciated.
-
- 11 replies
- 1.6k views
-
-
Hi, Is it possible to have the Active tab display a differenet colour than the inactive tabs? For example, if tab_1 is selected it is blue whereas the inactive tabs are green. When I select tab_2, it becomes blue and tab_1 becomes green? Thanks in advanced, P
-
- 4 replies
- 2.3k views
-
-
Hi All, I'm wondering if someone can help me out here because i just cannot work out how you would go about doing this... let me explian. I have 3 tables in a database: companies, addresses, contacts. So one company can have many contacts and addresses. What i am trying to do is i have created a drop down box on my contact where i can select what address ID that contact is at... and what i want to be able to do is display the rest of the address details for that address ID but i just cannot work it out. Any advice is welcome. Thanks in advance, ieuuk
-
- 5 replies
- 1.5k views
-
-
I am creating a simple invoicing system in which the contact_fk is a drop-down menu of a value list created from the related contact table. In the contact table I have radio buttons that say "Yes" or "No" regarding if the contact is a customer or not. I have also included two calculations, the first being If ( CustList = "Yes"; ContactSerNum_pk; "" ) and the second being If ( CustList = "Yes"; Customer; ""). These are the two fields I want to use for my value list in the invoicing system. Here is my problem. What I WANT is a value list with the contactSerNum_pk as the first field and the Customer as the second field, sorted by Customer. For some reason FileMaker…
-
- 3 replies
- 1.2k views
-
-
Hey gang: Back to see if anyone can offer suggestions. I am trying to develop a report from my database. What I am looking to do is have a report available for admin that will sort on each employee and then total (show) the number of cases that they have assigned to them. I have this semi done in a columnar list/report which will list the employee and then under them list the case (and other information I would like in a report.) I am at a lose on how to get a total field for the cases (for each employee) Thank you for any help Opieos
-
- 1 reply
- 1.3k views
-
-
Having a Web Viewer with a static or calulated url displaying just a graphic (.jpg, .gif etc), like this (check this) (). What is the simplest way to make a script that does a copy (to clipboard or otherwise), thereby making pasting into a container field possible? *The doonesbury graphic is of course just an example.
-
- 2 replies
- 1.5k views
-
-
I've found that I can have local and global variables in FM. Local variables are visible and valid within a certain script. Global variables are visible and valid within a certain database (file). Questions: What about multi-user access? What about multi-database applications? Has every logged in user his own copy of a script and the local variables within this script and their respective current values? Has every logged in user his own copy of a set of global variables and their current values set initially or by the user? Is there a way to get from a database currently open and used the values stored in the global variables of anothe…
-
- 3 replies
- 1.3k views
-
-
I am working on an Enrollment Database and I want to ensure that a student is not assigned a class that is not for his/her grade. To avoid entry errors I have a check box field in the Classes Table (06. 07. 08. 09. 10. 11. 12) of the database which the administrator checks when setting up the database. In the Students Table of the database there is a field with the student's grade e.g. 09 In the classes + students join table I would like a calculation field that reads the students grade and compares it to the check box field and returns either "OK" if the student is in the correct grade for the class and "Wrong Grade" if the student is in grade 9 but the class …
-
- 2 replies
- 1.5k views
-
-
I have a value list that should get all records from 3 tables. I could do it with 2 if I have a value list lookup and choose first and second field. But what if I need a third? How can I list a field from 3 different fields and show it in one value list? I tried to create a calculation field and added: add_materials::add_name & eo_materials::eo_name & oil_materials:il_name that should list all 3 tabels name fields in one calculation. The problem is that it wont work because it cannot index the field. So how can I list all 3 tables name fields in one value list? Thanks
-
- 2 replies
- 1.2k views
-
-
Hi FM experts! I'm putting together a small project tracking system. I'd like the user to be able to mark any field with a little "red flag" icon, to indicate an area of risk or uncertainty. Is this possible in FM? Thanks, Frosty.
-
- 13 replies
- 3.4k views
-
-
The URL is translated in the Web Viewer to and does not work in the Web Viewer. How can I escape the pipe character [color:red]| not to be exchanged to [color:red]%7T? Thank you in advance. Ralph Nusser Sogetes Computer-Services http://www.sogetes.com Web_Viewer_Pipe_Character.zip
-
- 1 reply
- 1.7k views
-
-
I have an invoice table, with a record number on it. Whenever I export the record as a PDF to email it, the record number shows as "1". So even though the record # shows as 8 or 9 or whatever in the record in FM, the PDF always shows 1. Is there a way to fix this? Also, is there a way to make my record number have 4 digits, and start at 1000 or something. I just started a new business and I don't want someone knowing that they're only my 10th customer. Maybe for some businesses this would be cool, but I'm only 22 years old and it highlights my inexperience. I created the record number symbol by going to the Insert menu, and selecting Insert Record Symbol I …
-
- 5 replies
- 1.5k views
-
-
I am new to FM having come from DBase way, way back. I have constructed an FM database which, among other things has a numerical field which collects amounts of payments and an other field driven from a value list which indicates whether the payment was made by cash, cheque or credit card. Currently, the report totals all payment irrespective of type. I want to add some more fields on the report which break down the payment totals into Cash, Cheque or credit card. Something like sum for type = "cash" but I can't seem to find how to do it. I am sure there is a way - it would have been easy in Dbase. Any help to a newbie would be most appreciated. Many thanks, P…
-
- 4 replies
- 1.5k views
-
-
Was just wondering if anyone knew if there was a way to get your layouts to automatically resize based on the size of the window so that the edges of my layout won't be seen on various size layouts. I saw a runtime solution do this and was wondering if it was possible in FM.
-
- 2 replies
- 1.1k views
-
-
Hello all! I'm developing a simple solution for my office and I need help in one thing. I'm making a portal that will display the tasks for all employees. This task portal is filtered by employee name and task status through two drop down menus. I need to be able to create a report with this data. I must be able to select the employee, the task status and print a report. But I can't figure out how to create a found set of this records, based on the data displayed in the portal. Is there a way to do that? I'm newbie on scripts. Thanks in advance.
-
- 3 replies
- 1.2k views
-
-
I'm working with a layout that has a large text field. Users on occasion apply formatting to the text in this field, for example, setting the font weight to bold for a heading. On some computers, this looks great, but others show the font as fuzzy. The font being used is Time New Roman and the Bold checkbox is on in the Format>Text dialog box. On a Mac Book Pro and a Mac Pro, it looks good, but on another Mac Pro, an iMac and a Mac mini, the bold text looks fuzzy. This is true of all of the bold text on the layout, including the bold field labels in Arial. So far I've been unable to find the commonality between the systems that look good and those that don't.…
-
- 3 replies
- 1.7k views
-
-
A person looks at a layout of a solution I built. He/she mistakenly edits a field (w/o knowing they'd done it) and then move on to another record or layout. That change is permanent. Has anyone worked up a solution to make changes to any field require user approval? Such as a pop-up box "You've made changes to this record, click yes to save, no to revert". It feels like there's a way to do it, but I'm not sure of the logic that would go into it. Thanks in advance for any help! - Michael
-
- 2 replies
- 981 views
-
-
Hey guys, I have yet another query I can't get my head around. I have searcheda bout, read some material and followed the calendar tutorials online for filemaker, but nothing quite seems to suite this application. Essentially, I need to create a visual map for all the employees of a company (approximately 15) whereby it shows dates across the top, employees down the side (like a grid) and each individual day for each individual employee can be changed:i.e. to represent where he is in the country on that day. I have tried several methods but ended up with ridiculous strategies like having 31 fields, numerous scripts etc etc. all suggestions, references …
-
- 1 reply
- 1.2k views
-
-
How would I do a calculation in conditional formatting the would say "turn the text red if it is before today's date." I am getting suck on the date part. How would I specify a changing date like that?
-
- 5 replies
- 1.6k views
-
-
Hi Really stuggling with this, please help! I have 3 tables BASE SECTOR SELECTION Within BASE I have fields Code Sector (selectecd from a value list based on all records in SECTOR) Within SECTOR I have fields Sector List (calculated field - lists data from several other fields) Within SELECTION I have fields Code Sector Selection1 Relationships... SELECTION is related to BASE by the code field on both sides This relationship provides the sector field in SELECTION SELECTION is then related to the SECTOR table SELECTION:sector = SECTOR:sector Hope that makes sense so far !! Now what I want to do is with …
-
- 11 replies
- 1.8k views
-
-
I have a students database. I want to be able to show which cubicle they have been assigned to on a graphical representation of the floor plan. Can't figure out how to accomplish this. I have a basic "join" table with 3 fields room, cubicle, and studentName. This is working fine. I can see the student assigned to each cubicle; however, how can I then place this ONE field in each of the cubicles on the floor plan? Could not find a similar solution on here. Seems something someone who have done before. Any help is very much appreciated.
-
- 3 replies
- 1.7k views
-
-
I have a couple of things I am trying to do - I have a feeling they are quite simple but it's foxing me!! The first is: I have sequential job numbering set on one of the fields, I would like this to begin with the year as the first 2 digits, so 08001, 08002 etc. How do I set this so when we get to 09 it automatically starts from 09001 again? The second is: I have allocated time fields which add up in a total box, it does update but only when I click into the total box and out of it again which is a bit annoying - how can I fix this? Thanks in advance if you can point me in the right direction...
-
- 1 reply
- 1.1k views
-
-
I have a employee table that has a termination date field. I want to create a value list that only shows the employees with a blank termination date. Any help will be appreciated.
-
- 9 replies
- 3.2k views
-
-
Ok I know this has been asked before but I need some extra help I think. My Setup Broker_Table: Broker_Co Questionnaire_Complete (Check Box) Etc... Policies_Table: Broker_Co Etc.. Relationship: Policies::Broker_Co = Broker::Broker_Co There is a pull down menu on the policies page which has a value list that get info from the broker table. What I need it to do is only draw broker names who have a completed box checked... How can I do a conditional value list that only shows completed checked brokers. Thank you, Joseph
-
- 0 replies
- 1.1k views
-
-
So, I've got a Shipping Company dropdown, it holds information like UPS, FedEx and DHL. I then have a Shipping Method dropdown, that is filtered based on the Shipping Company selection. My problem is this. When I select a shipping company, and then try to select a shipping method, the shipping method list is either empty or filled with the filtered items from my previous selection. It only updates itself when I click off to the side of the fields so nothing has the focus, and then I bring the focus back to the shipping method field. How do I make it so that the shipping method dropdown is updated automatically so I don't have to click off to the side to update …
-
- 1 reply
- 1.1k views
-
-
Anyone know why Self() can be used in a Conditional Formatting calc on a text box, but not a button parameter?
-
- 4 replies
- 1.2k views
-
-
My problem is this: I have 3 fields in my layout. They are set in a table view going down then across. There are 3 columns when viewed or printed. The problem is that the table grid lines only show up in the first column (preview or printed). How can I make the grid lines show and print in the other 2 columns? Thanks
-
- 0 replies
- 1k views
-
-
This is probably very simple, and I'm probably over explaining it here, but I'm drawing a blank. My DB is for copyshop job tickets. I have a radio button set with 6 options for users to select the type of paper they want (plain letter, cardstock letter, plain legal, etc). The copyshop charges a rate for each paper type, but some of the rates are the same for different types - ie colored letter paper is the same rate as plain letter and the same rate as plain legal (.006 cents per sheet). The DB needs to record the paper type and assign the rate in a separate field for the same record. What I'd like to do is have a set of radio buttons to select paper type,…
-
- 3 replies
- 1.3k views
-
-
My situation is this: OBS:I have only filmaker 8.5 so no conditional formating. I need to make a field unchangeable depending on a value of another field. I could make it disapear if i had conditional formating.... So is this possible in Filemaker 8.5???
-
- 3 replies
- 1.5k views
-
-
I really hope this is in the right section. My business currently uses a web-based (our own domain) scheduling calendar that is able to send email reminders to the staff member that works a particular shift. The appointments are entered by one person so the calendar is not interactive. I am a filemake noooob but I was wondering if I could use filemaker for the same job? Am I getting into something I will regret here? I would even be happy to have this "off-line" and just have the calendar posted online for viewing with a script taking care of the email reminders. So what say yee - is this doable without breaking the bank or making me go crazy?
-
- 1 reply
- 1.2k views
-
-
Hello. I'm relatively new to FM, and am in the midst of redesigning a database for a school. It was set up based on names, and I am trying to get it set up around ID Keys instead. One problem that I am having is that, from a data entry point of view, people want to see names. Take, for example, our student agents. Some of our students are referred by agents, and we want to keep track of which student was referred by which agent. Students and Agents are both separate tables. I linked them by creating an Agent ID FKey in the Student table. I then set up the field to be entered by selecting from a drop down value list. The list came from Agent:Agent ID PKey …
-
- 15 replies
- 1.8k views
-
-
I have a text field that is presented in a tab control. Once the data is entered, and we move to a different note, the text gets displayed as 1.7201e+10. If we click on that specific note again, the text displays, but as soon as we move off that note, the numbers replace it. Any insights on what might be happening? The particular text is only 21 words in length ... Thanks!
-
- 6 replies
- 2.5k views
-
-
Am just starting to work with the Wb Viewer. I have a web viewer that I would like to show a clock in. I have copied a piece of code from a website that is for web clocks and have been able to get it to work but not as I would like or expect it to. I need to be able to use the whole piece of code but am lost as to how. "http://free.timeanddate.com /clock/i1a0ke7y/n28/fn8/fc090/tc000/pc000/ftb/pa3/tt0" frameborder="0" width="358" height="22"> Attached is a file that shows the actual code in use. As you can see the clock works but I am unable to change the font characteristics (Font,Size etc.) I realize that the font characteristics are cod…
-
- 1 reply
- 1.3k views
-
-
I'd like to sort by values from a summary field. I have a database for a fundraising event . One table has the donation information (donor's name, amount, student to be credited for donation etc.) that is linked by student ID number to another table of student info. This table may have several donation records per student. The Student table has the student information (name, grade, teacher, etc.). I want a report that is sorted by teacher's name then lists each student in that class by total donation amount per student. The layout works fine if it's sorted by teacher then student name, but I can't figure out how to sort by total donation amount per student. An…
-
- 5 replies
- 1.7k views
-
-
Hello. I would like to know if, when it comes to container fields, there is a way to show the name of the file only and if there is a way to show the according icon only. Thank you! Mike
-
- 0 replies
- 1k views
-
-
Hi there Is there any way to goto a field where that field is currently in stored in a $variable? Thanks for any leads ... Tim
-
- 6 replies
- 2.2k views
-
-
So, I am sure someone will make me feel stupid here shortly by pointing out the obvious that I must be missing but all help is appreciated. This is the what happens: From a project profile screen a user clicks "Assign Project Contact." This button opens a new window, creates a record in the PROJ_CONTACT table and sets the _PROJECT_KEY to the corresponding PROJECT:__KEY. Right, that was a mouthful. This new window shows a layout holding a portal with all the contacts (they can be filtered dynamically but thats not important here). So now, the user has two options: 1. Choose a portal row and click OK in which case PROJ_CONTACT:_CONTACT_KEY is set to CON…
-
- 1 reply
- 2.1k views
-
-
ok... My ideas have dried up and I need some new ones. Anyone know where I can go to get some fresh idea on layout design. Mine are looking old. I need to learn some fresh ideas. Any hints or ideas would be great.
-
- 3 replies
- 1.7k views
-
-
Left over from earlier FM versions, I have some fields with unstored calcs used to conditionally highlight records/fields. I saw somewhere that unstored calcs slow down your solution. Would I be wise to delete theseunstored calc fields and just conditionally format the relevant fields/objects now that CF is available in FM9?
-
- 2 replies
- 1.4k views
-
Recently Browsing 0
- No registered users viewing this page.