FileMaker Interface Features

Hello All! Ok, so I see that I'm not the only one attempting to use a 'Post' webpage. Specifically, what I would like to do is this: Goto a page, like https://www.econsumer.equifax.com/consumer/showmyequifax.ehtml?partner_cd=PPSS2 I would like some automated way to have data from the record pasted into the fields. Any ideas on a simple way to do this?

• 1 reply
• 1.6k views

Ted S

July 20, 200619 yr

hello again everyone was great the last time i needed help so here we go. i have a portal based on a table tracing various district attorneys and the trial they handle. in some cases there are two da's on a single case(lead-assisting). this info is entered by a value list containing an ada_id and ada_lastname. the problem is if i search for the da whose name is in the second portal row(assisting ada) the search results only shows me the result of the first portal role(lead ada). any ideas on how to search on the various portal rows to get the desired result. thanks in advance

• 0 replies
• 675 views

sbod

July 20, 200619 yr

I feel like I'm either clueless or having the worst luck. I have this task that should be simple--entering orders for more than one month's of services in one statement/invoice. Rather than using repetitions which are difficult to filter by (in my limited experience). I decided to make a related table using Order# and slap a portal in there. On the layout, I have the business contact information, an Order# and some basic order specifications. In the portal, I want to specify the month of each item and some other descriptors. However, it is not allowing me to enter more than one item/record into the portal, even though I have room for 12 records. Am …

• 3 replies
• 919 views

bjh

July 20, 200619 yr

Hi Guys, Just as the subject states, what is the difference between the two (Title Footer and Footer). I want to print something at teh bottom of the page, so I would place this in the footer. However I dont want to print it on every page, so I guess I will have to use the trailing grand summary. Unfortunately the trailing grand summary doesn't print at the bottom, as I only have a couple of entries, it just prints after the last record. Noticed in the parts Title footer but to me just looks like another footer, so why have it?

• 1 reply
• 570 views

Jalz

July 20, 200619 yr

