FileMaker Interface Features
-
I am testing a small amount of data in a FM file on a 2009 MacBook Pro with 4Gb of memory and a 128Gb Solid state drive. The file was 60GB on 9/18 and is now 155.7Gb. I have been entering very little data during this time. I have been working with this file for over a year and a half without anything like this happening. Because I am not entering much data the file has been around 50 to 60Gb for the last year. The slowness occurred at during this same period and I am not talking about slowness regarding processing data. When I make the window larger by dragging the lower right hand corner, it takes approximately 2 seconds to complete. I have run FMDiff to see if…
-
- 10 replies
- 1.7k views
-
-
This question might have a really simple answer but i just can't seem to find the answer by myself. I have a database called phone file which has a bunch of phone numbers we use at the office. Every time someone opens the phone file the window in which it comes up in is really really small. Everyone always has to re size the window so that all the phones are viewable. Is there a way to change the default size in which the database pops up in?
-
- 3 replies
- 1.2k views
-
-
Hi, Is it me or we cannot do conditionnal formatting based on global variables? Check the attached file, it's quite simple. I want to use two buttons to navigate through tabs. The buttons call the "gotoObject (objectName)" Script which set the global variable $$currentObject to the destination object name. The conditionnal formatting must match the $$currentObject. BTW I forgot to add a format to the "Text" button. forum_tab_button.zip
-
- 4 replies
- 3.1k views
-
-
Hi, I have a button: NEW RECORD Now if there is already a record, I would like to change the text into: EDIT RECORD The Problem: I have two tables: FIRST TABLE, SECOND TABLE The button is on the layout of the FIRST TABLE and if I klick it goes to layout of SECOND TABLE and will create a related record in the SECOND TABLE. How could I check if there is already a related record? (It's a one to one relationship) THX by ChiSao
-
- 2 replies
- 1.5k views
-
-
I'm having a problem with the webviewer, in that I cannot see anything on it at all. This just started happening, and I have no idea why! Even if I go in and hardcode the URL, to something like www.filemaker.com or a local file path, nothing happens! Not even a file not found, so I'm disinclined to think it's a connection problem. And no, I am not in find mode by accident. If I try to grab the source, all I get is . This is happening in all files, but only on my computer. Other computers on the network can open the same files without a problem. It used to work just fine, but I don't know exactly when it stopped working. Could I have broken it with a new java …
-
- 0 replies
- 1.3k views
-
-
I'd like to conditionally set the size and location of a field but have had no luck figuring out a way to set the filedBounds values. Any suggestions where I might find info on this?
-
- 1 reply
- 1.3k views
-
-
Dear Professionals, New row for entering portal data is defaulted to be at the very bottom of the list. Is there a way to keep it at the very top?
-
- 4 replies
- 5.1k views
-
-
Hi, Suppose i am generating a report in which 20 records are there. each page contains 10 records. at the end i want to add the signature label. but what i want is that,the label should appear only at the end of report not at the end of every page . plz suggest me how can i handle this issue .
-
- 1 reply
- 938 views
-
-
Hi, I am trying to create a simple inventory tracking solution for our shop. I have started with the template provided in FMP9 and working from their. i have added quantity fields for a count of how many items i have. Id like to create a layout which has 3 (or more?) colums. The colum would populate with all the items in a catagory as selected from a drop down list of categoriesavailable at the top of each colum. (If i dont select a category, no list will apear in the colum) Beside each item in the colum would be a field for a number. This would be the quantity of items i take out of inventory of that item. So, i can go down the list, put the numbers next …
-
- 0 replies
- 926 views
-
-
I am perplexed! I have a few layouts to print CD Jewel labels from a container field. These layouts differ in the rotation of the container field (which holds main content of the case label). I.e. the field is not rotated on one layout, and in another the field is rotated 90degrees depending on how the graphic was scanned. The problem is that on the 90degree rotation it is drastically cropping the edges of the graphic! (See attached screen shots.) Both are exactly the same record, exactly the same field, exactly the same data. I even copied the container field from 0degree layout over to the 90degree layout, rotated it and tried it again --- to preserve setting…
-
- 6 replies
- 3.3k views
-
-
I have made a Welcome screen that opens each time my data base is launched. I have a field that is a set of radio button (Yes – No). I am having a problem writing a script bast on this field as to let the Welcome screen show the next time the data base is launched. Any suggestions would be appreciated.
-
- 2 replies
- 1.4k views
-
-
It seems FM10 will show vertical scrollbars when it doesn’t need to when in browse mode with subsummary parts. See the attached file for more information. Any advice or workarounds would be appreciated. (Thanks also to Comment for providing the code to calculate the number of subsummary parts displayed). subsummary.fp7.zip
-
- 0 replies
- 1.1k views
-
-
Good Day everybody! I have a "big" problem: in my database, one of the layouts contain a portal that display records form the same table. What I am trying to do is just to go to the related record in the same layout(on the right side of the layout I have the portal , and I want to display in the left side the information about the record that I will select) I created a "go" button in the portal that I set it up to a script. The script will just use the filemaker function "Go to related record", but is not workiinnngggg.....not even "Go to Record" is not working! Is there anybody that has some ideas how to make this to work? : :qwery: :qwery: :qwery:
-
- 9 replies
- 9.5k views
-
-
I understand how to filter a portal with a global variable if the layout and portal are both drawing from the same table. But I have a layout that shows records from 1 table and include a portal that displays related records from another table. I want to filter this related portal. For example, table 1 is called Company, with a field (that I want to filter on) called Status. Table 2 is called Investors. A Company can have multiple Investors, and Investors can invest in more than one Company. I have a 3rd table called Shareholders that links the many to many relationship between Companies and Investors. I have a layout that draws records from Investors table. Tha…
-
- 6 replies
- 1.5k views
-
-
im trying to use a dynamic date range on a portal and it does not work. i tried performing a find of 9/25/2009 on the portal and it brings back all the original results on the portal. i can not perform a find from the date field. MORE DETAILS i have an employee table and a work order table the employee layout holds a portal from a relation from the work order table and i would like to perform a date range find to check on weekly status of work orders. But i can not even perform a search so im guessing this is why its not working
-
- 2 replies
- 1.1k views
-
-
I have a functioning system whereby I hide a button using an empty textbox. It works perfectly, except that Filemaker will *not* let me set the "hide" color of the box to match the background. I have tried everything I can think of (using the eyedropper tool, setting the background to a stock color from the color picker and then setting the "hide" color to the same one, letting Filemaker screw up the color of the button and then changing the background to match)... no luck). Filemaker always insists on making the "hide" box darker than the background. This is driving me nuts. What am I missing?
-
- 6 replies
- 1.8k views
-
-
I want to show a table with people who work for the same company. Also what formula what I have to use
-
- 1 reply
- 1.8k views
-
-
I have two tables: project records and outcome recordss. Not every project produces outcomes. I have a functioning button on the projects layout that triggers a script that finds and displays outcomes that cite the currently displayed project as their 'parent'. I would like to exclude this button from the layout if there are no find results. (Or at the very least, change it so that it says "No related outcomes"). It's not good enough to force the user to click and be confronted with "No results". I have two questions: 1. How do I exclude or change the button, based on the value of a variable? Note: this does need to work in IWP, so conditional formatt…
-
- 1 reply
- 1.2k views
-
-
Hi! I have a simple subscribers database w/3 tables: subscribers categories subscribers_categories (many-to-many relationship subscribers to categories) I have a portal that I can use to *see* multiple categories assigned for each subscriber, but I can't *enter* more than one category through the portal. I do have "allow creation of related records" checked. Please help!
-
- 5 replies
- 1.5k views
-
-
I have a container field that I want to set to a global variable which is an image. I would like to go to the object name of the field and set it without checking the "Specifying target field" checkbox. This works - If I set the field and check the "Specifying target field" checkbox. Example (one line of code): Set Field [TimeEntry::ContainerField; $$GlobalImage] This method works for both text fields and container fields. This does not work - I give the field an object name. Then I go to that object and set the field without checking the "Specifying target field" checkbox. Example (two lines of code): Go to Object [Object Name: "ContainerFieldObject"…
-
- 11 replies
- 2.2k views
-
-
Hi I have following tables Job Profile: ID, Designation, Branch[Text],Division[Text]...; Division: _kp_DivisionID, DivisionName; Branch: _kp_BranchID, BranchName, _kf_DivisionID. Division & Branch are related. Now I am trying to create two Drop Down/Popup text fields Division & Branch. Want to select Division and store the Division.DivisionName in "Job Profile".Branch field. So that it remains historical. Then want to select Branch.BranchName filtered by selected Division and store same way in Branch. So to achive that what I should do? Thanks in advance. Haseeb
-
- 2 replies
- 1.2k views
-
-
Hi All, I have a layout with a sub-summary part that works just fine when sorted by the breakfield. What I would really like to do is use some sort of conditional formatting to simulate a "alternating background fill". Here's the difference: I don't want to literally alternate every other row. I want to color them in groups. So, the first subsummary part, and all associated body parts are one color. Then, the next group is an alternate color, and so on. I've searched a lot for this, and haven't found a solution, and I keep running into dead-ends while trying to write a clever conditional formatting statement. Can anyone point me in the right direction?
-
- 4 replies
- 2.9k views
-
-
Here's a very simple question: What is the purpose of the vertical line that shows up on the right side of a layout? You can move it from side to side in layout mode but it doesn't show up in Browse or Preview mode and doesn't seem to effect pagination.
-
- 2 replies
- 1k views
-
-
Hello everyone, I was asked a question by one of our teachers who is working on a FileMaker database and I do not know enough to answer her question. Is there a way to change the currency symbol? Apparently she needs to show Pounds. I am thinking this may be a keyboard issue since all she has is the $ sign. Thank you, Michelle
-
- 4 replies
- 985 views
-
-
I haven't established any custom menus in my file yet...however not all access levels are able to access the same commands! All access levels are currently using the same menu, but some commands are greyed out. I can't figure out why this is... The most important missing commands right now are Control+ArrowKeys (on Mac) to navigate to previous or next records. I can do that no problem with [Full Access] account; but the moment I log into the accounts with restricted access privilege sets these menu commands get greyed out. All privilege sets have "Available Menu Commands" set to All. What am I missing? Thanks!
-
- 0 replies
- 1.7k views
-
-
Hi- I am having a most annoying and frustrating problem with the screen redrawing coupled with a slow checkbox response in FMP10. I have a list layout that has a checkbox with every record. I also have two scripts that allow one to either “Mark” or “Clear” checkboxes in a found set (and a third button that allows one to find a marked set- not a script). When I manually select a check box, FMP first takes a second (or more) to change its focus to that record… then marks the checkbox. If FMPs focus is already on a record, the checkbox response is okay. Manually unmarking the checkbox elicits similar response characteristics (FMP has to “think” about it). …
-
- 2 replies
- 1.5k views
-
-
When I copy fields to a layout, from another layout, the new fields are added to the tab order. These fields, by design, will never be included the tab order, so I have to redo the tab order for the form. Is there a property or attribute that I can assign to these fields which will keep them from being added to the tab order when they are copied to another form?
-
- 0 replies
- 785 views
-
-
Does anyone know where I can find an example to create financial comparisons from "raw" data? Data in my financial table includes: Date Amount Type (income or expense) Category (advertising, consulting, medical, show fees, etc) Vendor Animal Name Pay Type (cash, credit card, etc) Year (calc on Date) Month (calc on date) Sum (total of amount) I want to be able to run dynamic comparison reports, including: Category year to year Category month to month Income vs Expense by years, months) Animal costs by years, months etc.. See report examples attached. Not sure what I need as far as calc and summary fields and/or relatio…
-
- 1 reply
- 1.1k views
-
-
I’m trying to sort records using a more “natural” sort order. By which I mean that given a text field with records: 1 2 10 A B C etc. will sort to user’s expectations (in other words, not like this): 1 10 2 etc. There’s a great algorithm for this: http://www.davekoelle.com/alphanum.html However, implementing in Filemaker is problematic, to say the least. Prior to version 10, filemaker wouldn’t be able to iterate the calculation properly, and even in version 10 it’s incredibly slow. If anyone is interested, attached is a file with sample data, and some attempts at getting this to work. alphanum.fp7.zip
-
- 0 replies
- 1.4k views
-
-
Is there a way to programmatically determine the number of subsummary occurences in list view/browse mode. I have a function that calculates the minimum height of a window (based simply on the layout size and the foundcount). I would like to include subsummaries on this window now in FM10, but I cannot do so without knowing how this will affect the window height. If there’s an easy way to determine the number of times the subsummary will occur given the foundset, then I should be able to factor that into the window height function.
-
- 3 replies
- 1.1k views
-
-
I’ve probably caused this problem myself. I have a Layout based on global field that hold a Yes value. I have a Portal on this layout that show records that have been selected in another layout by clicking on a Checkbox. The relationship is on these two fields. Now, it works. A user can select records by clicking the Checkbox and then go to another Layout that show just the they have selected records. Problem is, it only works in Portal. I need to print out this list and cannot seem to find a way to do it. I thought I would be able to create a Table Occurrence that would just show the selected records, by I get the full Table showing. Can someone offe…
-
- 2 replies
- 1.1k views
-
-
i would like to ask if the ff. is possible in filemaker and how to implement it. i have a database with a field called "degrees" to show degrees earned by the person. it's possible that a person have more than 1 degree. i want that to fill this field, the user will be presented with a window with a list of all possible degrees i define, in some sort of checkbox set, check the degrees applicable and in the end fill the "degrees" field with values separated by commas. thank you
-
- 4 replies
- 1.8k views
-
-
09-28-09 03:16 PM - Post#37516 Hi I am not sure where to post my request. So it may appear in two places. I am new to File Maker Pro 8.5 (never used File Maker before). I am trying to write a script to do the following. If anyone can tell me what to do and how to do it, I would really appreciate it. I have set up a contact database. One layout is a form to enable data entry. Another layout which I have set up is in 'Preview' which is in three columns showing company name, address, phone, fax, etc. I have set it up using the sliding method so that if there are blank fields, no blank lines appear. As the company name and address is self expanat…
-
- 6 replies
- 1.3k views
-
-
I have a portal that when records in it are clicked, it will go to another layout showing more details. When the user returns to the layout with the portal on, it always goes back to the top record. How can I make the portal freeze position so the user goes back to where they were before they moved to the other layout?
-
- 5 replies
- 1.4k views
-
-
Hi All, I have a portal that is filtered using return seperated lists in global fields. I would like to create a print layout to print the information as it is displayed in the portal. Alas I can't just do a find by setting a field with the value of the global it is filtered by. Is there another way to mimic the filtered portal in a print layout? Thanks
-
- 2 replies
- 1.4k views
-
-
This is my first post at this community. I've got a problem with getting text data from web site. If it's just a html web site, you can use "GetLayoutObjectAttribute("web viewer"; content)" to parse all the html written in the web page. But if I do the same thing in order to get text data from the web like http://hoge.com/test.txt, unnecessary text part come with it.( like html header part) I've found the plug-in "Troi URL", with that I can parse the only part of the text I want. But if there is another way to do this without plug-in, that'll be awesome. Because I want to make an exe file with Developer Utility mode. (I guess that making exe file doesn…
-
- 4 replies
- 3.2k views
-
-
I have a value list called "Pricelist". I have a popup showing the value list so that I can select an item. Now I want a script trigger that after someone selects a current category, only the items from this category will be displayed. If I go into the value list editor, I can select "show only related items, …) and this works fine but of course I want to do this in a script step, so that when there is no category selected, it will display all items (if I do this now, it won't display anything based on the relationship).
-
- 7 replies
- 1.9k views
-
-
Is there a way to automatically copy a screen shot of a filemaker layout (that is active) and paste it into a container field?
-
- 3 replies
- 1.2k views
-
-
The attached file is an example of how you can do the following: 1) The active record is automatically highlighted when you access a record 2) Ctrl + click on a record to highlight more than one record at a time 3) Shift + click to highlight all records between the currently active record and the one you click on 4) Click the "View Highlighted" button to view only the highlighted records in a new window 5) now open a new window and do all of the above again - each window has it's own set of highlighted records! All documentation is in the file. Requires FileMaker 10. keywords: highlight current record, hilite row, hilite record, select row, sele…
-
- 12 replies
- 5.8k views
-
-
Hello, I'm D3D1 from Indonesia I using FM9 but I have problem in my ID number at list can't see ID 6700 but I can see ID 6999?.... why it's something wrong?.... /Users/Dedy/Documents/sample.tiff regard D3D1
-
- 0 replies
- 1.1k views
-
-
I need to design a layout for a search page that will display the found set like a portal below the search fields. How do I do that when working from one table only?
-
- 2 replies
- 1.2k views
-
-
I have to databasize a table that is actually presented as a pivot table this way: Company | Year1 | Year2 | .... Company1| Sales | Sales Company2| Sales | Sales Now what i did is make a table Company | Year | Sales| Now even though I can get it sorted as I like they want previous years to appear side by side as above and to make it more interesting the company number varies (Not all companies are present all years) If nothing is possible in excel I guess would need to export to a spreadsheet and move on from there but it would be nice if there where a way to layout it in file-maker even if it might be just for printing Thank for any hint, and for you…
-
- 0 replies
- 2.2k views
-
-
Hello Everyone. I have this FM 10 i have a portal with 35 rows, i have to enter dates into one field i have a button that duplicates these dates then i go back and enter my Dates. I would like to do this. If i have the same date twice i would like it to turn RED with conditional formatting. how do i do it. : :qwery:
-
- 1 reply
- 1.9k views
-
-
Is there a way to do a Replace function that will update all records in a portal, without having to loop through the portal rows? I have an ancestry/progeny relationship going 5-deep (5 generations) that build on each other with a parent-child relationship from the prior generation. It uses a list calculation to match to. The portals work great, but now I need to run a report (by animal) with all associated progeny, including the relationship (son, daughter, grandson.. etc.) I figured out that I can do this in a script by setting a field in the Ancestry table and then selecting that field to retrieve all the records that were set. However, the only way I …
-
- 0 replies
- 1.2k views
-
-
Hi All, I don't know if it is possible but I would like to generate a value list based on a field (Jobs::sets) with a number. If the number is 5 for example, I would like to be able to have a drop down list of numbers 0 - 5 as well as a selection for all. So it might look something like this: -All- 1 2 3 4 5 Any help is greatly appreciated
-
- 5 replies
- 1.5k views
-
-
THis is related to my previous post, but different. I'm wanting to produce an "Activity Report" for a single record in a database. Let's say we're talking about Paintings. I have two child tables off of the Paintings Table -- one keeps track of Exhibition hisotry -- one child record for every time the painting is exhibited, with fields for Date and Location. The other keeps track of Conservation activities, with fields for Date, Type, Status and Note. So on the data entry side, I have two portals on the data entry page so the user can enter these two kinds of activity. Dandy! Now, say I want to produce a layout for printing up All the information about eac…
-
- 5 replies
- 1.3k views
-
-
I do a lot of work with database structures with simple series of one-to-many parent-child tables like: Room > Shelf > Box > Item Let's say I want to allow a user to print out a report that inventories the entire contents of their storage facility, which contains several rooms, etc. (Each Item is in a box on a shelf in a room). I'm finding that my head is spinning a bit with several ways of accessing parent-child data. Should I be creating a List (Field) function on each table that returns a nice list of its child records that can in turn be combined in a List (Field) calc on the next-higher level? Or should I be creating a multi-…
-
- 2 replies
- 952 views
-
-
I have a web viewer that is displaying youtube movies. The problem i have is that the new movies HD size is so big. I would like to see a smaller version to take up less room in the web viewer. Is there anyway to do this and to center the youtube video.Thanks
-
- 0 replies
- 1.1k views
-
-
Hello, I'm trying to build a type of user permission system which will restrict access to specific records and activities (such as exporting data, emailing customers, etc) When a new user is detected in my database currently, it creates a record in a table called "User_Preferences" and stores the Get(AccountName) to the field called Username As training for my assistant, I assigned him the task of creating a new table for personnel records to keep track of employee contact information. I want to link these two together with a field in the personnel table called r_username Is there a way to build the value list so only users in the User_Preferences tabl…
-
- 4 replies
- 1.4k views
-
-
I'm creating an archive of projects realized at the video studio I work at. I don't need/can't use a "day" entry in the DATE field, all I want is " month/year" (mm/yyyy) I've tried custom formatting the date field, but everytime I try to enter a date in Browse mode, FM says : the value of this field must be a valid date within the range of 1 to 4000. the date must look like this dd/mm/yyyy How can I get mm/yyyy date fields?
-
- 3 replies
- 1.2k views
-
-
: FOR SOME REASON THE SCROLL BARS ARE NOT VISIBLE WHEN A PORTAL IS CREATED AND MORE RECORDS ARE AVAILABLE TO VIEW. IF YOU SELECT THE AREA TO THE RIGHT OF THE PORTAL THE RECORDS SCROLL BUT THE SCROLL ARROWS DO NOT APPEAR. I HAVE CHECKED FONTS AND BACKGROUND COLORS ETC... BUT NO JOY ! ANYONE ELSE WITH THIS PROBLEM ? THE SHOW VERTICAL SCROLL BAR IS CHECKED !!!
-
- 3 replies
- 2.3k views
-
-
Is there a way to delete a layout that is no longer needed by using a script, or a OnLayoutLoad trigger? ex. I have first layout as a logon..once user enters correct "code", it moves them on to another layout. I don't want them getting that first layout again ever.
-
- 3 replies
- 1.3k views
-
-
Hi. I use FM 8.5 Advanced. I copied Fields from a file to another. Then I copied a layout from the parent file to the one that have just taken the copied fields but the layout came with the fileds in it blank. (Blank Text fields. Is there a way I can copy a layout from file to file.
-
- 5 replies
- 2.1k views
-
-
Hi. I am using FM 8.5 Advanced. I am looking for a way to help me find and replace field names so that I can change 50 of them to new names the way we do in a word document.
-
- 6 replies
- 1.6k views
-
-
I've seen database solutions with perfect placement of navigation and subnavigation across tons of layouts. There must be some automation tool out there that allows you to build these because doing it by hand is so time consuming. You need to move the navbar a bit or swap two buttons, and you're into it for another couple of hours doing basically nothing. So, what am I missing? I have tried searching for layout automation, auto layout pasting, layout navigation and I'm coming up with nothing. What's the secret here? Thanks much! James
-
- 4 replies
- 1.7k views
-
-
Its an OrderEntry thing// I have a parent ORDER, with 1 child ORDERITEMS that gets its info from 2 child INVENTORY file All the items in my ORderItem file accrue so I can run reports of Posted items When operator checks out buyer, they select MAIN Description using list.. then they select the 2nd List or 'thePackage' ..Now, its depending on package to find the cost and stuffing it to Cost field.. Operator finishes then enters the QTY and it subtotals Can't figure for life of me.... how to get COST field to fill in when selecting the Package?? My sample attached code uses a zippscript to in the Package field and trigger that says "H…
-
- 5 replies
- 1.5k views
-
-
How do you update on a layout design without a user being able to access it while you're still tweaking it and satisfied you want to make it live?
-
- 3 replies
- 1.1k views
-
-
Is there a way you can change the selected and non-selected colours on the tab headers? Currently, the background colours on the tab headers are white (selected) and gray (not-selected). For example I'd like to be able to have the selected tab showing a red background and the non-selected tabs to be white. The fill colour of the tab body should not affected when you switch tabs. Thanks Brian
-
- 3 replies
- 2.7k views
-
-
Hi, I have a many to many relation (patients <-> allergies) Tables: patient, allergy, join_patient_allergy Problem: On the Patient layout I would like to have a checkbox for each allergy. I've looked into the JoinDemo.fp7 (found somewhere in this forum) to better understand this type of relationship. There the solution is a portal but I would like to use the checkboxes and I don't know how. Any ideas? Regards ChiSao
-
- 9 replies
- 3.9k views
-
-
Can someone suggest how I might visually highlight the top three values in a scrollable portal? The portal displays 20 out of a possible 100 records. The "top 3" would be the top ones out of the 100, so at any moment, all or none might be displayed. One alternative I've thought of is to have a script sort the Found Set and individually flag the top three values. The problem is how to trigger the script when there are changes to records. Any suggestions will be appreciated.
-
- 5 replies
- 1.4k views
-
-
Hi All, Is it possible to define a value list which displays one value such as 1, but stores a different value such as Yes? Thanks for any help. A
-
- 6 replies
- 2.2k views
-
-
I haven't used auto-completion option for Field Setups much so I don't know if this qualifies as a feature or just odd behavior... If I type a few characters into a field and it matches multiple entries then they are displayed in a drop-down style as expected. However, if I use the delete key to remove all of the characters then the list does not disappear. Instead all of the prior entries into this field suddenly appear. The behavior is different if the auto-completion feature matched only one prior entry. Deleting the text makes the list disappear (as I would expect). Feature or odd behavior?
-
- 0 replies
- 858 views
-
-
Hello Another strange problem. I have a portal that display Lists of line item. Many prices come from calculations, When I open my file and look at the portal, the calculated result show $0, when I click on the field the price come back. The summary field don't display the calculated price until I click on it. I suppose it come from the unstored calculation that generate the items prices. I can't store them because they come from other calculations. How can I solve this problem? Is there a starting script that I could build to solve that problem? Thank you
-
- 0 replies
- 887 views
-
-
I thought I had this figured out. I have a Layout that is supposed to be in a certain font. So when I created the layout, I configured the field to be a certain font and size. This was working perfectly for 95% of my records. But for some reason, several records are coming in as a different font. I can't determine why. How is the record's Font superceding the field's set font. Any ideas?
-
- 3 replies
- 1.1k views
-
-
Hi - I am wanting to conditionally format an object based on the value of of a GetLayoutObjectAttribute calculation field: Focus = unstored calculation; GetLayoutObjectAttribute("tab_1" ; "isFrontTabPanel") However, the Focus field does not seem to change value in an "unstored" way. When selecting different tabs, it changes on the layout only when I click into the field - but it seems it IS changed in the underlying table because when I click into and then out of the object (another field) that is conditionally formatted (based on the value of Focus), the conditional formatting works... but this does NOT change the displayed value of Focus... and I definite…
-
- 4 replies
- 3.2k views
-
-
Hi, I generally un-check "save record changes automatically" option in data entry list views. But the problem is about serial numbers. Order No field is auto enter serial number field. If the user creates new record and don't save it, record automatically deleted but it does not roll back serial number. I know this is not a bug of FileMaker but it is not the case I want. So, I am searching for a best way to do it. The alternatives that I am considering are: - New record script always set next serial value (this may be slow down in huge data) - Trigger may help about this issue (but there is no onRevert trigger option) - Control new record proc…
-
- 2 replies
- 1.5k views
-
-
Hi I have two tables Division{ID,Name} Branch{ID, Name, fkId_Division, Division Name} Branch::ID, Branch::Name and Branch::Division Name fields are populated. My goal is matching Branch::Division Name with Division::Name, grab the Division:ID and put in Branch::fkId_Division field. Thanks in advance.
-
- 8 replies
- 2.5k views
-
-
I´m using like 20 scripts, all they appear in the menu script, I selected the check box for these scripts in order to use them via shortcut but they only let me use the first 10 scripts!!! I need to use all of them via shortcut, anyone knows how to make or assign a shortcut to all the rest??? thanks Sincerely BluiSh
-
- 1 reply
- 1.8k views
-
-
Hello I have a portal that can be access from a menu on top of it, wich display different categories (to sort the items). In each categories I can add items into the portal using a script. I do not want to allow the creation of records from the portal. I prefer a script because it goes to the related LineItem to get some variable and sets some fields first. Everything goes very well except when the portal is empty. Then I can't get last field information (of course) and I can't find the right way to tell the script something like: if the portal is empty just create a new record in the lineItem. In other words: -my script goes to the last portal row and col…
-
- 3 replies
- 1.1k views
-
-
Attached is a layout I am trying to build that will track multiple items through the development process. The problem is that it runs slow. When the screen "refreshes" the fields rebuild across the screen like dominos falling. There must be a better way to do this, and I am hoping this is the place to get that answer. thanks, idee
-
- 3 replies
- 2k views
-
-
After much puzzlement I am asking for help. I have a portal that works normally in one tab and doesn't work in another tab in the same layout. I just copied and pasted into the other tab. I even pasted it outside the tab so I've got one copy in the tab section and one right next to it outside the tab and the one outside works (displays all related records) whereas the one in the tab only shows one record. I give up. Help please :0
-
- 2 replies
- 1.1k views
-
-
Google offers a free charting API. It is actually pretty cool. Here is a very crude example where I used to produce a pie chart in filemaker. I wanted to share this idea. I think this may be much better and has more functionality than most add-ons that are on the market.
-
- 1 reply
- 1.7k views
-
-
In a layout.. I can make my Number field look like $0.00 fine.. But can't figure.. tried the commands I thought.. my totals look line 10 for $10.00 and 9.5 for $9.50 "Order #" & msg_id & ¶ & msg_All_Items_c & ¶ & "Total items $" & msg_SubTot_Order_c & ¶ & "Discount $" & msg_Tot_Discount_c & ¶ & "Taxable $" & msg_SubTot_taxable_c & ¶ & "Tax $" & msg_Tot_Tax_c & ¶ & "Total Order $" & msg_Tot_Order_c & ¶ & ¶
-
- 7 replies
- 1.8k views
-
-
FM Verion 6.0Dv4 (Mac) How can I enlarge a full layout site up to 175%? Unfortunately FM allows to scale from 150% to 200% only. For my 24" display a view of 175% would be just perfect. Any idea where/how to get that? Thanks. Horrister [email protected]
-
- 1 reply
- 4.5k views
-
-
How do I determine if a record has been saved more than once? I have a field called "RecordStatus" in every table. I want to display the entered user, entered date and entered time in this field. If the record has been edited after the initial entry I want to display (in addition to the entered data fields previously described) the modified user, modified date and modified time. To get the result I want, I have compared the entered user and modified user along with the entered timestamp and the modified timestamp. Since the entered timestamp and the modified timestamp will always be different, all six fields of information show up on every entry. Any ideas?
-
- 2 replies
- 972 views
-
-
I have a button that I created named "Print Barcodes" I have that button assigned to a script. Question: Is there a fast way to change the text on the button. I seem to remember that there is a way. Right now, I am having to unassign the Button Step, change the text, then reassign the button setup. I would just rather change the text while I leave the button setup in place. Thanks, CCB
-
- 2 replies
- 1.4k views
-
-
I am trying to make a Layout that will help me assign lockers in a locker room. If a locker is assigned, I would like the locker number to turn red. I have each locker as a separate record in: LockerTable I have locks in a separate table as I reassign them each year. I have students in another table. Each time I assign a student to a locker, I have a field in the LockerTable that automatically changes to the number 1. I am able to conditionally format the text that I have in this layout, however I only am able to conditionally run this formatting on ONE record. Is their anyway to conditionally format many text items in the same layout however indi…
-
- 1 reply
- 1.1k views
-
-
Hi I have table "Job Profile"(ID, fkId_Classification, "Salary From", "Salary To"...) and Classification(ID[pk], Classification, From, To) My goal is to pick a Classfication from a Drop down list and populates the "Job Profile":"Salary From" n "Salary To" from Classification:From n To. Now the Classification table will be updated from time to time when new salary scales are proposed. But do not want the old "Job Profile" records to be updated. When it is committed its done. New Salary scale(From n To) will only reflect on new records. So to do that what I should do.
-
- 1 reply
- 1.3k views
-
-
Hi guys, New to this forum and this is probably a simple question to get answered but here goes: I have a portal with 2 rows and on each row I have a 'Google Maps' button. What I would like that button to do is grab the data from the 'P/Code' field and then goto the Web viewer layout to display the Postcode data on Google Maps Now the way I have it at the moment works fine for the 1st row only, I cannot for the life of me get it to grab the 'P/Code data' from row 2 or 3...4...5 etc I have tried quite a few scripts and calculations but must admit get lost in the math Image of portal rows: thanks, cheers, Martin
-
- 8 replies
- 2.6k views
-
-
Hi everyone, Hopefully this is a quick and easy one. I have a webviewer that I use to extract some figures from a webpage. The webviewer is in the header. I'm in list view. When I move to a different record the webviewer reloads unnecessarily. If I'm not connected to the net I lose the page I had. Thanks Phil
-
- 2 replies
- 1.3k views
-
-
I am trying to automatically filter out items in a valueslist once a value is selected. Table 1: Animals Field: Herd_ID Field: Name ValuesList = Name from Animals table Table 2: Group Field: Herd_ID Group uses the Names list from Animals to select animals for a selected Group. When a name is selected from the list, the related Animals::Herd_ID is stored in the Group::Herd_ID field. Is there a way to filter out that selected animal from the Names list, so the user cannot select the same animal again? For example: Name List display (1st time): Adam Betty Carl David User selects Carl. New Name Lis display: Adam …
-
- 1 reply
- 1.3k views
-
-
Hi, script A raises a pop window, the user click selects an item in the popw portal row which executes script B. Script B does stuff bts, then closes the popw. Under windows (xp/fm9A), the main layout window is maximised to hide the application window bar. When the popw opens however, the main layout undergoes an 'adjust' behaviour by showing the application window application menu bar. It is not instructed to do so. Under mac (osx6/fm10A) it just raises the pop without changing the presentation on the parent window How does one prevent the main window showing the application menu bar as the popw is opened? Script A #raise popw and …
-
- 2 replies
- 1.5k views
-
-
Hi everybody, I'm a new filemaker user, I would like to ask your help, I have a "Delete button" and I want to protect using a password so that if anyone will use the data base can't delete any of my file how can I do that?. Thank you very much to any help that you can extend. thong
-
- 1 reply
- 1.4k views
-
-
Hi, When I compile a runtime.. incl, check 2nd box to Disable Admin items My runtimes still have the Top FM menu.. where as user if smart enough can click Records and start Deleting.. I played around.. with Set Custom Menu... Is this the pathe others use? ..that seems to help elimited those items... but I wasn't able to keep the 'Insert' for images into a containers.. ANy help or comments how others eliminate the FM top menu
-
- 2 replies
- 1.8k views
-
-
Hi, I'm trying to remove a list of items from a given value list. I tried using some custom functions like AddRemove etc but they only accept single values to remove. Can anyone help me to make a function to produce this? listOfValues = "GSX¶TZR¶CBR¶YZF¶FZR¶CBF" listToRemove ="TZR¶FZR" RemoveListFromList(listOfValues;listToRemove)= "GSX¶CBR¶YZF¶CBF"
-
- 15 replies
- 2.5k views
-
-
I have three databases/tables that all reference each other... a Line Items table with a calculated Quarter field (dependent on the date that the record is created) a Quarters TABLE that automatically generates a new record for each new quarter in the Line Items. a Client table with a list of clients. The clients table is linked to the Line Items table via Client ID. In my Client Database i am trying to display a Quarters portal that lists out quarters that Client has done business with us in, and show a sum of line items for each listed quarter. I am having trouble doing this. I've tried every which way but can't seem to get it. The best I can do …
-
- 5 replies
- 1.6k views
-
-
Is there a way to change the font, style or size of the Window Title? I have tried the available script steps, but none seem to work. This is a trial at changing the size and information. The data changed, but the size did not. TextSize ( Get ( FileName ) & " - " & Get ( LayoutTableName ) & " - " & Get ( LayoutName ) ; 8 ) thanks
-
- 3 replies
- 1.2k views
-
-
I currently have 2 files: Projects and Quotes. In quotes I can add line items, which are based on value lists, if I select from this value list, the field called "cat_a" will fill itself with the number (e.g. 5), see here: http://robin.saestudent.com/Quotes.png When I select 5, next to it, it will also show the second value from the value list (or the name of the item). Now in Project, I have a relationship to Quotes so I can link to the quote as well and adjust it. However, when I import my value lists from the quotes files, and I select it in the portal, it will look like this: http://robin.saestudent.com/Projects.png In other words, the second value of t…
-
- 0 replies
- 1.1k views
-
-
Hello all I am very new to Filemaker, had it a few days. I have been tasked with creating a Data Capturing interface for a Film Shoot. I have managed to create it the data capture interface successfully. Yet now that it is up and running I have a problem. I am approx. 300 records/Entries in and I noticed that my FM file size was over 100MB. This is because when I have been inserting an image I have not been ticking the “Store only a reference file” in the “insert file” interface. So my question is twofold: 1) Can I turn my stored images into reference images with having to re-insert them 2) Can I make a global rule that it will by default it will ins…
-
- 1 reply
- 1k views
-
-
Hi People Is it possible to get a vertical portal, instead of the default horizontal format in FMP? I've got student assessment results that I'd like listed vertically by attempt. So x axis would be "attempt #" and y would be "question #". The resulting data would therefore be result. Any ideas? thanks Cory
-
- 14 replies
- 4.2k views
-
-
I have an odd issue with on of my databases. This is only happening to on of the databases i have on my FileMaker server. When i open the database, instead of being aligned to the left, it opens all the way to the right (see attached screen shot). Is there a setting or variable to change this so it opens aligned on the left like every other database i have? Thanks
-
- 1 reply
- 1.4k views
-
-
Haven't been able to figure out if this is possible - if there is more text than fits within the boundaries of the text box on screen, I'd like to change the background color or give the user some other clue to click on the field and read everything.
-
- 8 replies
- 3.9k views
-
-
I have a container field which has an object name. When I assign a button script to that field, the object name for the container field disappears. If I try to renter the object name for that field, it will not accept it saying that the object name is already in use. Any ideas? Also, is there a way I can attach a sample file to this post?
-
- 5 replies
- 1.3k views
-
-
Hi What I'd like to do with Filemaker is this: Instead of using several tables for static values, I'd like to use one central table. 1) I have a table which is named "codetable" with the fields "id", "domain", "value", "text", "language" This table contains different values, which are usually used for valuelists. For example for a salutation field on my address layout the codetable would have values like "1", "salutation", "1", "Mr.", "1" "2", "salutation", "2", "Mrs.", "1" If I had a status field on the same layout, I'd like to use a valuelist which takes the corresponding values from the codetable "3", "addressstatus", "1", "active", "1" "4"…
-
- 8 replies
- 1.8k views
-
-
I find that navigation scripts to a field is very limited in control. If the button script is any where below the field you like to navigate back to,when you click on the button then that field appears as the first line at the top of the page, not in the center of the page. Likewise when your button is above the intended field, when you click on the button to navigate to that field it appears at the last line at the bottom of the page. Normal thinking or navigation on this should be that you end up with that intended field somewhere in the center of the page/layout your viewing. Please tell me if my thinking is flawed here? Or if I am missing something?
-
- 0 replies
- 1.1k views
-
-
I have a pricelist that is divided into category: 1 Audio 1.1 Editing 1.2 Recording 1.2.1 Engineer for Recording 1.2.2 Studio for Recording … Now I'm creating a quote where the user can select each sublevel, e.g. he can select 2 different items under 1.2.2 called 1.2.2.7 and 1.2.2.8 (these are examples). Now I want to create a simpler view (for the printing), I'd like to only show a header (if there is an item selected inside this subcategory): 1.2.2.7 is selected, so I would want to show 1 Audio 1.2 Recording 1.2.2 Studio for Recording and then the line item. Would this be easy to do in a layout and how (I have many different c…
-
- 0 replies
- 1.1k views
-
-
Can some look at my code.. I have in view 2 records in my portal Attach 2 images 1 looking at userlayout screen other is the code to print or combine format of invoice to single field.. The green screen on very right.. is missing the 2nd or $40 item Code on right resultant only showing the 20$ item from portal first line as seen at green right most screen.. missing the 2 record? ...I am learning by doing.. stepping through its not looping back . fyi, my portal records are not sorted.. (want them in order entered) TIA Rod
-
- 16 replies
- 2.4k views
-
-
I have a field that is a text calculation. What it does is takes several other field's info, and puts it all together here. The problem is, two of my other fields are numbers, that have been formatted as currency, so they show the decimal places and a $ sign. But my calculation in the main field only copies the raw data. I want it to copy the $ and the decimal places.
-
- 2 replies
- 1.5k views
-
-
I searched the values list forum, but could not find this problem mentioned... I have a simple custom value list with 2 items: Process Now Schedule for Future When I select Radio Button to display the list, it truncates the values. I tried different fonts and font sizes and even reversed the order. I tried a horizontal and vertical display and made sure the field is large enough to fit the full value. If I add several spaces to the end of each value, it will display the values. If I add 1 space to the end of each, then it displays Process Schedule I am running on MAC, FMP 10. Anyone have this problem??
-
- 5 replies
- 1.8k views
-
-
How do you stop users from entering restricted data into a field. I am more interested in restricting symbols etc "#,%,@". I found a single post last night but cant seem to bring it up again and I threw away the notes I had started working on a solution. I think the post I saw was about validation by calc. Jim
-
- 4 replies
- 1.4k views
-
Recently Browsing 0
- No registered users viewing this page.