FileMaker Interface Features
-
I have a “main” record layout and users can click on a button which calls a script to open a smaller window to make certain selections from another layout. The results of the selection are seen back on the "main" layout in a portal. I've discovered that I can edit the data in the portal - and it updates back in table - which I really don't want. Is there an easy way to prevent this? I need the users to be able to edit this data - but never from this portal. Thanks in advance, Mark
-
- 3 replies
- 842 views
-
-
I'm brand new at Filemaker (Dev 7), coming from an MS Access/SQL Server background. My database schema contains several many-to-many relationships, represented as usual with a "relationship table". The canonical example is a student table, a class table, and a student_class table. So, given that I have a layout displaying a given student, how do I display the class information for that student, given that the info I wish to display is actually in the class table, but I have to go through the student_class table to get the recordset? Thanks in advance,
-
- 5 replies
- 721 views
-
-
I have a “main” record layout and users can click on a button which calls a script to open a smaller window to make certain selections from another layout. (See the attached PDF.) I then have a button in the smaller window that is labeled "Continue" that does a "Resume Script.” If someone uses the button, all works fine. BUT... ...if they don't use the button and simply close the window by clicking the "X" in the upper right corner of the small window, all SEEMS fine (their selections are made) - except the script is really still left running - as proven by the Script "Continue" & "Cancel" buttons in the Status Area. I don't want this circumstance to ar…
-
- 2 replies
- 827 views
-
-
Ok, I'm about to pull out my hair trying to figure out how to do this. It *should* be simple, but I'm just not getting it. Is there a way to format a calculation field to have leading zero's? For example, if the number is "7", I'd like to see it show up as "07" in the field. If the number is "12", it just shows up as "12". All the fields that are part of the calculation are numbers. Thanks!
-
- 3 replies
- 938 views
-
-
The follwing script works for d > 14 and turns days_return red. However, I cant get it to work for d < 14 and leave days_return black. Any ideas? TIA Ivan If (Return_Date > 1 ; Let (d = Return_Date-InvoiceDate; If ( d > 14; TextColor ( Days_Return ; RGB ( 255 ;0 ; 0)))))
-
- 1 reply
- 690 views
-
-
I have a single portal on my layout where one of the fields is a number field. For each line of the portal I need to show the difference between the numeric value for that record and the previous record. For example Rec Num_Value Diff 1 3 2 5 2 (i.e 5-3) 3 9 4 (i.e 9-5) 4 14 5 (i.e 14-9) 5 21 7 (21-14) etc. The difference field will show the difference between that record and the value in the previous record. I guess it must be via a calculation field but I really dont have any clue how to start Any help please Thanks
-
- 2 replies
- 722 views
-
-
I put myself down as an intermediate skilled FileMaker but I am for sure in the newbie funk. Despite some time with Filemaker and a deep history with scripting in a number of other apps FileMaker always manges to stump me. The hardest area for me to understand is the way scripts work with the interface objects. I bought a very good book from Que publishers, "Using FileMaker 7" but it is somewhat advanced for me in a lot of areas. The book states (page 264) that you can attach and trigger a script from any layout element but does not go into it. This where I am stuck because I can only see buttuns as doing that. My interface problem... I need to have an element t…
-
- 2 replies
- 888 views
-
-
Dear FM Experts, I have a major problem with my database with needs to be web published. I've defined value lists that displays values from 2 fields, it works perfectly fine until I web published it. Only values from the first field showed up. For example, I have a departments value list, with the first field being the department number and the second field being the department name. I can't just display the department name only because I used the department number to look up other things about the department. Also I've defined fields such that when I select the department, a description for the department is automatically entered. This functionality is also go…
-
- 13 replies
- 1.3k views
-
-
Hello filemaker veterans, Filemaker cant display the mother data for subsequent rows of portal data when ported to excel, but only the first one (portal row data). I am sure this is a bug. Try it export any portal data with multiple rows to excel and some data from the mother file - and look what happens! first row id 1 - mother data.....portal data - sweet! the rest of the rows id 1 - mother data blank - portal data visible - bad! where is my mother data? this guys is having the same problem too http://www.dbforums.com/archive/index.php/t-1175557.html
-
- 5 replies
- 714 views
-
-
hi is it possible that filemaker changes the font color all by him self? so that i could set the numbers from 0 - 30 to be shown in red and 30-60 in green?? thx Gilo
-
- 2 replies
- 844 views
-
-
all, been reading posts here the past week (since i've started with FM7) and i've found it truly valuable. thank you! been able to accomplish most everything so far, except for this challenging requirement. thought one of you may know of a solution. i've got 3 tables -- location, group, and permissions. the location and group tables are simply lists of possible entries, and are not "user-editable". the permissions table has a primary key of loc_id + group_id, and has a 3rd column of a permission value. it will contain a cartesian product of all location+group combos, plus the corresponding permissions value for each combo. i'm trying to create a form …
-
- 8 replies
- 1.2k views
-
-
I have a value list that is populated with values from a field. This field holds about 30 values but the pop up value list will only display 16 without additional scrolling. Is there a way to increase how many values can be displayed at one time without scrolling? Thanks, Jarvis
-
- 6 replies
- 835 views
-
-
Lets say there is a Company table and a Employee table. Company Table fields: CompanyID Company Name Company Address gStatus etc Employee Table fields: EmployeeID CompanyID Employee First Name Employee Last Name Status etc If I wanted to have a portal show the records of the contacts for each company, with a radio button for full-time status and part-time status, its no problem as, I can have the relationship match on CompanyID and gStatus to Status. Now the problem is that I want the user to be able to select an option to show ALL the employees regardless of the status. I tried making a match from the gStatus key to a calc…
-
- 4 replies
- 1k views
-
-
Is there a way to open a layout in the body of another layout? I want to open up a list view layout in a custom designed layout workspace. Kind of like frames in html.
-
- 4 replies
- 1k views
-
-
I am cleaning up a FM 7 database with 50 + layouts. I need to delete all layouts except one. I am now deleting one layout at a time from the layout-delete layout menu. This is pretty repetitive and time consuming. Is there a way to select and delete a bunch of layouts at once? I will be doing this same thing one another file soon, so if theres a shortcut it would help me out. thankx
-
- 1 reply
- 717 views
-
-
I have a simple database of company contact information. I want to create a portal to list the firm name of all records. How do I do this?
-
- 5 replies
- 794 views
-
-
Hi First i have to tell you i'm an absolute newbie I'm wanting to start a database of my students so i also want a layout where i can print out the grades of my classes. I manage to do that layout but i'm wanting to be able to print the grades of the different classes. So that i can have a print out of class VII with all the students of that class and there grades. How do i do that? I've got a whole class on one site by using the search function but the i do not get the class name in the header area. Please help Thanx Gilo
-
- 0 replies
- 669 views
-
-
I have two tables related, Calendar and appointments. I have records from Appointments visible in a portal in calendar. I am trying to get a script in calendar to create a new portal row and enter the fields with data from global fields in calendar. It seems to keep writing over the last portal row and not create a new row. How do you create a new portal row (record) and enter data in it? Thanks in advance..
-
- 5 replies
- 968 views
-
-
Hey, I've been developing a rather large soultion entirely on mac in FM7 with but the goal is for it to be used on both PC and Mac. When i was finished on my mac a took the solution to a PC and everything worked excpeted for the graphics, they where all of. Text wouldn't fit on buttons and in fields and so on. So i fixed it. Then i took the PC-file to the pc and network where it should be in use. Here again all the text where changed this time it even looked like an other font than the original one (Helvetica). Plus that some scripts didn't work but this I have not looked further into yet. For exampel it seemed like when i had used Get ( LastMessageChoice ) num…
-
- 2 replies
- 859 views
-
-
Is this right? I've done a bit of a search in the forums and have come to a rather "shocking" conclusion that it can't be done!! I have created my layout for 800x600 rez (at clients request) only to realize it looks like crapp on his new 15" flat screen LCD monitor. The text looks really fuzzy, but graphics better . If he changes his rez to 1024x768 and I use fm's zoom, text looks crisp and clear. But I can't seem to work out a way to zoom into the correct percentage. Apart from the standard zoom options, can you zoom in at 1% increments? If not, can it be done in ver7.??
-
- 1 reply
- 728 views
-
-
I am baffled by this. I place a vertical line, solid colour 3 pixels wide on my layout at the right hand side, almost full height of the visible screen. In Browse mode it is invisible. It is definitely on the top layer and there are no portals or other objects near to it. I now move the line 20 or 30 pixels at a time to the left when it reaches about 400 pixels from the left side it becomes visible. From now there is no problem, I can put it back to the right side of the screen and it is still visible. This behaviour is repeatable on this layout but it does not occur on others (I haven't checked them all). I assumed there was some sort of corruption of the layout so I mad…
-
- 3 replies
- 986 views
-
-
...Layout, in Browse Mode? and Table View? I have a layout 'show all records table' created with 'Table View', to allow the user to sort the fields, if needs be. The user gets to the layout by clicking a button on the main menu. It works fine. BUT, how does the user get back? I cannot find a way to put a button on the layout. Well actually I can, but when I return to browse mode, there is no sign of it. John
-
- 5 replies
- 848 views
-
-
I have an image and a menu on the left hand side of the List View Layout. If I insert this menu into the layout, the body of the layout becomes large and the list becomes spaced apart and my menu repeats as well. Is there a way to insert a menu or other layout objects into the list layout without adjust the spacing between records??
-
- 3 replies
- 842 views
-
-
How do I the results from the portal so I can restrict results limited only to portal records shown? I am building a greyhound racing analysis software for fun and want to limit results. EX. Main layout is Raceform, List 8 dogs in a race Dog 1 Portal pulls in his average speed from Dog Stats database. (matched by dog name) I have an inequitable relationship so the records pulled in the portal show his average speed of races run before the race date, sorted by date, most recent race first. I have 9 portal rows showing, however my field in main layout (average calc formula )averages all his past races. I want the average only to reflect his last 9 races. …
-
- 2 replies
- 681 views
-
-
Does anyone know how to have the field you are dragging TO end up active after the drop instead of leaving the field you are dragging FROM remaining the active field.
-
- 0 replies
- 814 views
-
-
I am trying to size a window that pops open with certain scripts, but I want that window to be very small. I try to resize it in layout mode but can't get it smaller than a certain amount. Is there a setting somewhere to allow windows to be smaller than a certain size? Thanks for the help
-
- 2 replies
- 825 views
-
-
I have a HireDate field for each employee. I have a Pay Class field structured as a Pop up Menu with the following list values: 1. A03 2. A01 3. A06 4. Facility I also have 6 textboxes named the following: 1. Review Dates 1 2. Review Dates 2 3. Review Dates 3 4. Facility Reap 5. Facility P& T 6. Annual Review Note: Review Dates 1, 2, 3 are date fields. Question: Please help!! How do I do this? If user clicks on A03 then Review Dates 1 field should be hiredate + 35 days and Review Dates 2 field should be hireDate + 70 days and Review Dates 3 field should be hireDate + 90 days note: results should be in d…
-
- 2 replies
- 659 views
-
-
Hello there, Is there anybody can tell me how can I manage the highlight color when I press on a button? For exemple a field with a white background and a black text does a black background and a white text when I press on it? Thanks. Dom
-
- 3 replies
- 898 views
-
-
It used to be so easy, hold down the 'alt'-key click on a field in layout view and drag. Et Voilà, I had a new field the way I wanted it to be. Gone in version 7? Or should I use another keyboard combination? Copy/paste is slow and always dragging a field from the field button is really slow too when you're used to the old way of adding a new field to your layout. Thank you for reading and eventually answering this question.
-
- 8 replies
- 923 views
-
-
I have a situation where I would like to highlight specfic records within a portal. If a series of records within a portal has the same data within a specific field. I would like it to stand out some how. Does anyone have any ideas? An example: Let's say I have a portal with five records in it with one field per record. In the field is a food item. Let's say Record 1 has "eggs" Record 2 has "fish" Record 3 has "cake" Record 4 has "eggs" Record 5 has "Turnips" I would like to make the portal highlight eggs because that piece of data has been repeated within the portal. When I mean highlight, I am just looking for any way to highlight i…
-
- 2 replies
- 933 views
-
-
How do you make one of the values in a value list the default value? In particular, I have a field defined with a radio-button value list, and for efficiency one of the choices should be the default. How do I achieve this?
-
- 3 replies
- 776 views
-
-
Is there any way to configure a default field size for a given field, such that whenever I place the field in a new layout it defaults to the size I want, instead of the size FileMaker wants? That would save a lot of time, if I didn't have to manually resize thirty different fields to exact lengths every time I created a new layout. Thanks!
-
- 0 replies
- 706 views
-
-
Ok, I have to admit just switched to 7 and need to develop a new application real fast : Here's my problem. I have a table "values" with values, each value has a category. So I have 3 fields :id,category,value. ex (just to be clear not the real data where cat. are abbreviations): 1-size-mm 2-size-cm 3-size-km 4-color-blue 5-color-red Several fields in the "products" table need to display these values in a value list according to the needed category (size or color). So I have a global which changes to the category I want to appear in the value list through scripting. The relationship works fine! When I check in a portal I see the…
-
- 9 replies
- 1.1k views
-
-
I am constructing a fairly complex database (at least it seems that way to me!), but I have encountered a very simple yet annoying problem along the way. For the purpose of this discussion, I'll only mention the two tables involved in my problem. I have two related files, one is a "Master" file and the other is a "Slave" file. The Master contains a portal that lists all the records in the Slave file. When a field is clicked on the portal, I would like the data from a corresponding Slave field copied into a field on the Master file for searching purposes. Unfortunately, my script only copies the information from the very first record of the Slave file. It seems t…
-
- 2 replies
- 727 views
-
-
I need to create a value list which includes the major languages of the world. Does anyone have such a list, or can you point me to a source for one?
-
- 1 reply
- 735 views
-
-
i have two scripts "accept" and "deny" and depending on which is run at the end of the script it fills in a field with either "accepted" or "denied" but i would also like it to show up bold and green for accepted and bold and red for denied can this be done in the script or do i have to do it another way i have read about it in my book and i have searched it on here and it still doesn't makes sense on what to do, could someone please dumb it down for me thanks vich
-
- 1 reply
- 913 views
-
-
I have a layout which contains field with 16 repetitions. I want to be able to scroll in the fields. Even though I can select "include vertical scroll bar" no scroll bar appears. Is this a known defect/limitation or am I doing something wrong?
-
- 6 replies
- 1.2k views
-
-
I have defined some fields as only enter in Find mode because I want to be able to prevent the user from entering data into the fields. But having done this, scrolling does not appear to work. Can I get scrolling to work and also prevent data entry?
-
- 4 replies
- 759 views
-
-
if anyone has any advice on visual appeal and making layouts visually appealing please help
-
- 12 replies
- 2k views
-
-
I am building a task management solution. It has three fields: PRODUCT > TASK > STATUS PRODUCT is populated with products from pop up value list. TASKS are generated from a value list that is related to the product value list. (If I select (PRODUCT 1) from the first list, the second list displays tasks that are germane only to (PRODUCT 1) etc.) STATUS toggles "complete" or "not complete". [color:red] Is there a way to make the TASK value list display related tasks, but only display the related tasks that are flagged as "not complete" in the STATUS field? Thanks for any help, Jarvis
-
- 2 replies
- 683 views
-
-
I'm wondering if I am taking the wrong overall approach here. The story: The system has three main objects (client, artist and event.) They want to be able to switch to finding on any of these objects while they are in the middle of updating an object. They also want to have advanced validation which I have implemented via scripts. The approach I took was to define 6 windows and for each layout, I defined two versions ... one purely for finding without any validation script, and the other with full update capability and using validation scripts whatever way they exit from a record. I thought this would simplify things. On the FIND layouts I put a button to swi…
-
- 1 reply
- 649 views
-
-
Hi all, I want to graph fied values, number vs. date, from different records. Can I do it and how I'm doing it. Please help. Thanks, Luc [email protected]
-
- 1 reply
- 752 views
-
-
i think this goes here...it involves portals.. if i have records with info similar to the following: apple; red apple; green apple; yellow when i setup a portal in another layout it comes in how i want: apple (title of portal) red green yellow the portal set up isn't really the problem but it the fact that that portal shows up on 3 records shown identically...i hope that makes sense
-
- 5 replies
- 710 views
-
-
I am trying to add data to a filtered portal The setup is as follows table1 is patients and key is patient id table2 is medlist and has many med entries linked to patient by patient id 1st layout is based on patient and has a portal showing all of the med entries for that patient 2nd layout is based on patients and has a filtered portal showing certain med entries that match a global field in table med entry. This is based on a second table occurence of table medlist. The relationship is between patient id and global field = med name eg: global field=aspirin and it will filter the portal to only show aspirin. I want to add a new portal entry…
-
- 2 replies
- 862 views
-
-
Hi, By clicking a button on a portal row, I would like to goto a layout in a related table, the name of the layout is in a field on the same row as the button. ( in fact, the portal contains a list of form letters, so each row in the portal is suppose to open a different layout). How can I get FM to go to to the active row in that portal and take the name of the layout from the field. Without that active row information, of-course FM will goto the first record in the tablet, and take the name of the layout from the field. And the result is that it will always goto the same layout. Have anybody got any good ideas, Thanks.
-
- 23 replies
- 2.9k views
-
-
As the subject states, I would like to create a value list with data from two fields in two different tables. Is this possible?
-
- 2 replies
- 811 views
-
-
Please could someone tell me if there is a way to stop the field value list opening once you have made your selections? I have created a parts file, the first field is called category. You select the category from a drop down value list, from this selection, a drop down list opens in the next field and the next etc. this is ok but once you have selected the parts in all the fields, the first list drops down again at the beginning. Is there a way to stop this?? Many thanks in advance.
-
- 2 replies
- 701 views
-
-
Trying to figure out: I have a database with 4 files. Two are information files that are accessed for two or three fields; one is a line items file and the last is the one that ties them all together (invoicing). My question is, where to design the print layout? If I create it in the last file, it has to be a portal of the line items, but I haven't been able to figure out how to get it to print over multiple pages. When it comes time to print an invoice, how is it done? Also, is there a way to make the first page in one layout (like with logo and mailing window layout) and make the rest of the pages just of the line items info?
-
- 2 replies
- 798 views
-
-
Hi Guys, Sorry if this is not the appropriate area to post this question, but this is my first on this forum. I've already done a search but could not find a useful answer. My problem is white text disappears upon entry into a field. I have a field (text set to white with transparent background) over a dark colored graphic element that I have inserted. Looks cool, but when I select the field to change the text (which is numerical) I can't see the previous entered text. This is a main function of my program - to change the number and re-calculate a fomula. It's important that the user sees the previous data in the field. It's not a problem if …
-
- 6 replies
- 934 views
-
-
Hi, I have a filemaker database that keeps track of tickets for IT requests. I was wondering how I could change it so that once a ticket is closed, it makes the ticket no longer editable. Thanks.
-
- 1 reply
- 694 views
-
-
I got a problem with people entering Carriage returns in text fields. Like in an e-mail field, someone presses [enter] but it creates a 2nd line, so they re-enter the e-mail address. Now when I do an export it has: [email protected][][email protected] (the [] is a box) Sifting through 2000 e-mails looking for this is tedious. Is there something in layouts/field formats that can prevent a carriage return to be entered? Or is it something that is controlled in Define Field? Thanks in advance. FM Version 5, windows 2000
-
- 1 reply
- 738 views
-
-
Hi all I have very little experience in portal but i was wondering is it possible to have a portal to only enter information and not show pass information enter into it. Example: Information enter on 5/12/05 for number of X-ray films expose on a job. Same job different day 5/15/05, want to enter the information for number of x-ray films exposed that day but do not want to see the information from 5/12/05. Is this possible Thanks Lionel
-
- 2 replies
- 676 views
-
-
Hi, all, I tried count (field) and it always return 1 although I changed several fields. Does any one know how to count the total number of records in a database. It should very easy but I just can not get it. thanks.
-
- 6 replies
- 1k views
-
-
Maybe I just can't find a reference to it, but I have a columnar list layout with leading part based upon product. There is no body; only Product and summaries. Of course it needs to sort first by Product. I then select 'sort by summary field' and select Total Sales. But it won't allow me to sort descending!!! Either I'm blind or missing something very basic here or ... ? Sales Manager wants to see all Dollar summaries descending and I couldn't even do it! I'll be switching to a different process soon but until then, he needs these regular reports. Help please!! LaRetta
-
- 3 replies
- 965 views
-
-
I have a field with a value list with A B C D E F each one is a zone for advertising I want a way to count how many checkboxes are checked in this field I Was trying this but does not work! Evaluate ( Substitute ( AD TABLE::GlobalMthZones1 ; 1 ; "+" ) ) Thanks! Tony D.
-
- 2 replies
- 1.8k views
-
-
Hello... For this purpose I'm using 2 tables. A master estmiate log and an Events Log. I'm currently using a portal to display a series of events related to an Estimate... The events are "Bid Due" "Walk Through", etc. and list the date and time of each. I want to be able to pull the "Bid Due" date and time only and show them on the main layout page of my Estimate Log. How would I calculate and/or script going into the portal, finding the field containing the entry "Bid Due" and then pulling the date and time to display in the Estimate Log Table? Thanks. Joe
-
- 8 replies
- 1.6k views
-
-
Is it possible to create a portal that shows records from another table, but filters what is shown by information in the record your currently viewing?
-
- 6 replies
- 948 views
-
-
Hi All How can I count and summarise (i.e.show only once) the number of times a text field appears within a portal. Flook
-
- 2 replies
- 631 views
-
-
Is there any way of sizing a layout to so many pixels across by so many pixels down as you can do to new windows? Frank
-
- 3 replies
- 916 views
-
-
Hello. I've noticed that when I look at my file son other computers, they just do not look the same as on mine (ie development), Is there a way to sciprt this (or any other way) to change depending on the display settings of the computer that it is being ran on?
-
- 2 replies
- 808 views
-
-
I thought I would be able to find something on this but no luck (my search skills are not the best). Is there a way to eliminate the last empty portal row. I have a solution with a portal on a layout that I don't want to appear like it is a portal. The layout in question requires some editing and I only want the user to be able to edit the records that are visible and leaving a blank one on the bottom would allow them to enter something into it. Thanks in advance
-
- 3 replies
- 675 views
-
-
Can anyone help? I'm inserting a merged number field into a letter and its taking the formatting of "format as decimal". How can I change this option as i can't bring up the menu as I would on a field i.e. right click/number format. Additionally, how do I format the today's date i.e. // ? It’s coming up as numbers and I want it in words. Is this possible Many thanks Simon
-
- 2 replies
- 749 views
-
-
Hi all I have created a calculated field using the fields "process & process1" with a carriage return between them. I called this field "list". I created a relationship between the fileds called "process3 & list". Then I made a relationship between the fields "process3 and list" and then created a value list using this relatioship and chose the option use only related value then i attached the value list to the field "process3. the value list is very inconsistance. the list somtines displays the correct value, sometimes it displays an extra value and other times the value list is blank. Any ideas of what iI am doing wrong. I ahve attached an file that i have …
-
- 5 replies
- 820 views
-
-
the boss man wants a portal that displays a graphic...and well i don't know how...alittle help?
-
- 2 replies
- 623 views
-
-
Can anyone help? In my database, I want to be able to make an entry into one field, have the same data copied into a different field in a different layout, but have the data entered one record before the original entry. The Gobblers
-
- 3 replies
- 834 views
-
-
Comment helped me out with my recent difficulty in setting up a self related portal filtered by one field. I am puzzling here all day as to how one would filter a portal via two conditional value lists. Have searched all relevant posts I think] here to no avail. I am conceptually challenged. It must have to do with table occurences and how the relationships are setup, right? Any help appreciated.
-
- 10 replies
- 829 views
-
-
Hi, I have a new solution need your help! Everytime ask you to help, hope you don't ask me to pay you hehe..... My solution is: I open the Quotation to my client and I want this Quotation post to my Invoice...can this done? Thank! Quo._to_Inv.zip
-
- 7 replies
- 904 views
-
-
// RANT ... I might have put this in Wants and Wishes; however, I decided Right Brain (User Interface) seemed more appropriate. I'll get to FileMaker directly about it. I don't have the statistics but I would bet that a third of the world's population is over 35. And since those under (say) age 6 aren't going to be using business applications (our solutions, web etc), that again shifts the numbers. So a vast number of people USING our solutions will have decreased eyesight (for one reason or other; or just naturally). And I'm tired of attempting to read web pages, forums, calculation boxes etc, that use ridiculously small fonts!! The percentage of Users I…
-
- 5 replies
- 1.3k views
-
-
Hello everybody ! I ran into problems with my solution again I have made a vehicle status system in which every unit has to report it's position by radio every 30 minutes. By clicking units symbol on screen a new timestamp and record is made to a log file. If the unit hasn't reported in 30 minutes the symbol turns red. There is about 20 units at the same time. The different units status is shown in one file on portals. Now the problem is that how to refresh the screen every minute so the over dued timestamps turn to red ? I have tried to do it with an eternal loop -script, which refreshes the screen every minute, but it doesn't work, because then you canno…
-
- 2 replies
- 675 views
-
-
Hello All, At our company (packaging industry) we use couple of dozens proof printing profiles. Some of them are assigned to particular clients but some are designed for general use and the CLIENT_ID remains empty. Let's assume that we have an order from client 'X'. One of the required information is the profile. It is chosen from a dynamic list which should contain the profiles of 'X' (having 'X' in CLIENT_ID) and the universal ones (having CLIENT_ID empty). Obviously it is very easy to display one subset of the profiles but how to display both)? How to combine them in one list? I am not quite sure if my description is clear, maybe the attached file cou…
-
- 5 replies
- 819 views
-
-
I would like to get the contents of a "child" portal to appear in a single field in the "parent" table. I am familiar with the method which uses the "get (valuelistitems)" for a value list made up of related values. Is this still the best way to do it, or has anyone discovered an alternative? Also, is there a way to get the nth (i.e. 2nd, 3rd, etc.) row in a "child" portal to appear in a field in the "parent" table? I have no solution for this one. Thank you! DSW
-
- 2 replies
- 800 views
-
-
Hello, I am currently working on a solution that helps medical practices get rid of their paper charts (ChartPACS). Anyway, the solution looks fairly nice on the Mac (I design on a Mac), but I'm having problems with screen flashing on Windows. I've included a stripped-down version of a typical layout. The example file just has tabs that allow you to switch among a few layouts. Some notes about the example file: 1) The striped background initially was a graphic, but I later converted it to a series of lines using Filemaker's built-in line tool. 2) The header graphic was initially just placed in a layout, but I later placed it in a container field. 3) T…
-
- 8 replies
- 1.7k views
-
-
I am making extensive use of container fields to colorize a record based on certain condtions. In MS Excel you have an option to AUTOFIT selection. In this option, the row or column would automatically size itself to accommodate the largest item in the column or row. Is there a way to do something like this in a columnar-type layout? Specifically, I would like to be able to match the height & alignment of my container field with that of the row size. I can affect the size of my container field via the pixel size dialog box but I cannot find a similar dialog box (or method) to control the size of my row. Any ideas? Jarvis
-
- 0 replies
- 793 views
-
-
A customer bought FM7 on the understanding that it would enable them to go from an active layout (creating a new record) and open another layout to browse some data ... without having to complete the data entry. I haven't seen anything which describes this ... does anyone know IFF this is possible ... and if so how?
-
- 13 replies
- 916 views
-
-
:shocked: Hi all I have attached an file I hope will explain what i am trying to do Thanks Louviere sample.zip
-
- 0 replies
- 737 views
-
-
Hello- I have a database with each record being a Purchase order, and a Portal setup to find all the statuses of the line items within that PO from another database with every line open from every Open PO in our system. What I need to figure out is how to export the record so that it will list all of the statuses in that PO which the Portal displays. The ideal output would be PO # - Status 1 - Status 2- Status 3- Status 4, etc also is their a way to filter out repeated statuses in the portals so that it lists each status only once? thanks!
-
- 1 reply
- 638 views
-
-
When in layout mode, is it possible (and if so, where) to hide/unhide the lines that mark the page margin (vertical and horizontal "squiggly" lines)? I know that in layout setup, I can change their placement on the page, but I do not know where to go to hide/unhide them??? I have a database that shows the line and when I email it to a colleague, he cannot see the line. Is there a preference setting somewhere that I am missing? Thanks for the help. D
-
- 0 replies
- 652 views
-
-
This has been addressed in other places on this forum but I haven't been able to follow the solutions provided so I'm asking again: I have a table with an index key (sorry - i'm an access user) that is an autonumber called Physician ID, then a field called FirstName and another called LastName. What I want to be able to do is to have a popup on my layout that shows Physician ID #, lastname, firstname and when I choose one of those physicians listed I would like the other 2 fields populated (LastName, Firstname). If the physician I want isn't listed, I want to be able to input the required names into the 2nd and 3rd fields and have the first field automatically upda…
-
- 2 replies
- 762 views
-
-
I have a solution that created dues forms for the year. I want to be able to save these forms and reference them at a later day if necessary. Is there any way for this to happen? Thanks
-
- 8 replies
- 870 views
-
-
I'm trying to sort portal records using a custom sort order based on a value list. The value list is actually in the same file as the portal records. However, the value list does not sort in the custom order as defined by the value list, but rather alphabetically. The value list is rather long, but it worked in FM6 just fine. I've tried: sorting the portal records via the portal definition sorting the records in the relationship definition Both have the same effect Any ideas?
-
- 3 replies
- 606 views
-
-
I am trying to puzzle out how to create a "due date/renewal reminder" setup where the user can find out which records are due/unpaid etc., preferably using a button/script setup I have an auto-created field 'created' and another calulated field 'due date'. The calculation is "Date(Month(Created) + 12; Day(Created); Year(Created))", which I think gives me the first renewal date for one year ahead. But this of course has a logic flaw, i.e. what happens years 2/3/4 etc. Any suggestions or examples would be appreciated. Hope this is the right forum.
-
- 3 replies
- 953 views
-
-
In a file called Journal, I have a 'Journal' table and data entry layout on which I have three text fields which I will call category, subcategory and subsubcategory. Using a file found here at fmforums entitled Conditional Value List_4, I constructed a three level conditional value list setup for these three text fields. The actual data referenced by the three value lists reside in another file, 'Setup'. 'Journal is related to 'Setup' by two table occurences, see attached picture. On the same data entry layout I would like to have a self related portal through which one could view, ideally, other records from the same subsubcategory, or even a multi filter of three g…
-
- 2 replies
- 730 views
-
-
Is there such a thing as conditional layouts? I'm using FM7. I am working with two databases: television projects and film projects. I would love to be able to combine these two into one as they are each considered "projects" outside the database (and 80% of the fields are same). I am envisioning a list layout with both type of projects listed. Click on one and it takes you to a card layout, let's say television show project. Next card though, as it is say, a film project, will need to show that 20% different information (different fields need to "appear" on the layout. Make sense?
-
- 7 replies
- 1.3k views
-
-
I have a layout that has a leading sub-summary part. It is only printing once (on page one) and the part is extending to take up the whole first page even though is is set to be a very small part. I have attached screen shots of the layout and what the first 2 pages print out. Sub-Summary.pdf
-
- 1 reply
- 775 views
-
-
:crazy: I have a report file with 99 fields....almost all of which could use a drop down choice list. BUT FM Pro V6.0 only allows 50 files to be open at the same time. Any suggestions on how to get more value lists to work while I have 50 files open OR how not to open 50 files every time???
-
- 3 replies
- 663 views
-
-
Hello all of you! i have a small difficult... I'm ..french and an other problem with filemaker Problem and question: I have a check boxe with numeric values I created a calcultation with result, but.. when I do a multi check, when many boxes are checked, the calculation take just the value of the first checked boxe! how to get the sum of all the values checked? im not clear, I kwnow jb thanks
-
- 7 replies
- 987 views
-
-
Is it possible to arrange radio buttons vertically instead of the default horizontal? The client wants to see the following ("0" represents a radio button, and only one button can be checked at a time, hence radio buttons) 0 EAP 0 No Heat 0 Crisis Imminent I'm trying to talk them into this: 0 EAP 0 No Heat 0 Crisis Imminent Is this layout possible, or is there a way to fake radio buttons using another technique? This is an online imitation of a form from the state, so I have very little leeway in changing the layout. Thanks, MichaelE
-
- 3 replies
- 2k views
-
-
I have a layout, "goal", that contains a set of information....maybe 20 fields. For each record, though, the number of times I need that layout varies. For example, record 1 may have 4 goals and record 6 may have 15 goals. Is there a way to create the "goal" layout and add it to a record as needed? Alternately, is there a way to construct the fields so that there are x repetitions, but only one repetition (times 20 fields) prints per page? Thanks, Rick
-
- 0 replies
- 682 views
-
-
Is it possible to setup a portal to display the relating records so that the portal field will automatically expand or contract to how many records it displays? Or is there another type of field/solution i should use? Hopefully i explained this right
-
- 6 replies
- 1.1k views
-
-
I wish to put in the header of my form a "Page x of y Pages" counter. In FM5, I had to write a script to go to preview mode, count the pages and insert that number into the "y" page number. I thought I heard that this was simplified in FM7. Has it and how is it done?
-
- 5 replies
- 1.2k views
-
-
My user wants to be able to tab to a pop-up menu field and also he wants this to be the first tab field. Is this possible? I think that a pop-up list field would work but he wants a menu ... I guess the ideal situation would be for it to pop-up automatically when the layout is opened. Is this achievable?
-
- 1 reply
- 635 views
-
-
In the Photo Catalog Template database there is a Thumbnail view where you can click on an image and be taken to the same image in Browse mode. Works very well! My problem is I can't figure out how it works. Working through the Scripts it appears to work as follows. 1) a Label Layout is used to configure a field grid 3 x 5. 2) a thumbnail LAyout displays the contents of the Label Layout as seen in preview mode. 3) You click on one of the 15 displayed images and by so doing Perforn one of 15 scripts named "GO TO Record n" where n is the image position. Works great. Problem is I can not find anywhere in the Table Fields, Layouts or Scripts where th…
-
- 2 replies
- 981 views
-
-
Hi, friends I have a value list based on a field contents. How can I dinamically have the list shown only the values of the found set, after a "find" based on another field of the same record ?
-
- 5 replies
- 1.3k views
-
-
hi, I have a report with numeric data that sorts by date. I set a page break after 20 occurrence. I want to add a subsummary row that summary the data in the page (as a running total) thanks Thanks in advanc inbal
-
- 6 replies
- 1.3k views
-
-
So I'm trying to figure out this situation. I have 5 seperate name fields. I'd like to have a button script which would grab each name value and then create a value list with the results so that I could then assign said value list to another field as a pop-up menu to get a final result something like this: Gilligan MaryAnne Ginger Mr. Howell Skipper Thanks in advance for any assistance...Kirk
-
- 2 replies
- 688 views
-
-
I am a web developer and am fairly new to FileMaker. I would like to be able to use more that one table (and it's related portal records) on the one layout. In other words, I would like to I want to have two or more "starting points" for portals on each layout. Is this possible? I understand that all the portals on a layout are keyed off the primary table for that layout. But I want to have more than that going on on each layout. For instance: One layout needs to contain the info about the records I'm using. But that same layout needs to have another "source" table that I can use for menues and layout navigation. On web pages that use SQL quaries th…
-
- 5 replies
- 1.9k views
-
-
Hi, I would appreciate some help with this. I've got a database for some information on hospital patients. Each patient record has a hospital admission date which is manually entered and can be unique for each patient record. I need to associate dates during the admission with events that occur that are related to each patient. I would like these associated dates to be part of a value list calculated based on the original admission date. So the value list should dynamically contain a range of dates specifc to each patient, based on the manually entered admission date. The range would be (admission date up to admission date+10days) So the date value list for each pa…
-
- 7 replies
- 1.3k views
-
-
For some reason my portal scroll bar is not showing. I have selected show vertical scroll bar...and it is there because in browse mode, when I click approximately where it should be, the portal records do scroll. Also there is the plus sign in layout view. But why is the scroll bar not visible in any view?
-
- 2 replies
- 1.4k views
-
-
I have a file with quite a few layouts - they will typically be viewed in order. I want to create a prev and next button - the prev button does a go to previous layout and the next button does a go to next layout - what is the easiest way to do this with scripting?
-
- 2 replies
- 1k views
-
-
So the old technique of using related repeating fields in a Find interface for performing an AND search on related records does not work in Filemaker 7! Anyone come up with a new work around? I suspect with the new features of 7 it may be an entirely different approach.
-
- 1 reply
- 693 views
-
Recently Browsing 0
- No registered users viewing this page.