Hi all I just reworked my relationship table and smoothing out some of problems I getting with portals not showing within layout even through there is relationship?, if you have chance to have look at the attached FHPRO7 file and look at the layout Job instruction there are two portal one "items" and other "amendments" can any one see why I not seeing them? (As use them to enter data about the job instruction I very stuck here, looking forward to seeing peoples suggestions regards Damian print_specs_Clone-v6.fp7.zip

• 4 replies
• 622 views

Hack

July 19, 200619 yr

FMP had a great IDEA, but ruined it with a simple omission. The web viewer needs a URL, it can't display the content of a field that would contain HTML source code. That's reall disapointing, it would have open a new wealth of opportunities, like previewing data. Please make it in 8.5v2

• 55 replies
• 8.9k views

Brudderman

July 19, 200619 yr

FEEL LIKE BEING CREATIVE? YOU CAN HELP ME!!! I am not sure this title covers my question, but let me give it a try. My file setup consists of a server part and a part that users have locally on their own computer, as many times as they have projects. The local file uses the data that are kept on server. When users make their selection from these data, they do so via 8 portals. Each choice filters the available choices in the next portal. I have two questions, hoping for solutions / alternatives that i am overlooking. NOTE: I do NOT use plug ins (not allowed to due to budget cuts) and I am not familiar yet with VB etc. NOTE2: there is no opti…

• 3 replies
• 1.1k views

Ender

July 19, 200619 yr

Hi, I'm real new to this. I made a database from scratch that contains employee data and contains a portal to list employee training. I managed to figure out the tab thing in the body and have three tabs for three levels of training. The sheet is unfinished but I know how to do everything I want to do with one exception. I cannot figure out how to get a "List View" of the employees that I can click to a form view. I know I need to do it with scriptmaker but because it's a clean sheet there are no scripts defined. Attempts to import scripts from other sheets always fall short and I always get errors in the import. Help. I can post the sheet or ema…

• 1 reply
• 1.1k views

JapanJohn

July 19, 200619 yr

I'm doing a huge image database that I have to put on the web. There will be over 5,000 pictures and all pictures are about 3 megs each. Does anybody have a template that allows for people to search and label, while at the same time having small enough (size wise) thumbnails to make it run quickly over the web? I'm struggling trying to make one. Any help would be much appreciated.

• 1 reply
• 927 views

T-Square

July 18, 200619 yr

Hi all! Well, the subject says it all: I would like to have a Sub-summary layout part appear when in Browse view? I never need to print this layout, so it is not at all formated to be viewed in Print view, but that is the only view I see my Sub-summary. Thanks for your help! -Conner

• 1 reply
• 630 views

Søren Dyhr

July 18, 200619 yr

I did not know what area to post this, sorry if it does not belong here. Is it possible to change the icon (FM folder) in the top left corner of the bar. Is there a way we can place our own icon there? It would at least be nice to do on a kiosk project. Thanks, Jim

• 2 replies
• 643 views

Totes

July 18, 200619 yr

Hi all, I've been very impressed with these forums and I have a simple question, I think. Referring to the Relationships.png: I have a portal in the (blue) Product table that views the (green) Product_Surface join table. I have value lists created dynamically for the (grey) Finishes and (grey) Base_Material as well as a static surface treatment value list. Referring to the Choosing.png: The only way I've gotten it to work is that the ID's must be present and remain there. This looks ugly and will confuse my simple minded boss. I've checkmarked the box on the value lists that says "Only show values from second field" as you can see from Choosing.png. …

• 1 reply
• 671 views

hillborne

July 18, 200619 yr

I've noticed that in databases I design, people often end up in the find mode and don't realise. Or they forget. So they perhaps click the find button get a bit confused by something and then forget they're searching. The difference between the browse layout and the find layout isn't great! I was thinking of changing the find layout - maybe a background colour to make sure people are aware of where they are. But I can't figure out how to do that. Any thoughts? Or other solutions?

• 4 replies
• 876 views

Nicnacs

July 17, 200619 yr

I have a contact database that has a separate table for phone numbers. This allows us to have multiple phone numbers for each contact. Each record in the phone table has a phone number field, a type (home, business, fax, etc.) field, and an ID key field. The question I have is in displaying the phone numbers in the Contact database. I can easily create a portal to the phone table and show all the related phone numbers for each contact. However, I would like a little different functionality, but I'm not sure if it is possible. I am envisioning a portal with only one row, showing one phone number. Next to it, I envision a pop-up menu field displaying the type of …

• 2 replies
• 705 views

Scott Hall

July 17, 200619 yr

hi im trying to create a searchengine that searches a through some portalrows in my contacts table. it suppose to search the portal at the first contact, then go to the next contact, search that portal, next contact, search, and so on. when ever it hit the right value it suppose to stick it in another table. the problem is that i cant get it to find the first portalrow in my contacts table. i use the gotoportalrow[first] but i doesn´t seem to find it, it only highlights the contact_id, which happend to be the first field i have. the really funny thing is that if i manually highlight the portalrow (clicking on it) everything works fine... i cant stickt the button…

• 2 replies
• 637 views

Saucepan

July 17, 200619 yr

I'm building a solution for a parts catalog. The records in the main data entry table are called PageSets, which are created on a layout called DataEntry. A portal on the DataEntry layout lists the Parts for the particular PageSet. It does this by way of a match table, LineItems. Related LineItems can be created in the DataEntry layout, within the portal. The key field for relating LineItems to PageSets is an auto-enter serial number in PageSets, PageSetID. Often, when adding a new PageSet, its parts list is very similar to that of an existing PageSet record. So I go to the existing PageSet that I want to duplicate to use as a starting point, and then choose Rec…

• 1 reply
• 684 views

Søren Dyhr

July 16, 200619 yr

Hi, I have a layout which has a tab section...my question is this: Can you place another set of tabs within a tabbed layout without causing any problems? So, what I have is my layout with tabs: 1,2,3,4 and when you click tab one there is a set of tabs nested in the body of tab 1, called a,b,c, etc. . I could not find any mention of it being ok or not ok to do. Thanks, Jim

• 2 replies
• 1.3k views

Totes

July 15, 200619 yr

I have photographs which show based on a relationship of two keywords (by using a relationship back to two global fields). The valuelist of first field is based on values on the keyword of the daughter table (building name). The value list for the second global field (the building storey) is created with a self joining relationship of the first keywords. Unfortunately the valuelist only works once the relationship has been resolved and have manually typed the correct second keyword. Hope that makes sense. Is there any way around this? Thanks

• 2 replies
• 639 views

Aussie John

July 15, 200619 yr

The web viewer seems so modular, I can almost imagine it not interfering with the older fm8 functionality. Faced with the start of a large build for a new client, dare I dive in and recommend the untried 8.5 for this undertaking? I'd hate for them to go through the hassle of updating later after it has been put through it's paces, and FMI has released an update or two, or to miss out on the webviewer (which has no use in out CURRENT scheme.)

• 0 replies
• 1.3k views

MorFologist

July 14, 200619 yr

not sure if this is possible...or maybe it's a really simple answer... i have a drop down that is generated from the values of a field. right now it sorts the numbers...but it goes . 0 1 11 12 2 3 etc. is there a way to make it sort a certain way so that it would go . 0 1 2 3 11 12 etc. thanks :P

• 6 replies
• 1.4k views

NeoCryptic

July 14, 200619 yr

Is there any way to have FileMaker 8.5 do this: Go to a web page with a form that uses the POST method, input data, and hit submit? I'm working on a USPS integration, and image data is sent back to FileMaker via XML that is Base64 encoded. I've written a perl script to decode the image and display it, which I can do by hand just fine by copy / pasting and clicking on submit, but I'd like to have filemaker do this for me. Anyone have any ideas if this is possible?

• 2 replies
• 1.6k views

mberding

July 14, 200619 yr

I work on a report. The report is based on the table which is organised this way: tbSchedule ID Fk_Class DateClass Month Week Desc The report should grouped by Class (Header) Month (Sub-summary) Week (Sub-summary) DateClass (Body) Desc (Body) what should give me this: Class 3600 Date1 Date2 Date3 Date4 Date5 Date6 Date7 Date8 Date9 Date10 Date11 Date12 Page break (how?) and next class: Class 5600 Date1 Date2 Date3 Date4 Date5 Date6 Date7 Date8 Date9 Date10 Date11 Date12 I divid…

• 1 reply
• 928 views

sotiris_2

July 14, 200619 yr

I have created a Form with the desire to diplay specific p/n data from FMParts. I have inserted a Portal in that form that contains fields from FMParts. You can see the relationship in the attached jpg. When I do a search for a p/n that is containged in the FMParts file..the data that is displayed is not what I searched for. Help please.

• 0 replies
• 755 views

MyTonkaToys

July 14, 200619 yr

I have to following tables - Project, Role and Address. I want the information added in Role to show in a portal on the Project table. I have done the following. Insert Portal. Show related records from Role. Specified how to sort the records. Number of rows 20 I have then added the fields that I would like to show in the Portal. Still I cannot see anything in the portal. I can imagine that I have not related all the tables right. In define database the following are related ProjectID (Project) = ProjectID (Roles) I am aware that it might seem like a stupid question, but as a rookie I would be very greatful for all advice i can get. Best wish…

• 2 replies
• 624 views

frida

July 14, 200619 yr

Is it possible to merge together several related records? Here's what I'm trying to do: I have a many-to-many relationship between Authors and Books since a book can have one or more authors. In the books database we see a list of the associated authors via a portal. This is all well and fine for data entry screens. However, when doing reports we don't have room for a vertical list of authors, we need them to be listed horizonally. Typically we'll only list their last name. The three things I can think of are a horizontal portal, merge field, or calculation. The first would involve rotating the orientation of the portal somehow so that multiple records are disp…

• 10 replies
• 988 views

bdam

July 14, 200619 yr

I am working on a database for an Talent Agent and need to have a section for scripts that they recieve. I would like to created a button where you can add roles and when you press it I would like there to be a pop-up row with fields to enter... Basically on of the records to be a pop-up... Is that possible? Thanks Frida

• 4 replies
• 958 views

frida

July 14, 200619 yr

I had a non-specific question - what is the most common layout size that developers use. I tend to use the FM default - 640x480, and it leaves me cramped for space. Since people have higher resolution monitors now, it is OK to move to 800x600 or even higher? How about full screen layouts? Will customers accept it? Most of my windows customers seem to want a full screen mode and mac customers like a small window. When developing for mixed OS use, I'm stuck in between. thanks indy

• 1 reply
• 710 views

IdealData

July 14, 200619 yr

I think this is a fairly simple question, but I can't find the answer to it anywhere, either in the manual nor in the 'Missing Manual' book. I need to make an Invoice-like layout, that summarizes a physician's appointments in a particular date range. So basically, I need the user to be able to select a patient, start date, and end date, and find matching records (there is a table which contains the appointments). I haven't figured out how to 'Find' records that lie between the two inputted dates. How do I do this? Thanks in advance!

• 10 replies
• 1.1k views

Kadin2048

July 14, 200619 yr

Hi all! How is it possible to get the Language Info out of this code? In this example it is English but could be anything. I tryed "LeftWords ( iMedia::Test; Position ( iMedia::Test ; "Language:" ; 1 ; 1 ) + 2 )" But no success! This is part of the HTML code I try to filter. Language: English Like always thanks in advance. =) TMAS

