FileMaker Interface Features
-
Hi all. Noob. 8.5, Mac. I've got a quick & dirty database that allows one to enter related child records via a portal. Not the recommended solution, but it's really just for (my) training. It appears that when you begin to enter data in a portal row, the next row's fields become 'active', highlighting field borders and activating popup menus (although they all remain blank). I'm sure that a new record isn't being created, but it's odd looking, and implies to a user that another record was created. The portal's deletion mechanism also implies that there's one there. In fact it's left ambiguous as to when a child's actually been created. Is this the normal beh…
-
- 2 replies
- 996 views
-
-
Hi This is my query. I have a button on LAYOUT A to create a new project. When this button is pressed, the script takes you to LAYOUT B and creates a new record(Project) for you. After creating, it goes to the first record and shows that one instead of the newly created record. I added GO TO Record LAST in Script step and it does that but after the step is completed, it goes back to record 1. This is really driving me crazy. I do have a commit record after New Record request. Any help would be very welcome... Thanx
-
- 1 reply
- 755 views
-
-
Hi there, I'm building a task management database, and have hit a problem with using tabs on the layout. What I want is to have seven tabs, showing the upcoming seven days, letting the user flick between them and see what tasks lie ahead for them. I'd like to have the names of the days on the tabs themselves, but this needs to change dynamically. So on Monday the first tab says Tuesday, next one says Wednesday. On Thursday the first tab would say Friday, second Saturday etc. The problem is that using Filemaker 8s built in tabs layout tool thingy, it seems that the tabs can only have basic text names. Is there any way around this? The only way I can th…
-
- 4 replies
- 1k views
-
-
I can generate a value list of ID numbers already in use, and validate from it to verify that an ID number is in use. Is there any way to use the same list to generate an Id number that is _NOT_ in use? Alternately, is there any way to make a value list of numbers NOT in another value list, or in a specific field in a multi-record DB?
-
- 1 reply
- 955 views
-
-
I've started playing around with the data:URI trick shown off by "The Bridge", and SVG to allow the dynamic creation of graphics in the webviewer. My examples are pretty lame so far, but there is clearly a lot of potential here. Take a look at the attached fp7 file. The sample file is setup for Mac users, and you'll need to download the SVG plug-in from Adobe if you haven't yet (the link is in the fp7 sample file). Hopefully this will motivate someone to do something cool, I'd like to see a custom function that constructs a pie-chart, for instance. :) svgSample.zip
-
- 14 replies
- 4.2k views
-
-
Hi. New to this forum. Thanks for having me. I've learned lots of useful stuff so far. I have a very frustrating problem and one that's vital to the success of a current project. Basically I have a bunch of records that need to be printed out in a report that looks exactly like a pre-existing MS Word document. The information is contained in a table with 1pt borders for all of the rows/columns/cells. With sliding, merge fields and horizontal and vertical graphical lines I have managed to create a document that is 95% what I need. Unfortunately underneath the bottom most row of every report page there are "extra" hanging vertical lines right above the f…
-
- 0 replies
- 749 views
-
-
How do I create a horizontal slider? I want the user to rate between "good" and "bad", good being 100 and bad being 0.
-
- 4 replies
- 1.2k views
-
-
Preface: I am using FMP 8.5 and Running it thru FM Server 8.0v4 on a Windows 2003 server. We are autheniticating via external server. I received the Web viewer example from Filemaker and thought that I might be able to utilize the graph examples that were included. After some tweeking I was able to get them to do just what I wanted. The problem is that after I copy the new file to the Databases folder and start the FileMaker Server service, the web page in the viewer cannot locate the VW.html file. Whats strange is that the file is found when I'm connecting with out the files being hosted by the FM Server service. If anyone has any experience witht his I'd be happ…
-
- 0 replies
- 1.1k views
-
-
I have a layout with a title header, regular header, body and footer. Everything in the body is sliding up and slides great! But no matter what... it always seems to print two pages. Anybody think of a reason why it would do that? Is there something I have to do to the body so that it doesn't always show 2 pages even if all the data has moved to the first page? Oh and just incase, there's TONS of room on the first page when I test it. I'm puzzled
-
- 2 replies
- 797 views
-
-
I have 3 Tabs (One, Two, Three) which each contain 64 Unique fields in 8 rows by 8 columns. The first field in each row holds a unique ID number. This unique ID number is currently being input by typing. I have a portal which contains the unique ID number that is currently being typed into the Tab. What I want to do is: Click on the ID field and have the Unique ID number in that field placed inside the Tab ID Number field. Herein lies the rub: I need the current TAB (one, two or three) and an EMPTY Tab ID Field to be selected. So Far: I have made the Portal Field ID Number a button and have extracted the info from there. Having trouble finding an empty…
-
- 18 replies
- 3k views
-
-
(Update): I just now saw that the "Security" section where this should have been posted, if the MOD wants to move it to the proper section. Sorry about posting in the wrong section. Update 2: I just found a post asking about a custom message like this and was stated as this is a canned message. So, I guess Im stuck with it. Thanks. Now to my question: On a layout which the user does not have permission to change data in a field (as defined via their Accounts and Privilege settings) is it possible to change the default message of "Your Access Privileges Do Not Allow You To Perform This Action" be changed to a custom message? Or is this a canned system mess…
-
- 0 replies
- 803 views
-
-
Alo I would like to create a txt file from filemaker but what I itend is to apply the ID of a X record to be the name of the file.
-
- 6 replies
- 1.2k views
-
-
This is my 2nd problem with current project. This one I don't really have any idea. I am designing a bookings database for an Entertainment company (electric bull, castles etc). I have the following tables. - Clients - Bookings - Products - Delivery Details All seems to be working OK, but I would like a report in a calendar layout for each month. can this be done, through Filemaker, or a third party plug-in etc? Something like this - standard online events calendar layout. http://www.calendarscript.com/demo/calendar.pl Many thanks Trevors
-
- 2 replies
- 1.6k views
-
-
I am trying to figure out how to handle this problem, and I am sure the experts on here know the answer. I have a layout that has a value list to select the employee. The value list shows related values based on a table that filters out employees that are not mine. So when a Supervisor goes to the layout and makes a record, when he selects an employee, only his show up. The Supervisor may have 13 employees, but if i didn't do this, all 350 would show up in the pop-up list. If I am looking at one of the records and duplicate it, then go change who the employee is, I see only my employees. When I click on new record, which is what I would really want to do, I g…
-
- 8 replies
- 1.5k views
-
-
We bow to thee oh mighty forum! I hope Ill explain myself right. I have a master record in a master table with a related table. In the related table are two lengthy text fields. The related table has say, 20 records relating to the first master record. When I want to print the one master record i wanto print the 20 related text bits with it. Easy I hear you say, just smack a portal on your print layout, give it say 50 instances and set sliding printing "up" and bingo it all will print. Yes and no and this is a baaad approach because: a) the size of the portal may be smaller than whats in the text fields so they may be cut off and : what i…
-
- 6 replies
- 1.2k views
-
-
I have used the infininate assignments example from filemakermagazine to create a 5 level dynamic value list. In the sample filemakermagazine uses a portal to select from that list. I am hoping to show the parent list items in 1 window, and show the children for each subsequent level in its own value list display. Hence, for a five level list like mine, there should be five windows, each one showing the available selections based on the parent. Here is my sample: www.jarrodprice.myhomeserver.com/sample.fp7 Please feel free to make any changes to the file
-
- 0 replies
- 1.1k views
-
-
I have a database with the following tables: Customers Orders Products I have done a layout for the order that is linked using a relationship to the customers table (Customers::CustomerID linked to Orders::CustomerIDfk). It works fine However, I have also done a portal in order to select the different products bought by a customer. I have established a relationship between the order table (Orders::ProductIDfk) and the Product table (Products::ProductID). I want to be able in my order layout to add records via the portal but it doesn't work. What am I doing wrong : Hope you can help...am i missing something ?
-
- 7 replies
- 1.4k views
-
-
I'm trying to populate a drop-down list with one field based on the value of another field (both fields contained in the same table). I have a table, contacts, containing: contactID isFacilitator The isFacilitator is a yes/no dropdown box for data entry. In another table, I need to enter facilitator information. I'd like to populate a drop-down value list there with the contactID of all the records where isFacilitator equals yes. This seems like it should be pretty easy, but my googling and searching here doesn't seem to help me much. I'm a total noob to FMP, which probably explains why what I'm finding seems far too complicated. What's the ba…
-
- 0 replies
- 960 views
-
-
Is it possible to switch a portal based on changing a value from a value list? i.e Let's say the user chooses store # 100 and there is a portal that lists all the items for that store. The user then chooses store # 105. Can the portal then be switched to the info housing store # 105? Thanks for any insights!
-
- 1 reply
- 909 views
-
-
I'm a beginner at all of this - so sorry if my question is in the wrong place or is a repeat of past inquiries (I tried to find something like this in the archives but was not able to). I work for a contracting company and am trying to come up with a solution for creating a calendar layout for the jobs we are installing. Most of our jobs take a minimum of two days. I have fields in our customer database for "Start Date" and "Completion Date". We have been recording a visual journal in Excel. It consists of columns which are assigned to an installer, and then each row represents one day (which is nice because we can see 3 weeks worth at once, and schedule th…
-
- 1 reply
- 1.4k views
-
-
I have checked all over this website and i cannot see to find the answer to my question. I use Version 6 and i have made a few databases with relationships and all. i have: Orders Customers UPS Now what i want to do is in the UPS database is make a dropdown value list that populates based on another dropdown list. (confused???) read on: in UPS Database i click on CustomerNAme and my Values are a lookedup value from the Customers Database. THis works fine but what i want to do is populate the P.O.Number Dropdown list with only the values that are associated with the CustomerName that i picked. example: in UPS Database i Click the Custome…
-
- 1 reply
- 984 views
-
-
I am trying to creat a portal where each row has many choices that can be made and not simply one drop down list of several choices. As an example lets select to purchase an ad: First would be a drop down list of the publication type (weekly mailing, seasonal, annual directory, etc.), then based on which one is chosen we now have a second value list that directly reflects the first choice. The second drop down is the location that the publication is sent to, if the first choice was weekly mailer than they may get 5 locations available but if they chose annual they may get only 2 locations available. Following would be a third drop down for ad size, again that list would b…
-
- 1 reply
- 930 views
-
-
In a webviewer, when clicking a link that is specified to open in a new window, the default browser is opened. Is there a way to force it to open in the same webviewer in FMPro instead? TIA, .sly
-
- 1 reply
- 1.4k views
-
-
I need to create a series of fields with value lists similar to this: Field 1 uses value list: Vegetables, Fruits, Meats. Field 2 uses value list: tomatoes, corn, apples, grapes, beef, chicken. Field 3 uses value list: Beefsteak, Cherry Tomatoes, Corn on cob, kernel, red delicious, granny smith, red grapes, green grapes, steak, roast, whole chicken, fryer parts. Now here's the tricky part (well tricky for me - that's why I'm here). After I choose say Fruits from the first value list, I want ONLY choices applicable to fruit to appear in the next value list, in this case APPLES, GRAPES. Then when I choose one of those, say Apples, I want ONLY the following to appea…
-
- 3 replies
- 1.5k views
-
-
Hi! I want to remove the filemaker menus in FM6. Is this possible? Normally I work in FM8.5 Advanced, where the solution is a walk in the park. In FM6 I am somewhat more disoriented... Thanks!
-
- 4 replies
- 2.2k views
-
-
Is there a way to show/hide an item on a layout based on given criteria? For instance, in our system there are times when we print a different invoice for the customer based on actual items on that invoice. We have a script that prints off an invoice and runs through If/Then check to see what items are on the invoice and decides which layout to use to print the invoice. I'd like to the same type of thing with actual items on a layout. If I create a button on a layout, but I only want that button to show up if the field Auction_Status = 'Current' for example. Any information on how I could do this would be greatly appreciated. Thanks!
-
- 3 replies
- 1.1k views
-
-
Hi all Is there a way to attach a calendar to a date field and have the calendar popup when the user enter the date field and the user then can pick the date from the calendar. Can this be done by Filemaker or is there a add-on that can do this. Thanks for all the help in the pass and in the future. Lionel
-
- 7 replies
- 1.1k views
-
-
SHORT DESCRIPTION OF PROBLEM: How do I keep the "second value" in a value list from disappearing if the relationship between the two tables is no longer valid? LONGER DESCRIPTION: I have two tables: PRODUCTS and SEASONS. Every product is assigned a season via a value list, and the season ID is the match field that links the two tables. The value list is defined to show only the "second value", which is the friendlier season name. Users can "close" seasons on seasons pages, meaning that the seasons have passed and will never be chosen for new products. I want a closed season to not be available in dropdown lists to keep the list from growing ever longer as years …
-
- 3 replies
- 1.1k views
-
-
I'm a FileMaker newbie with Access experience. I'm trying to set up a reporting menu where the user can specify the criteria to filter records by and some other data to use on the report. On the main data layout, there is a portal and that is one of the fields by which records can be selected for reporting. Using a script, I have managed to get into Find mode and insert some data from the reporting layout into the field on the main data layout BUT it is the field name from the reporting layout, rather than the contents of that field. What's the magic characters I have to add, please?
-
- 3 replies
- 1.6k views
-
-
I have some student evaluations that I need to display in a portal but I only want to display the last evaluation for each students based on a search date (a global). I have a script markings these records right now, but would want to eliminate it (no buttons). What's the best way to achieve this ? I'm trying with a custom function but I'm stuck on how to do it (not enough experience). Must refresh quick if report date changes and be indexable for use in the portal relationship. Thanks Claude Ex. All last evaluations before 22/02/2006 (the global) would give ID_________eval date___[color:red]Calc result student1___28/02/2006___0 student1___2…
-
- 0 replies
- 832 views
-
-
I print an attendance roster of members eligible to attend faculty meetings, some who have voting rights, some who do not. If a vote is going to be taken in the meeting, we need to accurately count the number of voters to establish whether a quorum has been reached, in order to make the vote official. I used to have the names formatted as such: printed in red for voters and black for non-voters. But these prickly professors were offended by being marked in red (or not marked in red), so I created a calculation field which displays a discrete * by the names of the voters so we can take our necessary count. Here's the problem. In two places on the page when I print…
-
- 1 reply
- 969 views
-
-
Using 8.5 Advanced on XP SP2. Problem has happened on all version 8 releases, and maybe 7 although I don't really remember. On imported graphics, things like a Photoshop border with a gradient shadow, when I stretch it, it starts to get lighter and lighter on the right side. The pixels start to disappear. If I put it in a container and then stretch it, same problem. Anyone see this before and have a solution? This never happened in 6 or below. Thanks, Steve
-
- 3 replies
- 1.3k views
-
-
If I need to post this in a different forum, please forgive me and point me in the right direction. Creating a database for a client and have one more bump to get over before I'm home free. I'm trying to set up a report and I can't get the results I want. I know it's simply because I don't know enough about parts and summary fields, so I could use some help. I have a number of financial entries. Let's say five of them are in January, and five are in March. When I create my report, sorting by date, it gives me January, January, January, January, January. I'd like to group all financial entires in January, so that I have a "January" heading with just the fina…
-
- 6 replies
- 2.1k views
-
-
I have an invoicing database that pulls pricing information from another table. We have multiple prices for the same items depending on different criteria. What I have done is create a table that holds pricing information and this table has multiple entries for each item depending on how many different price options there are. Works fine except for one picky detail....I find that when I'm doing data entry I prefer to use all keyboard shortcuts and not use the mouse....when I tab into the dropdown list and hit the down arrow key to select a price, it selects the second value in the list not the first one. This behavior is not what I would expect and actually causes the…
-
- 0 replies
- 970 views
-
-
This is definitely a newbie question, but here goes: I've got a field in the checkbox format. I would like to show the checkboxes, but not the border around the entire field. I've tried every possible manipulation I can imagine in trying to remove the border while retaining the checkboxes, but they seem to be linked in their formatting. As you will see on the attached, this field is currently really ugly--it works on my layout, but it looks bad. Can I keep the checkboxes but lose the border? Or are they considered the same 'thing' by FM? Thanks!
-
- 6 replies
- 1.3k views
-
-
I have two tables... Schools List Courses/teachers I check if the ID of the school matches the ID with the course/teacher. From there I print out reports to each school showing the complete list of what courses each teacher is going to using portals. No problems. But... The last report I did was four pages for each school, on page three I needed to show all of the teachers in the school not just ones which were allocated courses. Also since some teachers are in the system more than once becuase they are going to more than one course I needed only unique values. So I used ValueListItems (Get(FileName); "Value List") from the schools table to index the field. …
-
- 8 replies
- 1.6k views
-
-
I don't know if this is a script question or a Portal question. I want to create a portal to show a brief summary of related records, that I can do easy enough. But, I want the user to be able to click an icon inside the portal row that will cause all the details of the related record to show up in a "highlight" box to the right of the portal in the same layout window. Any ideas? Regards, Patrick
-
- 5 replies
- 1.1k views
-
-
Hello, I open a pretty large, multi-file solution each day. Sometimes the display refreshes many times before stabilising. Most times, this does not happen. Today it happened a long while after I opened the solution. It just went on and on. A bit of background which may or may not be related: 1. I zip a backup on a remote machine each night. 2. The zip file is transferred and unpacked locally. 3. I then open it. Anybody else suffer 8.5 hiccups? Any ideas of why or how to avoid it? Norman
-
- 0 replies
- 1.1k views
-
-
I run ASP applications within Web Viewers inside of our FileMaker files. It works great, but I've kinda stumbled into something and I'm not exactly sure what's happening. This particular ASP script that I'm running marks invoices paid/shipped on eBay when we mark them paid/shipped in FileMaker. I used to do this using Open URL and it would actually open your browser to run the page. This was fine except the pop-up kinda annoys some people. I created a separate layout that holds nothing but a big web viewer. I made my script switch to this layout and use that web viewer to run the ASP scripts and then it switches back to original layout. I'm not exactly …
-
- 1 reply
- 1.1k views
-
-
I currently have 3 fields relating to an employees employment date: The first field is the date of hire The second field is a calculation of years from the first field. The third field shows an employees exit date. My question is this: is it possible to have the second field (calculation of years worked) stop calculating the years if a date is entered into the third field (date of exit) I know I could get a calculation from field one and three after the employee leaves however I do not want a calculation of that nature, I need to be able to look at the field and get a “live” display of the worked years. Or does anyone know of a better way showin…
-
- 9 replies
- 1.1k views
-
-
I have a laptop that runs both Filemaker Advanced 8.0 V3 and 8.5. It's a Dell Inspiron 9300 with 1gb of RAM and an ATI Radeon X300, Windows XP Pro SP 2 all updates. For whatever reason, if my laptop is not restarted for a few days, the display of Filemaker gets out of whack. If I go into Layout mode, I can't see any of the borders of any text objects or any objects at all. When I go into a field and I try to type into it, you can't see any of the text you are typing. When I click out of it, whatever you typed in there will be displayed. All button effects do not show up at all in any format such as Bezeled, Chiseled, Drop Shadow, etc. This is driving me cra…
-
- 5 replies
- 1.2k views
-
-
:) Hi -- can you help me with the best way to approach the problem of having set up a layout which is fine until... one of the fields has too much text in it. I've attached a screenshot of my layout. It's for a database of video tapes. It fits onto one sheet of A4. But there's too much shotlist information to fit in the box. What next? Is it a tab control? I can't work out what I need. I don't want to create a second page for every record -- only those that need the spillover text. Thanks for any help. Phil -- Filemaker infant. Please be gentle.
-
- 1 reply
- 865 views
-
-
I have a long list and would like a record to highlight when it is clicked on. This solution is in a multi-user environmnet. I know this must use either variables or globals and a container calculation result but I just cant seem to put it all together. Thanks, Drew
-
- 2 replies
- 1k views
-
-
I have a layout with a 2-tab panel and both are named objects. "TabOne" contains a simple 2-column portal of Table::Field1 and Table::Field2. "TabTwo" is an expanded version showing several additional fields from the same Table. The two portals are sorted the same so they align properly (e.g., the 4th record in Table is the 4th row in both portals) when the user clicks between TabOne and TabTwo. The user clicks a button at the side of either portal that runs a script that calculates a particular record for the user to make changes to. A script parameter (1 or 2) tells the script which panel the request originated from. The script attempts to return to that same …
-
- 5 replies
- 1.8k views
-
-
I am a relatively new Filemaker user. I have pro 8 advanced and am working on Mac OS X. I am trying to add tooltips, and am able to do so in Layout mode, but after I save and switch to Browse mode, the tooltips do not show up when I run the cursor over the field. Does anyone have any suggestions? Thank you. Sibilla
-
- 3 replies
- 2.9k views
-
-
Thanks in advance for your help! I have a field in my layout header that successfully counts the total number of rows in my portal, and arrow buttons that move the cursor through the rows (using the script go to portal row next, etc.). It looks something like this: << < Record x of z > >> What I want to be able to do is add the current record number, i.e. the "x". I have defined a portal row field = Get (PortalRowNumber), but I cannot get it to work, even if I have the portal rows numbered inside the portal using @@. I have tried using @@ in the header but it also doesn't work. I want to keep the counts and arrows in my head…
-
- 7 replies
- 1.2k views
-
-
I have 5 seperate files, each containing > 600 fields with specific tab orders. When the customer makes a change which adds a field or changes the location of a field I have to change the entire tab order from that point on. Or do I? Is there any short cut, rather than resetting the entire tab order? Please keep in mind I'm new at this. Thanks
-
- 2 replies
- 925 views
-
-
Hi I want to access directly to google calendar without put the login and password every time i run Filemaker. Is possible with the web viewer? Thank you.
-
- 0 replies
- 2.3k views
-
-
Hi, I have a portal with a button in it. How do I get the field value of a related record? Is there a function that can do something such as this: $fieldValue = GetFieldValueInPortal(rowX, fieldY) BTW, in my problem the related table is in another file, so I think the GTRR function is not usefull in this case. Thank you
-
- 2 replies
- 946 views
-
-
Ok, after the battle last night with my portal problems (again thanks to those who helped), I think I have now lost my mind. I’m not sure if this is a layout question or a tab question so I will post it here in hopes that this is the correct area. I have gone blank on this…I have a tabbed layout containing information about an employee spread out among the five tabs, all is working well. I have one tab which contains an employee evaluation form. Now, as with any evaluation a new one is done each year. My question (which has me stumped) how do I create a new record just for the evaluation form inside the tab area? Example: I have all my tabs containing…
-
- 3 replies
- 932 views
-
-
I integrated the Chartmaker that Filemaker has on their site into a solution i am developing and i am having a problem with it. It seems that when ever i go to close the file using the buttons at the top left (i am on a Mac using FMA 8.5) it closes the window but then it crashes the application. If i go to a different view or Table then close it doesnt crash on closing. The only difference is that the page that is crashing has the web viewer in it showing the charts. Has anyone else run into this problem? I have a suspicion that it maybe because the Chart is constantly refreshing and closing the window like that causes the crash? I cant think of any other reason…
-
- 0 replies
- 1.1k views
-
-
in hopes that someone can help me! the business problem: for a task, we can have several funding programs for the same fiscal year. we have a funding portal set up that allows the same fiscal year to be chosen more than once in case there is more than one funding program. dollar amounts and program codes are entered for each row what we need: two other views of the portal - one that shows a "rollup" to the fiscal year level and one that shows a "rollup" to the program level I included a stripped down version of the file in hopes someone can help me. if anyone can help i would be most obliged. im stumped. thank you so much. please let me know if anything is…
-
- 20 replies
- 3.8k views
-
-
I have a report layout which has a letter on it. In the middle of the letter I have a 12 row portal. Each row in the portal has 2 rows of fields, the top one is merge field with a description and cost, the one below is a paragraph of formatted text which describes the item. I have the portal expanded down quite a bit to make sure there is enough room to fit the varying lengths of the description text. I have set the sliding to All above/reduce the size of enclosing part. But it's not reducing the extra space in the portal at all. It’s leaving it the exact same size. Any ideas? I just can't figure out what's wrong.
-
- 15 replies
- 1.9k views
-
-
I have a value list on the current table that has become too large, so I have transferred the list to a separate table with each item being an individual record. I have set up a relationship between the two tables and a drop-down list that can access this table. My problem is that I wish to retain the existing data from that value list for the current records but be able to utilize the new method for new records and perhaps even change previous ones. Unfortunately changing the field drop-down list from the old value list to the new one causes the old data to disappear.
-
- 0 replies
- 948 views
-
-
I hope I am posting to the correct forum. Please advise if I should post elsewhere. I am using FMP 7 Developer. I am reworking a patient management system from 6 dev to 7 dev. Using the new windowing features of 7, I want to be able to create a portal of CURRENT patients as a navigation list. Basically, the user would just click on a name and the record in the main window would jump to the appropriate patient. A patient is current when the admit date contains a value and the discharge date does not. The relationships are a bit complicated: ONE visit (hospital stay) can have MANY admissions and discharges. The tables used are as follows: Patient (med rec # is pr…
-
- 1 reply
- 792 views
-
-
I have an instance where the user needs to create a new record that displays (as one line) in a portal. The position of the record in the portal is determined by a sort on default fields that are set as part of the create script. The sequence I would like to acheive is this: Step 1: User presses a "Create New" button beside the portal Step 2A: Script executes to create the record Step 2B: Script sets the default fields Step 2C: Script causes the portal to re-sort so the record takes its proper position among others Step 2D: Script activates the first entry field for the record. Step 3: User enters the remaining fields directly on the portal row. I've…
-
- 10 replies
- 1.6k views
-
-
Hello... I have got a problem with value lists. I have got: value list with dates (for example - 13/11/2006, 20/11/2006 etc.) contain 3 years field where show this value list (open through drop down menu) and i want to view on drop down menu only values included for example 1 month in past and 2 weeks in future.. how can i do this?
-
- 4 replies
- 963 views
-
-
I am coming from the world of MySQL & PHP and am a relative new-comer to FileMaker. The company I am now with uses FileMaker Pro 8.5. I have searched the forum(s) for a solution to a problem I have regarding value-lists but can’t find one. (Here’s my problem) I have a Company Information layout page with the following fields: “Company Name”, “Address”, “City”, “State”, “Phone”, etc… I also have a Checkbox Set (defined as “Contact Type”) with the following choices available: “Client” “Consultant” “Personal” “Prospect” “Other” I have defined value lists according to these Contact Types. When a “check-box” is marked and the record has …
-
- 2 replies
- 1k views
-
-
I hate these.... I have been using 8.0 since it came out but have not gotten any of the upgrades yet. I am also on Windows XP. Had no issues then yesterday I did SOMETHING not sure what. Now when i RUNNING FM and i try and copy, cut, or paste in any application it hangs all the applications which i have to force end by hitting the close X or using the task manager. Besides reinstalling any ideas on how to fix this? I have tried other brand new DBS with no success. I can cnp without FM just fine it is only when it is running that i have clipboard issues Strange eh?
-
- 2 replies
- 802 views
-
-
Hi, I have a table with 3 fields: Field1: Key Field2: Color Field3: Maker There are some records that share the same color. There are some records that share the same maker. The same could be true for any other values in field2. I would like a portal to show only unique values for field2. Any ideas? Thanks in advance VL_duplicates.zip
-
- 2 replies
- 5.2k views
-
-
I'm a newbie and thanks for you help. I need to make a report with the monthly totals of the records. All the records have a date and an amount that I need to group by month. I only need to see the monthly totals, for example... Oct.......54,000 Nov.......55,000 Dec.......56,000 I've tried to make a summary report it has a subsummary sorted by date part which i put the date field and the amount field into but it does not total by month. It shows like 20 Octobers followed by 25 novembers, etc;... please help.
-
- 3 replies
- 1.4k views
-
-
Thank you to everyone who keeps these forums so lively, interesting, and informative. I'm working on a system which feels much more like a "problem" than a "solution" right now; I suspect that there's a relatively simple way to achieve the results I want, but I also suspect I'm using the most complicated paths possible. I have tables for the following: Programs Program Application Components Students Student Applications Each of 100+ programs has a slightly different list of required application components (Application Form, Letter of Recommendation, Deposit; or, Application Form, Statement of Interest, Deposit; etc.). It's been simple enough to…
-
- 2 replies
- 969 views
-
-
Hello, I am working on a invoicing solution for the company I work for, and as part of this solution I need to print off a calculated number of labels. (For packaging) I have a count field with the number of products on the invoice. And what I would like to do is to use this value to print off that number of labels. I have looked at the "Label Generator" file but I am having difficulties trying to reverse engineer this to match my own needs. I would be grateful if anyone could give me a few pointers on how to manipulate this to solve the problem listed above. I appreciate any help that might be offered.
-
- 3 replies
- 1.1k views
-
-
Hi, Do any of you mathematicians out there can help me with the formula for rounding up and down a time to the nearest quarter hour? Thanks in advance, Ukyo
-
-
- 31 replies
- 10.1k views
-
-
Hi, New question I have a tab, which displays a portal. In this portal I am displaying data about training. The Fields are: Date, Course Number, Course Description an Course Hours I have a button to delete that portal row…and all is well. Now I have been asked if I could add a note section to the portal. What I would like to do is this: Add a small button to the end of the portal which will open a new window and have a small text area that the instructor could write any necessary notes about that course (this will be only for the instructors viewing). I have a new window set to open with such a text area…here is my problem; how do I get…
-
- 10 replies
- 1.3k views
-
-
Hi - I'm trying to create a layout for assigning items to something like an invoice. No problem creating a portal to show items already assigned (ie related) to that invoice via the invoice ID. But I'd like to have a second portal on the layout, showing items that have not yet been assigned to any invoice to pick from. I initially tried to figure out a way to show any item with nothing in the invoice ID field - but by definition those are unrelated records, so couldn't figure out how to show in a portal. I can create a separate layout and run a script that searches for records with that field blank - that works, but is not what I wanted. There is also a boolea…
-
- 2 replies
- 1.1k views
-
-
Hi I am not sure where this query should be but I am just putting it here. I would like to store the login information of all the programmers that work on the hosted Files. I also would like to capture their IP Address and Computer Name. Get(HostIPAddress) and Get(HostName) gives me the IP Address and Name of the Server where the files are hosted but I would like the client IP Address and Client Computer Name which the programmers are using. Is their a way to do it ? Thanx
-
- 3 replies
- 1.4k views
-
-
I'm not sure I'm explaining this correctly - but the problem is that the layout stops showing the sub summary sort after I've gone back into the table to make some data changes. The sub summary is based on the "street name" field (and there's a "street name summary" field )and then there are a series of summary fields, let's just call them a, b, c,d, etc. For each street, I get the totals for each of the summary fields. The first time I set up the layout, after much trial and error, I can get the layout that I want (I'll skip over why I can't get it right the first time.) But - when I review the list of streets, I see that some streets are listed twic…
-
- 0 replies
- 1.1k views
-
-
I created a db to track inventory, assigned my own Product ID to each product. I purchase the same product from different suppliers depending on price then I create a purchase invoice (based on my suppliers invoice)to enter the new purchases. My problem is this; when entering the new purchases I would like to use the suppliers product ID #'s when available & obviously my product ID #'s when I purchase from the cash/carry. So I want all the different supplier ID #'s & my ID #'s to represent the same product.When I enter either Product ID # I want the appropriate Product Description to appear in the invoice, I don't know how to do this, I've included a sample of w…
-
- 2 replies
- 908 views
-
-
Been lurking here for a while, and have learned quite a lot from the knowledgeable people here. It's credit to the programmers at FM and the people here that I've never found a question I couldn't find an answer for - until now! I have an application to automate a repair shop. On the printed invoice that it generates, there is a portal for the parts/supplies that are used in the repair. Some of the parts the customer pays for, but some are simply included in the cost of the repair. The problem is that on the invoice, the customer doesn't need to see a whole list of parts that were used - just the ones that he will be paying for. The rest are there for the inter…
-
- 3 replies
- 979 views
-
-
I really hate to bother everyone with such a newbie question, but this thing is getting the best of me and I am about to just give up on it. I have a date field and I want the date shown to turn red if it is within a 7day window, so the viewer can see that the date is approaching soon. I have tried the Date <= get(currentdate)+7 and change textcolor calculation but I get nothing. What am I doing wrong? Can the textcolor be used on a date field? Thanks James
-
- 9 replies
- 1.2k views
-
-
OK let us say that you create a new record, then you input a number in a field, lets say 1,000. now what i am trying to do is to get a second field to reconize what has been put in the first field and automatically put the correct number in the second field lets say the second field is to show 10% of 1,000. so you put 1,000 in the first field click off the page and 10% of that thousand automatically pops up in the second field. any ides??
-
- 2 replies
- 872 views
-
-
The concept is simple, but I'm having trouble putting the problem into words. Here it goes: Is it possible to get data from table B which was created through a portal from table A, and simply show a field from one specific record in table B on a new layout (new layout is based on table A)? Background: I have a db for doctors where we store all the contact and licensing info. I have created layouts with background images which are forms we regularly fill out. These forms are "automagically" filled out already because I simply placed copies of the contact info fields over the correct spot on the form. Currently I have fields hard coded for the doctors' …
-
- 4 replies
- 1.5k views
-
-
Hi, I am new to FM7-8.5 (have been working on FM6 for years, but I am updating my knowledge now). I have been struggling with value lists. I would like to create a table that holds all my value lists, for my whole solution (one file). In any specific table, I would like to be able to have any field formatted as drop down (or whatever) to show only the list of values that are pertinent for that field. For instance: Table1 ID Field1 - Colors (drop-down) must show only Colors coming from Table2. Table2 ID Data (Colors, Models, Makers, etc.) Data_Code (all colors would have the same code, all models will have the same code, etc.) I un…
-
- 14 replies
- 2.4k views
-
-
Hi, I'm using a split filemaker application: - GUI (layouts, reports etc) stored in one FMP file running on a client computer. - Data stored in another FMP file running on a FM Server. I've got 2 ways to define a Value List (to show the value of a field in a table) 1. On the client: "Using Values from Field" (pointing thus to a field in a table stored on the server FMP file) or 2. On the server: define a value list #1 "Using Values from Field" AND on the client: define a value list #2 pointing to that one on the server ("Use value list from another file"). I'm wondering what is the best option in terms of display speed. It all depend…
-
- 5 replies
- 1.3k views
-
-
Please help me. I need to turn this PDF into a FileMaker report. I have a report that first list the top 4 projects. Then at the bottom it lists the additional projects excluding the 4 projects. Is this possible? Thanks, Maria IMS_Project_Status_120506.pdf
-
- 0 replies
- 1k views
-
-
In my learning process for FileMaker 8.5 I'm using the FM Creative Pro sample databases to fool around. In particular I'm using the Base Builders Praesto Project Manager. For some reason I can't add a tab to one of the layouts. There is only one tab - I am unable to get to the Tab Control Setup. Perhaps it only looks like a tab, but is faking it? Any ideas?
-
- 2 replies
- 1.5k views
-
-
I currently have a field that "Flashes" or "Blinks" when you navigate to that layout. It is the only one on the layout that does this. I cant seem to locate any information about a problem such as this. Has anyone ever had this happen before? Thank You, Brandon
-
- 5 replies
- 1.4k views
-
-
I have created a custom pop-up window/dialog which I would like to be able to close by hitting the enter key (rather than using the mouse). Is there any way to do this in Filemaker 7 or 8?
-
- 1 reply
- 866 views
-
-
I cannot figure out how to number portal rows in existing data. if i put an autocalculation..Get(PortalRowNumber) on new rows it works fine for the new ones. I tried doing a Replace with the same calculation, but no luck. Can someone please help! thanks Bev
-
- 1 reply
- 974 views
-
-
I'm trying to manage large blocks of text displayed in individual fields. I'd like to provide the user with buttons to move to the top and end of the block. In other words, exactly what the Ctrl+Home and Ctrl+End keys do from a PC keyboard. I've been working with the Set Selection[Record::Field] but can't get the results I need. My example shows the results I've gotten so far. Is there a way to construct a "Type In" script step that is equivalent to the user typing into the field? If so, can the characters be control characters? If so, will they be stored in the block or acted upon (as if they were being typed)? BTW, I want to avoid executing any tru…
-
- 0 replies
- 893 views
-
-
Hello everyone, I need some expert advice. I was building a layout with a field for a “Course” selection, I was just going to us a value list with drop-down arrow on the field, and then I found out that they had about 400 courses. How can I effectively implement a solution so that the user will not have to type each course ID in the field? The only thing I can think of is using the value list, and have the auto complete enabled and not show the drop-down arrow on the field? Am I thinking correctly on this one, or have I once again made it more difficult than it has to be? Thanks for any suggestions. Barndon
-
- 2 replies
- 868 views
-
-
Hi! I need to update some data in my solution from web source. Is it possible to fetch address to web viewer like mysite.com/data.php?variable=5 and have php process request and return data in XML? Then I could grab data with GetLayoutObjectAttribute (object; "content") and import from XML format to correct fields. I was thinking about ftp but I can't do it without plug-in. And import from XML Data Source is not available in ScriptMaker. Does anybody have solution for this problem? Or more simple procedure? Thanks in advance
-
- 0 replies
- 1.1k views
-
-
Hi, I am looking for a calculation which can change the text colour in my value list. I only have three possible text drop down options to choose from: If user selects "optionA" from the drop down,then font colour will be red, if he selects "optionB" then the font colour will be blue etc.... I have tried to use the case function in my auto enter calculated value, but no success. Any help gratefully received. Simon.
-
- 5 replies
- 1.1k views
-
-
Hi there, newbie layout puzzling question... I 'm trying to show in a 2 row configuration data from a database, in a "calendar like" way. For example, we want to show appointments at a given date. We get the results for that given date and we SHOULD have an appointment every 15 minutes starting from 10:00am (15 minutes is not a rule it could be 30 on occasions). I can only manage to show each appointment time and name on a single line with the next following on the next line... This is how the layout looks now: Header -> Appointments for Date variable Body -> App_Time variable - Last_Name variable - First_Name variable What I want is to have 2 app_tim…
-
- 4 replies
- 1.1k views
-
-
I've converted a Customized ValueList containing a code and code description to a related table occurance with an ID field, code field & code desription field. I need to load the existing records in the main table occurance with the values from the original value list. I've tried importing, I've tried doing a find on a particular value from the value list field and then attempted a replace field contents on the two new fields from the related table which are displayed on the layout of the main table occurance. It only worked on the record I was in. Is there any way of putting the correct codes and code descriptions in the matching records?
-
- 1 reply
- 1.2k views
-
-
I'd like to use a consistent GUI for the Contacts database I'm developing, with navigation buttons on the right. However, I can't follow this through to the List View (or table view, for that matter). So I thought I'd try and show the records (found set) in a portal on a Form layout so I can keep the GUI consistent. Problem is, I can't get the relationship to work properly and display all records in the found set of the primary table. I'm using the field "ContactID" for the self join in both the primary Contacts table and the TO of it. I've tried the "=" operator as well as the "X" operator, neither of which is getting me the proper results. Any suggestions…
-
- 0 replies
- 1.6k views
-
-
I want to store only a reference to a photo in a container field to reduce the size of my database file. Q1. If the photo is stored only as a reference, does this affect speed of navigating between records & layouts ? Q2. Using FM Server does the folder containing photos need to be in a specific directory on the server e.g. ..../data? Hope someone can help.
-
- 9 replies
- 1.2k views
-
-
I'd like something equivalent to sliding (for printing) to occur in Table View on Screen so that Browsing in Table View could look something like the following for a 2 field, 3 record example: Description_________Item number Short text_____________349 Longer text____________444 description of item 444 causes just this row to be larger Another short one______222 Is it possible?
-
- 0 replies
- 886 views
-
-
Hello, I am very new to FM and I have a question which I am sure is so simple, however I cant find the solution anywhere. I have created two tables, I want to enter data into table #1 and have it also fill in table #2. I want to be able to delete the data from table #1, yet have the data in table #2 remain, I guess what I want is a record kept of the data from table #1 even though it has been deleted. Could someone point me in the right direction? Sorry if this is not the beginners section...could not find any area for new kids on the block. Thanks for any help. Brandon
-
- 4 replies
- 1k views
-
-
I have certain layouts that have the status area toolbar hidden. When I hit a button to find records I cannot see the records in the found set as the staus area toolbar is hidden. [color:orange] How can I show the records in the found set whilst the toolbar is hidden?
-
- 4 replies
- 1.1k views
-
-
I am working on a relatively complex relational database that logically has different tables for each category of data. I want the user interface to be intuitive and simple so tabbed panels seem like the obvious choice. A tree structure would also be OK but that solution is not built into FMP 8.5. I set up a preliminary tabbed layout with more tabbed panels inside of each outer tabbed panel. I discovered, much to my horror, that I cannot add fields from other tables than the one associated with the tabbed layout and have them accessible in Browse mode. The fields are inaccessible and say " There must be someone here who has done exactly what I am trying to do. Thanks…
-
- 9 replies
- 1.9k views
-
-
Hi I just found something strange today. In FM6 if you created a value list using values from a related file's fields with 'Also Display value from' the second field, and then when you use a popup menu, when you selected a value, ONLY the first field's value is displayed. However in FM8 once selected, it displays BOTH field 1 and field 2. In other words, lets say you have two fields that you select to be your value list. The first field is a person initials and the other one is the name. Okay if there are two names of Donald Duck and Mickey Mouse the popup list itself will display as DD Donald Duck MM Mickey Mouse So in FM6 once you select the first choi…
-
- 2 replies
- 1.1k views
-
-
I'm trying to display a preview of PDF files in a container field. This is in a cross-platform FM8 database stored on a server. The users are 1/3 Mac, 1/3 Windows 2000 and 1/3 Windows XP. I could get the file preview to display in Windows 2000 and Mac by using a Windows 2000 PC to drag the file from it's folder on the network into the container field. The first page of the file then displays as a preview on the Mac and Windows 2000 PCs. BUT on Windows XP the preview doesn't show unless you click on the container field. Then the file hangs up for about 3 minutes until the preview displays. Way too slow to be functional. This happens whether it's dragged and drop…
-
- 2 replies
- 1.7k views
-
-
What types of things should I take into account when deciding between hard coding the values for a value list versus creating an actual table that holds the values that I want to populate the value list with? What are the performace issues? Also, how will one choice over the other effect my ability to sort in particular orders based on the contents of the field? I'm on 5.5 if that makes a difference. Thanks!
-
- 4 replies
- 1.9k views
-
-
On a layout I have a portal displaying related records. There are several fields in the portal which means that I can only display so many records - no problem I just have multiple portals for the same relationship using the "Initial row", "Number of rows" parameters to have side by side portals display the data. My problem is jumping to specific portal rows in the multiple instances of the same portal. Let's suppose PortalA contains records 1-20 and PortalB contains 21-40. If the focus is in portalB and you run a script to go to portal row the dialogue shows "Go to Record X out of 40 and if you make x = anywhere between 21 and 40 you do indeed go to that portal r…
-
- 25 replies
- 5.5k views
-
-
ok, what i had: Employees table, linked to activity table (list of stuff to do) so an 'activity' portal within emps layout will show everything that person has to do. Great, done, no problems, easy. NEXT: filter/ refine the portal so that only certain activities are shown in the portal. e.g. phonecalls. theres all ready a field marking the 'type' in activity, so i created a global in employee, which ='phone' and made them relational. so that worked...sort of. the problem is that occassionally no data is shown in the field!? then 5min later it will work again. the database is on the server, and there are upto 5 ppl using it at onc…
-
- 0 replies
- 1k views
-
-
Hi Folks: I'm trying to do something that seems simple and straightforward, yet I can't seem to find my way there. As I recall, I used to do this in Access without a problem, but I don't see how to do it in FileMaker. I have a layout that shows fields from a Main table, as well as a portal containing records from a Child table. Child records can be scrolled, edited, and added; and they are sorted appropriately. This part works fine. Now I want to add a portal to an Unrelated table, where I can similarly scroll, edit, and add records. I also want to control the sort order, as before. And I want it to always start already scrolled to the last record, with t…
-
- 14 replies
- 7.7k views
-
-
Someone has probably asked, but I couldn't find anything. So anyway. I have used the setting "do not print selected objects", but now I have some layout where the fields do not print. The appear fine in browse, but not in preview. It sounds like "do not print selected objects" is set for these objects, but it is not. Has anyone had this problem?
-
- 4 replies
- 1.1k views
-
-
Can someone please update this to make sense for version 7.xx and up ? Their script steps and associated syntax do not match our version and even the article itself seems to contradict itself. http://tinyurl.com/w8qcq Answer ID 2654 APPLICABLE TO FileMaker Pro 4.x, FileMaker Pro 3.x This solution can be used to create return address labels, to duplicate a specific number of records, or to duplicate individual records a specified number of times. The solution assumes that you have already created the fields and records you wish to duplicate. Also, because this solution adds duplicate records to your database, you may want to apply the solut…
-
- 2 replies
- 1.4k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online