FileMaker Interface Features
-
I have a custom label layout with a 1â�� header. Each label is 4â�� wide and 7â�� long, in Portrait format, on 22â�� X 17â�� paper. (Double-size business cards).  I am printing 5 labels across in 2 rows, 10 labels per page.  The layout's Header lets me put a Printerâ��s Crop vertical line at precisely 4â�� and at precisely 8â�� at the top. So it places the crop mark for the first and second columns only.  My layout doesnâ��t let me â��seeâ�� the remaining 3 columns to put in the Crop Marks. The header area for these last 3 columns is greyed out. I can put the Crop mark there, but it doesnâ��t print.  My attached screenshot shows the first two crop marks in…
-
- 0 replies
- 1.7k views
-
-
I think I've found a bug related to setting fields in related records using scripts. If, in an open record (i.e. Get ( RecordOpenState ) = 1 or 2), an attempt is made to set a field from a related table in a portal by a script set to run with full access privileges when the logged in user is NOT assigned the [Full Access] privilege set, the changes are not shown in the field until the record is committed. Notes: A refresh window (flush cached join results) script step does not help The field can be directly on the layout or in the portal I'm using a data-entry pattern based on the ideas in this soliant article http://www.soliantconsulting.com/blog/2012/08/easy-filemak…
-
- 1 reply
- 1.1k views
-
-
I've seen this done before, but forget where I saw it and how to do it. I'm hoping someone can refresh my memory...   I have set the relationship to allow creation of related records for the portal table occurrence, now I'm trying to cover the last portal row (the one that allows creation of a new record) with a clear message telling users to click on that row to add a record. It is currently a text object with conditional formatting testing if the primary key field is empty. This method requires the user to type data, then exit the field before the conditional formatting refreshes and the message is hidden.  What I want to do is have the message be hidden as…
-
- 2 replies
- 1.6k views
-
-
Hello, I have a database to record data entry errors. In the "Log" table the user selects the transgressor from a value list "staff" that pulls from a field called "StaffID" in a table called "Staff". I would like the values displayed to be from a second field- "Staff::Username". Unfortunately, "Username" is a calculated field - Right(Users::LoginID;Length(Users::LoginID) - Position(Users::LoginID;"";Length(Users::LoginID);-1)) "Users" is a external SQL database. The values of LoginID read like DOMAINNAMEUsername so the calculation is to trim off the domain name and the slash. If I try to create the desired value list, when I specify the fields for it, I sele…
-
- 1 reply
- 1.2k views
-
-
Hi guys, I was hoping I might get some assistance for a feature I want to include on one of my layouts. I have a drop down menu which triggers many different scripts when the users elects one of the options. This has always worked well, but on a new layout I'm creating I don't have the real estate I need to add the entire field when this is in list view. What I'd like to do is have a button which will display the drop down menu when it is pressed. My best guess would be to put the actual field behind other layout items, and then use the button to trigger the arrow on the drop down list to display the options. Any help would be greatly appreciated. Kind…
-
- 6 replies
- 1.1k views
-
-
-
I have a flat database that runs a 'case' calculation in two "Product total" fields, to result in a count of products (that exist in other multiple fields). ie. each "Product total" field is for a specific product (I'm only interested in two products). There are unique customer numbers, of which some have multiple counts for either or both of the products (in the two calculated fields) and some, nothing. I am trying to 'compress' 10000 records to result in one record per unique number with a total for each of those two "Product total" fields next to it ... is this even possible? All of the other data (fields) are not required for this layout. I have tried various…
-
- 1 reply
- 762 views
-
-
Hi all. I am relatively new to Filemaker programming, but I have come across what I thought was a bug, which I have been tearing my hair out trying to squash, only to find it is more a "feature" than a bug. I have a field set as the key for lookups in a ms sql database which I have created a relationship with. I have it set as a drop down, and it is showing 2 fields (last name and first name). Unfortunately, it only shows 1 person per last name in the sorted list (example, there are 5 people with the last name "Bennett" but only 1 shows). After driving myself nuts trying to find the error, I found the following in the filemaker troubleshooting section: : …
-
- 6 replies
- 4.1k views
-
-
Greets, all! I thought that since this is more of an eye candy topic than say, a script or calc, so I'm posting this question here. I'm sure this is easily accomplished just that I'm not seeing it; I perused the Get functions and didn't see anything there that would help. Then again, I'm known for missing stuff. *blush* I'd like to have a text field's fill highlight itself when when a user clicks his or her mouse while inside the field but de-highlight itself once the user starts entering text. It's tricky since I can't use a container or a conditionally-formatted button behind the field since the text field has to use a pre-set color fill so it can't be set to transp…
-
-
- 3 replies
- 1.6k views
-
-
I have some layouts where I've implemented an icon for toggling a boolean field. My implementation is to place on the layout an unstored calc field, called z_button_publish, with calculation Case ( Reagent::status = 1 ; Graphics::%CHECK_24 ; Reagent::status = 0 ; "" ) Where Reagent::status references the boolean, and Graphics::%CHECK_24 is a global container with a checkmark graphic. This field object is set to perform a script on click, which simply sets the Reagent::status field to not Reagent::status, which effectively toggles the value between 0 and 1, which forces the graphic in this unstored calc to update to a check mark when it is 1. This is all fine and …
-
- 4 replies
- 1.4k views
-
-
I have a simple situation and thought there was a simple portal filtering solution. I have a text field that contains phrases: "Newly Minted in New Hampshire" "New Ways to Run a Railroad" "An Old Story Told Anew" "Newfound Methods" When I set New as the filter keyword, it displays all four records. But what I'm trying to display are the first two. My portal filter is set as PatternCount (Table::Field ; Master::Keyword ) > 0 ... which I understand is looking to locate the text anywhere in the string. But this is where I thought there was a technique that could be applied. I've tried using apostrophes around the keyword and a equal sign prefix, bu…
-
- 5 replies
- 1.3k views
-
-
hello can someone help i need a drop down list what im looking for example if i type legal all the record with legal should be in drop down
-
-
- 6 replies
- 1.7k views
-
-
I have ongoing operator script of templates saved in folder file names, using a picklist to select I suppose i can put in 20+ fields to show etc.. I want to show on single single field in one layout.. Wondering if i can pull in each individual text data to a field all ascii text files or even a Clipboard TIA Rod
-
-
- 5 replies
- 1.7k views
-
-
Disregard.. where in heck can i remove this... so i write this.  I solved my Dial out to through a voip provider.. using IWP as suspected.  By just opening a certain URL assigned to me, auto triggers myself as a agent to Dial via assigned url.. I edit on the fly with a dialing phone#. The hosting Voip provider, thus dialing out any number of phone#, like our FM Dial command for my messaging application I simply use a softphone to talk.
-
- 0 replies
- 2.5k views
-
-
I'm a software developer, but pretty new to FileMaker, and have been stumbling my way through building a daily assignment scheduling system for students from scratch. Yesterday when setting up a new layout, I encountered a maddening portal behavior in FileMaker 12 that I cannot figure out at all: On one of my layouts, I am able to edit fields in a certain portal row. In another layout, in an apparently identical portal, I cannot edit the fields. Based on my examination every property of the two layouts, controls, table occurrences, there is no difference that I can detect between the two layouts: - The field behavior allows data entry in both layouts. - …
-
- 2 replies
- 4.8k views
-
-
Hi, I am trying to change the layout that loads when I first enter my database. This seems like it would be rather simple but I've been trying to figure it out for a while without any luck. I changed it under File-> File Options and that works for a second but then the original layout comes back immediately without any user interaction. Any help would be greatly appreciated. Thanks!
-
-
- 2 replies
- 1.1k views
-
-
A number of our users increase magnification of layouts. This sometimes means that to view elements at the right hand edge of the layout they have to scroll across. Since we upgraded to FMP12, when they click in a field that they have scrolled across to reach the window immediately scrolls back to the left, so that they have to scroll back to the right to continue entering info in the field. Obviously this is frustrating and time consuming. Has anyone else encountered this issue?
-
- 2 replies
- 955 views
-
-
Is there a InUse_Record like command? I have a CMR.. and multi agents are working the file... I need a way to know if a operator already in use on the record, ..if so to bypass to next record not in use All i can think is write my own when in record to occupy a field, when leaving record clear a field, then test is record is occupy before landing on it in my Nav code? or another idea? TIA Rod
-
- 7 replies
- 1.2k views
-
-
Hello my partner what to do a file maker price quote for him self. and asked me for some help. the problem i have with what he want is he has 15 products and etch time he does a new quote all the items will be in the portal so he can go through them all. (so he can offer it to his client) what is the way to do this Tahnks dani
-
- 1 reply
- 801 views
-
-
Hi, I have been looking around how to solve this problem. I have one quotation system that have a related line Items. What I need is to have 3 conditional value lists, all of them depending on the first value selection. Example I will select the MEDIA, then the value list of SPACES and the value list of EDITIONS will depend on the MEDIA. I can send an example file by email to show what I have done so far. (The system didnt allow me to upload the file here) My problem is that in the PRICES, appear all the possible SPACES for the different MEDIA, and not only the prices related to the selected MEDIA. I will appreciate any help. Thanks in advance, …
-
- 0 replies
- 999 views
-
-
As I understand it correctly, if you do conditional formatting, the formula equals either 1 or 0. That is, yes or no. I have a tab I want to hide by changing the fill color to the background of the project. I want to hide it if the person logged in belongs to the Auditor group. I can get the Privilege set with the Get ( AccountPrivilegeSetName ) = "Auditors" But I'm not sure how to pass a yes or no to the formula. IsValid doesnt seem to work I also tried If Get ( AccountPrivilegeSetName ) = "Auditors" Value=1 but that just produces errors. What would yall recommend I use to get the privilege set of the person log…
-
-
- 4 replies
- 932 views
-
-
I have several scripts that open certain database tables in a new window for users. I name these windows "$TableName" & ":" & "$RecordName" for usability. Unfortunately, I have another script that relies on the fact that each window has a unique name, but this is obviously not the case. Is there any way I can get a unique ID or something for the window, rather than referring to it by its name? I know there is a Get (WindowName), but is there something equivalent to what a Get(WindowID) function would do? Is there a way I can use Get (UUID) here? Let me know if more information is required. Thanks.
-
- 7 replies
- 4.2k views
-
-
Hi, I've been trying to understand / research why my "Formatting Bar" continues to check itself even after I've unchecked it!. Upon start up within my startup script where I've chosen to "Hide" tool bar. Yet, no matter what, the "Formatting Bar" continues to recheck itself upon relaunching of applications, huh ?? Now I know the "Formatting Bar" and the "Status Bar" are two different things ... but I just don't understand why the "Formatting Bar" continue to re-check itself upon start up!! How can I STOP it!!! :-) Any assistance in this matter I would be grateful. Please see .pics. One of the .pics is the actual Pull Down Menu where I de-select "…
-
- 1 reply
- 1.1k views
-
-
Anyone here use Dropshadows / box-shadows on their layouts? From what I can tell the only performance impact they have is on the client's rendering, i.e. some poor performance PCs may render a little slower if there are a ton of dropshadows, which honestly doesn't matter to me, just the networking/bandwidth issue (like pushing pictures with the layout). Editing a custom theme CSS file helps with getting the right dropshadows. Also, has anyone had any luck with making text shadows? I've read that tex-shadow is ignored by FMP12. For now I've been stacking text objects with a slight offset to make a "fake" shadow but it's annoying when you have t…
-
-
- 4 replies
- 2.2k views
-
-
I am building a "Magic the Gathering" program. The program has 23,106 records. I am trying to figure out how to use the check box to check more than one card at a time. For instance: Dragonmaze has 248 cards. I own all of them. As you can see on my interface there is a button on the card marked own. I was thinking that I could search for Dragonmaze cards and that would givce me all the cards for that set. Then click over to table and click on the own button at the top and it checks all 248 cards. But I cannot figure it out. Unless someone has a better idea that I need to go with. Thank you. Magic_FMForum.zip
-
- 4 replies
- 1.1k views
-
-
Hi All, I'm new to FM Forums so I hope i'm following all the correct rules and procedures of the site. My Question: - I'm an experienced Microsoft Access User and on a form you can add a 'Combo Box' or 'List Box' that will list all the records for that single form and when one is selected will take you straight to that record. I suppose in a way it's acting like a filter without the need to scroll through all the records on the form individually. I've recently just purchased Filemaker 12 as required to develop a database for web use and trying to do a similar thing with a 'drop down list' on a layout. i.e My table is called 'Primary Schools Directory', a lay…
-
- 17 replies
- 8.4k views
-
-
Hi, I am trying to find the CSS code to disable portal row highlighting. (Filemaker 12 adv) (or change the highlight color) I copied an empty portal (no fields) to the clipboard. Loaded the clipboard into Textmate. Than I can read the fmxmlsnippet of the Filemaker Portal I can change borders, background color etc. (load it back into the clipboard and paste it into Filemaker -works-) But I cannot find the way to disable the highlighting of the portal. There is a line that references to the highlight color but that seems to do nothing when I change it. Any ideas Thanks Henk Rotterdam Holland
-
- 3 replies
- 3.7k views
-
-
Hi Everybody, I am newbie with FM and I have a global variable that contains several values in different lines. I would like to insert automatically these text values in a field as a value list with checkboxes, could anyone help me to solve it? Thank you very much, Wardiam
-
- 5 replies
- 5.7k views
-
-
Morning all.... I will attempt to explain my problem as best as I can, please bare with me. I built my solution a few years back and it's had a few tweaks since. I am now trying to give it a overhaul on the UI. On one of my layouts I have a portal which brings records from [RECIPE] records into a jointable [DISH_RECIPE] This is a many to many relationship: many recipes can be on many menus This has functioned okay - upon clicking on the last portal line a drop down showed a list of all the recipe title fields, pulling in the data from the recipes ID The issue I don't like is that there is thousands of recipe records. What I want to achieve is the portal to display …
-
- 4 replies
- 1.1k views
-
-
Hi, I am trying to find the CSS code to disable portal row highlighting. (Filemaker 12 adv) (or change the highlight color) I copied an empty portal (no fields) to the clipboard. Loaded the clipboard into Textmate. Than I can read the fmxmlsnippet of the Filemaker Portal I can change borders, background color etc. (load it back into the clipboard and paste it into Filemaker -works-) But I cannot find the way to disable the highlighting of the portal. There is a line that references to the highlight color but that seems to do nothing when I change it. Any ideas Thanks Henk Rotterdam Holland
-
- 1 reply
- 999 views
-
-
I have created a database containing 2 tables, 1 being 'customers' the other being 'work info'. The relationship is set too one to many. I have a layout displaying the customers info and have set it up so when I click on a customer it opens a new layout showing the work information related to that customer. Ive placed two buttons at the bottom of the 'work information' layout for up and down but I can't work out how to script these to step up and down the found record set being displayed. The 'customers' table contains a 'pk_customers' number field set to auto. The 'work info' contains a 'pk_job' number field set to auto and a 'fk_customer' number field, link…
-
- 2 replies
- 1.1k views
-
-
Can I change the Custom menu for all layouts at one time??
-
- 3 replies
- 1.2k views
-
-
I am new to Macs and I want to know if there is a way to correct the overlapping of text. In Windows, when the end of a field label, text box, etc. was reached, the text would wrap to the next line like a normal document does. Since I started using a Mac I am getting overlapping instead of wrapping. Is this a Mac issue or a FM issue? Is there any way to fix it? Overlap.tiff
-
- 5 replies
- 1.5k views
-
-
I can not get webviewer to display the listed URL that works fine in IE or Chrome, I must be doing something wrong, encoding maybe, I left out the actual login and password info http://149.5.17.108/fmi/iwp/cgi?dbpath=%2Ffmi%2Fiwp%2Fcgi%3F-db%3DHelp_topics%26-startsession&acct=account&name=accountname&password=password&login=Login&-authdb
-
- 3 replies
- 1.7k views
-
-
Hi Everybody... I recently updated a Filemaker project management solution that's been in use for 5 years. I upgraded it to Filemaker version 12 from 11, and created a brand new graphic user interface for it; totally overhauled the look and feel. The new GUI uses a good amount of imported 72 dpi Adobe Illustrator objects, and the disparity between the size of the old database vs. the size of the new version has raised questions in my mind about the prospective performance of the new version. The database contains around 300 different fields spread across 12 different tables. There are 103 layouts, though of course not every layout is visible to the user, imp…
-
- 5 replies
- 1.7k views
-
-
I am looking for a rich text format field much like Access supports. Does Filemaker have such a thing? Is there a plug-in somewhere?
-
- 0 replies
- 1.2k views
-
-
Numbers reported in sub-summaries in reports are automatically rounded. It would save me an enormous amount of time and effort if there were merely some way to convert those numbers to integers. Since they are showing up in reports, though, it seems to be impossible to perform any calculations on them, and for other reasons it is difficult to convert to an integer elsewhere. Alternately, if it is possible to capture a number displayed in a sub-summary into another field for manipulation that might work too, but again because this is in a report every time I try to capture the number, I end up capturing a number representing the entire found record set, not just t…
-
- 2 replies
- 1.1k views
-
-
I'm modifying a FileMaker 11 template (time billing) and in copying or moving items, they drift on the screen as the layout is enlarged by stretching its borders. I don't know much about this technique, so I can't seem to fix it. I've tried undoing the anchors in the layout palette. Any pointers as to how to fix it?
-
-
- 2 replies
- 1.1k views
-
-
Hi... how to set time in minutes in install on timer script.. i dnt want do like 2 min...
-
-
- 1 reply
- 1.4k views
-
-
I am currently using fm12 on a Mac. I have a field in my database called Selections which uses a value list with 5 options as checkboxes: Option1, Option2, Option3, Option4 and Option5. If I do a search and click the Options1 and Options2 checkboxes, I should find all records where the Selections field has both the Options1 and Options2 checkboxes checked. However, I am getting results where records with Options1 and Options3 checkboxes are checked - I am getting records which do not meet the search criteria. I am thinking: is this a fm12 bug? I started the database using fm8 and have just converted over to fm12. Searches with value lists created when I was u…
-
- 6 replies
- 1.2k views
-
-
Forgive what is obviously very basic beginner stuff, but I can't figure out how to get started. I have a fully populated database (FMP12), now I need to generate a report. I have a table called "Sites" and a table called "Equipment". They are linked by site_id. I need to generate a list of all sites, and what equipment they have. Kind of like this: Site 1: Equip12 Equip24 Equip31 Site 2: Equip54 Equip92 Equip45 etc... The report itself gets a lot more complicated than that, but I'm hoping that if I can just get this first step out of the way I'll be able to figure the rest out. Thanks for your help. If this post i…
-
- 4 replies
- 1.1k views
-
-
ON EDIT: Resolved the problem by using the Resize to Fit script step.
-
-
- 8 replies
- 4k views
-
-
Please Help I need two fields payment and Method The Payment should be dropdown list cash, check and credit card. If i choose Cash in the method field should be Cash (number) f i choose Check in the method field should be Check (number) f i choose Credit Card in the method field should be CC (number)
-
- 1 reply
- 1.1k views
-
-
I have a shipping solution that includes these 2 layouts: -First, a layout for Printing packing slips which is 5-1/2" X 8-1/2" outputting on a dot matrix printer. - Second, a layout for printing individual labels that prints on a thermal printer in a 4" X 6" format. This is my problem: I want to create a PDF of each packing slip which is 5-1/2" X 8-1/2" but wnenever I go to make the PDF, the layout defaults to the 4" X 6" format instead of the 5-1/2" X 8-1/2" layout. I use a script to switch printers without a problem, but whatever I create the PDF of the packing slip layout, it defaults to the 4" X 6" label size, thus cutting off part of the information from the…
-
- 1 reply
- 799 views
-
-
hello everybody, my problem is the following: i have records with numbered index fields like: Record: 1 Index: 10 Record: 2 Index: 20 Record: 3 Index: 25 Record: 4 Index: 27 Record: 5 Index: 30 and i need them replaced with the value of a valuelist like: a,b,c,d,e respecting the sort order of the numberd index field. Basicaly my output should be Record: 1 Index: 10 CalculatedValue: a Record: 2 Index: 20 CalculatedValue: b Record: 3 Index: 25 CalculatedValue: c Record: 4 Index: 27 CalculatedValue: d Record: 5 Index: 30 CalculatedValue: e is there some function to help me? To make it harder i can add that the index field can repeat…
-
- 1 reply
- 1.6k views
-
-
Hey guys, Any body here working on an EMR project like ComChart? I wish he/she is a member/s of this site because I really admire the project. Any idea guys how they make the navigational interface of this filemaker program? Thanks
-
-
- 6 replies
- 2.3k views
-
-
I have designed a new layout in my DB and want to replace the old one with the new one. The problem I'm having is that every time I try to rename the old layout, all the scripts that referenece the old layout, change to the (old layout) new name. And then when I rename the new layout to the old name, the scripts still reference the old layout with new name. IE.. script01 ---> Welcome Layout (rename old layout) Welcome LayoutOLD script01 --> Welcome LayoutOLD (rename new layout) Welcome Layout script01 --> Welcome LayoutOLD So the script will never call the new layout. Last time I designed was in FM3. So please forgive me if it i…
-
- 5 replies
- 1.1k views
-
-
HI, I have one portal in a layout showing the records from a table with no problem. If i place a second portal on a layout and set it to display records from the same table as the first portal it shows nothing. You can add records through it but both portals are showing different data although all the data is in the table. Any ideas how to do this? Thanks
-
- 6 replies
- 1.5k views
-
-
Hi, i have a table called "stock" and portal on the admin layout displays the data from the table no problem. I need to put another portal on the user layout displaying the same data as on the admin layout. I need the portal to show the same data on every record, so when a user goes to next record the stock data is still displayed in the portal. i have tried self join but cannot get the portal on the user layout to show anything at all. Any Ideas?
-
- 2 replies
- 1k views
-
-
Hi. I hope this is the right section for the question. When using calculation List(field) the result is well, a list: Value1 Value2 Value3 Is it possible to get the values to list next to each other? Value1/Value2/Value3 Thanks.
-
-
- 4 replies
- 822 views
-
-
Hi brainiacs, Â Description of the problem is below, but the resulting question is this: Â How do I have a script in one file tell a particular window of another file to "go to record number 50" ? Â Specifics: I have a web viewer with a jquery slider (see attached image). I'm using to replicate Filemaker's record scroller. Â This will only work on a hosted file, not a file running on a local workstation. Â It works by... Â Assume the slider has a minimum value of 1 and a maximum value of 100... Â 1) User moves slider to 50% mark 2) jquery records the slider number (50) 3) jquery calls a script in the file (fmp://207.xxx.xxx.x/hosted_data_file.fmp12…
-
- 3 replies
- 5.1k views
-
-
How does one write a script to auto number a portal row as each new portal is created related to a record? I have an order database that has a portal for line items. I would like to give each line item it's own number. If I have to rely on people to enter the number it happens sporadically. I would like the user to still have the ability to enter the field and change it if they decided that one item should be ahead or before another.
-
- 7 replies
- 9.3k views
-
-
I am looking to implement a a flag that would indicate if any records meet a particular criteria. In the header of a layout I would text to show up red if any record in the table has field1 with a value of "myValue" The idea is that any record that was created by a particular user will be scripted to set field1 with the value of "myValue". I want a flag to show up for a higher level operator to review that record. // Just to express clearly I do not want the flag to only show up on a record that said user has created, but rather a flag to show up on every record to indicated there is a new record somewhere that the higher skilled operator needs to revi…
-
- 2 replies
- 1.5k views
-
-
Hello! I've put a vertical scrollbar on a text field that sometimes has lots of text (extending beyond the visible range of the text field), sometimes very little. Currently the user can't tell by the appearance of the slider whether there's more text available or if they are seeing all there is. The slider fills the full height of the scrollbar regardless of how much text there is. The danger is that the user will miss the 'hidden' notes. The slider does change appearance (as in, gets smaller if there is lots of text available) if the user clicks into the field, but it would be much better if it could show this all the time. Is there a solution? Thank…
-
- 3 replies
- 812 views
-
-
Is there a way to paste information into a field on a webpage within web viewer through FileMaker? Also, is there a way to copy text from the webpage within web viewer? Thank you very much for your help, Fed
-
- 2 replies
- 1.3k views
-
-
Hi everyone, I'm working on a FM database that was created by the predecessor of my position. We are due for an upgrade really soon (FM9 -> 12) and I want to make sure that I clean up the database as much as I can before migrating. The idea is to merge multiple tables into one file rather than having multiple files, and to also establish relations between these tables. Here's a challenge I'm coming up against - my current tables make much use of the "Custom Values" field in the Edit Value List menu. I want to convert it to "Use Values From Field" while using the old value to create links to the related table. For instance, one field has the Custom Value field fil…
-
- 9 replies
- 2.9k views
-
-
Hey guys. I've got 3 individual portal rows that must be populated by three different Value Lists upon creation of a new record. These portal rows track pass/fail tasks that the user must perform on equipment. These pass/fail tasks fall under three different categories. When the user has created the new quality control record for the asset they are testing, I would like them to click a Populate button above each of the three portal rows. I have all the values for these categories placed in their own Value Lists, which upon population, creates related records in their respective portal rows. How can I script FileMaker to pull values from a Value List and create individ…
-
- 3 replies
- 2k views
-
-
Hi All, I have a database attached to this post that has a relationship between table "HOTELS" and table "TOURSv2". On a layout "ROOMINGLIST" (click on the "rooming" button next to the navigation buttons) I have placed a portal where I'd like to put a script on the blue buttons that deletes the according portal row. Why does the master record get deleted as well when I select a portal row and delete it? I only want the portal row to be deleted. The message asks me if I want to delete "that related record" and when I click yes, the master record on layout "GUIDED TOURS" is deleted as well. I have read the manual, have bought the "missing manual", I have searche…
-
- 15 replies
- 4.9k views
-
-
Hi,, Final... after all done.. last test, won't run in XP, my runtime all created in Win 7 using FM ver 12 and to works just fine I even tried creating the Mp3 on my XP,, using 2 different application, conversions etc thinking maybe Codec problem think my mp3 audio file is good Same machine.. I able to dual boot XP to Win7 Running FileMaker ver12 win 7 only I have a container field using inspector heave set data as audio etc In the layout I have the container field, its set as global - should make a differ ? loading it. I have a Insert command pointing to this mp3 file and Go to Field Don't think those 2 fields are n…
-
- 0 replies
- 678 views
-
-
please help me about this i need two fields one is state one is county what im trying to do is if i enter state i need all the county list to another field Ex. if i select AL the county field should be autauga, baldwin etc
-
- 1 reply
- 859 views
-
-
(spoiler alert…they should) Recently, you may have heard a lot of discussion about “HTML5″. I believe HTML5 is a game changer. It can revolutionize the way we design our FileMaker databases. I have spent many years in the FileMaker market. I believe this combination of technologies is going to lead to some of the most dynamic FileMaker Layouts that possibly we’ve ever seen. This is the inception of some very exciting and compelling things are moving forward in the FileMaker world. HTML5 has been deeply etched into the fabric of the industry as “the technology that makes rich web applications”. For my money, I am fine with it. As long as we all understand that wha…
-
- 0 replies
- 3k views
-
-
Seems to be restricted to a particular file but borders and text shading only shows when a record is selected and doesnt print. Maybe I have done something odd? cheers
-
-
- 3 replies
- 1.6k views
-
-
Here is my problem. I have two layouts that are linked together, Master Records and Products. I use a value list to display the status of the Master Record and Products (In work, Proofer, Final) I want the status of the master record to reflect the status of multiple products. So if product records 1,2,and 3 have a status of "in work", the master status is "in work". I want to make it so the status of the record in the Master Records on lt goes to "Final" if all the products statuses are "Final". If one of the products is "In Work" and the other two are "Final" the Master Record record should still show "In Work" Thanks Rob
-
- 10 replies
- 1.3k views
-
-
I am using ExecuteSQL() to gather values and display them as merge variable on buttons. If we attach a button to them, they re-evaluate just by hovering over them (please see attached file). This is new file created for this purpose and I have replicated it in other files as well. The top right grey buttons switch to the correct value as you make changes to the checkbox but then when you hover, the merge variables revert to the prior value. I've solved it (potentially) by using a separate transparent button over them. If the button is separate, the value will not revert. It is only when the button itself has a script attached and you hover on it that the value re…
-
-
- 6 replies
- 1.9k views
-
-
Hi everyone, I am writing an opening script which will go to a certain tab control which contains a portal. This portal contains dates from 2+ years ago and also dates until the end of this year. What I want to do is upon opening, go to the portal row that contains the current date as the first portal row. I have played around with calculations to no avail. I have tried setting a $CurrentDate variable upon starting the script and then setting that field in the portal but i get a dialog box that says "go to record [734976] out of 10. When I press enter I get an error that the number is too high. When I change that number to 10 or less, it carries me to a diffe…
-
- 1 reply
- 798 views
-
-
Hi everyone, This might be a very simple question, but I just couldn't figure out how to change the background color of my layout design? I tried to adjust all kinds of color in the pane, but none of it seemed to be related to the background color. Is "fill" the right one to look into? Thanks a lot!
-
- 5 replies
- 10k views
-
-
Hello, I work from a few months to try to make a database for recording work. The result is in the attached file, but i don't know how to get values list, in layout "Detalhes de Trabalhos" in the tab "Consumos" which the portal is related to the table of the "Materiais". What I wanted to do was select material basis at work by selecting "Categoria", "Descrição" and "Tamanho" after writing the spend amount in "Mt. Liniares" to decrease in stock. I leave the attachment if someone can help greatly thanked. Sorry for the short text but do not know much English writing, hope that the file help to understand the question Thank you very much Cópia de Cópia de Miste…
-
- 2 replies
- 1.3k views
-
-
I love Filemaker and have been using it for years in our Church Boyscout Group called Royal Rangers. You all have helped me from time to time to figure stuff out. I am a phoneman for at&t and by no means a programer. My databases are basic and not fancy.  I have been printing out 400 certificates for the boys for their merit work. It also fills out the order forms and prints off the lists for our Awards Ceremonies.   Last week a guy spent 6 hours using power point to display 200 merits for about 60 boys. It was a hit. I thought well I have the data. I just need to figure out how to put mulitiple merits accross the screen.  Certificates are ea…
-
- 23 replies
- 2.5k views
-
-
The label templates in FMP 8.5 does not include 5366. Called Avery for alternate # that would work for 5366 all alternates also not available in FMP. Will I have to create a layout from scratch and make my own label/layout? I started by formatting the page size, margins etc. However when I started place the merge fields on the layout I realized that when in preview the merge fields will simply repeat the one record. Am I going in the wrong direction? What and how to do this?
-
- 3 replies
- 3.9k views
-
-
I am having an issue regarding Field Values List using related value Table one maintains collectors pieces, each piece has 3 fields use the Contact Id supplied data. Seller Id, Appraiser Id and Buyer Id, [All are numeric fields that are indexed] Table two maintains the contacts information and has a sub-table named Contacts Type – The same source can be a seller, an appraiser and a buyer. This sub-table maintains the Contacts foreign key and the Contact Name field populated via a look-up. I have a defined a self-relationship in the Contacts Type sub-table with 3 constant fields that auto-filled value of seller, appraiser and buyer that respectively relate to…
-
- 0 replies
- 1k views
-
-
I have a layout that has header, subsummary, and footer. It displays fine in browse mode, but I can't scroll the window to the record I want. I can use the scroll window page down, but that doesn't give me control to stop exactly where I want. The user sees the list of subsummaries, then clicks one. That takes the user to a report. Then from the report, they can go back to the list and I want the window to be scrolled to the same place as when they left it. Go to record by calculation and scroll window to selection don't work in this layout. Is there any other way?
-
- 3 replies
- 1.2k views
-
-
Hi, I'm using web viewer to display some formatted text from field and I'm unable to find out how to get same formatting in iwp. In filemaker everything looks correct but in iwp there isn't any word wrapping. I was thinking I'll replace CR with <br> tag but I need functionality in filemaker and in iwp. I've tried safari, chrome, firefox, IE all behave same. Any idea? Thank you AD
-
- 3 replies
- 1.6k views
-
-
I have converted many of my FM 11 files to FM 12 with no problems. However, I do experience a large number of annoyances when working with the converted files in the layout mode. I really can’t tell if these are issues with FM 12 or the conversion processes. Here are some of them. 1. Quite often, objects “jump” and slighlty change position when clicked with the mouse. I have to re-align mannually. The jump is about a pixel. Even being extremely careful when clicking with the mouse doesn't help. 2. Ctrl-Shift-Drag a field does not constrain the duplicate to be line with the original object (as it did in FM 11). It’s off-set is must be positioned manually. This …
-
- 1 reply
- 1.6k views
-
-
I have a text field that holds a text of, let's say,17 lines long. When it has more then 10 lines of text, the surplus of that text has to go to another textfield. So I have textfield A that is 10 lines long (holding 10 lines of text) and a textfield B that is also 10 lines long, but holding 7 lines of text. Regardless of the length of a text line. So I don't have 17 Carriage Returns to identify a line. Just 17 lines of text that could have only 3 Carriage Returns. How can you do this? Appreciate your answer in advance. Wilfred (I have FMpro 12 on Mac)
-
-
- 23 replies
- 3.4k views
-
-
I have an attendance status field which should reset everyday at 23:59 to a blank field. Please advise how to create a condition attached to the field to perform the task? Regards, Kishan
-
- 1 reply
- 1.3k views
-
-
This is genuinely weird.  I have a Members table that is the basis for Members form. On the form is a separate TO of Members that lists, vertically, Member Names. When a member's name is selected a GTRR runs which puts the member information in the main window. This works.  The member portal (Navigation) shows just the Member names. The portal shows a max of 28 names. The problem is if I select member #47, the member is selected and then the elevator jumps to the top.   I have tried to program for this:   And this code works .... As Long As I Am in Debug. Huh? When I run the code in development mode it frequently fails with a jump…
-
-
- 20 replies
- 2.5k views
-
-
Hi! I hope I'm posting this in the right place, and that it isn't TOO simple a question. I'm still a newbie, and am working on a pretty straightforward contact management database in FM Pro 11. Thanks in advance for your help! I need to attach files to quite a few contacts, so I've made a Files tab and added six container fields (and can add more as needed). My problem: I don't know how to add a tiny field next to the tab that shows how many files exist for that contact. I imagine that I'd need to create a function that checks to see which container fields have files, and adds them up. How do I do that? (Also, if there's a better way to attach files to a contact, …
-
-
- 1 reply
- 1.6k views
-
-
I have a Portal that contains 10 Containers. Each Container is a thumbnail picture stored externally. I want to click on the thumbnail and open a large view of picture. I can only get it to work on first container field by opening new window. How do you change the field by caclulation to get different container to show?
-
-
- 5 replies
- 1.2k views
-
-
Is there a way to control the original window? When you open a file, you cannot specify what kind of window opens (FMP12) nor the controls.
-
- 1 reply
- 1.4k views
-
-
Hi All, Is there a way in FileMaker Pro to take a screen capture of the current application UI Layout? The "Print[]" or "Save as PDF[]" script steps will print only the portions of the layout that comes within the print margin. The rest part of the layout will not get printed. I tried with the Screen Capture functionality of "360wroks ScriptMaster plug-in", it works well it takes a screen shot of the entire desktop. But here I want only to capture the current FileMaker Layout window not the desktop backgrounds for example the system task bar, other objects visible at the background of FM application window. I could able to do some calculations to set the…
-
- 2 replies
- 7.7k views
-
-
Hi! I have a 'Days' portal on my 'Sheet' layout ( which shows list of days from a particular month). Requirement: 1. I want to display seven rows in the portal. 2. I want to be able to select a day from the portal and then position it in the middle ( i.e 3 days less than selected day are placed above the selected day and 3 days greater than selected day are below the selected day). 3. Allow scrolling using portal scroll bar. I am able to position the selected day in the middle using a portal filter and a script, however I am not able to enable scrolling using the portal scrollbar. Is there any other way I can achieve this such that the scroll bar will work…
-
-
- 9 replies
- 1.7k views
-
-
Basically I want a simple layout like the picture attached but the question is if I wanted another row underneath the first one without creating a new field in the database, Is this possible with a button?
-
- 9 replies
- 1.3k views
-
-
I was wondering if there was a way to change to List view by using a script? Thanks in advance, Fed
-
- 3 replies
- 988 views
-
-
I am using FM 12 03 in Windows 7. Question: Is there a way to freeze the header on a layout so that when the user scrolls down, the header stays fixed and visible? (Like you can do in Excel) Just wondering... Thanks
-
-
- 5 replies
- 2.4k views
-
-
There is a lot of real estate open from [Preview] to [Aa]. Can this gap be closed?? On my Mac this is a lot of cursor movement. TIA
-
- 1 reply
- 842 views
-
-
I have a layout with a Header part. When I select the Header and press delete I ultimately get this:   I repeated the process 3 times and it happened 3 times.  Â
-
- 0 replies
- 622 views
-
-
im trying to copy a portal to another portal but the script i have only copy the first row , i need all the portal copied . it is possible to copy all the portal records? thanks for your help portal.fmp12.zip
-
- 1 reply
- 967 views
-
-
I want to have a webview that uses either mapquest or google maps that shows the mileage between two locations, based on "To" & "From" fields in Filemaker. I'm having trouble figuring out how the syntax works. I do have on another layout with a webviewer that interacts with a website and information is fed to & from filemaker so I know it's possible. To sum it up, I want mapquest via filemaker to take the city, state from & to and feed me back the mileage. Any help or guidance would be greatly appreciated! Thank you, Caroline
-
- 4 replies
- 2.9k views
-
-
I have a portal that shows log events as they happen, chronologically. For UI reasons I need the oldest events at the top and the newest at the bottom. I'd like the portal window to keep scrolling down on its own so it always shows the newest event (at the bottom) and as many previous events as would fit. I do not want to have to GoToObject to make this happen; I would like it to do it on its own. I know that I can do it backwards. I.e., if I sort the list in reverse order and have newest on top, then the portal will update on its own, happily showing the newest at the top all the time. But there are other things on the page that show newest on the bottom, so as I said, …
-
-
- 2 replies
- 3.2k views
-
-
Filemaker really has some deficiencies that annoy the cr** out of me. Is this possible, either literally or just 'effectively' (or creatively, using non-layout techniques (I don't know), etc)? I want to have a list layout where one of the fields can sometimes contain a lot of text, or sometimes very little. I really wish the height of this field object would vary to accommodate the amount of text in the field for each record without really going over (or at least have reasonable proportionality - if I have to formulate a way to do it pretty closely based on character count, so be it). (So I can use screen-space well, without having to scroll inside of records)…
-
- 1 reply
- 737 views
-
-
I have one field that I cannot click on for search. I can get to it by Tabbing. All the right boxes are checked, still won't work. Any ideas?? TIA
-
-
- 5 replies
- 1.3k views
-
-
Hey All, So I thought I found a great solution but unfortunately it's not working in IWP and thought maybe some of you would have ideas. Most of our clients access our database through IWP. It would be nice if there was a way for them to store documents related to project records. Using the client I can setup a web viewer to look for a particular folder in dropbox. After an initial login to dropbox, the web viewer will show the project folder according to a formatted project-id as you scroll through the records. I thought excellent! But alas nothing is loading in the webviewer when accessed through IWP. Any thoughts or methods? Thanks in advance. Jon
-
- 2 replies
- 1.6k views
-
-
Enabling tech behind next #filemaker version? http://www.webmonkey.com/2013/04/the-future-of-css-flexbox-is-a-game-changer/
-
- 2 replies
- 1.5k views
-
-
Hi, I imported an Image from my server into webviewer via this.: "data:text/html, <html> <head><img src='" & "http://www.LisaPrice.info/fahrtenbuch/images/" & Buggy Fahrtenbuch::fileversion & "/eingabelocked2.jpg" & "' style='width:100%; height:100%;' /></head> <body style='border: 0; margin: 0'> </body> </html>" The Result is an image without any borders. Works perfect. When I import the image as an html, I keep getting a wireframe, and it seems this wireframe is generated by webviewer. Can anybody help me. My html file behind the Url: "http://www.LisaPrice.info/fahrtenbuch/images/" & B…
-
- 1 reply
- 2.1k views
-
-
Hi All, I'm brand new to Filemaker so I apoligize if this post is confusing in some way. In coming over from MS Access, I'm a little dismayed at how Filemaker handles it's down-down control. Specifically, that with a two field drop-down, the first field (usually an internal ID number) is displayed and not the second field that the user actually chooses from. I’ve seen a number of slick work-arounds like stacking fields on top of one another or suggestions to use the pop-up menu instead. It seems with the advent of the ExecuteSQL function in FM12 that another (perhaps better) work-around is an option. Unfortunately, my knowledge of FM scripting is not yet able to p…
-
- 7 replies
- 3.9k views
-
-
I am using FM Advanced 12 03 on Windows and Mac.   If I attach a custom menu to a script that creates a Preview Window, the ability to page through the found set is grayed out!  Here is the script:   If I don't have a Custom Menu, the user has full access to the Filemaker Menu.  Is there a way to have both the 'record scroll' icon in the Status bar AND have a custom menu?  Thanks for your thoughts.  Â
-
-
- 6 replies
- 3.4k views
-
-
Hi everyone, I believe mine is an old and easy problem and should have been covered in some of the earlier post. But I have search thru this for weeks and don't seems to find anything near the solution I am looking for. So I really hope to get some help here. I have a dropdown box which I want to populate with fields from the same table. Table : Items First Field ItemID : 1,2,3,4,5,10 Second Field : ItemName : BreadFast, Lunch, Dinner,Soccer, Bank Interest, Others Create New Value List - Under File/Manage/ValueList Now what I want is for the dropdown box to display the values in the order as I have type above - (ref : second field)…
-
- 3 replies
- 1.6k views
-
-
Hi, maybe someone can help me with this question. I have three tables set up: Instructor table Instructor PK field Name field Programs Taught table (join table) <----- for many-to-many relationship Instructor FK field (Instructor PK) Program FK field (Program PK) <----- pop-up menu Hire Date field Program table Program PK field Name field Record State field ("Active" or "Inactive") Layout and portal: I have a portal showing the related records from the Programs Taught table on a parent layout based on the Instructor table. The portal has a pop-up menu with a conditional value list to select an existing program from the Program table and set …
-
-
- 1 reply
- 2.8k views
-
-
I'm trying to simply script tab navigation using the commonly-recommended method of naming the tabs as objects, and the using a GoToObject script step. While this certainly works with script buttons placed outside each tab on the tab panel, it doesn't seem to work when placing buttons on the tabs themselves. I.E., I have button on tab 2. It's displayed properly from Tab 1, but when attempt to click on it (from Tab 1) I'm navigated to Tab 2 first. Only then can I actually click on Tab 2's button. If this is standard operating procedure for Tab Panels, then scripted navigation is useless, imo. I mean, I'm scripting the navigation to OVERRIDE the existing tab …
-
-
- 18 replies
- 3.8k views
-
-
Cannot get this script step to work and can't understand why it won't work.
-
- 3 replies
- 1.4k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online