• 2 replies
• 1.4k views

tmas73

July 14, 200619 yr

Is there a way to edit the html page that FM generates for User login for Instant Web Publishing? Why I am glad it has that feature, I would really like to change the way the login page looks.. :)

• 1 reply
• 770 views

Tanner

July 14, 200619 yr

Finally a way to display gif on a layout !! use a small Web Viewer and a local gif file address and you are ready to go ! Xoomaster

• 1 reply
• 1.4k views

Raybaudi

July 14, 200619 yr

In my latest upgrade (FM8 Adv) users are complaining that some records in some layouts have anomalous spell check options. Instead of Replace at the top choice in the spell check window they get Next. I can't figure out why this is so, or what to do about it. Seems quite odd. Have tried various approaches, dictionary selections etc. Any clever ideas?

• 1 reply
• 634 views

Raybaudi

July 14, 200619 yr

Should we be concerned about stuff like malware and other web nasties getting in through the web viewer?

• 1 reply
• 1.6k views

AlanP

July 13, 200619 yr

I hope i can explain this clearly. I have a parent TASK table. Two children tables, BUDGET and FUNDING, tied to TASK On the main layout I have portals for both children tables. A button script adds a new portal row in BUDGET. When i add a new portal record, I would also like to add a new FUNDING portal record and any data that is typed into BUDGET will get copied into FUNDING. I hope to allow the user to manipulate the data in FUNDING, without touching the fields in BUDGET. How would i accomplish this? Thank you!

• 0 replies
• 717 views

deego55

July 13, 200619 yr

I was playing around and it seems you are limited to receve of data to the pre defined web services, like google, fedex and so on. Would it be possible to recieve data from Amazon.com or imdb.com? Anyone knows? Will this be possible?

• 13 replies
• 2.8k views

Wim Decorte

July 13, 200619 yr

I am wondering if it is possbile to only show a specific value of a field inside a portal. For example, If I have a drop down value list where I can choose either birthday party, group event, or coporate, I only ever want my portal to show the values for the birthday parties. Right now I have my relationship(self join) based on reservation type and I am getting all three(birthday party, group, and corporate) to show up in my portal. If anyone could help it would be appreciated thx

• 1 reply
• 648 views

Fitch

July 13, 200619 yr

Hi everyone, I am a beginner in FM (using FM Pro 6) and have troubles customizing even though I have went through the help files and book. Hope someone can help me on this problem I have. I have 2 fields; Field A and Field B. Field A is linked to a value list. However, my problem is that I want it customized in such a way that when I select an item from Field A, if would reflect a value list of my choice in Field B. e.g. When I select "Furniture" from the drop down menu of Field A, I would want to see a list of furniture (already created a value list for it). Likewise, when I select "Hardware" from the drop down menu of Field A, I would want to see a list…

• 2 replies
• 737 views

lefei

July 13, 200619 yr

Hi all, I've got a portal on my main layout which links to a "Notes" table, where the "Note" field for each record linked to my main layout's "Task" field is displayed. Some of the "Note" fields can contain a LOT of text, but when I browse my layout, it gets truncated to fit inside the field as drawn in the portal. How can I make the portal field 'grow' to show all of the Note text? Many thanks, Steve

