FileMaker Interface Features
-
Hi Not sure if this is an easy problem to solve? I have a a field on a record which is a drop down value list. I want to ensure that one particular value 'Completed' can only be selected by users if the contents of the 'Client Account Number' match a particular customer and the 'Purchase Order' field is NOT empty otherwise 'Completed' cannot be selected. Do I use validation by calculation or what are my options? Many thanks for your help Rich
-
- 0 replies
- 1.1k views
-
-
Trying to see if filemaker can extract a url from a given web page. Just wondering if that is something that can be made into a calculation to retrieve
-
- 7 replies
- 8.1k views
-
-
I have a Database that does calculations and displays data for a report. I have a script that does a "Delete all Records" at the beginning so the old report is cleared out, and re-imports data for the new reporting procedure. The problem is that even if there are no records, my Layout is still reporting values in some variables just before I import data. Most reports do not use all the Display variables I have so these "no data" values are still showed. Is there anyway (other than a script step that sets all these fields with nulls and zeros. And I'm not sure that will work anyway because there are no records in the DB when I need to set values) to do th…
-
- 7 replies
- 1.3k views
-
-
Is it possible to have the header not move in a database when in form mode? Similar to how frames work in a webpage, if you scroll down the body, is it possible for the header to just stay put and not scroll down as well? That way you always know what the title is of the record, even if you're at the bottom of it?
-
- 3 replies
- 1k views
-
-
Now that we have conditional formatting (or perhaps it was possible before), is there a way to specify a color in such a way that many different layout objects throughout the database are automatically assigned that color? So if you gave a particular event database a different color theme each year, you could change this color once and have all of the layout objects that use the color change to that new color, instead of having to update each background, button, etc., individually. There are lots of ways that might work: you could write a script that changes all of the colors, which you could run once when you create the database, or use calculated fields that would …
-
- 0 replies
- 1.2k views
-
-
Hello, I am using iwp to serve a database to many users. I am using tabs for navigation. When the user clicks on a tab the window is not active, with the advice of another post I had to create a button attached to the script "open record request". I was wondering instead of the user clicking the button to invoke the script. Do you think when the user selects the tab I could attach the script to the tab itself. This is the post number for the initial advice. Post#280206 Thanks in advance DH
-
- 0 replies
- 1.7k views
-
-
Hello, I have a drop down menu that lists way too many items right now and I want to limit those values listed based on another value in the table. The values in the dropdown are NAMES of projects from my table PROJECTS. In my projects table there is a value of Open or Closed when a project is complete. I would like my drop down to ONLY show projects that are currently open. It's a little unclear to me how to get that done. Any leads help appreciated! - loopy
-
- 2 replies
- 1.6k views
-
-
Hi I want user to navigate through basic icons to access different databases. I am wondering how to hide the "Show Window" from the menu commands by customizing the menu bar.
-
- 2 replies
- 1.7k views
-
-
(Not sure if this is the most appropriate sub-forum for this question. If not, please suggest a better one and we can move the discussion there.) Can anyone suggest a technique for transferring a found set from one window to another, already existent, window? I know that one can use the New Window script set to create a window whose found set is the same as the one active when the script is executed, and I know about using Go To Related Record to show related records in the same window or a new window. But the missing piece is showing the records in a distinct, but already existent window. I'm using a workaround that first destroys the target window and t…
-
- 10 replies
- 2.3k views
-
-
I need to archive a lot of paper documents in manila envelopes. I would like to include some information about each project on a mailing label and affix the label to the envelope. I've tried this a couple of times in the past without success. I can't remember what the meltdown was but I recall it had something to do with the particular Avery label I was trying to use. Before I go to the office supply store in search of new labels, can anybody recommend a particular label that's about the size of a business card. I would like to be able to do this with a pre-set layout from the labels menu. Thanks
-
- 1 reply
- 1.3k views
-
-
I'm adding a Flight Tracking Module to my Event Planning Database. No problem building the relational tables for tracking multiple flights or anything like that. The only problem I am having is with the Flight Tracking Report I'm building. The summary/sub summary report is sorted first by Home Gateway, then by Arrival-Departure Pattern, with the body containing delegate information (of not all the sorting functions and that output is working flawlessly). The specific problem I'm having is that in the record row (body) which is one per delegate including their name, passport number, etc., I cannot get the multiple flights information to slide up if the above fields are…
-
- 1 reply
- 1.2k views
-
-
is there a way to select what row or column a label will print in? it's hard when we are printing one label and it always does the first row/column thanks!
-
- 1 reply
- 1.2k views
-
-
How do you get pasted text to comply with a field's formatting? The online help says that pasted text is supposed to take on the filed format settings, but mine is not. I am copying info from .pdf manuals and I have to adjust indents, etc. Fitz
-
- 11 replies
- 2.2k views
-
-
As the topic implies, I am wondering how I can achieve this. In case you were wondering why I want to use an Iframe, the answer is simple. My supervisor wants to integrate the filemaker-interface into our intranet web-interface. However, whenever I try to display the fm-webinterface through an iframe, the cgi-script overrides the iframe and the page automatically resizes itself to fit the browser's entire window.. Does anyone know how I can solve this problem? Thanks
-
- 2 replies
- 2k views
-
-
I am very new to filemaker.A complete beginner.I have a table that has a field named date and a field named #of nights. This is associated with room bookings. I need to create a calculation that will generate the actual dates associated with the number of nights. Example: Start Date: 01/01/08 Number of nights: 5 I want to generate the dates as follows in separate rows: Calc Dates: 01/01/08 01/02/08 01/03/08 01/04/08 01/05/08 How can I do this or what formula can I use to look up the start date and multiply the nights?
-
- 8 replies
- 2.1k views
-
-
Hi All. Please bear with me as i try to explain this! I have a report layout that I need to create that will replace a paper form currently in use. The form allows for the inputting of several fields for an invoice. The fields are repeated 4 times on the form to allow for 4 invoices. I have my database created to where the invoices show up on the recreated form in the database, but the fields only show up for the related invoice records. For instance if there are two invoices, you will see the fields for both, but the form will not show the blank fields for two more invoices. Is there a way for the form to show the fields for all 4 entries? I am required to…
-
- 7 replies
- 2k views
-
-
I think this is the best place to post this question? I am using Filemaker Pro version 9. I have a text box that allows user to enter text. I also have a portal item that allows user to enter many records associated with the text box I just described. How can I update records in the database to reflect the text in the text box item and have it associated with each portal record being entered? The index is correct I just need the ability to update each item with the text from the text box??
-
- 2 replies
- 926 views
-
-
I can't seem to get the 'Undo Formatting' menu item to work correctly in my custom edit menu. Let's say I copy a block of formatted text from a browser and paste it into a text field on my database. In a 'regular' edit menu, immediately after the paste the 'Undo Formatting' command would appear at the top of the edit menu, which I could then select to clean up the pasted text. The Undo Formatting command would then change to 'Undo Paste', which could be used to...um...undo the paste. When my custom edit menu is loaded, the 'Undo Formatting' works as expected, but instead of seeing 'Undo Paste' next, I actually see 'Redo Formatting' instead. Hope that makes sense…
-
- 0 replies
- 1.8k views
-
-
I have a client who wants to be able to type into a field that uses a pop-up value list. She does not want to click on a button to get to "add a new value" to the list, she simply wants to type something if it's not in the list and have the new entry automatically added to that value list. I haven't found any function like that. I told her I didn't think it was possible since you need to have a command to add something to a value list. Or...?? Is it possible?
-
- 1 reply
- 1.3k views
-
-
I need to know how and where to input information in a file that will be "connected" to another file so that when I type an item number, then the description, cost, and quantity in stock will appear.
-
- 1 reply
- 1.2k views
-
-
Hello everyone, I have hit a stump with a current solution I'm working on and wondered if anyone would have any ideas. The problem is that i have 2 conditional value lists but i need them merged into one. For our example here's my database: Groups.Groups_ID Items.Groups_ID Items.Options_ID Options.Options_ID Options.Options_Name Options.is_global The first value list will have a relationship that returns all Options that have the same Group_ID as Items.Group_ID which the user selects. We'll call this relationship"Group Options" The second value list will return all Options that have the is_global flag set. We'll call this relationship "Glob…
-
- 2 replies
- 1.2k views
-
-
I am new and seem to be having problems with layout I want to create layouts that relate to each other such as writing letters or forms that use the same fields such as persons name and address but when I enter a new layout it ask that I enter a new record and does not carry the persons name and address over to the new layout. I have set up my relationships and can not work out what else I am suppose to do.
-
- 0 replies
- 963 views
-
-
This is so weird! I have a database that has about 3000 names. Every time I have a layout with a merging "first name" field, all the names turn out to be fine except one "Elizabeth" is always in a smaller font than the rest. I tried erasing and retyping the name but did not work. Any ideas? Thanks!
-
- 4 replies
- 1.2k views
-
-
I have my database setup right now consisting of 3 tables: Autohire, Notice, and Main. My overall goal is to have my layout relating to Main be my main page consisting of a portal and a few buttons. The buttons I can worry about later, right now my current goal is to get the portal working. In the portal I want it to display information from Autohire. Autohire consists of different information. The two items I'm only really concerned about display in the portal are the fields recordnumber (which is a number field that enters an auto-enter serial number), and title (which is a text field so that a user can enter in a title of a job position). In the Main tabl…
-
- 3 replies
- 1.4k views
-
-
Using Filemaker Pro 9 I have a file with about 150,000 customer records. I want to have a portal that shows me the states customers reside. Currently, the portal shows every records state. Then I would like to show the number of records per state. Any advise would be much appreciated.
-
- 9 replies
- 1.6k views
-
-
Can anybody point me to a solution where there is a layout with several portals across (3-4) and with each click moving from left to right the next portal fills with the options related to the first. Basically, I would like to implement something like this as a user-friendly way to create reports or lists with the search criteria laid out for the user to select. Ideally, the first portal would be where the data comes from like Institutions, Students, Courses, Budgets, etc. Then each sequential portal would have the options relative to the original table. So my thoughts laid out would be something like: Students->Year->University->(speci…
-
- 2 replies
- 1.2k views
-
-
[color:blue]I need to figure out if its possible to create a Windows Explorer style layout, where I can create a list view of customers on the left-hand side, and write a script so that when a customer in that list is clicked, a list of jobs for the customer is displayed in the main body. Does anyone know if this is possible? I think I can figure out the scripting part, I just can't figure out the layout part...
-
- 4 replies
- 1.5k views
-
-
(I promise I've tried to find this on the forums and interwebs; if this is a FAQ, please forgive me) I have two value lists (ValueListA and ValueListB). I have a radio-button field with the values "A" and "B". I have a pop-up menu field. How do I get the pop-up menu to display ValueListA or ValueListB based on whether "A" or "B" is selected in the radio-button field? Thanks in advance, if anyone can help me-
-
- 8 replies
- 1.9k views
-
-
Is it possible to hide a button based on a condition? I know you can 'hide' things in various ways by covering them up or using a container calculation. However, I not only want to hide the button I want to make sure people can't click on it when it's hidden or at least that the cursor doesn't turn into a hand. I have a table where we can 'set' records. The idea is that we enter a record, set it, and any changes from that point on are tracked. So I want the button to be visible while it is unset but once it is the button should get out of the way. Thanks
-
- 2 replies
- 1.7k views
-
-
-
- 0 replies
- 1.1k views
-
-
Has something happened between fmp8 and fmp9 to mess up the technique for making objects appear and disappear from a layout? I'm referring to this technique: -- Define unstored calc uc_Charge = "Charge" -- Define self-relationship ShowIfCharged based on uc_Charge = PaymentMethod -- Create 1-row portal based on ShowIfCharged whose dimensions are 217x63. -- Place a 215x61 box containing some text atop the portal, being absolutely sure it nests fully within the portal. Finally, I want this text box, if shown, to slide upwards. I select the portal and all the stuff lying inside it, and set sliding on / directly above / reduce enclosing part. It worked on …
-
- 28 replies
- 4.8k views
-
-
Hi everyone. First i would like to say thanks to those who have helped me previously in this forum. This should be a pretty simple question, but i need someone to point me in the right direction. I am building a database to manage sales, inventory, employee and customer records amongst other things. A part of this includes a record of every sale made with the foreign key ID of the salesperson, date of sale and item sold. the details are based in two tables labelled Sales and Sales Lines. Sales containing the date of the sale and the fk Employee ID and Sales Lines containing the quantity and item sold and is related to the table Sales via a Sales ID for…
-
- 12 replies
- 1.9k views
-
-
I have filemaker 8.0 and am not planning to upgrade. I need to go to a website and wrote a script go to url that works great. Next step is to automatically log in if possible and also enter the name of the current client into the first field of the website. the website is another database with the same clients as my filemaker database. eg. on client jones in filemaker I want to go to www.alternatedatabase.com and automatically enter jones on the first field of the web database. I though i could do this with a query statement. thanks
-
- 0 replies
- 1k views
-
-
I have two main tables: Projects, Tasks. Task records include all the possible tasks I ever might apply to any Project. In my Projects layout where I define the values of the project fields, I have a field 'possible tasks' which i fill with a checkbox valuelist of all the tasks listed in the Tasks table. I have an Activities layout where I select which project I worked on for the day and I want the task field to display only the tasks that I had selected prior. I'd prefer if this happened dynamically within the layout. I need to be able to track hours spent on particular tasks later on, which seems to further constrain my choices. I've spent days trying to…
-
- 13 replies
- 2.9k views
-
-
(Sorry, I couldn't come up with a better subject line.) I'm still trying to create a DVD rental system using FileMaker. Please, don't get hung up on the general structure of the tables and their relationship, unless it disallows me to do what I want. I have two tables, Customers and Movies, which are related through the table Rentals. Rentals is another table which keeps track of the movie ID number, the customer ID number, and rental dates. Now I want to create a simple (at least it should be) layout which will allow the user to search the Movies table for a movie name and the Customers table for a customer name and take the related movie ID and customer I…
-
- 4 replies
- 1.5k views
-
-
I just need a little help. I am trying to figure out on how to add a dotted line before words in a field. Say for example (the field in red is what I want automatically changed) Measurements: [color:red].............7.45 x 5.46 x 2.53 mm Measurements: [color:red].......................0.76 x 1.26 mm I would like the dots to be autimatically added or subtracted in the length of the field before the word or numbers. Thank you
-
- 9 replies
- 2.4k views
-
-
How do i pass a field value in one layout to a field value in another layout? I'm trying to pass a patient name from the contacts table over to the 'estimated costs' table. Any help would be greatly appreciated. I'm very new at this. thx, bill
-
- 2 replies
- 1.2k views
-
-
Hello Everyone, How can I display the field label inside the field and make it disappear when an entry is made? Your help is appreciated. Thanks
-
- 4 replies
- 1.7k views
-
-
Hello, I bought brian dunnings FM7 chart maker...i can not figure out how to change the colors of the bars...does anyone know how to do this? i included a printscreen of the chart. Thanks! Rick
-
- 6 replies
- 2k views
-
-
GetLayoutObjectAttribute("blue_box";"bounds") returns the bounds of a manually drawn square named "blue_box" (e.g. 99 82 919 182 0). But how do I alter these bounds, for example with data out of 5 number fields. It would be great if there was a function like: PutLayoutObjectAttribute("blue_box"; var_1, var_2, var_3, var_4, var_5) I made a sample in PHP of what I want to accomplish in Filemaker: http://www.arubaserver.com/beta/window/ Please comment.
-
- 13 replies
- 7.8k views
-
-
I designed a chart solution without the need of plugin. It utilizes a html file with some javascript to create a square. Dynamic input of color, width and height is very easy. For now you need to replace "file:///Users/michiel/Desktop/chart/chart.html" with your own file path... chart.zip
-
- 0 replies
- 1.8k views
-
-
I am working on a layout that I would like to prohibit editing to, once signed. What I'd like happen is the following: When a new record is created, its status is defaulted to "Open". Then, when a user presses a button to sign the record, etc, the status changes to "Signed" via a script. Thereafter, the record has view-only access. Could anyone suggest an easy way of doing this?
-
- 1 reply
- 1.2k views
-
-
I know there is no direct way to rotate a portal 90 degrees, but anyone seen either a work-around or a way to simulate the effect. i am trying to use related data in a columnar report and need the portal to show the keys or legends of the portal rows.
-
- 1 reply
- 3.5k views
-
-
I would like to know if it is possible to have a found set of records in a portal for a related record? EXAMPLE: (Table1 = Service Calls, Table2 = Employees) On Table2 there is employee info with a portal that displays all the service calls made by each employee. (This part works fine) The problem I'm having is when I try to do a find to see the service calls for a particular employee within a given date range. It seems to be returning all service calls, not just the service calls for that particular employee. (This strange due to the fact that when all records are shown, the portal only shows service calls related to the specific employee) Any help would be greatly appre…
-
- 1 reply
- 1.4k views
-
-
I'm setting up our Collectibles database, which is a pretty basic catalogue system. I'm nearly finished but really struggling with what should be a relatively simple task, but the last time I used FM Pro was version 4 with no training, and I can't spend any more time trying to fathom this! I have pre-existing categories and sub-categories which pertain to them... I've set the CATEGORY field as a drop-down value list and I'm trying to make it so that, when I've selected (eg) BOOKS from the value list, the SUB CATEGORY field will automatically show the BOOKS Sub Categories value list... Does that make sense? I'm now utterly confused as to whether this should be a…
-
- 1 reply
- 1k views
-
-
I am trying to search an inventory file. I've included a field for Jewelry Type ID. I am using an unrelated file which has an ID field and a name field. I've set the value list to draw its first field from "Jewelry ID" and the second field "Jewelry Name." Then I set it to only show the second field. It only shows the first record. The only way I can make it work is to use only the first field, "Jewelry ID." But that won't help the user, picking from "1,2,3,4,5,6, or 7." I can't figure it out.
-
- 1 reply
- 1k views
-
-
I want to display the total contacts for each company but I don't know how to do it. Could anyone help me? Thanks. PS: if a contact change to the different company, the result of total contacts must change to. Thanks James Total_contacts.zip
-
- 7 replies
- 1.6k views
-
-
I am wondering if I can just type in 7777777777, and get 777-777-7777? How would I format for this? Thank you. note: I am a total novice.
-
- 8 replies
- 2.1k views
-
-
Does Sliding work when the layout objects in question are located in a Sub Summary Part? I have a field that I want to expand based on the amount of text entered but it does not seem to work. The only thing that seems different is that I have it in a Sub Summary part instead of a Body Part where I have succesfully used the technique in the past. Thanks, Steve
-
- 1 reply
- 1.1k views
-
-
Hello! In a multi portal layout, when I run another script, I can keep a portal row visible in a 10 line portal even if it is the 25th record, with the Go to Object/Go to Portal Row steps. The only thing is that it puts that portal row at the bottom of the portal. Is there any way to "freeze" it, so the user is always looking his record in the line of the portal that it originally was? I hope you understand what I mean. TIA.
-
- 2 replies
- 1.4k views
-
-
I have a leading grand summary in a layout that shows standard fields (not summary) from a related table. In the Leading Grand Summary only half of the fields are editable for some reason? Ex: the fields in the lower half of the LGS are editable and the fields in the upper half are not? All records come from the same related table, and have a one to many relationship. All fields have the same perm, and are editable in browse and find mode, there is nothing layered over them. I have rebuilt the layout 3 times and get the same thing every time? Once more if I take a field from the upper half of the summary field and move it to the lower half it becomes edit…
-
- 23 replies
- 3.4k views
-
-
I am creating a FM7 database to manage projects handled by our in-house design group. I'm using portals to capture time and materials used on each job record, and creating an invoice layout that uses copies of those same portals to show what resources were used, along with the associated costs. Since both billing and time data need to appear on the same single page invoice, and the number of records in the portals usually exceed the available space, I would like the portal to return a summary of the total quantity of items used (per item) or the hours worked (per staff member). It currently looks like this (sorry 0 the html post is killing the spaces - name is in one c…
-
- 3 replies
- 1.1k views
-
-
I am creating a FM7 database to manage projects handled by our in-house printing department. I'm using portals to capture materials used on each job record. I would like to create a lookup table so that when the choose an item from the value list it auto-enters a specific item cost into the appropriate field. The FM7 help is pretty thin on how to create lookups. What I have been able to do seems to pull only the value from the first record in the portal. Can anyone give me some pointers? I'm stuck... Thanks in advance, Jen
-
- 2 replies
- 1k views
-
-
Hi FM Masters, I'm creating a library for casting... I work in the entertainment industry and I can't figure out how to create an "insert" button for fields inside a layout. I'm working with families in which all can be different amounts of family members. My base layout has five members. Name 1, Name 2, etc.... Relationship 1, Relationship 2... D.O.B 1, D.O.B 2... and Occupation 1, Occupation 2... My problem: I would like to put a button where I can insert more fields (one row at a time... a row consisting of Name, Relationship, D.O.B, and Occupation) into the database/layout for the families with more members. Also, when the fields are added, I would also like …
-
- 2 replies
- 1.2k views
-
-
Hello, I have a layout that has many custom dialog boxes. Is it possible to have a scroll bar included in a dialog box to accommodate various amounts of text or simply format the box so all of the text is in view without manually resizing the box on the lower right to show all text? I designed a runtime application with Filemaker Developer 7.0 and noticed several dialog boxes had the text cut off at the bottom, I had to resize the dialog box manually. Can anyone help me out on this issue? Thank You, Steve
-
- 3 replies
- 1.5k views
-
-
I want to be able to change a record to a next status. The record from the table [data] only stores the id field information to [status] on data.status_id = status.status_id. I need the radio buttons to display all entries (except one) where data.status_id <> status.status_id How can I do this? Also I'm going to attach a script to this control, for on some status a mail needs to be sent too. This must be a temporary field for my records must be left read-only. So a sql statement script will do the actual updating.
-
- 0 replies
- 1.2k views
-
-
Hello. My layout consists of a portal on a table alias NAVIGATION. it's an alias for DATA which is the layout table too. I linked navigation to data on STATUS = cPORTAL_FILTER Portal Filter is a global field. I placed data.portal_filter on the form. Going to brouwse mode show an empty portal. Only if I enter something in cPORTAL_FILTER I get a message that the field isn't editable. There is also a link on the tables on order id so when clicking in the portal the clicked record is displayed.
-
- 1 reply
- 1.3k views
-
-
I'm using a variation of Ray Cologon's Portal Sidebar Navigation System. I added a navigation bar at the bottom of the portal. My problem is that in order to get the portal line item to show the related record in the main screen there is a container field with a script step attached to GTRR. So when I click on the portal row it activates the GTRR and shows the related record. However, when I click on 'Next' or 'Previous' on the navigation bar it only goes to the next portal row, but does not activate the GTRR. I tried a script with a script parameter to mimic this, but, I get unreliable results. Any ideas how I can accomplish this?
-
- 2 replies
- 2k views
-
-
My layout is for use as a digital preview as a record. How can I make a field read-only, so you can't enter information in it [sOLUTION] use field behaviour :
-
- 1 reply
- 1.1k views
-
-
I'm not a developer or a guru, but I have made several databases for my school and now I'd like to roll them into one and call it a home-grown Student Information System. Instead of my usual boring buttons, I'd like to branch out a bit. Would anyone be willing to send me a screen shot of a not too complex layout that might work? I want to give access to about 10 different DB. Thanks. Laurie
-
- 1 reply
- 1.7k views
-
-
Is there an easy way to hide a button (or make it unclickable) when a user switches to find mode (probably by clicking a button that performs a script)? I'm still learning the basics of scripting. Thanks in advance, Joni
-
- 3 replies
- 3.7k views
-
-
Hi all, Is it possible to login to a database in IWP directly inside a webviewer? Is IWP using a POST method? Thank you for all the comments... -)
-
- 1 reply
- 1.3k views
-
-
Hi All, I have a project that I am working on and I guess I am a bit brain dead. I have a noequi join between the Consultant TO and ConsultantTime and I only want to show a drop down list of consultants with a particular customerTypeID. I think I have it but it still shows every customer type. Any ideas what I am doing wrong. The database is a Consultant Time and Billing solution. I have attached the database for review. Thank you, spurpurajr SCPSolutionsTimePro.fp7.zip
-
- 2 replies
- 1.2k views
-
-
I am stumped by this one and am wondering if any of you out there in cyberspace might have some suggestions. I have three databases and in the third I want a field to show a popup menu listing values from a value list in database 1 and all the values from a value list in database 2. The values of the popup list are not conditional...just show all of the field values from field TextValue1 in Database 1 and field TextValue2 in Database 2. I have no problem setting up a value list to show the entries that have been made into TextValue1 and I have no problem setting up a value list to show the entries made into TextValue2. Just can't figure out how to show all t…
-
- 1 reply
- 1k views
-
-
Hi all, I have a FMP database that tracks artwork for a London gallery - images of various pictures and information about them - all fairly simple and straightforward. One thing I'd like to do, however, is to drop a big red SOLD graphic across all those images of pictures that have been sold - leaving those unsold images just as they are on the main layout. It'll need some sort of script that, say, if the buyer_name field is empty then the image remains as is - but if that field - or another chosen field that means the same thing sale_date or something - is filled then the SOLD sign drops in somehow across the image, or becomes visible across it. I can think of no …
-
- 4 replies
- 4.6k views
-
-
I need to query a web site by entering an account number, then hitting Submit. I assume that I need to intercept the HTML query as it submits in order to build my URL for Web Viewer. How is this normally done? Is there a utility for MacOSX that will help, or can it be gleaned from View Source on the HTML page (form data is there)? When the page returns, how do I scrape the data to populate my database with the results? PatternCount on the object?
-
- 24 replies
- 7.3k views
-
-
I have a series of 7 duplicated layouts, the first of which shows 1 pixel shift of all field and text when moving from layout number 1 to any of the other 7. If I check the fields and text with "object info," the numeric referents are exactly the same. If I use the T-square, the pixel shift is apparent. I can't figure out what makes this happen. Thanks in advance for shared wisdom.
-
- 8 replies
- 1.3k views
-
-
I am very new to FM9. I would like to display on a main page all the records from a table called jobsheets. I thik I need to use a portal but on trying it as not worked. I just get a blank table. Can anyone help me out please or point me in the right direction.
-
- 2 replies
- 1.3k views
-
-
Hello: I´ve done a video database and I use web viewer to load the quicktime that are hosted in a pc with IIS.The problem is that in spite of all the pc´s has the quicktime pro installed just the macintosh can load the films from the wwwroot.Anybody knows why?
-
- 6 replies
- 1.9k views
-
-
I'm working with a series of pages inside a web viewer. On the final page I display a subscription ID that is returned by PayPal's system. I need to get this ID value into a field in FM. GetLayoutObjectAttribute("SubscriptionBrowser" ; "content") gives me the source code of the currently viewed page in the Web Viewer. Similarly, GetLayoutObjectAttribute("SubscriptionBrowser" ; "source") will give me the current URL of the web viewer. However, if I add these values into unstored calc. fields they do not update until I click into that field on a layout. Data Viewer will show the calculations correctly at all times. I can also run a Refresh Window sc…
-
- 5 replies
- 1.7k views
-
-
I'm having trouble getting the Grand Summary section to give the correct amount on this layout. I keep getting zeros for Summaries based on a parent related fields. The layout below is showing records from the TicketItems table, Item lines are the body. The subsummary section is based on sorting by TicketID. TotalCost is a Summary of Cost, but Haulchrg, Surchrg, and Total exist only on the Ticket because they only apply to the Ticket. Ticket1 Item 1 Cost Item 2 Cost subsummary TotalCost Haulchrg Surchrg Total Ticket2 Item 1 Cost Item 2 Cost subsummary …
-
- 4 replies
- 1.3k views
-
-
Hello. I am working on a research project which tracks ethnicities of our subjects among many other things. The database that I was given to work with has a separate field for each ethnicity and is displayed as a checkbox. For example, in one record, "African American" has its own checkbox, "Filipino" has its own checkbox, "Hawaiian" has its own checkbox, etc. I am trying to create a report where I can summarize each subjects' ethnicity in one textbox. So if a subject has the "African American", "Filipino", "Hawaiian" checkbox marked, it would show up in an i.e. ETHNICITY field I have created as comma-delimited text. So under ETHNICITY, I would have: A…
-
- 4 replies
- 1.8k views
-
-
Ok trying to print a layout but whenever I sort the records it always puts for example: 1934-1935 After 1953. I know technically why this happens but how do I fix it.
-
- 2 replies
- 1.1k views
-
-
hi All, I am new to filemaker but, I have worked with as a developer for more than 28 years. I have a filemaker database with lots of relationships but for some reason I can not figure out how to make a layout that will allow more than one table for instance a layout with a table and its child records. For instance a Customer and Addresses. I have included the Database file in this post so that someone can point me in the right direction. Thank you for all your help, spurpurajr SCP_Solutionsfp7.zip
-
- 5 replies
- 1.3k views
-
-
I want to print an addressbook for my filofax, pages are 3 3/4 by 6 3/4. I want each letter to be a different page so I can use the letter dividers. I know I will need to do some sort of letter sort, but don't know how. I also don't know the best way to do the layout to get it to print the way I want, but 2 to a full size page that I will then cut. Anyone able to help?? Thanks, Cindy
-
- 1 reply
- 1.1k views
-
-
Hi! I'm new to FM Pro and i'm having a problem that when i try to create a new Portal in my Workflow layout, it suddenly desapears! I make all the necessary connections and relations but when i change from layout mode to browse mode it desapears! Please, help me! I'll be glad! Thanks! :
-
- 9 replies
- 1.9k views
-
-
Does anyone know of a good layout software that can integrate well with FM. I need something that I can create layouts and assign data from individual record. This will be for a print catalog.
-
- 1 reply
- 1.3k views
-
-
Is there any way to set your arrow keys to function like Excell in table view mode. I would like to go form field to field using the arrow keys Thanks The Tramp
-
- 1 reply
- 1.1k views
-
-
I changed a value list to contain different custom values. I replaced some values and deleted others. The field that uses the value list is formatted as a checkbox field. I assigned new selections to each record in my found set, but when I exported the data from that checkbox field, it had both the old custom values and new values for each record. How can I change a custom value list for a checkbox field and replace old values with new ones without completely deleting the field and recreating it?
-
- 1 reply
- 1.2k views
-
-
I have a portal that show me records from my main DB. We are a printing company and I use it to show me all of the jobs that are printing on a certain kind of paper. So in my header, I choose a paper type and the portal displays all records which match. Each record in the portal also shows me how many sheets I need. I want to find a way to total all of thos sheets via the portal. Is this possible?
-
- 3 replies
- 1.3k views
-
-
Hello Board! Thank you for all your advice so far! I am trying to build a very simple data-capture program that is only 3 fields. However, i would like to use a touch-screen monitor and remove the keyboard. Is there a way for me to build a 1-9/0 keypad on the screen, so when i touch the buttons the numbers come up into a specified field? I would like to publish this on the web and serve it through an intranet and i'd rather not use the OS built in 'on screen keyboard'. A nice and simple 1-9 pad is all that is required. Thank you for any input you can give. If this isn't in the right forum let me know! Cheers, Harry
-
- 1 reply
- 1.9k views
-
-
I have a list of transactions showing in a portal with date, document number and simple invoice value - not calculated. How can I get the list to show a blank new record? At present it only shows the list of previous transactions and allows editing or deleting.
-
- 6 replies
- 4.8k views
-
-
Hello, I have a container field that holds a pdf file (reciept/invoice) for my expense record. The db will be published to the web. Currently, when the user opens the pdf file a copy is saved to the user's desk top. Is that the only way a user can open the file? If it's saved to the desktop? The user's desktop will become swamped with pdf files. I just hope there is another way. Please advise!
-
- 1 reply
- 1.1k views
-
-
Hi everyone, I wasn't sure where to post this so here goes. I have a solution that tracks jobs. My field people enter information about functions that have been completed and what is left. It also tracks revenue and cost. My problem is that my boss needs to view what he calls a dashboard where he can see a list of all the jobs, what has been done and what is left with all costs and revenue. This means a layout with hundreds of jobs and with the exception of the job number, every field is either a calculation or summary of all the individual functions. It is unbearably slow! Is there a some other way to display this info all together? Are there alternate calculations…
-
- 1 reply
- 1.1k views
-
-
I need access to currently open window names to script in closing certain specific windows. I can make the WindowName function work in two ways, neither of which matches what I read (and what I need) as described in the help file. I should be able to have it display only currently open windows. Formula 1 (see attachment 1) shows one open window (Story Builder - yellow background) when in fact there are three windows open. Formula 2 (see attachment 2) shows three open windows (see window with blue background) when only one window is in fact open. Both calculation fields reside in only one of 10 related tables. Any insights greatly appreciated and t…
-
- 2 replies
- 1.1k views
-
-
Has anyone else come across this bug with which involves Headers Pop-Up Menus and Table Views? It is basically a redraw issue, but the pop up menu seems to move, because when I click there it doesn't respond. ( See attached image... Mac OS X 10.4.11 / Filemaker Pro Advanced 8.0.3 // As a side note the upload of images (png and jpg) to this site doesn't seem to work properly. Only a compressed image was accepted. : / bug.png.zip
-
- 5 replies
- 1.4k views
-
-
Could not find this, if there is a thread about this please point me in the right direction. I have a value list that displays only related data. It shows data from 2 fields. First field is text and the second is number (formated as currency). The field in which it resides is text. Value list itself works perfectly. the problem is that is shows: Item1 6 Item2 7 Item3 8 How would I format it to show Item1 $6.00 Item2 $7.00 Item3 $8.00 or Item1 - $6.00 Item2 - $7.00 Item3 - $8.00
-
- 10 replies
- 2.3k views
-
-
I have a container field that gets populated via a script using the 'Insert File' script step. The file gets placed properly, but, I can not open it from the container field. I thought you could click/double click the field and open the file. Also, can't you use a variable to place the file. I tried that as well and I get a box to highlight the file instead. What am I doing wrong?
-
- 3 replies
- 3.5k views
-
-
I'd be inmensely grateful if you could explain a novice using FileMaker 6 in a FileMaker-ignorant country how to do this. I hace two fields, 'Material' and 'Type', the second depends on the choice made in the first one. In Field1 'Material' I have different choices to be taken from 'Value List Material': 'Bronze', 'Pottery' and so on. Field2 is 'Type'and depends on Material. I want that, depending on the choice I made from Value List1 in Field1 ('Material'), different Value Lists appear when filling Field2 ('Type of object'). That is, if I chose 'Bronze' in the first field, FileMaker should now call 'Value List of Bronze Objects' when trying to fill…
-
- 4 replies
- 1.8k views
-
-
I have a container field that has 3 options. Each option contians a logo. Based on who the customer is, a certain logo appears. This works great until I close out and reopen the DB. All of the images are gone. I have tried using both options when placing the image and nothing works. Any ideas?
-
- 1 reply
- 979 views
-
-
Hi, Is this possible to access my network (Folder and file) in a webviewer trought open remote (ouvrir à distance). I can see my folder in the webviewer when I'am on the principale machine but not on the other machine. I set the webviewer with C: or file:///C:/users....Can somebody help me on this.... Tanks Steeve
-
- 5 replies
- 1.6k views
-
-
Is it possible to script the interaction with the web viewer? When I get to the page I want with the URL, is there a way to automate the clicking of a button, or filling in a field on the web page? Thanks.
-
- 2 replies
- 1.4k views
-
-
Is this possible perhaps using the GetLayoutObjectAttribute function? ie Table Occurance Relationship (squid) Business => PortalFilter => ProjectsDate Layout based on Business has portal named 01 for example. PortalFilter Table has field which uses GetLayoutObject calc to find out which portal it is in (this is the hard (impossible?) bit...) and then adds it to date. So field = portal number + TodaysDate. Relationship to Projects is based on above calc field. So I can use this single relationship to display different records from same table occurance based on the portal object name... If I could get a portal record to identify…
-
- 0 replies
- 1.1k views
-
-
Hi everyone! I'm using a portal to manage my members of staff who work for me like: assistants, makeup artists, producers, etc. I have two fields in this portal called "Type"(drop-down menu) and "Name"(drop-down menu) which means that in the"Type" field i'm placing the type of staff (makeup, producer, etc.), and in the "Name" field i'm placing the name of the staff related to that type of work. Now, i do have a table just for my staffs registration, and what i want to do is; when i select the type of work in the "Type" field, in the "Name" field would appear only the names related to that type of work. For example: If i select in the "Type" field "Producer", when i'…
-
- 4 replies
- 1.3k views
-
-
I have a portal which displays data from [use] table with fields "propertyID" "Line#" "Code" "Size" sorted by Line number. Line# Code Size 01 5000 400 02 8000 100 03 3000 85 04 8000 250 In a second table [uSECODES] I have fields "Code" and "Description". Code Description 3000 descr a 4000 descr b 5000 descr c 6000 descr d 7000 descr e 8000 descr f ... ... I want to display the description of the code in the above mentioned portal so it would be something like this Line# Code Description Size 01 5000 Descr c 400 02 8000 Descr f 100 03 3000 Descr a …
-
- 2 replies
- 2.8k views
-
-
Hi, Could someone provide additional details on the tip published in FileMaker Advisor magazine (http://my.advisor.com/doc/18702) on sending email from Instant Web Publishing (IWP) in FMP 8.5 or 9? With my admittedly limited programming skills, I have had zero success implementing this tip. The goal is for users who access my FMP databases via IWP click a button when they have entered a new record whereby the button sends an email alert to me so that I know there's a new record. The email alert should originate from the email client and account of the person who entered the data rather than from the email client and account that resides on the server where …
-
- 1 reply
- 1.5k views
-
-
Hi All I am still a complete beginner, so I expect this is a fairly simple problem. I have a drop-down menu with options "beef", "pork", "salad", "fruit" and a radio button set with options "meat", "vegetarian". If the user selects "beef" or "pork" from the drop-down menu, I'd like the radio button "meat" to be automatically selected. If they select "salad" or "fruit", I'd like the button to switch to "vegetarian". Is this possible? Thanks for your help and patience.
-
- 3 replies
- 2.1k views
-
-
I created a runtime solution that uses custom images as buttons, this works fine on my machine but when a user opens the runtime product all they see are white squares where the button should be. Any ideas as to what the issue/solution might be? TIA
-
- 2 replies
- 1.2k views
-
-
For those amongst us who are somewhat artistically challenged. I found a few great websites which assist with colour choices etc. Slayeroffice will give you 10% gradients lighter/darker (hint, change the base colour field) Colour Schemer gives you complimentary/colours of the same luminosity. Here's the original article I found the links in Enjoy
-
- 1 reply
- 1.9k views
-
-
I'm working on an Invoicing solution and I'm trying to decide between displaying Invoice Items (a table of labor and materials consolidated for reporting) in a portal or in a list view layout. Items are added to an Invoice from a floating menu of billable items. I need to Display the Items that have been added to the Invoice. I would like to retain the easy searching and sorting, and potential dual use of the List View layout as a Reporting layout, but I haven't come across any elegant solutions for auto-updating the displayed found set when Invoice Items are added. In short, I'd like to get a list view layout to act like a Portal showing only related re…
-
- 18 replies
- 5.8k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online