FileMaker Interface Features
-
I want to insert a picture into a layout. The layout is a letter with mail merged inside address, etc. The picture is my signature (scanned as a jpeg). I can insert the picture, but it doesn't flow with the layout. In other words, if the mail merged information changes the length of the letter (some people have an inside address of 3, 4 or 5 lines), the signature falls out in the same place on the page no matter what. Is there a way to get the signature to flow inline with the rest of the text?
-
- 5 replies
- 1.4k views
-
-
Howdy, howdy: I have multiple T.O.s in my solution and in a few of them they have a text field named "City." Rather than each T.O. having its own City value list I thought I'd have them all access a single field ("City") in a T.O. named Preferences; it would be accessed via the "Use values from field: Preferences::City, show all values" drop-down menu set-up. My question is: how to enable all the T.O.s to "see" the City field in the Preferences table? Do I need to link every T.O. to Preferences using the typical pk_city_ID/fk_city_ID relationship, or...? TIA for your help! Rich
-
- 1 reply
- 1.3k views
-
-
I can't say for certain, but there seems to be some sort of limit on the number of items that can be in a value list. Say I have a list which is based upon a field: [car parts::serialNo] And then I use [color:red]ValueListItems ( fileName; valuelist ) There will sometimes be items missing. If instead I use [color:red]List ( car parts::serialNo ) This problem does not occur. (Before anyone asks, the reason for not using list in the first place is for backwards-compatibility). Has anyone seen anything similar? Is there a known limit on value list items?
-
- 6 replies
- 1.7k views
-
-
Hi - first of all, thanks for such prompt, clear support. I've had data in FileMaker for about 6-8 months, since I moved to the Mac, but I haven't worked with it until now. So I'm here with questions. I created two layouts, and I think I didn't deal properly with the sort when I created them. Now I have it done the way I want, but, when I switch from layout to layout, the sort order doesnt' seem to be saved with the layout. Is that possible to do, and how? Thank you- Marion
-
- 2 replies
- 999 views
-
-
It is so nice to be able to get a movie into webviewer. The problem is you always have to scroll to get the movie centered. Is there any way to script this so we can find an exact location on a web page that has all their objects in the same places each time? Thanks
-
- 25 replies
- 7.2k views
-
-
I can't imagine this is possible, but, I see the topic here, so I'll ask. I have a table that defines various terms for paying royalties. Basically, it's set up as: person Rate type (value list: fixed, percentage) rate Amount (such as $1675 and 3.875%) Now, I know very well that the rate amount can happily hold 1675 and .03875 But, when I print the report for anyone, they need to see the info as $1675 and 3.875% Suggestions? I looked at Format->Conditional and that helps me a bit... I could make anything > 10 be formatted in bold, for example... but that isn't ideal. Thank you !
-
- 5 replies
- 1.6k views
-
-
Is it me or they didn't fix the problem with multiple portal in FM 10? I need 6 portals and in each one there is another one. How can I fix this problem? Thanx Here's a printscreen
-
- 17 replies
- 5.8k views
-
-
hi all, i hope i'm in the right place for this question. is it possible in FMP 5 to set a default value to a radio box or checkbox. its a simple yes / no function and i recently added it but i need everything to be standard set to yes. is that possible. and if it is so could someone tell me how? thanks in advance
-
- 4 replies
- 1.4k views
-
-
Is there a way to determine visible rows in portal? Or to scroll a specific row into the visible row 1 position? Here is the issue, I have sets of data in a portal and as the user selects the master record in the above portal, the child portal below scrolls that set into view showing 1st row of that data in first row. I had the scrolling working by scrolling downward far enough that the first row set of data would appear in first row. But this all broke when the portal auto-sizes for larger screen resolution. So if I can get an answer to one of the first 2 questions then I should be able to do what is needed.
-
- 2 replies
- 1.3k views
-
-
Any Photoshop wizards here? I have PSD-file and i need to change some text in it and then save picture as jpg. How this can be done?
-
- 1 reply
- 1.8k views
-
-
I read with great interest the recent posts on embedding an animated GIF and displaying it with Web Viewer. Link It seems to be an ideal solution for displaying popup-style messages during longer operations. But when I constructed a simple message box, I encountered a problem as shown in the attached image. Does anyone know what is generating the large white rectangle? I'm using the latest IE8.0.6, but have I overlooked some Web Viewer default setting? Thanks in advance for any help. PopupTry.fp7.ZIP
-
- 4 replies
- 3.2k views
-
-
I tried to post before, but can't see it anywhere, sorry if I've double posted. I'm trying to conditionally format a field according to whether or not a record with the same id exists in another table. I'm using this... PatternCount( List(OtherTable::ID ); ThisTable::ID) >0 but if ID number 10 exists in the other table, the item in this table with ID 1 also seems to meet the condition. Gotta be an easier way right? Phil
-
- 6 replies
- 1.8k views
-
-
Is it possible to have templates in FM10? Most of my layouts will have a number of common visual features and I'd rather lay these all down in a template which I can then edit, rather than having to make changes to all my layouts every time I want to change something.
-
- 1 reply
- 1.2k views
-
-
Is there any way to do a simple, animated, "Please wait" message in Filemaker? Just the standard spinner device would be great. I've tried using an animated GIF but it doesn't work.
-
- 2 replies
- 1.8k views
-
-
I have designed a till in FM which has a layout containing two portals: one for items bought, the other for payments made. I now want to print this layout (re-themed, of course, but displaying the same information) in preview mode. Sometimes there are so many items in the "items bought" portal that they don't all fit on the screen. I have therefore added a vertical scrollbar to the portal. However, this disappears in preivew mode so I can't see all the records. Is there any way of getting round this problem, so two portals can be displayed in their entirety in preview mode, no matter how big they are?
-
- 3 replies
- 1.1k views
-
-
Hello there, fellow FM'rs! In my database, after much blood, sweat and tears (relationships, portals, etc), all the necessary info now appears in the correct table, all that is needed is a snazzy presentation! I'd love to show the relevant records as a series of pyramidal hierarchies, so one quick glance gives an overview of the whole organization. Each area subdivided into tasks, each task performed by an employee, with name and photo displayed. These elements are all in my table. However, Filemaker seems to list multiple records only vertically. A thorough search here in the forums did not find any topics that really address the specific goal at hand.…
-
- 7 replies
- 4.1k views
-
-
I am trying to combine 2 value lists into one - they are from 2 different tables and need to be use in a 3rd table. 1. TimesheetsTable = table where the TASKS value list needs to be available. 2. ProjectsTable = contains a value list of all the Tasks assigned to that Project. 3. AddendumTable = contains a value list of all the Tasks assigned to the Addendum. • In the TimesheetsTable the person chooses a Project 123 and based on that choice a pop-up displays the list of Tasks assigned to Project 123. Works like a charm. • Now, when we create an Addendum for Project 123 the Addendum info is in a separate table ... the Addendum can include different Tasks…
-
- 4 replies
- 5.3k views
-
-
Is it possible to count occurrences in check box set fields? In other words, if I have three sizes of shirts, S, M, L as check boxes, can I count the number of different sizes as a summary field or calculation field across multiple records?
-
- 2 replies
- 1.3k views
-
-
I've just run across this perplexing problem. On a Windows machine, when tabbing into a pop-up menu field, the pop-up shows with all its options. But, on a OSX machine, the same tabbing will not show the pop-up at all. In fact there is no visual representation that the field is active so pure keyboard entry cannot be used for that field. Is this a bug or am I missing something?
-
- 1 reply
- 1k views
-
-
I found some .PNG files that could be used in fm. What's the easiest way to them as buttons. Is there a better way than copying them in and then putting a clear box around is as the real button?
-
- 1 reply
- 949 views
-
-
I find that the "delete portal row" script step doesn't work when I have the layout in Table View. Is this a known bug? I attach a small FM database to demonstrate. The 2 scripts work correctly (deleting a portal record from a related table) when the Main Table layout is in Form View or List View, but not when it is in Table view. For this test file, I've set up two different sorts of relationships: (1) a relationship from the Main Table to a secondary table called Other Table; (2) a self-map relationship from the Main Table to a second instance of Main Table titled Main Table Self-Map. In both cases, the relevant script will delete related records onl…
-
- 1 reply
- 1.4k views
-
-
User jumps to a dedicated layout for searching and automatically enters Find mode. Presses a button labelled "Search" which performs the Find and goes into Browse mode. This works fine. Now the client wishes the label on the "Search" button to change its text, depending on the Window Mode — "Search" when in Find mode, "Start Over" when in Browse mode, which would re-initiate going back into Find mode. Excellent idea. Created a Calc field which evaluates the Window Mode and returns the appropriate text. However, when in Find mode all fields go blank. Can anyone think of a workaround? Much appreciated.
-
- 1 reply
- 961 views
-
-
Hi, Is it possible to show/hide sub summary in preview mode based on a condition. Assumming I have a "sub summary when sorted by group field", how can I get the sub summary to follow below condition? If group =1 show sub summary Else, don't show sub summary Thanks in advance, Garu
-
- 1 reply
- 1.2k views
-
-
Hi all! Over the past few weeks we've been building and fine tuning our new contact database and this is the first issue I can't resolve through research or doing countless trial runs. I have a long list of job titles we categorize clients by. They obviously fall into larger groups based on profession. Thus we have a short list of Professions and a longer list of Job Titles. I already have the drop down value list for the professions working fine and could do the same for the job titles but what I'd really like to do is have the second list of job titles shorten based on whatever is selected from the Professions value list. E.g. if somebody chooses Photogra…
-
- 15 replies
- 2.4k views
-
-
Somewhere in the distant part of my brain I recollect a filemaker feature that automatically re-sized layouts to fit screen size of whatever monitor the application was being displayed on. Is this just a movie in my own head or does this option really exist? I do most of my work at home on a 24 inch Imac but the screen I have at my shop is only 20 inches. Is there a way to truncate the screen display when using smaller monitors to eliminate all the scrolling?
-
- 3 replies
- 1k views
-
-
Hi there, I set up my database size to 630 x 950 pixels with the Adjust Window (Resize to fit) script. When I run it in a runtime solution, I notice FileMaker frame uses more room on screen that the database itself. What should I do to make FileMaker frame fits my database size? This happens on Windows only.
-
- 1 reply
- 1.2k views
-
-
Hi, I have a layout with few tabs, when I create a new record I would like it to go to the first tab, how can I do that in script? Thanks in advance. Garu
-
- 5 replies
- 6.9k views
-
-
A few of the scripts in my current FM project move between multiple windows. When this happens, the screen "flashes". Is there a standard way to get round this problem? I have tried setting the size of windows to 0 by 0, by it seems that changing the size of one window stops my main window from being maximized, which is problematic.
-
- 5 replies
- 1.9k views
-
-
I have a single table solution to track feature requests. One of the fields is "Complete". I want to use a checkbox on a layout to allow the user to toggle the value of Complete between true and false or 0 and 1. How do you do this in Filemaker? Thanks!
-
- 1 reply
- 3.1k views
-
-
I have a layout that will automatically get a different heading if it's a July report or if it's an August report. Besides that I have two possible portals that will show up in a subsummary. The july portal if it's a july report or the asugust portal if it's an august report. Any idea how to display the proper portal through my script? I know how to get different headings by passing parameters. I can't figure out how to get different portals.
-
- 7 replies
- 2.4k views
-
-
Hi I put this post originally in the layout forum and received no reply so I am trying this forum (which I just discovered -duh!) I also tried to search for an answer but, zip so far. I have a field with a defined value list on two different layouts. One a drop down the other a pop up menu. The values are from the field itself. The values are "batch numbers" so it builds the list 1,2,3 etc. Currently the list sorts 1 through the highest number. I would like it to sort the opposite so the highest number is at the top. Possible? Thanks for your patience and any help. P.S. I'm at work on 8.5 Advanced on XP in case my home profile shows up as 9 &…
-
- 1 reply
- 1.4k views
-
-
Displaying the Text Ruler has two unfortunate display side effects in FMP10. 1. The worst, it automatically redraws the screen to go to the default tab. The end user is disconcertingly jumped to some other tab automatically. Since there's a script trigger attached to the tab panel working out a solution is tricky. 2. The Adjust Window Resize to Fit command doesn't take account of the additional depth of the window, now that a ruler is in place. Both problems are cludgy, requiring complex coding to provide the user with expected behaviour. Anyone have comments?
-
- 0 replies
- 1k views
-
-
I am adding data to a file via a portal and after adding it I want to print it out. No matter how I design the TO relationship I can only get it to display the portal row with the lowest portal row ID number. How do I point to a particular row so I can print just the one row??
-
- 7 replies
- 1.8k views
-
-
I want to use the google maps feature with webviewer but don't want all the extra boarders and crap google maps adds. I would love to have just what is shown with an embed link. Just the map at a custom size and zoom level I choose. I have been able to get the embed link to work but can't figure a calculation to make it generate from some address fields.
-
- 4 replies
- 3.1k views
-
-
I was recently looking at some template files that came with the software, and this one in particular caught my attention. I would like to use something similar to the portal in it and was wondering if anyone could walk me through setting this up in my own database. Any help would be very much appreciated. Resource_Scheduling.fp7.zip
-
- 12 replies
- 2.7k views
-
-
I'm trying to get a field to fill up the Layout like this: Scene1 (record 1) - Scene1 (record 2) - Scene1 (record 3) - Scene1 (record 4) - Scene1 (record 5) Scene1 (record 6) - Scene1 (record 7) - Scene1 (record 8) - Scene1 (record 9) - Scene1 (record 10) Scene1 (etc.......) - Scene1 (etc.......) - Scene1 (etc.......) - Scene1 (etc.......) - Scene1 (etc.......) Scene1 (etc.......) - Scene1 (etc.......) - Scene1 (etc.......) - Scene1 (etc.......) - Scene1 (etc.......) But whatever Layout Type I choose I can only get it to show the records like this: Scene1 (record 1) Scene1 (record 2) Scene1 (record 3) Scene1 (record 4) Scene1 (record 5) Scen…
-
- 12 replies
- 1.9k views
-
-
Hi I have a field with a defined value list on two different layouts. One a drop down the other a pop up menu. The values are from the field itself. The values are "batch numbers" so it builds the list 1,2,3 etc. Currently the list sorts 1 through the highest number. I would like it to sort the opposite so the highest number is at the top. Possible? Thanks. P.S. I'm at work on 8.5 Advanced on XP in case my home profile shows up as 9 & Mac
-
- 0 replies
- 1.1k views
-
-
I have a strange request of filemaker. i have customers and jobs and several jobs going on at once. I would like to create a form where I could log the day's work in one place. Date of Service Invoice number / Job / Rep (This line would be repeated depending on the jobs done that day) Then each customers invoice would be populated with the data. Would I use several portals? Thanks for any help.
-
- 1 reply
- 1k views
-
-
I have 4 tabs on a layout. Job Details, Schedule, Estimate & PO. The Tab names are displayed from Nav_Tabs table. For some reason, the tabs and the tab names get deleted from time to time. Has anyone else had this happen. Any help or any idea would be highly appreciated. Thankyou
-
- 5 replies
- 2.3k views
-
-
I would like to add a page with GoogleMaps to my address database where the address is taken from the record I just selected in browse mode. I guess I will have to tell FM which record it should refer to but I don´t know how to do this. I already tried to just point FM to the relevant fields but it did not work out. Any help out there? Thanks
-
- 4 replies
- 1.7k views
-
-
I'm having trouble with this and it may be because conceptually I've got it wrong. What I want to create is a portal which displays all records from a table, that contain a certain value. However, when I placed the portal in, all I get is one record at a time. I think my relationships aren't right, or perhaps I need to create an extra table? Any help would be much appreciated.
-
- 12 replies
- 7.5k views
-
-
Hi everyone. I have a script already written that work well that send an email to a bunch of people. Now I need that script to be trigger by a Checkbox. If they click on The X on the Checkbox the Script for emailing is being run . . . How can I do That ?
-
- 3 replies
- 1.8k views
-
-
Hello, I am sure this is probably very simple, but I am having trouble figuring it out. I have a table that contains last name and first name as two separate fields. I would like to create a value list of the format "Last name, First name" so that someone can select from this dropdown list when editing records. How do I create a value list in this format?
-
- 4 replies
- 1.9k views
-
-
When I open a "Show Dialog Window" that was previously open in a expanded or shrinked down view Seem to retain it's size? Any ideas how to solve this ughhhh TIA
-
- 3 replies
- 1.2k views
-
-
Would appreciate some help in the form of an example or a referral to a tutorial or something of that sort. I need to create a formatted address field from a number of elements. The elements with sample data are as follows: House_Number, 1234 House_Number_Suffix, 1/2 Street_Direction, East Street_Name, Data Street_Type Avenue Street_Direction_Suffix, West Unit_Type, Bldg. A Apartment_Number 206 An example using all the elements combined in a single formatted field would be: 1234-1/2 East Data Avenue West Bldg A Apt.206 Thanks for any direction on how to d…
-
- 8 replies
- 1.7k views
-
-
I'm not sure if this is the correct section to post this question, but I couldn't find a better fit (part of being a noob). I am trying to print a MICR check field and need to take the check amount and "merge" that into a fixed layout. For instance, if the check is for $323.95 then the layout would be: 0000032395 I'm able to get the check amount to appear, but I can't figure out how to pad the left most side of the field with zeros (for a total of 10 digits). Any help would be greatly appreciated! :(
-
- 2 replies
- 1.1k views
-
-
Hi, I have a value list which is a related value list using "Include only related values starting from" radio button option. It is a value list from a Date data type field. I want to show user with this value list. The value list should be sorted for the required date field. Pushkraj
-
- 1 reply
- 1.2k views
-
-
Hi, Is it possible to display the value of a Variable into a Layout without storing it into a field? The reason why I ask this is I need to display a person's name on every report on different tables that i have and I thought of storing it into a variable instead of creating a global field which requires to create relationship to that field on every table just to get the person's name. Any clue? Thanks, Garu
-
- 2 replies
- 1.8k views
-
-
I need to put some info in a text field but it must be formatted as a table, but i don't need to create database tables for this info, is just a matter of showing it in a given order. Example: Suppose is a database of a girls club. the important information is about members, but they can add personal food recipes in a text field. We don't need database structure for ingredients, or kind of food, or preparation time, only the field to store the recipes each member wants to add. i've been told these recipes field should have two column format or maybe table format like if it were a Word table. Sorry if i'm not clear enough, as you can see my english is far from…
-
- 1 reply
- 1k views
-
-
I am adding a basic value list to my layout. When I format it for checkboxes, the checkboxes won't "check". It also stops another very small checkbox already on the layout from functioning. When I delete the second value list field, the first, previously working checkbox field still won't work. I've reinstalled the FileMaker Pro 5 software, remade the value box and field from scratch, and the results are the same. The Value List I'm adding has 39 items on the list with a maximum of 18 characters each. It originally had hyphens and slashes on some of the items. I have since eliminated any character that isn't A to Z. I am on a Mac G3 with an 8.6 OS. This sh…
-
- 0 replies
- 1.3k views
-
-
Hi, I've never worked with custom menus before. How can I link a custom menu to a privilege set? Thanx
-
- 3 replies
- 1.8k views
-
-
We have a text field that we need to auto size on a layout by the amount of text in the field. Is this possible in Filemaker? Currently some of the data is being cut off and we don't want a large empty space in the middle of the document if there is no data.
-
- 2 replies
- 3.8k views
-
-
I have a "status Field", and i created a new field, that i would like to fill Green is the Status Field gets change to "approved" (drop down List) or Red, if the Status Field gets turn to "Not Approved" any ideas how to do this. Thanks
-
- 2 replies
- 1.4k views
-
-
Hi all, hope someone out there can help... I am working on a workflow management system. I have a table that stores job stages and a related table that stores time logs for each of the job stages. for example a job may be created with a job stage "Design - Concept" and the operator may then log hours against that job stage on a few separate dates. I am stuck with producing a calculated field to evaluate all related timelogs and then returning the newest date for the related jobstage. So if the operator logged time entries against job stage "Design - Concept" on 01-Apr-09, 04-Apr-09, and 05-Apr-09 I would want the calculation to return 05-Apr-09. Than…
-
- 2 replies
- 1.2k views
-
-
Am I crazy or is FM10 resetting portal row positions if any script step runs after a "Goto Portal Row" step? Previously in FM9, in this same script, "Revert Record/Request" could be run after the portal position step to pop the cursor out of the field used to step into the portal and the visible portal rows would not shift. In FM10, the portal always resets to the top. Anyone else seen that?
-
- 6 replies
- 1.6k views
-
-
I'm new to FM, just got version 10 a few weeks ago. I'm proficient in an old legacy database program (filePro), but it's time to move on. I have a database of equipment. A portal relationship (to "servicehistory" table) holds the service history for an item. When available (i.e. the info gets written on the work order), there is a field for the hour meter reading, "hourmeter". I want a field in the main (equipment) table set to the most recent, non-blank, hour meter reading entered into the portal records. I spent several hours on it today. Everything else about FM has come easily, except this. Portal records are sorted by date, with the most recent ap…
-
- 2 replies
- 1k views
-
-
I am putting together a database to input orders. I can't find help on how to format checkboxes to get them to show the correct data in both a data input form, or the associated table. here's the deal: I have a table storing data (yes or no) and a form for people to enter the data. They have a field at the top of the form in which they enter the product number and up should pop the description and whether or not it is in stock (in the form of a single checkbox for each size--size0, size1, size2, etc.) using the associated table's data. There are 12 different checkboxes on the form... They are all number/boolean fields and checkbox format. How do I get the ex…
-
- 13 replies
- 1.8k views
-
-
I have a text field which I populated using a script and then used as the basis for a Value List. What's weird is that, when I pull up the value list in a pop-up menu, the list will dynamically change — as if FM were treating the text field as a calculation field, and recalculating the value of the text field by re-applying the script. I can explain in more detail, but I'm not sure it's necessary to do so. I gather that this is one of the new features of FM 10 (or 8 or 9) — I only recently upgraded from FM 7. I'm writing in hope that someone can explain the underlying principles of this dynamic. I'm accustomed to FM forbidding me from using calculation fi…
-
- 2 replies
- 1.1k views
-
-
Hi, Is there a way to check if a tab is selected? I tried GetLayoutObjectAttribute ("myTabName"; "hasFocus") but it doesn't work. Thanks for any help
-
- 7 replies
- 1.6k views
-
-
Hi all, I have a 3 tabs in my layout. tab 1, 2, 3. tab 1 being the default. I created a script from a portal in tab 3, and it goes to a related table and performs a few stepts, but once i sent it back to Original layout it goes back to Tab 1. I need it to go back to my working tab, which in this case is tab #3. How can i do this from my script? Thanks
-
- 1 reply
- 2.6k views
-
-
I have a layout with two portals, each one shows information from its own related table and users can insert files in both, one portal for images and one for pre-recorded speech. I defined a script to insert files in portal 1, it works fine, but when I assign this script to a different button for inserting files in portal 2, it always points at first row in portal 1; each one has 3 rows, so I thought that possibly filemaker saw portal 1 (rows 1, 2, 3) and portal 2 (rows 4, 5, 6) as two pieces of the same portal, then, in script for portal 2, i used the script step "Go to portal row (4)" which would be first row of the second portal, but it didn't work. I'm confused, …
-
- 2 replies
- 1.2k views
-
-
I want to be able to choose one of four possible addresses per contact to create mailing labels. I figured out how to add the radio dials and entered custom values (business, home, home2 and other/foreign). In an ideal world, I want to click on "home" and the data stored in the home street, home street, home street2, home city, home state, and home zip should be placed in to a "Mailto" field (or a Mailto home street, mailto home street2, etc). I have not yet set up these Mailto fields because I'm not sure if the information can be dumped from several fields to one larger field. I believe that I need to set up the "mailto" as a calculation field and using a case …
-
- 2 replies
- 955 views
-
-
Hi all, In my university database, I have a portal which includes the fields of subject, year subject offered, not offered etc. Problem 1 I want to create a layout (letter) where I can selectively choose particular subjects to appear in the letter. Currently ALL the subjects appear (or as many rows as the portal has), which is not what I want. I want to selectively choose subject 3 and subject 5 for instance, to appear in the letter and no other. How do I do this? Problem 2 There is also a script set up as a button which database users can press to email individual students if a subject becomes available. Again, how can I selectively choo…
-
- 5 replies
- 1.4k views
-
-
Hello all, I hope everyone is well and in good spirits! I'm looking for some direction/advice. I have just started working on an inventory solution/daily sales log. I just wanted to make sure I can accomplish what I'm after using a portal or portals. I have attached what we have been using to keep track of daily sales. (its a .pdf of an excel file) I would like to have my portal automatically display all the active items and look pretty close to the attached file. I threw a quick portal together and the drop down method works fine but i would like to make what Im working on as close to looking like what we had been using. A friend of mine put one together w…
-
- 3 replies
- 1.4k views
-
-
Hi I have a field on my layout that has the control style "checkbox set" with a value list "1". The field is mapped to a text field in the database. When the checkbox is "ticked", I notice the value in the field in the table (looking at it from another layout where the control style is edit box), I noticed the value is a space, followed by a return char then 1. Looks like this: " 1" (without the quotes of course) Why is that? I was expecting a "1" only if ticked an "" if unticked.
-
- 8 replies
- 2.1k views
-
-
does anyone know how to turn this off - many of my apps use paging to trigger other events or calculations - use of the scroll wheel will defeat these functions. i also think this feature increases user error when they inadvertently page to another record.
-
- 7 replies
- 2.1k views
-
-
I am trying to keep the Status Area hidden from the user. Is there a way to change 'Include' to 'Omit' in the hidden Status Area from a script?
-
- 7 replies
- 2k views
-
-
The idea is simple - I have a portal which has three rows of fields on each portal row. Thus, I cannot add header labels to indicate what each field does, unless I add three rows of labels on top of the portal (ugly!). Thus, my question: can greyed text be shown on each field, with a description of what the user is expected to enter? Eg. you could see: [color:#AAAAAA]Type your username here Which is cleared when the user enters the field. This is used in may applications and websites, so it's not an uncommon UI feature. I've not found a way to do this yet. Regards, Mike
-
- 1 reply
- 1k views
-
-
I am creating a flat database to catalogue my Microscope slides, and using the serial number function to automatically number the slides. If I remove a slide from the collection, how can Filemaker pick up that there is a gap in the sequence and offer to fill that gap when the next entry is created.
-
- 4 replies
- 1.2k views
-
-
Is there a way to control the ordering of a conditional value list? I'm trying to develop a task list for my cabinetshop. If you choose "DOORS" as your first selection, then the second list of values is germane to door making activity. The second list shows up in alphabetical order but I would rather have it show up in sequential order (i.e. step 1, step 2, step 3 etc) [color:red]Is there a way to establish a custom ordering of the conditional values? Thanks for any help, Jarvis
-
- 7 replies
- 2k views
-
-
I upgraded my filemaker 9 to the filemaker 10 trial and when i removed the trial and continued to use the FM9 version all of my pages sizes were converted from 8.5 X 11 to 3.5 X 6 I CANT PRINT ANYTHING!!! I have no idea how to change this back and i tried to call FM customer support but apparently you have to pay. Can anyone help me out?
-
- 1 reply
- 978 views
-
-
Morning everyone! My boss has asked that I print a weekly report on updates I make to notes on each company, and export them to an Excel file. Here is the tricky part: When I do the report, only the most recent note/time of creation/creation date, appear. I need ALL the notes to appear for each company, including their corresponding dates/times. The data containing the company notes and date/time is coming from a tab containing a portal with a "note" relationship . Photos are included that display all the info pertaining to this problem. I'm sure it's a simple fix....just not a request I have run into before. Thanks everyone!
-
- 27 replies
- 3.7k views
-
-
Wondering if anyone can help me with this. I'm making this Formula 1 Database that consists mainly of an Event table (the "Grande Premio" sub-area on the attached layout, p.s. it's in portuguese, my native language) and a Results table ("Resultado" sub-area) linked thru the common field Date. I want to include in my layout driver and team point standings after each race ("Classificação" sub-area, based of course on the Points field of the Results table (rightmost column on the layout). Could anyone give me an idea how I can accomplish this? Do I need to create a new table and a portal for that or can it be done with a simple script or calculation? Also it would be …
-
- 0 replies
- 1.2k views
-
-
I just wonder if there is a simple way to do this (Filemaker 9) Basic invoice situation: Inoivce Table Line Item table Product File Enter item# in and description and price are displayed in that line item of the invoice. Simple. Now I want to be able to choose multiple item#s for that ONE line item. For example: Items might be - Shampoo $20 Color $35 Set $10 I want to choose multiple items from a list and have it concantenate so the description reads: Shampoo, Color, Set $65 We don't have the space to have a checkbox where you can select more than one item. What's the cleanest solution? I have ideas but they all seem to t…
-
- 4 replies
- 1.3k views
-
-
Is it possible to use conditional formating to format a number field in a portal so that if the number is lower than the number above it in the portal the text will turn red. Month Amt Jan 20 Feb 19 text turns red Mar 16 text turns red Apr 20 May 19 text turns red
-
- 2 replies
- 1.4k views
-
-
Hi everybody, I hope i can get some help with this. I have a layout which allow users to insert sounds, or images, using a portal but, while images seem to work fine, when i insert mp3 files, i can't play them using double click on them. i was having trouble with this, but i found solution in this very forum, RIGHT HERE ; my own previous solution was to use a join table, (many sounds in one article - many articles can have repeated sounds from other articles), the problem inserting one different file in each different instance of the sound container field was very similar to that exposed in the link above; when i was trying my own solution i could play the mp3 files…
-
- 1 reply
- 1.4k views
-
-
I know that I can format a field on a layout as a checkbox set, radio button set, drop-down list, or pop-up menu. But what I would like to do is format a field as a scrollable value list, where the user clicks on a value to highlight it. If this isn't clear, think about the interface in iTunes: You have, essentially, three global fields (g_Genre, g_Artist, and g_Album) that you set by choosing from a scrollable list, and then a portal of records whose fields (genre, artist, album) match the global fields. I thought there might be a way to rig a drop-down menu to stay "always open". That would sort of simulate what I am after. But whenever I exit the field th…
-
- 1 reply
- 1.1k views
-
-
Is there a way to show the 'Formatting Bar' in a script. In addition, is there a way to hide the 'Formatting Bar' in a script.
-
- 1 reply
- 4.1k views
-
-
I am looking to add animations (an animated navigation bar) to my database and was thinking that using the Web Viewer would be a great/only option. I have a large database filled with marketing lead currently. I want to add an animated FLASH or HTML navigation bar in the header for the different layouts that I have in Filemaker. I have the FLASH/HTML part down, but [color:red]I was wondering if there is a way to control navigation to other filemaker layouts and scripts from the web viewer (ie. click on 'Home' in the web viewer navigator and the filemaker layout will change to my home/base layout). Any help would be appreciated. Also, does anyone have any l…
-
- 2 replies
- 2k views
-
-
Hi everyone... I'm trying to set the spell-checking (File options - Spelling - Indicate questionable words..) automatically ON on the startup of my solution but I can't figure out the way, because every time I open my base, it appears unchecked! Does anybody know how to set it up to automatically "indicate questionable words with special underline" not having to turn it ON every time I open the solution? Thanks a really really lot for your help!
-
- 1 reply
- 1.2k views
-
-
How do you show a found set in a portal? I have a very simple 1 to many relationship.
-
- 12 replies
- 2.5k views
-
-
I'm pondering the concept of abstracting all the strings (mostly messages that appear in dialog boxes) I'm using in a specific solution to a single place. Doing so would allow me to: 1. Reference all the strings from a single location. 2. Add localization pretty easily. 3. Imagine for a moment I was using a "grown-up" development environment... Anyway I have a couple ideas of how to do this, but they pretty much boil down to one of the following: • Storing a list of strings in a custom function • Storing each string as a record in a specific table I was wondering if anyone has experience of doing something similar, or knows of a "preferred" way of…
-
- 4 replies
- 1.7k views
-
-
I have a portal to display line items for an invoicing solution. I've inserted a small graphic into the portal row and set it as a button to delete the row when pressed. When I create a record in the portal, it always shows the button on the next line. I've seen other solutions where this is not the case, but cannot figure out how to fix it?
-
- 4 replies
- 1.8k views
-
-
8.5 Advanced. I setup tab order to go to a button. The button highlights but will only execute with RETURN and not ENTER key (the one on the number pad) Is it possible to execute with the ENTER key? TIA !
-
- 0 replies
- 1.5k views
-
-
I'm having a issue with creating regular US address labels. These are the fields I have and how they're formatted: <> <> <> <>, <> <> The problem is when I preview my labels there are blank lines within them because the Address 2 field is blank. Like this: Jane Doe 123 American Way San Francisco, CA 94400 How can I fix this? Is there a way I can only show the field if it has data in it? Please help!
-
- 13 replies
- 1.5k views
-
-
Hi All, Whenever I go into a field in browse mode, all other field's BORDERS get high-lighted, how do I stop this?
-
- 1 reply
- 944 views
-
-
Hi, I have created a "Values list" that display values from 2 fields. first field : Email second field: Full Name Then selected "Show values only from second field". Now, I have created a field that used a Pop-up Menu to display that "Values list". It work great, it list the Full Name but still seem to store the email address of that person. That way when I press my email button it use the email address of that person . This is what I want. My only problem and it's a very inconvenient one, I can't search that field using the full name as criteria. Even thought the pop-up menu only display the full name. What can I do ?
-
- 7 replies
- 1.8k views
-
-
I have a table of 14 records, each record has a field called description. I have a global field xyz in a second table. I create a layout using the second table. I put the global field xyz on the layout. I make it use a drop down list from the first table, field description. When clicking on the global field all I get are two descriptions. I'm missing the other 12. I tried everything. Any ideas?
-
- 1 reply
- 856 views
-
-
Hi To All, I am having trouble getting a site to load that is https and has a certificate. It comes up a "bad server certificate" Is there a way around this. It loads perfectly in Safari/Firefox. I am on OS X 10.4.11 I want to do WSDL calls to this site but I think this is stopping the query. Thanks, Lance
-
- 0 replies
- 1.1k views
-
-
I need help in figuring out the best way to use check boxes to tag records in a list layout. The users need to be able to tag one or more records and then select a "delete" or "process" button in the header. Sound easy and pretty straight forward, until you throw in a large multi-user environment. The "tag" field is currently a text field, and I can see where one user may be tagging several records for processing while another is tagging for deletion, and it's just a matter of who hits the button first. It would seem that I would need something like a unstored calc field but, cant get my head around how to make it work. Thanks in advance for any help.
-
- 4 replies
- 1.1k views
-
-
I need to find a way to take a field and add to it to form a filepath to an image. For example, My field is SKU123 I need to take that field and use it to display the image at: c:photossku123.jpg How would I create this filepath using that field, then then how would I display the image on the layout using it?
-
- 8 replies
- 2.1k views
-
-
I'm using FMP10 but I've yet to see the new "Find" icon when in Find mode. What setting enables utilizing this new feature? Appreciated.
-
- 1 reply
- 858 views
-
-
Hi all, Please could you anyone help me out with this. I have tables invoice Product material In the InvoiceItem portal I have a quantity field. In the ProductMaterial portal I also have a quantity field. In a layout from invoice, I pull all the materials from the ProductMaterial Portal, but the quantity field always goes to the 1st field of the InvoiceMaterial,any suggestion on the calculation of the quantity field to go with the invoiceitem. Thanks for any help.
-
- 3 replies
- 1.2k views
-
-
Hello all, I have a value list, that is based on a field. I have chosen the primary key (autocreated unique number) as the first value and another field from the table as the second value. When i make the value list sort by the first value, everything displays fine. I can see all records from the field. However, when I select to only show values from the second field, some values disappear from the list, and instead the end of the list just displays a bunch of blank values? What could be the cause of this problem? I checked that neither the key field, nor the second field contains line feeds.
-
- 5 replies
- 1.7k views
-
-
I am running FileMaker 10 Server Advanced with FM10pro on all our machines. One of our Mac os X (not Leapord) won't load a web viewer page. I have set the web viewer to "www.google.com/calender" and have also tried a global field. All the viewer does is state "loading www.google.com/calendar" but never really loads. As it is only on one machine, what should I check? Thanks.
-
- 3 replies
- 1.6k views
-
-
Here is the problem I'm trying to solve. I have a layout for invoices. In the layout is a portal for invoice line items. Each line item has a VAT code and VAT value and net price. I want to show a 'VAT breakdown' on the Invoice screen. This needs to be a dynamic list, with one line per VAT code. So if the number of invoice line items is 20, and between then there are three VAT types, then the 'VAT Breakdown' will show three lines, with the NET totals for each line. I don't want to hard code fields, one per VAT type.
-
- 1 reply
- 1.1k views
-
-
We are running a relatively simple database to manage information on our students. We have a number of fields, but 2 fields are causing a problem, and they are crucial fields for us. The first is Status- this is a checkbox group (current, active, alumni, etc). The second is Program (MDI, NPD, BTH, etc.) In a list view both of these fields are used for calculating statistics. The problem is that the Status field is not being populated with the information it has for each record. The information on status is sitting, hidden, in the program column. So for a record a student is listed as being in the MDI program. When I click MDI in the list view, below it pops up …
-
- 18 replies
- 2.2k views
-
-
Hi I am looking for a good way to handle a drop down list that would be required to match on three different criteria. It is a list to enter an airport and this can be matched by either a three letter IATA code, a four letter IACO, or the place name itself. Currently I am working in version 9 and while I think I could trigger these entries to complete a join table (from the Airport table) on field exit in version 10, I am struggling to think of an uncomplicated method for version 9. The result I am after is just as the BA.com website, any thoughts would be greatly appreciated.
-
- 3 replies
- 1k views
-
-
Hi, Is there a way I could use a key stroke to move to the next tab panel? (Direct key, script, script trigger...) This would be useful for the end user. Thanks for help
-
- 4 replies
- 2.3k views
-
-
Hi I have a rather large note field in a layout and in that are various 'words' that aren't recognised by the spell checker. Whenever these words are displayed they are underlined in red making them very difficult to read (some of them are case sensitive passwords). Is there any way in which the spell checker can be turned off for particular fields? many thanks Graham Keeley
-
- 5 replies
- 1.7k views
-
Recently Browsing 0
- No registered users viewing this page.