• 7 replies
• 1.2k views

Genx

July 13, 200619 yr

Hi, We have a User privilege set, for whom we want to deny access to certain menu options, for example: Records, Duplicate Record. We also have an Admin privilege set, for whom we want to have access to all menu options. The default menu set in the file, and the default menu set for all layouts is the Standard FileMaker Menus. We have a script setup in a file, like so: If [Get ( PrivilegeSetName ) = "User"] Install Menu Set ["Custom Menu Set"] End If This works really well, until we use: Go to Layout [x] As this effectively brings back all the menu options... Doing it the other way around is not really an option either (by settin…

• 7 replies
• 5.1k views

mlemmnapa

July 13, 200619 yr

I have an Invoice table and a Payment table with a join table in the middle: INVOICE ------ PAYMTDETAILS ------ PAYMENT. In the PaymtDetails portal on Payment layout I have InvID set as drop down list based on a value list. The VL is built on a second TO of Invoices linked to Payment by custmer ID (gCustID in Paymt = CustID in Invoices2) to allow me to filter the VL by customer. It is working fine. I tried to improve on this by wanting to further filter the VL to show only invoices that have a balance left (gCustID = CustID AND gAmount in Payment < InvBalance in Invoice). InvBal is an unstorable calc field in Invoices. The VL stopped working because InvBal is an u…

• 0 replies
• 777 views

gaby78

July 12, 200619 yr

Hi we have 200 school,we do job for all schools every day,at the end of the month I have to do report showing school ID,schools name,total of jobs,total of copies. How do I do that? Please(por favor)

• 5 replies
• 953 views

DZ

July 12, 200619 yr

Hi, Hate to bother everyone with this (more than likely simple question)… I am plodding along pretty well, with my books and this forum, however I have one I just cant seem to make work. I have a date field, and I have a total hours field (the two fields go together in the same layout). I have a field which I want to show the total hours for all the fields which have a date during 2006.or 2007 or 2008 etc. Example Date Field xx/xx2006 xx/xx/2006 there is an hour field adjacent to the date. Hour Field 22 31 Then a total hours by year Total for 2006: This is what I cant make add up I want to have a field tha…

• 11 replies
• 1.2k views

comment

July 12, 200619 yr

http://www.filemaker.com/products/fmp/integration.html the phrase below is from page above; "Viewer lets you view information from Web-enabled products and services — and in some cases pull data from that web page into fields in your database." But how? and what is the cases. Thanks

• 2 replies
• 1.6k views

Fenton

July 12, 200619 yr

Hello All. I'm not sure if this is the most appropriate forum for this question, but I've always gotten great support from this site, so here goes: I would like to include a font or other appearance change as part of a script. I have many text buttons set on a layout to find various groups (using buttons rather than find commands to make the layout simple for novice users of this report). However, it's impossible for users to tell at the moment which button has been activated, and therefore which subgroup has been found. I would love to find a way to include a font color change as part of a script, so that I can make the button text indicate the butto…

• 3 replies
• 786 views

Fitch

July 12, 200619 yr

Hi, I'm having a really annoying issue with FM8 redrawing the screen multiple times. If I just click on the windows taskbar my FM8 screen will redraw itself sometimes 6 or 7 times ! I have now noticed that the redrawing is reduced and eventually eliminated by closing other applications. If nothing else is running, the redraws don't happen. But its impractical to have to close everything just to run FM. If I have another application in my active window, I can see my FM8 screen in the background busily redrawing itself over and over continuously. If I click on an FM menu option, I might get 3 or 4 redraws before the menu item I clicked on is activated. …

• 5 replies
• 981 views

djlane

July 12, 200619 yr

I can enter data into a portal and it creates related records, however the data entered into the portal then disappears! The related files remain. I cannot see my related records from the portal. Parent table: Volunteers Related table: Volunteer notes Any help would be appreciated. I am trying to get this database completed.

• 3 replies
• 763 views

J__

July 12, 200619 yr

need some assistance please: -- in one layout i have individual records with up to 10 categories assigned to each record via a custom value list. -- in another layout i want to select from a single pop-up field based on the same custom value list and perform a search of all records that have been tagged with the selected category (they then appear as a list). i've read that without a plugin, the only way to do this is with a scripted button, which is fine by me...but i'm having issues with that script...seems like this should be simple...but... also...one weird thing...when i select from the "search" pop-up...it seems to disappear...and otherwise behave er…

• 14 replies
• 2k views

comment

July 12, 200619 yr

Hello, I would like to know if some one is using an easy way to detect if some field in a layout has been modified. (I.e. using the eval function). I´m actually using calculation fields for every field that I want to track, but this is hard to use in layouts which has a lot of fields inside them. (sorry for my english) Thank you in advance.

• 3 replies
• 851 views

Razumovsky

July 11, 200619 yr

I've been playing around with this new function a little and I'm trying to figure out if there's a way to extract data from the web viewer window and put it into fields. For example, say I've got a table with about 50 records (or a lot more), each of which has a Fed Ex tracking number field. It's easy enough to have web viewer windows for each record to show the raw tracking data but I would like to be able to extract the pertinent data such as ship date, delivery date, signed for, etc., and automatically insert them into fields for clean reporting. Does anyone know if this is possible? Thanks!

• 4 replies
• 2.9k views

Buggen

July 11, 200619 yr

??? I may have misunderstood and misspoke--- and now I am really confused and would really appreciate being informed on the best practices…. I have a main menu- with Data Entry, Query, Reports and Maintenance I am in the process of changing the Data Entry screen so that you cannot do a find on this layout. Is that the best practice? What if a user wants to find a person and edit the record? On the Query, the user puts in the criteria and the find comes up in a table view—but she sees an error and wants to fix the salary or something. Do I link the find results to the data entry field? What is the best practices or what do you recommend? Thanks for …

• 1 reply
• 618 views

Fitch

July 11, 200619 yr

See now via FileMaker Learning Center http://www.filemaker.com/eight_five/learning/pop_movie.html?src=T01_v1.mov

• 1 reply
• 12.5k views

ralph.nusser

July 11, 200619 yr

I have a related field that displays in multiple rows in a portal. I need to create a list in sentence form using the related field as it presents sequentially in the portal (Field occurance 1, Field occurance 2, Field occurance 3, ...) Would I best do this with a script that copies each portal row and pastes the data into global fields, and then concatonates the globals in a calculation? Is there a more elegant way to do this? Thanks

• 42 replies
• 4.1k views

Squeaky Data

July 11, 200619 yr

Hello My (grossly simplified) situation is this: I have two tables called Apples and Oranges. They are linked properly using one field. Apples is the main table with records from Oranges displayed in a portal. Apples can be locked to prevent editing or deletion via scripting and the access in the Accounts & Priviledges setup. When this occurs, there is a script that also enables the Oranges records in the portal that prevents them from being edited or deleted. So far so good. My problem is this: Creation of the records in Oranges occurs from the portal on the Apples layout. Once the Apples record has been locked from editing (and at the same time …

• 1 reply
• 799 views

Tim W

July 11, 200619 yr

I have an application where it would be great to refresh a field to display the current time. In other words I want to automatically refresh the field every second to update the time for the user to view. How do I get Filemaker to refresh the field every second? Thanks!

• 8 replies
• 3k views

Reed

July 11, 200619 yr

I'd like to have the user select a radio button and then run a script based on that selection. I can set the script over the buttons, but it runs it without changing the value to the one the user clicked on. Any ideas? Thanks, Scott

• 2 replies
• 724 views

SteveB

July 10, 200619 yr

Please help me, I am a rockie when it comes to filemaker, but have been playing around this weekend and finally started to created my database. I'm stuck now though as I want to work with three tabswhere fill in information to make things easier for the users. When I add fields on a different tab they keep on overlapping when I preview. I want different fields in the different layers. How does it work? Please help me so I can crack on. Thanks Frida

• 4 replies
• 1.7k views

Lee Smith

July 10, 200619 yr

I have a field which uses a value list drawn from the records in a related table. All the items in the list display perfectly if I format the field as radio buttons or check boxes, but nothing appears if I select drop-down list or pop-up menu. Clearly, the relationship is good and the value list is properly populating - what's wrong with the display?

• 4 replies
• 727 views

jwhitmill

July 10, 200619 yr

I want to be able to sort the rows of a portal manually. If you happen to be a member of Netflix, in order to manage your queue, you rank the movies you want to see in the order you'd like them sent to you. You get an ordered list of every film in your queue with an editable field pre-populated with its current numerical position in the list. For example, if I wanted to move "The Big Lebowski" from position 9 to position 1 in my queue, I'd replace the "9" with "1" in that editable field and hit submit. "Lebowski" jumps up to the top and the previous number 1 film drops to number 2, while the previous number 2 film is reranked to 3 and so on and so forth to number 9,…

• 3 replies
• 981 views

Razumovsky

July 10, 200619 yr

Hi All, I'm working on a purchase order database with FM8. I have 3 tables (Product, Join & PO). When I create a summary report, only the first line of product from the PO is displayed. There could be multiple products in that PO. Do I need some kind of loop? Or a different layout? Any help on that is greatly appreciated.

• 2 replies
• 675 views

MTG

July 10, 200619 yr

GOAL: to set up a field in which I can add multiple values that cannot be predetermined; the values would be added at the "new record" stage and could be modified over time. For each specific record, there could be some with no values in the field and others with several. Then I'll want to sort and list the records for specific values. Example of a test file called "hobbies". Let's say there are 2 fields: name and hobbies in the "hobbies" check box I would list: golf, tennis, fishing, etc., with a carriage return after each entry. So far, I have no problem when I sort by the hobby field and then to a find for "golf" -- I do get only the records that h…

• 2 replies
• 760 views

susan siegel

July 10, 200619 yr

I'v got a delimina that I need a little help! Right now I've a a field for called "plated_for" that is a pull down value list. Some times each record could have more then one item choosen in the "plated_for". When printing I would like for the field to show each item that was choosen seperated by a /. example. if "plated_for" has 525 and the 840 selected then it needs to show it as 840/525. can this me done or is there a better way to go about this! Thanks Devin

• 12 replies
• 1.1k views

Devin

July 10, 200619 yr

Hi, I'm having a little problem with a conditional checkbox. Basically, I have 2 tables (Staff & JobRoles) and want to have a check box in the staff table which gets it values from the JobRoles table but conditional on a field in in the staff table that has the persons current qualification level. So, if a user selects say level 2 as the qualification level, the checkbox shows all level 1 and level 2 roles. The roles available would then increase as the person becomes more qualified. Can anyone help me... gratefully, Paul

• 3 replies
• 804 views

PaulS

July 10, 200619 yr

Is it possible to have 2 or more portals, both of which access data from the same table yet are sorted by different criteria on the same layout? For example: Portal 1: accesses data from invoices and displays the current weeks records. Portal 2: Displays all invoices for a particular customer. Both portals access data from the invoice table but are sorted differently. Thanks. Rick

• 9 replies
• 896 views

rborge

July 10, 200619 yr

Is there a way to make a button inactive if the user is viewing the database from a web browser as opposed to the FM application? I have a script that contains some functions that ARE web compatible, and some functions that are not web compatible within the script attached to a button. If a web user clicks the button, it runs part of the script (the part that IS web compatible) and ignores the non compatibile part, which then breaks the data in the database.

• 4 replies
• 896 views

Ender

July 9, 200619 yr

I'll bet there is a simple answer to this that I am missing. How do you set a checkbox with a script? It's not working consistently for me with records viewed through a portal. I can uncheck by setting the box value to null. However, setting the value to 1 only works for one record. The checkbox is only there to indicate that a record has been related with another through a join table. I just need checkbox on and off.

• 2 replies
• 930 views

dxl

July 9, 200619 yr

I would like to display a found set in a list-like format, using a portal on a Form View rather than using a List View. (I'm placing it on a tab layout which is in Form View.) I thought I could do it by creating a relationship between Contacts and Contacts_SelfJoined, and having the portal show records from Contacts_SelfJoined, but it only shows the current record, not the entire foundset. I think GTRR must play a role, since it allows me to specify "Show Only Related Records matching all records in current found set" but I can't figure out how to use it. Any help would be greatly appreciated! Chap

• 6 replies
• 1k views

hbrendel

July 9, 200619 yr

I am building a task management solution. The main screen contains a series of (one row) portals which display the most recent activity a worker has been engaged in. If the worker is currently engaged in that activity the portal is highlighted from behind with a yellow container field. This is pretty handy. At a glance you can see what everybody is up to and who's on board right now. I would like to be able to click onto a portal row and go to the related record for that row. I would like to be able to view that record from a different layout where I could include more information. My portals are presented as separate rows because of the yellow…

• 6 replies
• 866 views

comment

July 8, 200619 yr

I have a LineItems table linked to Inventory table (ItemRefNbr=ItemRefNbr). In Inventory table I have a Status field (calc field) with the following formula: Case(not IsValid(LINEITEMS::ItemRefNbr);ItemRefNbr). The Status field shows ItemNbr only for Items not sold yet. When I try to create a value list on the Status field (to show unsold items only), FM won't let me. It keeps displaying the same message "This value list will not work because the field cannot be indexed". I need to create a VL that shows only unsold items. Thanks

• 5 replies
• 1.3k views

gaby78

July 8, 200619 yr

How do you get a portal on one layout to display the found set from another layout? My portal holds 5 records. I would like this portal to only display records which have the STATUS FIELD set to "active". Right now this portal shows the first five record from the other layout. It does not sort for the characteristic "active". If anybody can tell me how to accomplish this I would be your most humble servant. Jarvis

• 2 replies
• 776 views

Jarvis

July 8, 200619 yr

Hopefully I can explain what I'm trying to do clearly. The table I'm working with has records for each student. There is a portal in this layout that lists what number the student ranked each studio. It will always be ranked 1-9. So the portal just contains the field Rank and Studio. What I need to do is summarize a count of how many people ranked each studio 1,2,3,4,5,6,7,8, or 9. The other problem is that I want this at the end of a layout. The report above it is a listing of each student and their respective studio rankings. I attached a picture of how it looks now which is how I want it to look. But I had to create 162 fields just for t…

• 2 replies
• 792 views

fmdummy

July 7, 200619 yr

I have a report Day (sub - break before each occurance) Department (sub) Body This will report all department activites for a single day. When they layout is set to a single column, it all works perfect. But when I set it too a two column layout the departments from the next day will flow into the current day if there is room. Please help - thanks

• 2 replies
• 847 views

rivet

July 7, 200619 yr

This is my first post, I've tried searching without much luck. I've created a "Part Database" that has all the different Capacitor and Resistor Values we have in stock. Anyways... for some reason everytime I open the file, it minimizes automatically. So whenever I open the file I have to maximize it, I made a maximize script to automate that. But I still see it minimize and then maximize automatically... that gets annoying. I've checked the File Options and all the scripts and stuff... I'm really stumped and getting somewhat frustrated. Someone please help! Thanks in advance.

• 5 replies
• 800 views

Lee Smith

July 7, 200619 yr

Hi everyone. How would I go about setting all my layouts to always be maximized? Sometimes, clicking back and forth on buttons will resize the screen. I've tried the 'specify button' options, but then selecting multiple factors (such as the move/resize window and go to layout) will void the first option (i.e. I wished that these would be on a check on option rather than the highlight). Any ideas?

• 7 replies
• 1.3k views

Lee Smith

July 7, 200619 yr

I have a script that runs and opens a layout and it is finding on all the entries that have a specific agent name. It is fine in browse mode and returns the right db entries, but when I switch to preview mode it only shows the entries in the trailing grand summary and the Sub summary when sorted by part is empty. when I take of the find criteria and have the script return all entries in the db it is fine though ?

• 1 reply
• 695 views

IdealData

July 7, 200619 yr

Hi all, I hope someone might be able to help me out by shedding some light on my problem or even pointing me in the right direction. Please do let me know if I'm posting in the wrong section as this seemed like the most likely place. I'm a newbie at this so hope that you can be patient with me. Brief history: "I'm trying to create a simple solution for a database of properties transacted(sold) in my area. In this database, it would contain photos of the houses along with certain general details such as land sizes, the road name and postal number. There would be a table/portal to show the different sales transaction on that particular property." I have 2 p…

• 12 replies
• 2k views

Genx

July 7, 200619 yr

I'm doing a layout for a List view and I want the top edge of the Footer to seamlessly blend with the body rows. Right now there's a one-pixel-wide black horizontal line where they meet. I managed to accomplish this once, by placing wide rectangles on both the footer and the body and nudging them into some magic position. Today, nudge as I might, I can't find the sweet spot. I've never understood the rules by which FM renders layouts whose parts contain objects that partially extend beyond the boundaries of the part, but I think that is key to solving this problem. Anyone? Thanks, Chap

• 6 replies
• 1.2k views

Mandu

July 6, 200619 yr

I have some drop down menu fields in a database, and when I go into edit mode from a "Instant Web Published" database, all the text in the drop down boxes look like they are too tall to fit in the box. Or that the box is too short to show the enitire height of the selected fonts text in that field. But when you are not in edit mode, they look fine. Is there a way to prevent this?

• 1 reply
• 579 views

Fred P.

July 6, 200619 yr

Hi all... I'm still tryin to create a letter in FMP 8. the letter is divided in: Introduction Content closing finalisation. Ok. I also have a table with letter fragments. Every fragment has its language (selected before by user), its Category (like is it a complaint, or an information etc, also selected before by user), and a topic (selected before by user) The letter is composed by dropdownfields, one for each position (Introduction, Content, closing, finalisation) Now for the user to be confortable, by example for a letter in english, about green hills, and beeing an information, only the letterfragments that fit these criterias sh…

• 1 reply
• 652 views

AyCaramba

July 6, 200619 yr

Hello, I have a problem with displaying related records from a match field in a portal. Ok I have a field that users can enter search criteria. Ex) If they enter pr I would like to display everthing in the portal beneath the search that starts with pr. I have a self join relationship with the search string(text,global) to a calculated field with the product including the number of characters. Search_String <-> Left(Search_String;Search_String_Length) (I also create the search string length from the first portal and set it as a global to create the calculation field). I can not get this relationship to work, So if any one has any advise I …

• 1 reply
• 634 views

IdealData

July 6, 200619 yr

Is there a method of creating a value list from the Account Names within a database? Not a custom value list -- I am looking for a calculation for a field that would string together all the Account Names in the database, which could then be used as a value list? All help is very much appreciated.

• 4 replies
• 711 views

FMNan

July 6, 200619 yr

In a table view, the current record is indicated by a narrow band at the left. Is there a simple way to arrange that the entire row be highlighted (as in Excel, when you click on the row number)? I know you can put a button over the row, and you get a highlight effect when you press the button, but that's not sufficient. I'd like that same visual effect, but automatically for the current record, without requiring any user action.

• 1 reply
• 798 views

Mandu

July 5, 200619 yr

I have a database for a procedures handbook...there is a text field that will hold the text of documents, but cannot hold the pictures that would normally be included. The owner would like it so that somehow there would be placeholder links or something that when a reader is reading the document, could click to see the screenshots that would normally be there. He doesn't want to have to export files to open up the document. Maybe even a list of the screenshot files on the side...that could be opened up when the person got to a certain point in the file that they needed to see a certain picture. And how should I handle this in FileMaker? I'm new to it...should i…

• 7 replies
• 1.3k views

NeoCryptic

July 5, 200619 yr

Hi: I hope I can explain what I want to do: I have a layout with records from Table A, I want to show found records from Table B (un-related)in a new window, but I want to continue to show the layout from Table A as well. From Table A I invoke a script that switches to Table B and preforms a find, if records are found I want to pop up a new layout with the found records. This works for the new layout, but the underlying layout switches to the same layout as the new one. Can anyone give me some guidance, please?

• 1 reply
• 605 views

Fenton

July 5, 200619 yr

I'm attempting to make a template table with certain "housekeeping" type fields including my primary key field which will always be a serial #. I would like this serial # to be done with a calculation so it will grab the first three letters of the LayoutName and then I want it to include a number starting with 1 but including six zeros before the 1. As the serial # grows, there will be less and less zeros before the # (ex, INV0000124, INV0001335) This is what I have so far: SerialIncrement ( Left (Get ( LayoutName );3); 1 ) I don't know how to write this calculation to force the # portion of the serial # to 7-digits. Can anyone help me out? Thanks! C…

• 3 replies
• 921 views

John Mark Osborne

July 5, 200619 yr

Hi, I'm a newbie. I thought this problem would be easy to solve for me but I was wrong. I have a table that contains- RecordID, CustName, UserName, Password. I want a layout that would show a list on the left side of the layout containing all CustNames (with scrollbar), a user could click on a name in the list and the Username and Password for that record would show up in two fields on right side of the layout. Can anyone start me off in the right direction? Thanks, Kevin

• 5 replies
• 888 views

KevinRan

July 5, 200619 yr

hi, i have a layout with a portal in it, it displays fine in layout mode. however, when i print it it always shows an extra record. the 'allow creation of new records' is unticked for the relationships. any ideas? thanks

• 7 replies
• 777 views

sal88

July 5, 200619 yr

Hi I've been working on a pretty large (well for me) database for a while now and the client has one final request, which has me stumped! I have two portals each containing a list. When I click on a row in portal 1 it appears in portal 2(All thanks to Reed : - Topic#174330 for those who would like to check out how to do this). What I now need to do is omit the item from portal 1 when it is transferred to portal 2 and visa-versa when it is removed from portal 2. Hopefully that makes sense, because I could really use a hand with this one! Thanks

• 0 replies
• 688 views

MYK

July 5, 200619 yr

Hi, I have a problem and I need some help. I’m a very beginner. I use FM8 on XP for the first time and as usually, it’s painful when you don’t know the software and especially scripting part. This is my problem. Let say I have one layout with portal, the main table and the related table – it’s in the portal. Now, if I have some records, it’s displayed in the portal. One record in the portal has ID record form another table. I would like to know: 1) how can I check the number of records in the portal (tab: Class & ScheduleClass) ? One field in the table ScheduleClass is populated from value list based on the table Plage. 2) if there are some records…

