FileMaker Interface Features
-
Since I can't find a way to "enter layout mode" from a script, what would be a good way to center data based on the following: I have a letter layout which has a date field, a composite name and address calcluation field, and a dearline field along with a field called gLetterText. The gLetterText field allows the user to enter text for the letter to be sent, the other fields I have as <<date>>, <<cCompAddress>>, <<DearLine>>. I have grouped this with the cLetterText field so that they move as a unit. However, what would be a way in which all of this data could move vertically based on the text in the letter so it was centered …
-
- 5 replies
- 1.9k views
-
-
I have a field with about 24 check boxes as I tab through them and press "spacebar" to check the boxes I would like those checkboxes to enter their values into another field. How would i do that? So if i had these check boxes 1. Book is in Very Good Condition - 2. Book is in Good Condition - 3. Book is in Acceptable Condition - 4. Minimal Wear Present - 5. Minor Wear Present - 6. Some Wear Present - 7. Previous Owner's Name on Inside - 8. Previous Owner's Note on Inside - and i only check boxes 1,6,8 my field would read: "Book is in Very Good Condition - Some Wear Present - Previous Owner's Note on Inside - "
-
- 3 replies
- 1.1k views
-
-
Hi there, i have try out a report printing for account GL listing, it will break by each account that i set it on subsummary part sort with account code field. Now the problem is if the account have many transaction and will need more than 2 or 3 pages. The account code only will display once on the first time and will not display on the next page(s), so i will not know the second or third page is belong to which account. I have try out the part definition setting but can't find the solution. Can this be done with FM. Regards, Henry Version: Developer v6 Platform: Windows 95/98
-
- 2 replies
- 1.3k views
-
-
Hi, I'm sorry if this has previously been discussed, I haven't been able to find anything on it. I have a portal with listings from a column of a related database. I would like that portal to display instead as a string, with each entree separated by a comma. For instance, if "red", "green, and "blue" were all entrees in this field, I would like to create a layout that says: "red, green, and blue" (will the ending and be a problem?). Thanks, Jeremy
-
- 4 replies
- 1.1k views
-
-
I am really stumped on this one...perhaps it is too late in the evening. I have successfully implemented the technique that will allow a user to enter a range of dates from a parent and then display all of the records in the child. I need to specify a date in the parent (say 3/10/2004) and then display all of the records from the child where Field1, Field2, Field3 or Field4 match that date. Any ideas? Thanks
-
- 1 reply
- 745 views
-
-
Hi everybody... is it possible to launch a script by checking a check box? I have a "Clients" database with a "Clients type" field being member of a value List and formatted as check box. Now one of the check boxes says " musician" , I have a "musicians" layout and I want to be able to open that layout if i check the Musician check box in the Client Type Field. Thanks for your help in advance! Version: v6.x Platform: Windows XP
-
- 2 replies
- 866 views
-
-
Well, I am excited and ready to explore, but I was so hoping that they would give us a better portal scroll, not one that pops back to the top when you click out. Oh well.
-
- 4 replies
- 1k views
-
-
Is it possible to export part of a record, that has been filled in with a portal, to another database table? I would hope to do this with a button on the record's line in the portal.
-
- 3 replies
- 934 views
-
-
Hi all I have read a post that states that the type ahead technique can be use with a pop up value list. Would someone explain to me how this is done. thanks Lionel
-
- 10 replies
- 1.6k views
-
-
I have a file called personnel which is basically a database of users for my application. I have two other files called reports and stats. Each of these files has a value list which is pulled from the 'display name' field in the personnel file. Now, what I want to be able to do is have a check box on the personnel file which looks something like: [] Include Personnel in Reports [] Include Personnel in Stats If the boxes are checked the name is included in the value list on the corresponding file (reports or stats). I have found a couple ways to achieve this, however they all seem a little buggy or overly complicated for what I
-
- 2 replies
- 922 views
-
-
Is it possible to put a bulleted list inside of a field and if so how? The amount of data in the field will vary but it is definitely a list. thx
-
- 3 replies
- 3.9k views
-
-
My FM 5.5 file has a lot of reports. Currently users have to go to a report layout and use buttons to choose the report they want. I would much prefer to group the reports and have users choose the one they want from a pop-up list or menu. When they select an item from the list, the associated script would be activated. A perfect example of what I am looking for is the "Jump To ..." menu at the top of the Right Brain forum on this site. Is there a way for me to associate scripts with items in a pop-up list using FM? I have looked at lots of posts but haven't come across the solution. I can't be the only one who wants to do this. (Perhaps I am the only one who do…
-
- 9 replies
- 1.6k views
-
-
Hello, I work with 3 databases: Orders, invoice & invoice articles. In the invoice database I have a portal that connects to the invoice articles. A field called project number has a valuelist which show all the project of the custumer which is selected. (I want only the one that are still open) Here is what I want! After selecting a project number it should disapear from the valuelist. What I did is making a calculation in the order database which make a choice if the project is already billed or stil open. if its open its show the product number and when it is already billed it reports nothing. So with this field a wanna make a val…
-
- 5 replies
- 1k views
-
-
Hi all, I am building an application and am really stuck with this issue, perhaps someone could help. What I would like to do is have a portal automatically size itself (in terms of the number of rows) to fit all the contents. This may sound confusing, but here is how I am using it: I have an order form, with a portal to another record containing line items. Using the same record as the orderform, I have created another layout, which is the invoice for the order, but just for printing (not data entry) purposes. The problem is: If I start with a portal of say 10 rows, I need it to add more rows if I have say 14 items. Can anyone help with this st…
-
- 2 replies
- 1.2k views
-
-
I know this is easy! I have a file of employee weekly attendance/time records, sorted by Week within Employee name. There can be multiple records for the same employee in a week (Annual Leave, Sick Leave, actual work, etc.) I have a report summarised by Week and then Employee. Now to the easy bit. For Annual Leave, an employee accrues a certain amount each week, might or might not take some of it, leaving a balance. Each Week subsummary shows Total Accrued, Total Taken, Balance. Problem is these figures apply only for the week. I want the same figures for year to date. Running Total doesn't work nor do the other weird and shonky thngs I've tried. In a nuts…
-
- 1 reply
- 1.2k views
-
-
Is it possible to enable a pop-up list set up in a database table, to function when that table is viewed in a portal?
-
- 4 replies
- 803 views
-
-
Hello! I've got a problem and hope that someone can solve it for me. I've have on file with undefined number of records. Each record contains two fields. One field is a text field and contains different kinds of training intensities (A1,A2,A3 etc). The other field is a container field containing a colarbar. Then I've a second file with a greater number of fields (maybe 15). One of these fields uses a valuelist based on the values from the text field in the first file. Finaly I've a third file wich is a calender. It contains portals which through a relationship will show values from the second file. This file works fine overall but I'm trying to use the color…
-
- 7 replies
- 1.1k views
-
-
I have a 1 child file that has Infomation Of Payroll Information. The information is inputed daily and usually has like 6-7 records of on unposted payroll and alot of posted records. I need a value list to display all the names of the employess that are unposted. How can I get a value list to look like a portal with many rows and scroll bar?
-
- 1 reply
- 725 views
-
-
I have a number of layouts that represent letters we send to customers. These include thank you letters, cover letters, etc. These letters are preformatted and include merge fields for the customer contact information. The default behavior is to have a button that opens the letter layout in preview mode, then takes the user to the print dialog to print it. They have no control over the contents of the letter. However, sometimes the body of the letters need to be modified before sending. This might include a sales person adding a personal touch to the letter, etc. The problem is that normal users permissions don't allow them to edit layouts. So, this prevents them fro…
-
- 8 replies
- 2.2k views
-
-
I have a database that holds our LEAN manufacturing data. It is often necessary to view the data in list format - with the operator having the option to look at an expanded version of any record by going to a common "data" layout. What I am wondering is, how do I make a button that will return the user to the previous layout, regardless of what layout that might have been? I have tried a couple of different options but have not been able to get it to work? Any help would be appreciated. Scott
-
- 4 replies
- 1.7k views
-
-
Hi, I have a several portals setup in a main window. I would like to be able to set a transparent button over the area of the portal so that when I click anywhere in a portal row, it takes me to that record. Is there anyway to do this.
-
- 3 replies
- 803 views
-
-
I finally set-up my portal properly. The way that it was explained to me. I went to select data in the field (pop up list of data) and then this error message popped up - "This field cannot be modified until "studentID" is given a valid value." I am an extreme beginner in FMP. If anyone can please help, I would really appreciate it. Thanks Geeker
-
- 4 replies
- 1.5k views
-
-
Hi all, I was a beginner filemaker back at 4.1, and have just come back for a client tracking/invoicing solution using 5.5 pro under OSX. I'm finding my way around the Filemaker Solution Framework, which seems like it should do everything I want, but I have a few questions. First, I'm currently working in Norway and need to print my invoices on a pre-printed form (GIRO F60-1 if anyone is familiar with it). In the print preview of FSF I can see that the layout will need to be modified so the fields line up properly on the form, but I can find no way to modify the printing layout. How do I do this? Second, not really a layout question but, where should I look t…
-
- 3 replies
- 1.4k views
-
-
Hi everybody, I'm stuck with a little DB file which I downloaded here http://www.fmforums.com/threads/download.php?Number=59739 I was advised by Ugo and this file was made originally by Djgogi. The idea is to update a value list by presenting only the values not selected in another checkbox field. So, everything works fine...but only for about 20 items ! The problem is, that I would like 100 items. In this case, It works fine If I select for instance item 65, 78, and 56 but not at all if I use item 2, 5, and 86. Of course, I did all the field calculation modifications. I've the felling that this is may be a calculation problem (especia…
-
- 3 replies
- 840 views
-
-
Hi all I am trying to get the portal to sort by employee last name after finding which company they are working for.Press the button in the upper right corner to goto the layout for the portal. The view layout sort properly but the portal does not. What am i doing wrong. Thanks in advance Lionel company.zip
-
- 3 replies
- 888 views
-
-
Hi All, im not sure if im just having a thick day!! but....... ....I am currently creating a reprot/spreadsheet in Fm Pro - basically im copying a spreadsheet from Excel. The problem is it goes across (left to right) to about 3 A3 sheets but it will only print the first A3 sheet from left to right. Is there a way so i can do a print which will show all of the fields which run across (left to right)? thanks in advance, Ricardo.
-
- 2 replies
- 1k views
-
-
I created a value list in my secondary file using values from a field. This field ("ID tag") gathers info from another file (Master file). I have 143 records so far, which isn't much considering what I plan to enter in the future. As soon as I created the value list, I noticed that everything slowed down. Response time during data entry slowed greatly, etc... As soon as I removed the value list, it was back to normal. Does this have to do with the length of the value list or the fact that the info is coming from another file? I should probably also mention that my ID Tag (which we've discussed at length in the relationship forum) brings in information with it (i.…
-
- 2 replies
- 755 views
-
-
I desperately need some help with this one... I am building main file called "Customer Selections" that will contain all the selections of a particular homebuyer for their new home. I have another file named "Options Pricing" that contains all options and retail pricing for everything that is NOT flooring. Each record has fields for: Trade, plan number, code number, option name, description, retail price, whole sale price, and number of total units ordered. My original thought was that when I needed to break down the flooring seIections, could get "Customer Selections" to look up only the records with the trade "flooring", then "pop up list" only the flooring…
-
- 6 replies
- 1.3k views
-
-
We have a basic PO tracking program. Currently we have just under 4000 entries. One of our accounting personnel noticed that portal info (data) that indicates purchased items and their prices are slowly being removed from the data base. It currently is deleting data from the back and moving forward with new entries. The quirk with this is sometimes it skips some of the old entries in the process. We have paper backup to confirm that the data was originally entered. Any thoughts from anyone would be greatly appreciated. The files are stored on a central independent server with access from a variety of staff. Thanks in advance, -Mr. Morning
-
- 1 reply
- 795 views
-
-
Hi all: I posted a question in January about this, but the post and answers were lost when the forums went down. The situation is this: I'm doing some print layouts for a customer, and he wants certain information to appear (small print, signature, etc) at the bottom of the last page. Someone showed me a trick involving a dummy subsummary part, with the fields to be printed at the bottom actually being part of the header, then extending through the dummy subsummary (fields aligned:bottom) to print at the bottom. It took a bit of tweaking, but works fine. However, if the printout is longer than one page, I'm now dealing with having a title header as well, an…
-
- 5 replies
- 1.7k views
-
-
I have a db of employees they have a location field in their record (this is a value list of different locations) - how would I make a value list automatically of employees who are at "location x"
-
- 2 replies
- 751 views
-
-
This is obviously Filemaker 101 stuff but how do I make the headers for a column layout what I want them to be? Right now, they come out as the field name for that column and that is of course unacceptable. Have to make them something nobody will understand.
-
- 1 reply
- 1.4k views
-
-
Hi, I have to use filemaker for a project, but have been programming db's for many years. I'm trying to adjust - it is not easy Anyway, my problem is, how do you set more than on field from a lookup/value list. For example, say I have the following two tables: work_selections: record_id selection_name cw_split ex_split selection: selection_name cw_split ex_split So the user adds record to the work_selection table by picking from the selection table. I have the portal and so on working, and I can add new records to the work_selection table, with the selection_name being filled in correctly. What I need to happen is for the tw…
-
- 1 reply
- 753 views
-
-
have a portal with dynamic value lists and relationships based on globals. Here's my issue... If I don't click outside the value lists, I can keep changing global fields and the portal updates automatically. Otherwise, it seems to stick and I have to continue to manually click outside the lists to get the portal to update. Why will FM cease to recognize the changes in the global fields once until I click outside the lists? Thanks. -Ruth
-
- 5 replies
- 1k views
-
-
I have a main file "Contacts" with a portal showing 2 fields from another file "Donations"(Related by Contact ID). The fields in the portal are "Date" and "Ammount". I want a script that will perform a Find using a logical "and" between "Date" and "Ammount". Currently it performs a logical "or" Find. The only solution I have been able to find, requires concatenation of the 2 fields in the portal. Is there another way to do this? Thank you, Chipper
-
- 3 replies
- 811 views
-
-
Hi all: This is a weird one. I've got a layout where the user enters data for a quote, including the body of a short letter to go at the top of the quote. The client wants to be able to change the size of the text in the letter. Okay, no problem, right? When the quote is printed out, it is printed from a related file (where all the line-items for the quote reside) and the letter body is a related field. Of course, it is formatted to a particular font & size (Courier 12). I've got a script which copies the text in the quote db, then pastes it into the field (really the same field) in the printout layout in the related file. Here's where it gets wierd. If…
-
- 4 replies
- 1.1k views
-
-
I have a DB of photos. Some of the photos are grouped which is shown in a portal along with the photo information. If you click on an image in the portal it will take you to that image and highlight it in the portal. But if you do not click the portal and just manually go to the next record the highlight will remain on the last clicked. So is it possible for filemaker to know the active record in a calculation without the use of a script. (see attached)
-
- 1 reply
- 1.3k views
-
-
Hi, It"s my first time on your forum. I'm doing a database for all the bottles of wine I have in my cellar. My question is how to be able to link two fields together. I have one field with all the countries in a pull down menu and what I want is if I choose for example France, it automatically gets all the region of this country on another field. I use Filemaker for a long time and can't remember how to do this. I don't know if I'm clear enough ! if not I will explain more ! Thanks
-
- 1 reply
- 1.5k views
-
-
FM Pros: I am an FM newby and I have a problem related to reporting on a group that represent a fraction of all records, while still included summary info from the total of all records. My report shows a fraction of all inventory records, but on each sub-summary line needs to include information summarized from the total. Specifically, I am showing transactions within a date range, and totaling weight shipped for those transaction within that date range, thus the sub-summary provides the net weight shipped in/out during the specified period. Now I need to have the total for all of the transactions up through the detail date range (a previous balance…
-
- 1 reply
- 1.6k views
-
-
I want to be able to have a specific checkbox list appear based on what is entered in a field. Ex. If the value entered in "Program" field is "Master of Arts in Art", then a check box appears that has listed: Application Official Transcript Official GRE Scores or if the value entered in "Program" field is "Master of Arts in Psychology", then a check box appears that lists: Application Official Transcripts Recommendation Letter 1 Recommendation Letter 2 Recommendation Letter 3 Statement of Career Goals and the list of programs that might be entered in the "program" field is multiple. Can anyone get me on the rig…
-
- 1 reply
- 762 views
-
-
I have a text field called "NAME" that is formatted to be a check box that uses the value list: "NAMES". I would like to have a script that automatically selects (puts a checkmark next to )specific members of the list. For example: In the event that I want to assign a task to a Skill Level 1 woodworker, Billy Bob & Zorro would each get a check by their name. If I wanted to assign the task to a Skill Level 2 woodworker, then Skippy & Rex would get the check by their name. Is there any "SET FIELD" type scripts that could select everybody in a specific list and put a check by their name? Thanks for any help, Jarvis
-
- 8 replies
- 1.2k views
-
-
im an extreme newbie trying to create a database for my middle school classes. i teach lot of different classes, so in logging my information i was wondering if there is a way to have the value of the 'grade field' (which is a drop down list from 5-8) define which value list will be used in the 'teacher' field, thereby minimizing the number of names that need to be scrolled through. for instance, once 6 is chosen (as in 6th grade) only the value list with 6th grade teacher names is available for the 'teacher' field. alternatively, if 7 is chosen, only 7th grade teacher names are available in the 'teacher' field. i just began using filemaker pro 5 last night, so my…
-
- 5 replies
- 940 views
-
-
I use a key field in each database for relationship. There are 3 records that should show in portal, but only the first is showing - 3 times! What is it???
-
- 3 replies
- 819 views
-
-
Hi All, I have spent a while trying to solve this question on the forum before asking this of you ! I have created 4 files. Invoice + Customers + Items + Ordered. The invoice file is the control file in this instance which presents the other 3 files as portals. They exchange data AOK,,,,whooopeee ;-) 2 Of the portals have a script attached to pull of records and enter them in the invoice file. The customer file has in excess of 2000 records and displays 6 rows in the portal. I wish to search the portal by name or part of name but due to the attached script I am unable to enter data in the portal row whilst in find mode. I have made several perhaps clumsy at…
-
- 2 replies
- 866 views
-
-
Has any one got any examples of stopping deduplication in a portal. Using portals to display contacts with in a company if someone enters a similiar first name it flags it and then if someone enters a similar surname it flags it. Any help would be appreciated Thanks Simon
-
- 1 reply
- 778 views
-
-
From the menu, I click Layout/Set Layout Order, I can see many layouts like A,B,C,D etc. On my screen, I see only layout A. How do I switch to the other layouts to look at what fields is used on the layouts?
-
- 5 replies
- 1.8k views
-
-
Looking for the reason why that on some PC's the layout pop-up menu (the one directly above the flip book) opens in a columnar fashion and others open with a scroll interface. Is there a registry setting that might be ammended?
-
- 2 replies
- 1.6k views
-
-
When I remove a field from the layout the field vanishes from the view as table also! How do I see it again so I can edit it? I don't want it on the layout becuase it is not something the users should be editing.....
-
- 3 replies
- 1.4k views
-
-
How can I show multiple records from two fields which sometimes match and sometimes don't, on one portal row? I'd like the end result to look like this: txt_Name.fp6 Ptl_Associated record(s).fp6 Fred 1,7,99 Joe 4 Rick 2,3,5 Etc... #1.) I cannot figure out how to derive Txt_Name.fp5 from two different fields: Txt_Composer.fp6 and Txt_Author.fp6, where Txt_Composer.fp6 sometimes matches Txt_Author.fp6, only return one record/ match. Where Txt_Composer.fp6 and Txt_Author.fp6 don't match, it should return two seperate records. #2.)I cannot find a way to make a portal show the wa…
-
- 1 reply
- 829 views
-
-
I'm trying to dynamically populate a dropdown list of current salespeople from a "Display Name" field in another file (the dropdown resides in a portal). The hitch is that there could be many people with the same display name - some current salespeople, some former (identified by whether they have an Employment End Date). In other words, in the dropdown, I'm trying to display all of the salesperson's Display Names, but only if they have a null Employment End Date. Any thoughts on how to get it to update dynamically? I thought about using a calculated repeating field for the value list, but am not sure if I'll exceed the max number of repititions (I'd need about 40). …
-
- 1 reply
- 1.5k views
-
-
Hi all: I've got a bunch of printouts which the client wants to have printed with blue text, just like on an old mimeograph machine (talk about trying to stick with your legacy stuff...) and although I've formatted the fields blue in the print layouts, sometimes the fields do not print blue. Furthermore, I've just noticed that sometimes they do not print in the specified font, either. I had thought that the color, font, size and style I indicate in layout mode would always stick, even if the user has entered the data in another layout using a different font, size, etc... what's happening? This is an FM Server setup, all Macs, the clients are all on OSX and FM 6.…
-
- 2 replies
- 994 views
-
-
Hi all: I'm in need of some basic icons (lock/unlock, for example) and wondered if anyone knew of a good resource for simple, free icons for use in FM solutions. Thanks, Stanley
-
- 2 replies
- 1.3k views
-
-
Thanks Stephen for such a speedy resonse creating this topic in the forums. I can't for the life of me figure out how to get a count of the number of groups in a subsummary, which is a count of the field that is used as the break field. To make my meaning clear, the example FM uses in the help files is a subsummary report of sales figures summarised by geographical regions A, B, C and D. In this example, as well as the summaries I would need a count of the number of regions the report found (ie 4 in this example). I have created a summary 'count' field for this field, but this gives me the count of every record in the report, not the count of the different…
-
- 2 replies
- 1.7k views
-
-
All the databases that I have developed in the past. I've always made it look like you were looking at one layout. The window from the user standpoint looks like another tab was chosen but it appears that you still looking at the same page. Programmatically they are looking at another layout. Well I've come up with this idea to create a pop-up with a related database. Programatically bring the related database window forward and then allow the user to enter information an then hide the window when they are through with the information on the related database. My question is can I programmatically resize the database window? If so how? Also can I move the position of the a…
-
- 2 replies
- 1.4k views
-
-
I am using a FilemakerPro calendar that utilizes a portal. Is there a way to back-up the data or even export it out of the portal? Thanks! Tarheelfan
-
- 2 replies
- 723 views
-
-
Hi, total newbie here, im trying to put a graphic in my database that is also a button,when i click it i would like it to show another graphic in its place that when clicked will return to the original graphic??
-
- 12 replies
- 1.9k views
-
-
Hello, I am having a problem with a portal I have created. It displays data from a related field (about 4 columns), ,but the last line of the portal will not let me enter data into the portal. I have seen other files that allowed this, but it is not an option for mine. Can I fix this? Thank you.
-
- 3 replies
- 668 views
-
-
I have a question regarding the way I am using portals in my database. I am new to Filemaker and have just begun to learn about scripts and calculations. My database is used for patient records. I would like to keep track of various other service providers that these patients see, such as orthotists, medical clinics, doctors etc. I have a contacts database which lists all the other service providers and need to associate them with the patient record. Originally I just used a lookup field to pick the contacts unique ID number, used relationship fields to show some of their basic info and a button which would go to the related record. However this se…
-
- 5 replies
- 1.2k views
-
-
I have a DB where users only access one blank ("view") record, populated with a portal based on a constant that makes all other records (in the same DB) appear in the portal. This is the names of Special Projects we have open. They click on the record they want and are brought to that record. From there, they are linked to all the info for the Special Project, portals to stores involved, vendors involved, etc. Works perfectly when it was me developing it. However, I just discovered that when anyone is scrolling the portal, the "view" record is locked, so no one else can scroll. I then replaced the "view" record with 10 "view" records, and each user is sent t…
-
- 9 replies
- 1.2k views
-
-
this forum is great if you have some experience using relational dbs but its not my thing, i got filemaker a week ago and have knocked up a db that works!! its simple cause thats all i need,but im seriously frustrated at the lack of basic info,even filemakers own tutorial breezes over sections without any explanation at all,for instance how to set up a letter from your db that prints a4??? how to put a graphic in a container, or even what a container is and when to use it, it begs the question why do people use pirate software....cause its very often incomplete...whos gonna buy a car with no wheels....
-
- 3 replies
- 1.8k views
-
-
Hi guys, just wondering other than changing the values of checkboxes. Is there a way to automatically check a checkbox after performing a function. What i have on hand is to send confirmation letters to the customers after they have registered with our company. When i click on the "send mail" button, is it possible for Filemaker to update the checkbox field after sending the mail?
-
- 9 replies
- 1.4k views
-
-
Hi I want to show 5 related fields from a related file in a portal. When I create a portal, it appears with only one column. How do I configure the portal columns (related fields) I want to display? Thanks Alain
-
- 9 replies
- 1.1k views
-
-
I need to create a script that will add a new record in a protal at the line where the cursor is situated. The new record step just throws me to the last line of the portal. Am I missing a step somewhere . Any help would be really appeciated. Many thanks
-
- 1 reply
- 775 views
-
-
Hi, I have a portal in a primary file that has 2 fields from a file related by Resource Number. The parent field is Resource Type and the child field is Resource Name. Both fields have value lists with drop downs. I want to have the capability to select a Resource Type and have all of the Resource Names with this particular type appear all at once in the portal. I also need the capability to choose more than one Resource Type. Some Resoure Types may have 100 or more Resource Names. At present we are choosing them one by one. All suggestions are appreciated!
-
- 2 replies
- 910 views
-
-
I have 2 related files: donor.fp5 and vendor.fp5 vendor contains a check box field with Yes or No as the options, and another field company name. Donor has a field: Non-Profit, which is a drop down from CompanyName in vendor. I want to be able to do a find in donor for all the Non-Profits that have the check box marked YES in vendor. I will eventually be performing a script from donor.fp5 with these records, so if I can script the requests that I want that would be good also. I am sure this can be done with the creation of some "holder" fields of sorts, but I am stumped. Any thoughts???
-
- 1 reply
- 774 views
-
-
I am working on a project management type system. Part of the project report will be a portal which lists "involved people." I have a couple questions about how I should set this up. The portal would look something like this: -------- ------------------------------------------------- [ menu ] First Name_______________________________________ Last Name________________________________________ Company__________________________________________ -------- ------------------------------------------------- [ menu ] First Name_______________________________________ Last Name________________________________________ Co…
-
- 2 replies
- 731 views
-
-
Hi all I have create a type ahead portal, but i have one question. How do you keep the curor form leaving the field you are typeing in and going into one of the fields in the portal after you type the first letter and press the tab button on the key broad. I have reviewed Russ namefinder and he has formatted the fields for "do not allow enrty" and have also reviewed Ugo type ahead sample and he has a Go button but you have to click in the type field everything time to push the button. If you press the tab button in Ugo example,you goto a field inside the portal. We have a contact db that has about two hundred names in it. Our sales people would like to search the db f…
-
- 6 replies
- 750 views
-
-
When using <<fieldname>> in a layout, some of my number fields appear with a $ in front of them in Browse mode...And, none of the non-merge appearances of that field anywhere in the database are set with that type of number format.and, I have changed it to General Format, and leave data as entered, etc, ....I am also particularly challenged on merge fields where the Define Fields creation was a calculation (number).....??---if I am only using it as a merge field in layouts where can I create or change the "numbers formatting"...
-
- 1 reply
- 1.1k views
-
-
What is the best way to match the contents of a field (text) with all items in a value list so that it returns a "yes no" or" 0 1"? Example: "song title" field matching to "original song title" field to compare for spelling mismatch, and flagging this mismatch. Thanks.
-
- 1 reply
- 801 views
-
-
I have a value list "Options" that have values: Sentance1, Sentance2, Sentance3, Sentance4, Sentance5. I use a Field Box, and change the format to "CheckBox" and assign the above list to it. Then I have another Field Box "results" that I want to show which options are checked. So a user can check option Sentance1, Sentance3 and Sentance5. Then in Results, I want it to display "Sentance1 Sentance3 Sentance5" Is there anyway to do this? Thanks in advance!
-
- 1 reply
- 822 views
-
-
Hi! I'm wondering if there's a way to display portals in columns instead of rows? Thanks for any input!
-
- 1 reply
- 869 views
-
-
Hello, I have a value list that that displays 4 items with checkboxes. When they are displayed they are right under eachother, I would like to put a space between each value so an example being. Checkbox1 Checkbox2 Checkbox3 Insead of: Checkbox1 Checkbox2 Checkbox3 I did use try to leave a blank space between each value in the Value properties box but a checkbox appears in the CDML page between each value where the blank space should be. Any clues? Thanks, Jaser
-
- 4 replies
- 813 views
-
-
Hello, I'm a somewhat "advanced newbie" trying to learn how to implement value list with the end goal of using conditional value lists on a web solution. But first I'm trying to figure some things out in plain old Filemaker. These are the basic relationships in my current solution: I currently enter in the customer number, then calculated fields pull the appropriate information from the Customer and SalesRep files. What I want to do is create a drop down value list of customers in the RequestLog.fp5 database that includes all the Customers. That much I have figured out. But I don't not know how to pull the CustNo and put it into the RequestLog.fp5 database b…
-
- 10 replies
- 1.5k views
-
-
Does anyone have a suggestion on how I can make a record "invisible" to certain level users after they have entered it? Specifically, a user signs in, is taken to the entry layout, inputs into 8 or 9 fields, then chooses "complete" from the status field. Upon choosing "complete", I want them to no longer be able to access the record (not even to read- it should "disappear"). The VPs who will handle the case will have access but regular users will only be able to enter into new records. (Medical field, sensitive data, etc., etc.) Thanks to any suggestions! Anna
-
- 2 replies
- 1.3k views
-
-
Dear Fellow FM Peoples, Newbie requires a little assistance. I have a value list which is being generated from a field. (Roll #) I have another field with the value list attached (Roll Selector) I have a Script which copies the Data from (Roll Selector) and performs a FIND based on your selection. The Script works just fine, the problem I have is with the VALUE List that is being generated from whatever the user enters in (Roll #). In that; say you enter a new number in (Roll#) then go directly to the (Roll Selector) the newly entered number does not appear in the value list until you click out of the field and click back in again. Is th…
-
- 5 replies
- 1.1k views
-
-
Hello, I have a value list that has 26 different comments. When a teacher updates the final class documentation they select comments about the student from the value checkbox. They can select any amount of comments per student. I would like to have a count per class on the comments selected. For example: Class 2 Comment 1 Total; Comment 2 Total; etc. What would be the best way to handle this calculation? Thanks, Shari
-
- 4 replies
- 1k views
-
-
Hi there, I am new to this world and I spend the whole day yesterday reading up, but could not find something that would deal with my specific problem, if I have overlooked something, please do point me to that thread. Here is my problem. I run an Art Gallery and want to set up a contact database. In this contact database I want to store all information about everybody possible. So the first file is contact details. Then I have separate files to specify what kind of contact I have with the individuals. f.e. Artists, and Art buyers. In the Artist file I want to store stock information. Paintings the Artists brought in, if it is in exhibition or if it has been…
-
- 0 replies
- 1.1k views
-
-
Hello, What is the found set in a portal? When searching for specific records the portal of course has all the associated records with it. Does this mean functions like lookups etc will apply to all the records? Or am I just hopelessly confused? Thanks, Glenn
-
- 3 replies
- 858 views
-
-
This is my first time on this forum,So bear with me guys.I have a done a invoicing system on the lines of the one shown at http://www.maclane.com/portinv.htm .It is extactly the same ,except In the Inventory file I have added a new field called "Qty" holding the stock quantity of the product.And also added a button called "Process" to the Invoice file.What I want to do is when I click this button I want to run a script that will substract the oder quantity in the line items file from the stock quantity in the Inventory file.Every way I try to do this only the first entry in the Inventory gets udated.Please not that the invoice line items are displayed in a portal in the I…
-
- 2 replies
- 1k views
-
-
Hello, Is there a way of referring to specific portal lines in a portal, to use in scripts (other than first, next, etc)?
-
- 2 replies
- 806 views
-
-
Hello People! I am not sure if this is even possible but here it is: ---value list----- 1 Soccer 2 Basketball 3 Racing .... Is there a way make a list behave like a web based list where user sees only "label"(Soccer..) while the values (1,2,3) get entered and never displayed? In other words my user does not need to know that eg. Soccer's Sport_ID is "1" This never really bothered me until I started to deal with a lot of lists and realised that after selecting/entering all is displayed are values...which in human eyes are not very re-assuring of the correct choice. Any pointers? Much apprechiated!
-
- 17 replies
- 1.7k views
-
-
I am new to "relationalizing" long used Filemaker files v5.5. I have 2 questions. First is baffling me but probably a simple oversight I have "Ship Tickets" and "Ship Tickets line item" files related by "TicketNumber". The portals in "Ship Tickets" display correctly but when i attempt to total "Shipped Quantity" using "QuantityShippedTotal"=Sum(BZ_ShipTicketLine Item|TicketNumber|BZ_shipTicket::QuantityShipped) in "Ship Ticket" file it only totals the first portal row. I have what i thought was the identical type of set up- fields, relationships, formatting etc in a "Contract" and "Contract line items" files and the totaling works perfectly I've tr…
-
- 0 replies
- 786 views
-
-
I have a database called Job Tickets and related database called Clients. I want to see if there is a way I can view the files in Clients as a seperate layout in Job Tickets instead of having to open the Client database to add/edit new clients. Kind of like the way ACCESS handle sub-reports in a main database. it allow you to create a main database, and add/edit sub tables inside the main database without having to open the sub table.
-
- 4 replies
- 870 views
-
-
Does the concept of sub-summaries exist for portals? I have an invoicing solution that has files called INVOICE and LINE_ITEM. I have a portal on my Invoice Layout that shows line items like this: Category 1 1000.00 Category 1 2000.00 Category 2 1500.00 Category 2 3700.00 I want the Line_Item portal on my Invoice form to *subcategorize* the info (like I could by using subsummaries in the LINE_ITEM file to print a report that shows: Category 1 1000.00 2000.00 ======= 3000.00 Category 2 1500.00 3700.00 ======= 5200.00 Can this be done in FileMaker 5.5?:??
-
- 1 reply
- 753 views
-
-
anyone know where i can get some fancy looking buttons to put in my database? not the OS x looking ones though!! thnaks in advance, ricardo.
-
- 10 replies
- 2.5k views
-
-
Hello People! I have just got my category and subcategory approach done. Although it works pretty nice I am concrened about maintance of the Catgory file...meaning, when the new categories and sub categories are defined...or in other words How do I control IDs and their increments? here is a visual: as well as the files attahced! I apprechiate any input! Thanx! CATS.zip
-
- 7 replies
- 1.3k views
-
-
I just spent hours perfecting a subtle design for some "tab" buttons, and got them just right. However, now when I click on the button in browse mode, it highlights the entire button as black for an instant while I click it. Is there any way to control what color this highlighting is (or in fact to get rid of it?)
-
- 1 reply
- 783 views
-
-
Pardon this newbie request, but I have looked through two FileMaker books and online, but I cannot locate the information on how to do which seems like a rather simple thing. I have mage a simple Yes/No list and attached it to two radio buttons. The seem to be working properly, however I want to have one of the values (No) pre-selected when a new record is created, instead of having to click on it. It seems like this should be simple, but I can
-
- 2 replies
- 2k views
-
-
I tried to find the answer in the Forum but no luck. Here is what I have: Two files call Vendors and Staff. I have a Job Ticket database that is related to these files and created relationships/Value list called VendorsList and StaffList, which is all the codes I use for each file (Ex: GWS for George Swisher in Staff file, and SYST for System in the Vendors file) I use vendors and staff to assign tasks to be completed, that is created in the Job Ticket Database. I have a field in Job Tickets call AssignTo, which needs to be a a drop-down menu with values from both files. What is the best way to do this? -george
-
- 1 reply
- 691 views
-
-
Is it not possible to have summary fields doing their thing for records in a portal, even when the portal is using a self-join relationship?
-
- 2 replies
- 713 views
-
-
I am having an odd problem. I have a style screen on my inventory database, on it is a field SupplierID which is created using a value list. My problem is that when I switch on in the morning the first thing I see is this style with the wrong supplier ID showing up. I do what most people do at this point and correct the value to what it should be but then when I go out to the main menu and return the value has changed back to the wrong value!?! I can not understand this as there is a lookup al right for this field but that can not be making this error. I just do not understand. I look forward to your replies. Mark
-
- 3 replies
- 856 views
-
-
I have several repeating fields [field1, field2, fiels3] repeating 5 times and all share a value list: A B C Can I total how many "A", how many "B", how many "C" and then total "A" & "C"? I usually can find the answers just by browsing around here. Thanks!
-
- 5 replies
- 961 views
-
-
Can anyone explain to me how to do indented portals?
-
- 3 replies
- 1.1k views
-
-
I have searched the Portal Forums, and can't find an answer I can make sense of. If there is an answer to this question...please point the way. My question: I have 3 Files: Assignments/Questions/Criteria. These are Parent/Child/Grandchild respectively. In a Parent Record layout I want to have 2 portals: Questions (related by Assign_ID) and Criteria (which is related to Question file by Question_ID). The behaviour I want is click on a row in the Questions portal and see all related Criteria in the other portal. I gather from other posts that I need to create a Global field in the Assignments field which would be the left side of a relationship with some kind of calc f…
-
- 3 replies
- 1k views
-
-
I have a database made in FMP 5.5, "Assets" that tracks inventory. When an item is purchased, its entered into this database with an Asset Number and quantity, and when an item is sold its Asset Number is entered into a different field "Linked Asset Number", and its quantity is entered also. However, when an item is being sold, I want a drop down list of assets that have not yet been sold. So I created a self-join relationship, between Linked Asset Number and Asset Number, and created a calculated field called "Quantity Remaining" (Quantity-Sum(Assets::Quantity)), which correctly calculates the number of units remaining for each asset. Then I added a calculated field…
-
- 4 replies
- 1k views
-
-
Hello all, I have a simple dB.fmp5 with a checkbox of YES and NO that I need to change the value from one to the other at year end. The dB has 450 records to loop through. I've got the script to clear the selected value but no luck at inserting the new value. Any help is greatly appreciated, Greg
-
- 1 reply
- 779 views
-
-
Hello all, Even short forum outages leave me on edge. What if it never comes back? What will I do? How will I get high-quality free help? Argh! Well it seems to be back for the time being, so I'll sneak in a question or two. I need to have various windows sized to fit on various users' monitor. I've read enough to know that the way to force the size of a window in FM is to create a blank layout and then put a rectangle object on it the size that you want the screen. Switch to the layout, zoom to the rectangle to force the size of the window, and then go back to the original layout. (This is one way to do it at least. There may be more, but I've got this…
-
- 11 replies
- 2k views
-
-
I have a layout with a number of check boxes. For simplicity, let's say they all have 2 check boxes labelled YES or NO. I want a count at the end of the month of how many YES were checked, and how many NO. Is this possible? I browsed other posts and saw a reference to something called PatternCount. Thanks in advance for any help.
-
- 1 reply
- 887 views
-
-
Do I gather that using a Repeating Field(s) for a purchase order will not permit me to produce summary values for specific Item #, i.e. report how many #347 knobs did I purchase last month? Is that not possible to extract from a repeating field, and/or is it thru a portal, or must I generate a separate record for each item on PO to accomplish this?
-
- 1 reply
- 835 views
-
-
I am trying to link pop-up menu value-lists. For example, if in the first field, "Color" I chose "Red," the menu for the field "Fruit," would only show a value list called "RedFruit." If a different color was chosen, a different subsequent menu would appear.
-
- 3 replies
- 851 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online