FileMaker Interface Features
-
Hi, I am not sure if this question even goes here, so forgive me if I posted it in the wrong place. What exactly is the benefit of setting up different tables in one database? Right now, I have built a database that I am going to use to manage a collection of artwork, and I have everything - from the item information, provenance information, valuation information, listed in one table. Would to break these different areas up into different tables? If I want to build a seperate area to search just for artist contact information, should this be in another table. Thanks for your help!
-
- 1 reply
- 753 views
-
-
I want a portal to display 4 fields from reccords in my database Basically i have a database of people, and i want a portal to simply show the age, birthday & last name of, for example, everyone with "John" in the specific field. (their name) How can this be done? i can do it if it were in a different file, but where i want it displayed and the table are both in the same file.
-
- 1 reply
- 954 views
-
-
Hi. I want to have a certain summary field in a record/table the summary should be like the sum of all records's field "amount" where field "deal_id" equals that record's "deal_id" field. I couldn't find how to do so in the basic sumary field options. thanks for your help, it is really important. yaron.
-
- 4 replies
- 900 views
-
-
I have Cases and Products (many-to-many); so I have a join table: CaseID ----< [CaseID|ProductID] >----- ProductID In the Case Table I have a field: zg_CaseID (global filter), set to a current Case ID. On a layout tied to the CASE TO I can display a portal with the related Products (from the Case_CPJoin_Product TO). What I'm struggle with is that I want to show those Products NOT related to the current Case (thus the user can select from this list without seeing the products already assigned to the current case, avoiding duplicate assignments). See attached picture (yes I know the TO name is messed up!). TIA
-
- 5 replies
- 1.1k views
-
-
Hi guys, and good morning. I have a small question hopefully Ill get the answer. Id like to create a button for "Next record" but I want it to take me not to the exact next record but to a record a head where a certain field's value is > 0. I tried several options and couldnt make it work . thanks. Yaron.
-
- 3 replies
- 933 views
-
-
I have created a script using Scripts-> Script maker. how do I attach it to a button? thanks.
-
- 2 replies
- 888 views
-
-
Has anyone been able to drag an image from Web Viewer and drop it into a container field on the same layout? I get the message "This file cannot be opened because it does not belong to this solution". I can drag an image from a separate browser window into the container. And I can cut/paste the image from the Web Viewer into the container. I can even drag text from the Web Viewer into a text field on the same layout. But dragging images from the Web Viewer are a no-go. Any suggestions of something to try?
-
- 4 replies
- 1.7k views
-
-
I would like my users to be able to enter addresses or Lats/Long and be able to click a button and map those point. I would like the map to have IDs for the locations. I have read some different threads in here but am still unclear about the best way to approach this or what extra software is needed. My users are running FM 8.0. I have FM Pro Advanced. All users are server based. Thanks for any input.
-
- 1 reply
- 1.3k views
-
-
This is kinda cool. Make a number field and put some data into it, make it italic, and color it red. Now, enter layout mode and change it to be formatted as currency with 2 places. Go back to browse mode. The field is formatted, but is still red and italic, it continues to match whatever format the source text has. It even works for "Format as Boolean"!
-
- 1 reply
- 742 views
-
-
Hi, What I am attempting to do with a script (without any success so far) is for the db backup to be created in a designated folder and have a sequential number. The db will be a small one and multiple progressive copies will not be a strain on the HD. Example(where Trumpet is the db name) Trumpet.FM7 Trumpet1.FM7 Trumpet2.FM7 Etc. I was told this could be done, but have not found any outside information on how to accomplish a script such as this and the scripts I have attempted will not work. I would like this to happen without any user input other than pressing a "Backup" button. Does anyone know how this can be done, or a link to…
-
- 4 replies
- 813 views
-
-
I hope this question is for the "portal" subject but Ill ask it also in layout. I want to create a ledger. I have 2 logical tables. Checks Due (amount, date) Checks Received (amount date) both of them have foreign key that represent a deal (where the money should be arriving in several payments) and I want a ledger to be created. where the lines are sorted by the date order. and I would have a total down at the bottom (or even a balance field on the right of the line) can I do it with portal? can I do it in a report? should I combine the "receivables" & the "received" tables into one table? I really dont want to do that.
-
- 3 replies
- 1.4k views
-
-
I need to determine if a user entered the DB thru IWP or Remote. I've tried Get(NetworkProtocol)but both return TCP/IP Thanks in advance. Steve
-
- 1 reply
- 1.5k views
-
-
Can I create a field that requires that the user will re-type the input for verification? Im talking about field like in password when most of systems ask the user to type the same password twice to make sure he doesnt make a mistake. Thanks. Yaron
-
- 2 replies
- 889 views
-
-
Posted this in "Relationships" but no reply...so I give it another shot here as I still could not make it work...found something similar here but not quite the same problem, so: I'm working on a db with several files. One file (called "Links.fp7") holds all the links if records from one file are matched with others (like matching a Contact with a Project etc.) and it works just fine. Related data is displayed in protals and also the matching itself happens there. The problem is matching a project to another project. I set up the relationships in the Links-file (see attachment1) and it seems to work fine there. But I can't figure out how to draw the right i…
-
- 4 replies
- 1.1k views
-
-
Hi there, I’m very new to portals, but somehow I find that portals are quite useful to an extend =) I’m creating an image database using tabs, and i had my image data records displayed in the portals, but when I delete a particular record, all my records will be deleted. I tried the delete record script and the direct delete record in the Browse Layout using the Menu bar (, ) but both will delete all my records. Plus, once I do a search, I can’t view all records in the “Image Overview” tab. How do I rectify it? And, is it possible to use a global container to contain the portals? Coz I just want to have 12 images/portals to be viewed at one time, so if I ha…
-
- 2 replies
- 914 views
-
-
Hello I wasn't sure where to post this, I'd like to have a feature where users can browse files on our server then add a link to the file so that when another user clicks on the link it opens to folder containing the file they selected or the file its self we are using only macs. Additionally I'd like them to be able to access this feature via IWP, any ideas or capabilites that aren't present.
-
- 0 replies
- 872 views
-
-
can i somehow prevent from dialogue boxes with the script? for example when in the find mode none record was found and there is a dialogue with three buttons and one of them is "cancel" but i don't want to have this button there because it stops the script. what can i do?
-
- 2 replies
- 806 views
-
-
how can i display high numbers on the layout as an integer, not in a form of real number? sju
-
- 2 replies
- 802 views
-
-
I am trying to create a Real Estate database. For each record (client) there are approximately 10 date fields which I need to monitor. Do I need to create a portal to display the list of dates in chronological order for each client? I am also hoping to have a "summary calendar" which lists all the upcoming dates for all clients on one layout, again in chronological order. Any advice would be grateful, I'm really struggling to work out how I can do this.
-
- 5 replies
- 1k views
-
-
Hello Can filemaker 8.5 do this I wonder? I have a database with a layout with some drop down menus. One of these is Grade and includes: GP Principal/Partner GP Private GP Registrar GP Retainer GP Returner GP Appraiser All of these people are GPs but they're all slightly different. What I'd like to be able to do is search for all GPs. The only way I can think of doing that at the moment is to go into the find mode, choose GP Principal/Partner, create a new request, choose GP Private, and so on down the list. Another way would be to display the Grade field as a check-box field in the find mode. So the field displays as a menu in the browse l…
-
- 2 replies
- 823 views
-
-
I want to create a buttom to place on my layout to continue a script that is paused. Can somebody tell me what script step to use? Marc
-
- 1 reply
- 973 views
-
-
Hi all, I'm trying to figure out a way of sorting a value list in as simple a manner as possible. Here's the scenario: I have 5 tables - Teachers, Assignments, Classes, Enrollment and Students. The Assignments table joins Teachers to Classes via their respective IDs to show which teacher is assigned to which class. The Enrollment table joins students to classes. In a report that lists the students that are enrolled in a given class, I'm showing the teachers' names in the footer by parsing the results of a conditional value list into a "comma+space" separated list. An example would be: Value list = Jane Evans Tom Smith Displays as... …
-
- 9 replies
- 1.4k views
-
-
I have a value list that has grown too large to manage effectivley. Is there a way that the value list can be sorted alphabetically when the pop-up window displays? :/
-
- 1 reply
- 847 views
-
-
Is it possible to load pdfs into the webviewer, that are stored internally, not by a reference? How is this done?
-
- 0 replies
- 1.1k views
-
-
Greetings, Is it possible to insert the current system time into a field via a "click" if not a click is ther a key stroke that could do the same function? What I am attempting to do is have a project start and end time field...while working on the db the user can click the start time and then proceed to add data etc. and when they are finished they click to add the end time. I would guess (newbie guess) that a script could be added to a button to add the time to a field? Thanks, Jim
-
- 2 replies
- 1.1k views
-
-
I want to create a ledger. I have 2 logical tables. Checks Due (amount, date) , id, forign key. Checks Received (amount date) , id, forign key. both of them have foreign key that represent a deal (where the money should be arriving in several payments) and I want a ledger to be created. where the lines are sorted by the date order. and I would have a total down at the bottom (or even a balance field on the right of the line) can I do it in a report? should I combine the "receivables" & the "received" tables into one table? I really dont want to do that. thanks for your help, I know it is not easy question but Im sure there s…
-
- 0 replies
- 1.2k views
-
-
is it possible to disable saving records with enter key? because i need to save records only with hte buttun which resume a script(there i need to check validation of data and then according to it switch the layout). sju
-
- 3 replies
- 903 views
-
-
My demo for FM 8.5 has run out, so I can't test this myself. Is there any way to download a file with the web viewer and have FM save it to a specific location on a local drive? I'm looking at downloading a 100mb file on an automated basis, and then being able to work with that file later in FM. FileMaker will know the URL to get the file, and it'll have a nice spot on a local drive to save the file. I just need FM to handle the download, and it would be nice if it could give the user some kind of progress dialog while it's working. Any ideas?
-
- 1 reply
- 1.3k views
-
-
Greetings, Ok, so I am sitting here slinging out tables and fields, in what I like to call a database-a-palooza. Onlookers can only stare in amazement with their jaws slack and agape at the many marvels I bring forth in FM8. And now back to reality…I am working on a db and all is well, I have reports, I have relationships, I have portals…then I decide I need a “User Defined” field and then it hits me or I have gone completely dumb…I have no idea as to where to start to set up a user defined field. On the db there is a list of about 20-30 known items on the list, and I wanted to add 5 or so “User Defined” fields but I am lost. Do I need to set them up as glo…
-
- 3 replies
- 808 views
-
-
Hey all: I'm new to filemaker and relational databases. I am trying to create an application for handling orders of gift cards. My five tables (so far):/ Customers (customerId, customerFirstName, customerLastName, customerAddress1, customerAddress2, customerCity, customerState, customerZipCode, customerPhone, customerEmailAddress) Vendors (vendorId, vendorName, vendorAddress1, vendorAddress2, vendorCity, vendorState, vendorZipCode, vendorPhone, vendorEmailAddress) Cards (cardId, vendorId <-FK, amount, discount) Orders (orderId, date, customerId <-FK) OrderLineItems (orderLineItemId, orderId <-FK, cardId <-FK) OK, good enough.…
-
- 2 replies
- 793 views
-
-
I want to have a drop down field that has values from another table based on a mach between the tables. can it be done? deeper explanation: I have table A with field "name", filled with 100 records, I have a form where I also have a field "name" , then I want another field called "family name" to be used with drop down list where the "name" here matches the "name" in table A can it be done?
-
- 4 replies
- 952 views
-
-
I have a strange behavior. I have 3 fields which the 3rd ond should be validated to be sum on the 2 others. so I declared calculation validation on the 3rd one. but when I put bad number on the sum field - and add record - I get message (this is ok) when I put bad number in any of the other fields and add the record - I dont get error message and ther record goes in the database. did I do something wrong or it is a known FM bug??? thanks alot.
-
- 6 replies
- 1.1k views
-
-
Hi I want my database to run in full screen kiosk mode, however i cant run it as a runtime solution because its is a database shared over network. is there any way to set database to full screen kiosk mode in normal filemaker 8.5. cheers
-
- 3 replies
- 2k views
-
-
Pressing the ENTER key while in a text field accessed through a web browser creates a small square symbol in the field when the record is viewed via the FM client. Is there any way to prevent this from happening?
-
- 1 reply
- 705 views
-
-
Hi there, Sorry if this has been covered, i could find it anywhere. I'm very new at this and this is my first Database. I've created a task data base for my work. Basically what I want is to be able to show how many days/Mb are left to complete on a per project and per priority basis. The project and priority are set by selecting from a value list pop up menu. So something like: Project A has 200 days of high priority tasks left, 100 med tasks and 300 low priority tasks. Then something similar for the memory lists. I hope that makes sense? james [email protected]
-
- 5 replies
- 1.2k views
-
-
Hello, I have been playing a bit with the webviewer. I am http request to amazon.com to get a picture of a book. http://images.amazon.com/images/P/0595345565.01.MZZZZZZZ The book shows up perfecly in the browser. I want to then store the pic locally. I tried naming the web viewer as a layout object and then using GetLayoutObjectAttribute (objectName;attributeName) to set a container field. However, it only worked with "source" as the second parameter and returned a text string web address. Instead I'd like image stored locally... I tried using "content" as the second parameter but it didn't seem to work. I can drag the image from t…
-
- 2 replies
- 1.7k views
-
-
I searched the forum and couldn’t seem to find this, but I am sure that this has been requested by others. I have a portal and want to show the last related record in the portal. I have People > Jobs (one person to many jobs ) and Jobs> Contracts (one job to many contracts). I have a job portal on a People layout and I would like to display the last contract written off that job. <> I was writing a script and this is what I have so far… but it’s not updating the job_display field GTTR Go to Record/Request/Page ([Last]) Set field [Job::c_display_last_contract;Contract::cn_apptperiod] Go to Layout [“People” (People)] Go to field [Job…
-
- 6 replies
- 1k views
-
-
Hello everyone, this is my problem: I have a field/value list 'Group' in my contact management db (i.e. Supplier, Client,...) formatted as a pop-up list. I would like to have a pop-up list of only the 'Suppliers' from that Group in my second db - purchases. I tried really hard, but being a beginner it is starting to smoke over here ...... I would be grateful for any advice/direcetions. Cheers.
-
- 2 replies
- 688 views
-
-
Is it possible to download images direct into filemaker through Web Viewer or is there still need for third party developers plugs? TMAS
-
- 9 replies
- 3.5k views
-
-
Greetings, Is it possible to “Retire” a record, that is to keep it in the db but not have it recalled via a normal query etc. What I have is an employee table, and I want to be able to “Retire” that employee but keep a record of their information for later use. However, since that employee is no longer around, their information does not need to be included in any currently extracted data for the company. I know I could set a "retired" field which I could omit during a search, I want to know if there is another way? Thanks for any information, Jim
-
- 5 replies
- 856 views
-
-
Hi I am playing around with the web viewer and wondered if it's possible to display a map say from streetmap, multimap and the like based on what UK Postcode is used in a PostCode field? If it is may I ask for an example or even dare to ask exactly how? Hope that makes sense.
-
- 2 replies
- 1.3k views
-
-
I have the FMP 8.5 Advanced edition and I'd like to make a runtime solution that doesn't have the sidebar on the left (so users can only see the navigation I've provided). I noticed that the demo files that came with FMP did not have this sidebar but I can't figure out how to get rid of it (either in runtime or on the guest account). Any ideas?
-
- 1 reply
- 775 views
-
-
I need to have Add Record on, but I don't want buttons in the last row to show (Export File and Delete). As a test I created a calc in a field of the portal file case ( isempty ( THE_Data_Field ) ,"", UI:Delete_Icon ) Works, no delete icon shows on the last "row". I'm just annoyed that I would have do that all over my tables where needed. Aside from the fact that I tested for a single field instead of a record present (TBD), Was there a more logical, easy method? I have a UI file, a Data file, and a FileLibrary (too chicken to store many file attachments to my "real" data.) The UI has image files to use as icons (instead of pasting/inserting on l…
-
- 2 replies
- 808 views
-
-
I'm trying to implement portal filtering in this example and it is not working. I stripped down my example to 2 files: pft_ui.fp7 (the ui file) pft_data.fp7 (the data tables) Base Tables: Cases Status Status Assignment (a Case-Status Join file) I want to display a list of Cases in a portal from a layout (HOME) in the UI file (pft_ui). In this portal I want to show Case ID, Case Name and associated Case Status. I then want to be able to filter on the Case Status to show All, Open, Closed, etc. I've read the other postings and Chapter 16 of SEU FileMaker 7 by Steve Lane, et al., on portal filters. However I can't seem to get …
-
- 2 replies
- 936 views
-
-
I have a field that should be validated against 2 constrictions: 1) not empty 2) calculation and I want the error message write " you must enter a value" when user left it empty, and another message on the other validity failure. can I do this & how. thanks.
-
- 2 replies
- 808 views
-
-
I am new to using the FileMaker TAB layouts. Is there a way to script/navigate moving between tabs so a user can go to a tab layout as the result of a calculation in a script? Thanks, Steve
-
- 3 replies
- 899 views
-
-
i woud like to make new records(with script) in the tables that are no displayed on the layout is it possible? cos i don't want to use switching layouts... thanks for replies sju
-
- 5 replies
- 799 views
-
-
Greetings, I currently have an error message which pops up on a db I am creating…however it does not pop up all the time. On my main page of the db, I have a button attached to a script to open a popup window, which has a portal layout in it. When I attempt to enter data into this portal popup, I get the following error (sometimes)…”This record cannot be modified in this window because it is already being modified in a different window”. Now if I go out of the db and reopen it I can call up this window again and enter data. What did I do wrong? Thanks once again. Jim
-
-
- 2 replies
- 996 views
-
-
Hi, I want to have a portal (cause I need to interact with each lines), displaying all my products broke down by categories like in the pictures attached. I already know to do the categorie only portal (depicted in Categories_tree.jpg). I want to do a portal like "Product_tree.jpg" I have 2 tables one with categories tree and one with "products to categories" It can't be a report, because I need to have it in a layout and I need to interact with each line. It should work in multi-user environement so I guess generating a table for display is out of the question.
-
- 6 replies
- 1.2k views
-
-
Hi, first post on the board. haven't been using filemaker very much although a lot seems somewhat intuitive. my problem is as follows: I have a database with 70k+ posts in a table with 8 columns. let's refer to the columns as A, B, C.. etc. I want to be able to print the results of a search but instead of trying to fit all 8 columns next to each other on a letter sized paper with lots of redundant information if only the A column changes between the posts, I want to use checkboxes. (Or any other bright idea you guys might have). I'd like to use 8 checkboxes to select which of the 8 columns I'd like to print. for example, If I want to print A, B, and F, I'…
-
- 3 replies
- 885 views
-
-
What is the best way to center windows so that when they open (no matter the monitor size) they will always centered on the screen. I realize one will need to use the Move/Resize function. But how can one use Move/Resize to get desired results?
-
- 1 reply
- 759 views
-
-
I have a problem to show the Fields from the "Inventory" tabe to show up in the "Contacts" Table. I created the "Inventory" fields in the contact table but none show, is it a relation problem? How can I get those relations to work? Thanks for the help Thomas Graph.pdf
-
- 7 replies
- 938 views
-
-
I am trying to use something like the example of "Web Viewer example" for displaying the PDF files, but using the FM server. What would be the address to use to display the PDF on a PC using the Open URL ? is it something like this ? it does't seem to work ?? "fmnet://192.168.0.104/Data/Databases/Folder_name/file_name" I want to keep the files in a folder named something like "Folder_name" that is located in the same folder of my DB that is located in the server folder "Databases" . Any help greatly appriciated. Xoomaster
-
- 6 replies
- 2.6k views
-
-
Hello - this is my first post so forgive me if I miss some kind of protocol - but I need some help. I am trying to create a spreadsheet style report which shows which classes students have attended in a semester. The report needs to show along the left column the names of students (from table:Students). The columns needs to be the specific classes (from related table:Classes). This is a many to many relationship created by a join table (table: Student2Class) which stores information on whether they attended the class or not. Obviously I could do this with a summary report of each student which then lists the classes he/she attended. However, the user wants to vi…
-
- 5 replies
- 973 views
-
-
I have a TO with the classes I teach. Each class/semester is a different record in that table. They all have unique IDs and are all labeled by the dates they are taught. What I want is to have a portal in a different TO that will show all the classes I am teaching this semester. I will use a drop down menu on that layout to pick which semester I want to see. Any and all help I can get is appreciated.
-
- 1 reply
- 763 views
-
-
I have a database that uses about 20 layouts. Each layout has a header section that contains links to every one of the other pages. This is akin to a webpage that has navigation links at the top. Using a website as analogy, when designing a website I can use a template that every page uses. If I add a new page or delete a page, I merely change the template and the changes propogate to all pages that use that template. Is there a comparable mechanism in FileMaker? It gets quite cumbersome to manually change the links on *every* layout if I have to make a change to the links. Cutting and pasting to each layout is still tedious (and silly, anyway). Someone re…
-
- 0 replies
- 569 views
-
-
Can you use the New Window command like a dialog box that floats in front of the original window? When I run the New Window command all the other windows minimize which ruins the effect.
-
- 2 replies
- 754 views
-
-
hi, can somebody help me? i would like to set fields from the table according the current fields in the layout without showing them. but each script step i tried reqires to see the field on the layout
-
- 3 replies
- 876 views
-
-
I have created a custom menu that allows a user to navigate to different layouts. I have a script on one layout that puts the user in find mode when entering the layout. if the user then chooses a menu item, they switch layouts but remain in find mode. is there a way to exit the find mode script when the user selects a menu item (like the option given to buttons and objects "Exit current script")?
-
- 2 replies
- 1.2k views
-
-
I searched the site, but wasn't able to find an answer to the following. I have ten tables in a file, each representing a different facility. The fields in each table are identical. What I need to do is combine data from each table into a consolidated report, but cannot seem to accomplish this. I know I am missing something (please see attached), so it is time to call on the Pros... Thanks, John J.
-
- 3 replies
- 897 views
-
-
Hi All I am trying to make searching easier for my users, so have included a calculation field in my record that just concatenates all text entries for a given record to allow users to just type one query in one box and search against all the fields in that table. However, I have had to expand the database to include a second related table that is viewed as a portal from the main record. Does anyone know of a way that I can include the data from the related records in the portal to the concatenated calculation field? Hope this makes sense - feel free to ask questions if it doesn't... Thanks in advance yoshi
-
- 2 replies
- 756 views
-
-
Greetings, this may be long, but I am hoping that I am clear about the situation and my issue. I have the following: people table job table contract table Relationships: People to job (1 to many) and then job to contract (1 to many) 1 person can have 1 or more jobs…. Each job record could create 1 or more contracts. or 1 person (ie Staff) can have a job record but will never have contract records. I created a report (based on the job table) and scripted a find (that follows rules) to display the appropriate data (there are actually 4 reports – 1 for each quarter. Ie Fall, Summer, Spring, Winter). Problem: It’s not displaying the appropria…
-
- 17 replies
- 3.7k views
-
-
hi i have i don't have enough experience to solve my problem. how can i make the scroll bar of the portal to look like typical mac's scroll bar, not like windows'?
-
- 1 reply
- 797 views
-
-
I'm working with a school that has a FileMaker 7 database. This is a conversion from a FileMaker 5.5 database. The only way spell check works is to be in a field, highlight the contents and then spell check. Check selection, all, record all don't work. I found a reference in a previous post (Topic#136024) where somebody suggested that this was due to copying and pasting entire layouts (graphics and text boxes). That is not the case with this database - the whole database was just converted. Their solution was to duplicate the layouts and then re-add the fields. This solution has 50+ layouts with over 2,600 fields! Any help on how to get the solution to behave would be…
-
- 0 replies
- 706 views
-
-
I've got a date field...with values such as 9/1/1934 12/11/1966 How would I count the number of people that have the same birthday, by date...meaning create a report that provides an export like this: 9/1 312 9/2 278 9/3 289 I know how to do sub-summary reports...but its finding and sorting thats giving me fits. Do I have to break up the date of birth field first to narrow down my set? Ultimately I will have to do an export of all these people who's birthday land on the same day and do a mail merge. I'm using FM8 Thx...
-
- 1 reply
- 1.2k views
-
-
Hello there. I have a database with checkboxes in different layouts. Its a kiosk registration form. I want the final page of the layout display on the checkbox forms that they checked. Its a summary of their purchase and so they can print out a confirmation. I can copy all the fields to that final layout, but it ends up being very long. I don't want to waste paper if they only checked one field and it prints out all of the checkboxes on 3+ pages. Thanks
-
- 16 replies
- 3.2k views
-
-
I have a main layout with two related portals. Portal A has two columns of data. I would like to add a button to the layout to move that data into new rows in Portal B, then be able to add additional rows to Portal B if necessary. Can someone please tell me the best way to copy the data into the second portal? Thanks very much!
-
- 4 replies
- 847 views
-
-
Hi All. I have a portal with several fields, all based on a year. There can be multiple portal rows for any given year. i would like to add another portal on the same layout that will show the sum of a couple of the fields for every year in the first portal. for instance it would look like this: portal 1 2005 | 200 | 100 2005 | 100 | 100 2006 | 50 | 100 Portal 2 2005 | 300 | 200 2006 | 50 | 100 Can anyone help? Thanks!!!
-
- 3 replies
- 1k views
-
-
I have a layout that displays a drop down pulling values from another table. On the layout, when a paritcular item is chosen, I want it's text to change color. Any ideas?
-
- 4 replies
- 1.2k views
-
-
Hi, I have a table with a portal that is the garden variety Main table with sub-list type of thing. I want to create a button that will make a new record in the portal, NOT the main table. How do I do this because I tried to use a button but only adds a new record via the main table. I really need to make this part of the DB all button driven. Thanks Vandy
-
- 2 replies
- 849 views
-
-
My first ever task using FileMaker is to fix bugs in a single application running on 4.1 on Windows. Six related forms all open up nicely, with main displayed and five subordinate forms minimized. All subordinate forms allow layout mode, but Layout is greyed out on the main form's Mode menu. What might the main form have done to disallow layout mode? Thanks, Tony Scandora Tony at AES Systems Corp dot com
-
- 2 replies
- 4k views
-
-
Hi, I was wondering if it is possible to join the text from each field in a portal so you can mail merge it. Eg. Instead of this....(bill and his related records (car,bike and boat on 3 seperate lines) you can actually join the related fields into a field on 1 line seperated by caridge returns??? bill | [email protected] | Car Bike boat If possible you could then mail merge each person and their related records. If it is not joined you only get the first item in the merge. Thanks in advance Beastman
-
- 1 reply
- 719 views
-
-
I have these 2 files connect like relational there is a field called protocol in the Project Tasks (PT) layout Note, that I want to link to Projects (P) you can see I connect them in the view Note Layout [if ask for other file do not need to open just cancel] the thing I cannot do is to put more option of the protocol field or add more Projects to a Project Tasks like 3-4 different for example a field about movie 0056 can be connect to politics 0042 or internet 0044 Any solution? DMAProjects.zip
-
- 13 replies
- 1.3k views
-
-
where do I determine what will be the order of entering fields? (assuming the user will pass them using TAB) thanks guys, especially you - who will answer this question.
-
- 1 reply
- 1.1k views
-
-
Hi. I have some optional fields in a record that can be left blank upon a selection in a previous field which is a checkbox. can I make it that a field will not be valid for editing & colored gray - upon another field's content? thanks. yaron.
-
- 1 reply
- 811 views
-
-
Hi all. I have a conditional set of fields which should be remain inactive unless another data entry box is checkmarked with a NO (the frist question in the screen picture). I want to not only have them visually different (the grayed out area), but to actually restrict the fields from being entered into. conditional_entry.bmp
-
- 5 replies
- 1.1k views
-
-
Hi. I need some guidance: I have two tables, one with event registrations (T1) and one with promotional items (T2). In T1, I have a portal where I select the attendees and then I pull down a list of items that mirror, but are not yet correlated, to T2. I want an inventory field in T2 to decrease as the field in T1 is selected. If you can help, I'd appreciate it. Thanks!
-
- 0 replies
- 753 views
-
-
first of all good morning. yesturday I posted 2 questions and got answers - so this forum works great. now for my very basic question: I want that when user enters a field value - there will be a manipulation on that value and the field will contain something a bit different than what the user typed. when it was easy I just used the field format. but when I need a calculation (like phone number) I dont know the procedure to do it: I believed I need to create 2 fields - one for the input and than a "calculated" one for the formated value. is that true?? (i hope not) if so than what should I do on the layout? put them on on another??? than…
-
- 3 replies
- 913 views
-
-
Is it possible to change the tab background via calculation?? TMAS
-
- 1 reply
- 768 views
-
-
Hi, Im extremly new to filemaker and have the folowing question: Can I make layout that will format my input? for example I enter "abc" and after moving to another field it will be showed/saved as "ABC" (making all the letters upper) same idea - can I enter a phone number 2121119483 and after moving to another field it will format it to (212)111-9483 thanks alot
-
- 1 reply
- 725 views
-
-
Hello you experts. I have a strange need: can I have 'square' radio buttons instead of round ones? can I make the sleection fill 'X' inside rather than filling the circle? If the answer is yes - please show me how... Y
-
- 1 reply
- 764 views
-
-
Hi quick question, i searched but couldn't think of the correct words to use to search for my problem i have a port related to a database, with a list of products in it. on a layout showing a quote form. so my 2 tables are Quote and Products. the portal has a few related products to the quote. i want to take all the product names and put them in 1 feild one under another. "Product1 Product 2 Product 3 " and so on. all i can find is to add numbers together from related records using a calculation feild and the sum function. can i make a loop to get the data out or is there a function that can do this for me?
-
- 2 replies
- 901 views
-
-
Hi, I want to create a multi-criteria portal and I'm having trouble with the logic. I have 3 ordinary text fields in a DB. I want to use global fields based on their indices to 'constrain' or 'filter' the portal. IOW ... I want to enter a word in the 1st global and see all matching records in the portal. When I enter a word in the 2nd global, I'd like the portal to 'constrain' the matching records and the same for the 3rd global. That's hard enough for me ... and I haven't managed it yet ... BUT! I'd also like it, if I could leave the 1st and/or 2nd globals blank and find matching records based on the 2nd and/or 3rd fields. Can anyone give …
-
- 10 replies
- 7.6k views
-
-
Any suggestions about using a pre-existing Flash program with web viewer ? For a lot of us, connecting Flash and FMP and practical examples are all a new world. Any Pro's out there ? Xoomaster
-
- 4 replies
- 1.8k views
-
-
I suppose this may be more of a wish than question as i am almost certain this is not possible. With the event of multiple windows i find it very useful being able to show a navigation list in one window and form layout in another window at the same time. I only wish that I could have the windows on the same level or specify that one could behave much the same way as the toolbar does and float on top. The real benefit of the list and form being seperate is that the list can take advantage if a user has a bigger screen and display more list items (so it wins over a portal in my opinion). Any ideas or comments would be great ... maybe 9 will let us customise …
-
- 2 replies
- 914 views
-
-
HI, I have two tables, 'A' & 'B' Want to copy some records from A to B based on a search . I have touble with the script. Please healp me
-
- 9 replies
- 2.4k views
-
-
While investigating the new Object Name feature of FMP 8.5, I found the LayoutObjectNames function. Here's a brief description from the help: I've used this function in a Custom Function that determines whether a specific object name is defined in the current layout. I'm curious whether anyone has found any other use for this function.
-
- 0 replies
- 965 views
-
-
Hello,a beginner here . I have portal showing customer/invoice no./order no. I want to be able to click on a specific order no, and that will allow me to bring up all records showing same order number. thanks preferably put it in another portal buy opening a layout would be acceptable
-
- 17 replies
- 2.7k views
-
-
I am doing an extensive data cleaning project with some end users. For one of the meetings that we are having, I would like to deisgn a layout where the potentially probelmatic fields are highlighted in some manner. My idea is to create a corresponding calc field for each field, which has a value of 0 or 1 based on whether the contents of the test field are considered valid. How can I set-up a layout so that the problematic fields look visually different (i.e. different text or bg color)? Thanks in advance! Courtney
-
- 10 replies
- 1.3k views
-
-
Hi, I'd appreciate some advice on how much effort to expend trying to fake a List view using a portal. Perhaps this topic belongs in Portals forum, but the only reason I'm trying to use a portal in this manner is that a tabbed layout doesn't accomodate multiple View types, and other tabs require Form view. The app (I mean, solution) is a simple Contacts db. Two tabs are Edit and Add, for working with an individual contact. Another tab is Find, for searching for contacts. And the last tab is List, which shows a "list" of summary lines for each record in the found set. You click on a summary line and auto-navigate to the Edit tab. I want the niceties that a…
-
- 4 replies
- 1.8k views
-
-
We have developped a fairly complex solution to help manage restaurants called BC Resto. Our main layout displays several portals linked to different tables. Unfortunately we are experiencing severe slowdowns when our program is used on a PC : On Windows XP, whenever we change something on the screen (adding a record, modifing a field and commiting for exampe) all of the screen redraws (even on top of the line brand new PCs) On the Mac, only the modified portal/record/field redraws. Is this a BUG ? Is there a way to change the way Filemaker redraws the screen ? Could someone attending devconf ask a Filemaker engineer what is going wrong ? You can d…
-
- 0 replies
- 1.2k views
-
-
I've been using FM since v. 4, and from the beginning I noticed that many of the sample files would split buttons up into a graphic showing a button, and an invisible area beneath (above?) the graphic that had the actual button functionality. Another question on the Forums got me thinking about this practice (since the invisible areas were not lining up with the graphics in IWP), and I confess I have no idea why this practice was ever used. Why wouldn't a developer just set the graphic up as a button? Could someone shed light on the practice? TIA, David
-
- 2 replies
- 733 views
-
-
Is there an easy way to have it so that when I double click a related record from a portal it will open that record in a different specified layout? I don't see any simple way to do this in the portal setup or behavior. I tried to search for this in the forums, but it's a bit hard since I can't sort the search results by relevance, only the newest records come up at the front, but I'm sure this has been asked before. Perhaps relevance can be added to the searches in the forums so more questions are not duplicated. Or if I'm missing how to do that, let me know. Thanks
-
- 1 reply
- 1.4k views
-
-
I'm using filemaker 8.5 pro, and I have started with one of the creative pro job tracking templates. After making lots of changes, I now realize that it is necessary to add another table, which means another tab, etc. This would mean changing the nav menu on every single layout, a painstaking task. Is there any way to automate this task by only changing one part, and having it update the others by automation?
-
- 7 replies
- 1k views
-
-
Hi Guys I have a relational DB that uses a left hand colum of navigation as well as the header. I need to create a list view for companies using about 5 fields but obviously cannot use the standard list layout as it runs edge to edge. I have tried using a portal but no matter what I do I can only get the details from one record to show on the first line of the portal. i.e. not all 200 records. Can anyone help
-
- 10 replies
- 1.2k views
-
-
I have what I hope is a simple problem. I have a report that prints, among other things, images through a portal. The portal has three rows (the only field on each row is *picture*), and is set to slide if there is less than three photos. My problem is that one extra row prints when there is less than three. So, if there are three photos, they print, if there are two, three rows still print, but the third is blank, if there is one photo the second row shows up blank, and if there are no photos one blank row shows up. Any suggestions? Thanks!
-
- 5 replies
- 838 views
-
-
I'm getting in a muddle with my tooltips here. I want users to be able to tick a box if they want the tooltips turned on. I created a global field 'novice' (yes/no radio buttons). Then I've been using a calculation in the tooltip itself If (gNovice = "yes"; FieldComment ("name"); "") However this doesn't always trigger the tooltips to work (- it does sometimes!) But I assume I've got this a bit wrong somewhere. Can someone help please? Rosemarie.
-
- 2 replies
- 1.9k views
-
-
Has anyone else experienced problems with popup menu's or drop down lists not popping up? We have two Mac's (G5 PowerPC OSX 10.3.9 and iMac OSX 10.4.7) on which the ‘GoTo Field’ script step does NOT pop-up the value list. Drop-down lists are OK, it’s just the pop-up menus. On PC's both types of list pop-up with the 'GoTo Field' step. However we did have one PC (running XP Pro) stop popping-up on lists and menus and I don’t know why. I think it went into Standby or Hibernation because the user left it on overnight and a complete restart fixed the problem. The PC problem could just be a fluke, but the Mac problem is annoying. Does anyone know how I can f…
-
- 3 replies
- 1.2k views
-
-
am I right in thinking that to get a tri-lingual db, the only way is to copy all the layouts twice, rename them, change the labels and adapt the button scripts so they link to the desired layout of the same language? I just want to be sure not to create an absurdly complex db for a very simple problem. thanks hans peter
-
- 1 reply
- 947 views
-
-
For the last few days I've been working on having FM update a webpage that displays MS Virtual Earth map with data for scheduled jobs and unscheduled jobs. The primary purpose of this is so if an installer is on his way home he can look at the map on the web and maybe pick up a repair job or something on his way home. What I have done is 1) Wrote up the VE webpage. It's not pretty, but it does have the map. 2) Did a whole lot of reading on GeoRSS and it's integration with VE. 3) Figured out how to make the xslt to format the xml exported from filemaker into the GeoRSS xml file that VE needs to display the data on the map on layers. 4) Scripted an FTP upload of…
-
- 2 replies
- 1.3k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online