• 8 replies
• 1k views

Vaughan

July 5, 200619 yr

Hi everyone, I have a newbie question...how can I auto-enter a single value in all the repetition fields? For example: I have a field "Color" with 3 repetitions. I would like to auto-enter "Blue" into all the repetition fields of "Color". Right now, when I auto-enter "Blue", only the 1st repetition field is affected. The 2nd and 3rd repetition fields remain blank. Thanks for your help.

• 4 replies
• 1.6k views

Søren Dyhr

July 4, 200619 yr

I am creating a bookings / scheduling system using FilemakerPro 8. I have two tables, one containing all the booking details and one containing client names, addresses, phone numbers etc. I want to be able to do the following: 1. Create a new record containing the booking details. 2. Have a pop-up menu showing a list of companies from the client list table. The user then selects one, for example Acme Industries. 3. Have another pop-up menu listing only the people who work at that chosen company. The user then chooses which person from Acme Industries. 4. Have the phone number of the selected person (this is stored in the 'clients' database) displayed automati…

• 0 replies
• 655 views

hellopaul

July 4, 200619 yr

Is there a way when using web publishing with FMP to have it default to not showing the left side panel that allows users to select layouts and move forward backward through records? I dont like the way that window looks.

• 1 reply
• 716 views

IdealData

July 4, 200619 yr

Sorry if this is not the correct section for this question but I did not see a section relating to backups specifically. I have two db’s that I am working with, I have defined the file reference to db #2 so that I can bring up the needed info to db #1. My question is about backup…if I do a backup via the standard method, I am only backing up the working db #1. Is there a script that I can use to backup both db’s in one motion. Thanks, Jim

• 4 replies
• 847 views

Its Just Me

July 4, 200619 yr

I'm having a small problem, well small isn't exactly the word for it. I'm attempting to relate a global in the parent table to an unstored calc in the child table and then to display the related records using merge fields --> All i get in browse mode is: . Could anyone please shed some light on this? Cheers, ~Genx

• 2 replies
• 1.4k views

Genx

July 4, 200619 yr

Is it possible to use a merge field and specify a repitition number for that field? If so how? I have a Global Text field with repititions used to hold user-friendly layout names. I want to show the user the Layout Name by setting the repitition number. Thank you.

• 2 replies
• 762 views

dxl

July 4, 200619 yr

This may just be a short coming of filemaker's features, but I thought I'd ask. Is it possible to have a layout or part of a layout that will lengthen and shorten itself based on the amount of data in a field? Some records I use have 30 lines of text while others have only 5. It would be great if I didn't have to use space on the paper when I print for 30 lines of text even though every record doesn't use 30 lines. Any thoughts?

• 14 replies
• 1.3k views

Razumovsky

July 3, 200619 yr

I am a total newbie when it comes to FMP, but I want to create a database (or set of databases) to keep track of my genealogy research. There would be a main database that would hold all the fields necessary for what I want to keep track of. I’m not sure if I will need to create other databases with relationships back to the main research one OR if Value Lists (editable) in the main research DB will be sufficient. So, my qustion is this: If I create a Value List for a certain field in the main research DB, say, Locality, and enter in about 100 entries, does that have any adverse afffect on performance in FMP? Would a better option be to create a separate databas…

• 8 replies
• 1.1k views

Genx

July 3, 200619 yr

Hello! So... I've got a product sheet that contains 8 sliding repeating fields (of maximum 10). As you can probably guess, this takes up multiple pages. I'm sure I'm not the first one to ask this (I did look), but is there a way to stop the fields from crossing pages and starting on the next page? I've fooled around with subsummaries, but I don't like the way they work, as on some occasions, these fields only contain one repetition. Thanks in advance, M

• 10 replies
• 1k views

Genx

July 3, 200619 yr

Hi, Need some more newbie help, cant seem to locate info or figure this one out on my own. I currently have 2 tables, I have a portal from table 2, but what is messing me up is the first field from the second table. I have 4 fields in this portal, for some reason the first field will reproduce the same data in each field. For example if I enter the following via the portal: (each number will represent data into a separate field) 1 2 3 4 (all is well, until I start to enter more data below if I enter 5 6 7 8…this is what shows up 1 6 7 8. So what I have is: 1 2 3 4 1 6 7 8 1 9 0 etc. The first field keeps changing to the…

• 7 replies
• 786 views

Its Just Me

July 3, 200619 yr

Hi, Newbie question i think. I have a related field that displays in multiple (26) rows in a portal. I want to put all the information from this portal into a field that I can insert into a calculation so I can email it. to someone. How do I get the contents from the portal into another field that I can email? Much Appreciated

• 3 replies
• 636 views

LaRetta

July 2, 200619 yr

I'm working on an inventory, invoicing, and customer database for an art studio. the invoice table uses a seperate line item table with a portal on the invoice layout. they only sell original artwork, so each record in the product table is unique and only has one in stock. I want to create a value list that contains all records in the Product(Art) table that are not sold.... whats the best way to do this???

• 2 replies
• 758 views

Don't Panic

July 2, 200619 yr