FileMaker Interface Features
-
Can I attach 2 value lists to one field? instead of creating a new field.
-
- 1 reply
- 934 views
-
-
I have a BD with addresses etc. One function I have is to pint a envelope. Now sometimes I might want, for example, the company name or country in it and sometimes not. Is there a way to make the field editable before I print? At the moment it is not and I can no find a way to make it so. (I get the message: This action cannot be performed because this field is not modifiable.) I have a Database that pulls all the information together as a calculation. TrimAll ( List ( Title ; TrimAll ( First Name & " " & Last Name ; 0 ; 0 ) ; TrimAll ( Company ; 0 ; 0 ) ; TrimAll ( Street 2 ; 0 ; 0 ) ; TrimAll ( Postal Code 2 & " " & Cit…
-
- 12 replies
- 1.4k views
-
-
Admins, please move this if needed. Sorry I could not see a better option. But I was also in a hurry! Cheers and thank you in advance. I have a simple dual monitor setup as I use several programs at a time. When Outlook 2010 and FM are open at the same time, if I click to change to a different mailbox (sent,inbox unread etc...) the FM window on the other monitor flickers until the Outlook program has finished painting the new window! I am at a loss mates! Cheers!
-
- 0 replies
- 789 views
-
-
I am using Filemaker Pro 12 since its release and the program crashed on me. On restarting the drop menus fail to automatically populate. They only populate by moving my mouse through the invisible list. This occurs with all databases including the sample ones provided by Filemaker. Is there a quick fix or must I reinstall Filemaker?
-
- 1 reply
- 1.2k views
-
-
So I have a portal, and I am using a tiered group of conditional value lists to populate some the field data (This works). The problem I am having is when I get to the last drop down and make a selection, I would like that last selection to populate a merge field with data. This data is located in the same table as the last drop down. For example: The last selection is part number and based on the part number, I want to display a description of that part. Part number and part description reside in the same table but neither one of them are in the table the portal is based from. How should I approach this? Do I use lookup fields in the table the portal is b…
-
- 1 reply
- 899 views
-
-
Hi, I have a table called Customers, holding fields 'Customer ID', 'First Name', 'Last Name', 'Full Name'. Full Name = First Name & " " & Last Name. I want a value list that will allow me to view the full names, and select a value based on this. How is this doable? I've tried many solutions I found around the place, but nothing seems to work. Any help would be greatly appreciated.
-
- 6 replies
- 1.4k views
-
-
hello! Not really sure where to post my question but it currently uses a value list so i figured let me start here. When writing orders we require that the salesperson choose either New or Repeat to let production know if the order is New or Repeat. It is a drop down with value of New or Repeat. One of those has to be chosen, but what is happening is when the sales person duplicates a similar order to speed up the process of generating a New order they are leaving the field as it was on the duplicated order which 9 times out of 10 says Repeat. So i constantly have orders sent through to production showing it as being repeat but actually is New. Just lazy sales staff. Is …
-
-
- 3 replies
- 884 views
-
-
I've created a layout titled Searchfields, which shows records from my master file The fields I have placed on this layout are: First Name Last Name Phone 1 Phone 2 City State I've created the following fields in my DB file _search_value is a global text field (to be used in the next step after I get this dropdown to work) _search_list is a Calculation, Indexed field FieldNames ( Get ( FileName ) ; "Searchfields" ) _search_field is a global text field I've created a value list search_names using values from the -search_list field referenced above. When I add the _search_field to ANY layout (the layout is based on t…
-
- 1 reply
- 778 views
-
-
Hi All, I was wondering if there is a possible way to turn on/off for "Allow Entry" to a field in Browse Mode. I would like the user to click a button to make the field "Active". If not possible, is it possible to set a conditional format to resize an object? Let's say I have a web viewer, when I click a button, the web viewer expands to a set size. Any help would be appreciated. Thank you, Dave
-
- 1 reply
- 1.7k views
-
-
Hi, What is the workaround if the background is a gradient for example, but you need a size 12 transparent text? Example: I have a check-boxes field and next to each value I put a a different text field.
-
- 5 replies
- 4.1k views
-
-
If ( IsEmpty ( Act1 ); ""; Act1) & " " & If ( IsEmpty ( A1_Start); ""; "-- Start: "& A1_Start) & " " & If ( IsEmpty ( A1_Stop ); ""; "-- Stop: "& A1_Stop) & ¶ & If ( IsEmpty ( Act2 ); ""; Act2) & " " & If ( IsEmpty ( A2_Start); ""; "-- Start: "& A2_Start) & " " & If ( IsEmpty ( A2_Stop ); ""; "-- Stop: "& A2_Stop) & ¶ & If ( IsEmpty ( Act3 );""; Act3) & " " & If ( IsEmpty ( A3_Start); ""; "-- Start: "& A3_Start) & " " & If ( IsEmpty ( A3_Stop ); ""; "-- Stop: "& A3_Stop) & ¶ & If ( IsEmpty ( Act4 );"";Act4) & " " & If ( IsEmpty ( A4_Start); ""; "-- Start: "& …
-
-
- 2 replies
- 918 views
-
-
I want to conditionally format something based on the most record portal row field value. Another words, ff the most recent portal field value = "yes" conditionally format a corresponding label to read "required". How would I do that?
-
- 3 replies
- 1.7k views
-
-
Hi, Has anyone had problems with layouts not converting as they should? I have one layout in particular, very complex, that's been fine since version 8 , 9,10 and 11 Advanced that's quite messy after conversion to 12. Blocks of text pasted onto the LAYOUT now have borders that are not specified in the inspector. It shows no line but these objects (non-data) now have borders. I've found no way to remove these.
-
- 12 replies
- 2.1k views
-
-
Hi there... obviously missing something here so I wonder if anyone can help.... Have a container filed. Have it set up for interactive content. It's a thumbnail size so I need a way of opening the pdf as its too small to view with the size of the container field I have. How do I open the pdf?
-
- 4 replies
- 1.3k views
-
-
hello , i want to know how to find an item from a portal an then export the found set to a new databse on a new record? is this posible? thanks
-
-
- 9 replies
- 1.4k views
-
-
In our portal, we have a Start Date and a Start Time field (popup value list of times). These fields let an instructor indicate the day and time they started a session. When an instructor completes the session they can start a new session and time on a new portal row. A small problem we have is that an instructor may start their session today at 1:00 p.m., then for their next session (on a new portal row) they may accidentally select 1:00 p.m. again (instead of 1:15 p.m.). Is there a way to stop them from entering the same start time for any of today's sessions. Michelle
-
- 2 replies
- 798 views
-
-
If a drop-down list has many items then one has to click, at the bottom of the list, on an ellipsis symbol "…" to force a display of all the items. This is new to FileMakerPro 12. Is there any way of reverting to the "old" interface which allowed one to see all the items without this extra step?
-
- 1 reply
- 1.3k views
-
-
I have a portal in which all fields are required. My script so far: If [isEmpty (table::StaffID)] Show Custom Dialog ["Validation Failure!! StaffID must have a value"] Go to Field [table::StaffID] Halt Script End If I have two problems to solve. 1) I want to invoke this script them someone tries to exit the portal row--all I can come up with is to apply a trigger to the last field, and have it implement on save or exit. What if the enduser skips the last field? (which they aren't suppose to do). Is there another way to do this. 2) There are a total of 4 fields in the portal and all four should be required. How do I modi…
-
- 2 replies
- 1.4k views
-
-
I have a table called Clients. This has all the clients information and a field called Active. This field is Yes or No. On a different table, Jobs, I have a drop down for a list of the Clients (the name field to be specific). I'd like to only show the ones that are Active. Is that possible? Thanks!
-
- 1 reply
- 1.2k views
-
-
I am having trouble with a value list used in a portal. Tables I have are: Items: ItemID SupplierID Description, etc. etc. Suppliers: SupplierID SupplierName, etc. etc. Orders: OrderID SupplierID Date, etc. etc. OrderLineItems: OrderLineItemID ItemID Qty, etc. On the Orders layout, I have a portal that holds records from OrdersLineItems. I want to be able to select ItemID from ONLY the Items that share the same SupplierID as listed in the Order. If I have an ItemID field in the Orders table, it works perfectly using the relationship between Orders and Suppliers. However, once I use it in the portal, it does not work. I assu…
-
- 1 reply
- 967 views
-
-
I realize this has probably been asked numerous times but I can't find another thread that I understand. I have an Inventory table with items listed by "shelf", "category" & "Stock ID". I also have a field that shows it's status as either "reserved or "Available". When entering a line item in my Invoice file, I have value lists for "Shelf", "Category" & "Stock ID". My Stock ID Value list now lists all related items but I only want my Stock ID value list to show me just the "available" ones. I don't know how I can do that. Any help would be sincerely appreciated.
-
- 4 replies
- 1.3k views
-
-
Hi, I've got a field (CardWallCert) with a check box which is fed by a value list with entries "Wallet Card" and "Wall Certificate". It describes which are applicable for a given course (there are a number of possible variants ) and every option is potentially possible (Either one, or the other, or both, or neither) I'm trying to textually describe the contents of the check box (and hence the course variant) via a calculation: eg: Case ( IsEmpty ( CardWallCert ) ; "NO card/cert, " ; CardWallCert = "Wallet Card" and CardWallCert = "Wall Certificate" ; "" ; CardWallCert ≠ "Wallet Card" ; "NO card, " ; CardWallCert ≠ "Wall Certificate" ; "NO cert, " ; "…
-
- 6 replies
- 1.2k views
-
-
I'm taking apart a working example of a conditional value list--recreating it myself to see if it will help me with understanding concept. The file I'm playing with is a two table example. Very simple. Designed to produced three layers of values (the second two value lists based on conditions). These values lists are on a single record context layout. The first two value lists work properly. The third is producing an undefined value. I've double-checked my relationships and fields and value list setup with that of the working copy and am not able to locate what I've done differently. Can anyone out there please take a look at this tiny file and point out to…
-
- 0 replies
- 880 views
-
-
Hi, I have created a phonebook database but for the printable version layout I am having issues with the sub summary parts. It is sorted by department and sub department but not all departments have a sub department so is it possible to set it so that the second sub summary part collapses when there is no content to display. Images attached to hopefully clarify what I am meaning. Image 1 shows the layout, image 2 shows what I am trying to avoid. Thoughts welcomed. Thanks
-
- 5 replies
- 2.3k views
-
-
Hello Board, I really like the idea of portals, or what i think they are, but i don't get it. I'm new to building db's. I have a table that records a job process. There is a 'Job Number' and then the individual processes that occur are added as New Records with that Job Number being the same. When someone enters a Job Number into the field, i'd like a Portal to show the other records that also have that same Job Number. I would also like to count how many records there are that are in that portal, matching that Job number. Is that possible? I'm not really getting how to use the Portal. i've tried building the above a few times but i can't seem to …
-
- 2 replies
- 1.1k views
-
-
We allow users to increase and decrease font size by clicking a + or - sign. Each sign is a button and the button is a "set field" with the field specified and the calculated result: textSizeChg (field ; "UP" ), where textSizeChg is a custom function written by someone long ago: *********************************************************************************** // fontSizeChg ( text ; upordown ) Let ( [ sizenow = Filter ( LeftWords ( GetAsCSS( text ) ; 5 ) ; "1234567890" ) ; sizenow = Case ( IsEmpty ( sizenow ) ; 12 ; sizenow ) ] ; TextSize ( text ; Case ( PatternCount ( upordown ; "up" ) ; sizenow + 1 ; Max ( 1 ; sizenow - 1 ) ) ) ) *************…
-
-
- 3 replies
- 2.4k views
-
-
Hi, I'd like to ask you if you can help me with this. We are running several FM DBs simultaneosly which was created from same template DB. During the time we want to add new feature(s) but it's very uncomfortable to synchronize all changes with all DB on the server. This features updates are not only layout changes but it could be anything. adding new tables, fields, value lists etc. Does exists some way how to manage all DBs together? Something like dynamic template? Joining all dbs to one is not possible. Any ideas are greatly appreciated. Thank you. AD
-
- 2 replies
- 1.2k views
-
-
Hello Board! New FMP12 user here. Thank you to all for the help i've had so far. I'm really getting this db firing and it's making a difference to us! I have a report that summarises work done in the day. A script searches then sorts the info and then puts the user into a layout that shows the info. It looks good on screen, contains a Header part and a Summary part only, but when i print it to a laser A4, only the Header prints. How do i get the Summary part with the data to print? Thank you! Harry
-
- 1 reply
- 708 views
-
-
Help... I have a small three table database. The context is based on _Staff. I have a portal based on a tabled called _Services_Referrals_Sensitive and a conditional value list called _Services_Referrals_Sensitive_cvl. When the staff member adds a new portal row they are able to pick a category but then the correponding list is cut short--only showing one item in a much longer list. Can anyone see what I've done wrong on the attached file? I'm going round and round in circles on this and would really appreciate knowing what it is I'm doing wrong. Any help would be so greatly appreciated... mpConditionalVLProblem.zip
-
- 1 reply
- 1k views
-
-
Hi Guys, I'm using the web viewer to show google maps but i want to hide the status bar and the direction panel so as to have a much better big map displayed. the web address is: "http://local.google.com/maps?" & "q=" & /*Address=*/ Overtime::g_GpsCoordinates can some help on this issue?? Thanks.....
-
- 2 replies
- 6.3k views
-
-
Does anyone know if Filemaker has a feature that will allow a news feed? Our company is using it for scheduling and managing workers on the field. We want to be able to see any recent activity on our end when they make a sale, add a contact, or finish a job.
-
- 1 reply
- 1.3k views
-
-
Does anybody know of a calc for conditional formatting that is based on whether the record has been committed. I have not been able to find an answer to this with a bit of web searching. many thanks in advance. Mike
-
- 2 replies
- 2k views
-
-
hi there. i have a DB that has the following fields: customer name, image (container), category, image name. what i am trying to do is make a printable pdf. there is only one customer, one image (no duplicates), one name per image, one category will have multiple images. so the customer name is always at the top. then the category (CATEGORY 1, 2, 3), then the images with names are laid out 3 or 4 perpage. so category 1 may ave 3 images, then category 2 have 5, on so on. i have tried to make labels and no go. any help would be nice. thanks
-
- 3 replies
- 1.2k views
-
-
Howdy, all: I'm trying to print the contents of several value lists into a two-column-defined layout but can only get the list to print on the left-hand/column side; it won't continue/wrap to the second column. (See attached) I have a single calculation/global merge* field (<<_g__ValueListList__lxt>>) in the layout that contains the following: TextStyleAdd ( "Duration (JOBS)"; Bold ) & "¶" & VALUE_LIST::Duration_JOB__gxt & "¶¶" & TextStyleAdd ( "Referred By (JOBS)"; Bold ) & "¶" & VALUE_LIST::ReferredBy_JOB__gxt & "¶¶" & TextStyleAdd ( "Result By (JOBS)"; Bold ) & "¶" & VALUE_LIST…
-
- 2 replies
- 1.2k views
-
-
I have a calculation field and using a repetition of 10. Now the calculation is only performed on the first repetition. Any idea why this is happening?
-
- 3 replies
- 1.4k views
-
-
I have Tab Control #1... and then I have Tab Control #2 embedded in the 4th tab of Tab Control #1 I have named the 4th tab of Control 1, WebTab4 On Tab Control #2 (embedded in Tab 4 of Tab Control #1), I have two tabs. I call them WebTab4a and WebTab4b, respectively. When I try to perform script step "Go To Object" to WebTab4, it works perfectly. When I try to perform script step "Go To Object: to WebTab4b, it fails with and Error 116 which is "Layout Object Missing". This happens regardless of whether or not I go to WebTab4 before, or not at all, prior to that script step. Any ideas? The environment is FM Server 12. Thanks,
-
- 6 replies
- 3.6k views
-
-
I've read a couple of posts about locking down specific records, what I need to do is lock down a specific field so that it cannot be edited. I figured out HOW to do this and it works fine, using a couple of scripts. My issue is: When I set the field up and select none of the field entry options, this allows no editing of the field. My scripts add data/information into the field without issue. The problem is once you uncheck all of the field entry options, it eliminates the vertical scroll bar so we can not see the information in the field once it fills the window on the layout. Attached is a sample file that hopefully illustrates my situation. Two fields N…
-
- 2 replies
- 793 views
-
-
Hi There, I have come up with a way of inserting/deleting records in a portal similar to how you would insert/delete in excel. If you could please evaluate and comment, I would greatly appreciate it. I am looking to see if anyone finds anything that I have not considered with regards to this process. The idea is that you want the records in the portal to be shown in the order they are entered, unless you insert a row between two records... you will see what I mean by looking at the file attached. Thanks so much for taking the time to look at this. Constance insert_portal.zip
-
- 1 reply
- 846 views
-
-
I would like to setup an 11x17 landscape print view layout. That will let me use a portal for data and keep running headers and footers. However, if i close the file, it reverts back to a standard 8.5x11 letter view. Is there anyway to keep the 11x17 view i need for printing?
-
- 1 reply
- 937 views
-
-
I have Instant Web Publishing turned on and when I view my layout in a browser, the web viewer field is not showing anything. I see the box, but there is nothing in it. I am currently on my Mac and trying to view it in Chrome, Safari, and Firefox. Thanks, Steve
-
- 1 reply
- 1.9k views
-
-
I hope to see in my portal a series of images My Mac DB fmp12 has an ID relationship with another DB where I have the images In the portal I create I can see the images, however I hope to be able to display them "horizontally" or, if possible, create rows and columns kind of design I hope be able to see as many images is possible rather than scrolling veriticaly. My screen is half empty .... Is this possible? Else do I need to create several relationships all linked through the ID equal in both DBs? Thanks a lot .... but I am new in using portals .... :mad:
-
- 6 replies
- 1.2k views
-
-
I have the PC, in which web-crawling script is running 24 hours straight. As time goes by, it seems the PC is getting slower and slower. I'm guessing that it's mainly because of the cache that web viewer makes. If anyone knows how to manage this kind of batch transaction, what would be the best way? any solution? As a consequence, I found out it's better to shut down FileMaker application and launch again and again repeatedly. It seems the most stable. Thanks!!
-
- 9 replies
- 8.3k views
-
-
Probably a silly question. When I go into layout the screen area looks like graph paper and for me that's hard to work with. I can't seem to find the setting to turn that off. Any ideas?
-
- 2 replies
- 919 views
-
-
I am new to filemaker but enjoying it more than I did Ms Access I took the Invoices "Starter Solution" that comes filemaker 12 as the basis of my database design. I want to have many people sign in and look at the items I am selling using IWS (Instant Web publishing). The starter solution invoices database makes use of global fields in the database for selecting say UNPAID invoices. How can I make a drop down list that is not connected to a field in the database? Ideally I would like to add a variable to the screen called say $FilterPaymentStatus when a user clicks on the field. He should see a pop up list Paid UnPaid DepositPaid ..... …
-
- 6 replies
- 864 views
-
-
I have a few files that have scripts that run dependent on the value entered into a field from a drop down value list. I always have a 'continue' button adjacent to the value list that runs the relevant script. I'm guessing there must be a way of running the script direct from the value list drop down without the need for a 'continue' button, but how?
-
- 2 replies
- 947 views
-
-
I've been working on a database that will be used as an appendix in a PhD dissertation. There are long example quotes of text in a field that can span multiple pages. This comes from several different editions of a text book and are categorized by the composer/hero that the text is about. Fields are Hero (which is the composers name), author, edition, page numbers and quote. I'm trying to have the layout look as follows: Sub-Summary Hero Body | Author Edition Page | Long Quote Repeat in the body with each author and quote then move to next Hero sub-summary. I have all of the fields set to slide up and resize the section. I have the sub…
-
- 0 replies
- 1.5k views
-
-
I have two portals on the context of Staff layout. The first portal the enduser picks the program initiative and corresponding person. The second portal is used to display only those records above that correspond with ID_PROIN_fk=17. I tried a variety of different relationships and filtered the portal but get funky data every which way. Can anyone see what I'm doing wrong? PortalFilter.zip
-
- 2 replies
- 1.1k views
-
-
I'm trying to get a line on a report to go from the heading through the body, one line for each column. In previous version I had to make the line halfway through the heading and body then halfway body and footer - something very annoying. In 12 I can't seem to get it right. Isn't there a simple solution? Thanks. Mike
-
- 7 replies
- 1.1k views
-
-
I have a table that holds all inventory in stock - CurrentInventory This contains: ItemID ColourID SizeID Qty There may be the same ItemID, with different ColourID, and different SizeID. Eg: Item 1, Colour 1, Size 1, Qty 5 Item 1, Colour 1, Size 2, Qty 5 Item 1, Colour 2, Size 1, Qty 5 Item 2, Colour 2, Size 1, Qty 5 I want to create a value list to be accessed from my Purchases section, that only lists the available ItemID, and then once that is selected, shows only available colours in the ColourID field, and so on. How is this do-able? All the examples I have seen have 2-3 tables for the set up, but all the information of mine is s…
-
- 2 replies
- 1.1k views
-
-
Hi, i stuck in container field,i want to put container field as signature in footer which should be show on last of page in preview mode .how it can be done,the signature field show only in last page.i have attach a screen page for this thanks in advance
-
- 2 replies
- 1.5k views
-
-
Howdy, all: I'm using a custom theme in a solution that has presents text color in white. Fine. The problem arises when a user clicks the Copy button in the solution that copies a field's contents: when pasted in another app--like TextEdit or WordPad--the text is white because they accept the style the text was created in. I'm having a devil of a time trying to code a script so that it temporarily turns the field's text black--which I've managed to do using Conditional Formatting and setting a global number field ("1" = black text, "0" = white text) as a condition--then copy it so it can be pasted as black text elsewhere. I don't (readily) see a script command t…
-
- 5 replies
- 1.9k views
-
-
Hey guys I have a small database which utilizes a portal where I enter my hours for each day worked. Time In, Break Out, Break In, and Time out. I then have a field that calculates the total hours worked (everything is in 12 hour time), and then another field that calculates my pay for the day based on my hourly rate which is entered in a separate field under a separate table (total hours * rate). My tables are Week Info and Hours Worked. I'm trying to include two check boxes on each row that calculate one or both of the following: over time (time and a half for any hours exceeding 8), and time and a half (for days such as holidays where I earn time and a half f…
-
- 13 replies
- 2.1k views
-
-
I have two tables: Items, and Suppliers. I have a value list to display Items, related to Suppliers. When I update the Items, and add new ones, the value list is not updated... I had to edit the value list, and confirm it was stil set up the same, and then when I selected OK it was updated... Why is this? Actually, it's not updating at all. When I go to select the item in the field where the value list is attached, it comes up as no values defined. I then change the value list to display all the items (not just those related) and I can select the item. Then once I change the value list back to being related, it only shows the single item I had previous…
-
- 8 replies
- 1.5k views
-
-
I've got a field/checkbox with 1 single box to check. I'm trying to make it so that when the box is checked another set of text turns red, and when its not checked it stays its normal color. Any help? Thanks
-
- 1 reply
- 1.3k views
-
-
Hi, I feel my problem is quite simple, but I cannot find a solution anywhere! These are the tables I am working with: Orders OrdersLineItems Items The Orders table holds just basic data - OrderID, SuppliedID, Date... while all the actual details are added into the OrdersLineItems (through a portal). In the OrderLineItems table I have an ItemID, which I have set to be a value list coming from the ItemID's in the Items table. This all works fine. What I am looking for is to be able to have the value list to select the ItemID from the Items table, but instead of displaying the actual ID, I want it to display the 'Description' coming from the…
-
- 13 replies
- 1.7k views
-
-
Hi all, I'm working on a solution in FM12 which requires me to filter a rather large record set (100,000+). Typically for performance reasons I would filter at the relationship level so that only a very small subset of records is returned to me over the network. However I've heard talk in FM12 that portal filtering is meant to behave much faster and - dear I say it - be carried out server-side? So in my testing the only way I've managed to get the portal filtering to actually behave the same as relationship filtering in terms of performance is to only reference hard-coded text strings in the filter, eg: Portal::Field = "Blah" Now, this is fine fo…
-
- 9 replies
- 2.8k views
-
-
i am really lost as to the best way to show a table of values related to the current record. I have have internally joined relationships and need to should a value table in a report. i just simply want to return all the fields and values from a specific table in my report. i have tried to use portals however they do not auto resize their rows based on number of values. am i going about this all wrong? i know this is probably very simple i just cant find a good solution. thanks
-
- 1 reply
- 775 views
-
-
Hello, I am trying to build a layout for printing a pdf document. I have built a table that have many fields to cover almost every stituation that might arise. When I print this, I want to find a way to make the empty fields (and the accompany field name) disappear so that blank spaces and field names with no accompany data do not clutter up the lay out. I've tried conditional formatting to make the field name go blank when its accompnay field is blank. I've done as much sliding up as I can to minimize the field size. But I have these annoying blank spaces are still there. If anyone might have any ideas, please let me know. Thank you
-
- 11 replies
- 1.9k views
-
-
This might be more of a script issue than a layout question, but I'll ask anyways. I was wondering if there is a way to format my text in a field to automatically space out on the "tabs" of the layout? I am trying to make a list with multiple columns and I don't know how long the input will be, so just putting in spaces could look correct for some input but bad for others. (i.e. In java I would use the tab escape character \t to line up the tabs) Is this possible to implement in FileMaker? Thanks.
-
-
- 2 replies
- 2.7k views
-
-
Hi,. I would like to show my image with transparent background. While click my image it should show like my attached image. I mean image background should be transparent. It should show background window contents transparently. Kindly help how to do it. Thanks in advance.
-
- 2 replies
- 1.6k views
-
-
This is driving me crazy: I snagged this solution from filemakermagazine.com and while trying to learn how it works, I added two fields, Popup List 3 and Popup List 4. For the life of me I can't figure out why they aren't populating with values on both the Main and Hidden layouts; I copied and pasted the original two existing fields, including their related scripts. Nada. You can see their data in the ValueLists layout so I know the data's there, just that the value lists don't appear. ...and what's _really_ going to tweak me is that it'll be something simple that I overlooked. *heavy sigh* TIA for your help! Rich Interface copy.fp7.zip
-
- 2 replies
- 990 views
-
-
Is there any way to choose the color of a color stop in the gradient part of Inspector prior to creating it? In other words, when I click on the gradient to create a color stop it gets created with what appears to be randomly chosen colors. I'd like to be able to control what the color stop's color is upon creation if I can. Thanks in advance, -Kent
-
- 2 replies
- 921 views
-
-
Oh, this makes me dance for joy ... FINALLY ... Show Field Frames when active in Layouts Setup is finally defaulted to UNCHECKED in FM12. yay!!! That deserves a dancing banana if I ever saw one! :yay:
-
- 0 replies
- 692 views
-
-
I have a table called Items. This stores information regarding different items, with fields (eg: ItemID, Name, Description, etc.) and a field called AvailableColours. I have a table called Colours (with the single field called Colour) , in order to make a value list from the values in this field. I have it this way as it will be easier to add a new colour to this table rather than a custom value list. I have a table called Orders with fields ( OrderID, Date, etc.) and another table called OrderLineItems with fields LineItemID, OrderID, ItemID, Qty, and also Colour. The OrderLineItems table fills each order through a portal by adding items, etc. This works fine. …
-
- 10 replies
- 1.9k views
-
-
Hi All I'm nearing completing my database and I had a couple of queries, though I'm not sure which sub-section is best - anyway, here goes! We're selling cars and every car when sold needs to have a PDI (pre-delivery inspection). There's a table for cars and a table for PDI information. Cars have a unique vehicle ID which links the two tables and I have also given the PDIs a unique ID. We have made the layout so that our mechanics can use an iPad to fill out the form. MY ISSUE is that they naturally want to use the "vehicle ID" drop-down I have to do a PDI on another car, but of course they're just changing that one ID and linking their info to a …
-
- 1 reply
- 1k views
-
-
I'm not even sure if I'm in the right section of the forum. I'm looking for a solution how to do it. (please see picture attached. ) This is List View. See below the last record. I have tested layouts themes in the FileMaker 12. This is a Theme "Silver". This theme is good but I need different. Creating own theme is the only solution? PS. My database will be shared by the server. I have FM 12.0v1 CE version. Update is not available table1.zip
-
- 1 reply
- 1.5k views
-
-
I have read and watched videos and still have problems getting my portal to work. I have an EXCEL spreadsheet that is set up to give the studentID, StudentName, then their courese. I am trying to get the courses to show in a portal. Right now one student has 7 records each for a different course. Cannot seem to get it to work. I have attached so someone can point out where I am messing up. Thank you. studentrecord.zip
-
- 11 replies
- 2.3k views
-
-
Hello, I'm adding in a Purchase Order module to my existing music department database and need some guidance. Our department has 15 accounts from which purchases are made. The account numbers on these accounts are static except for 2 digits that change based upon the fiscal year (from July 1 to June 30). I would like to have a way when creating a PO to select from a drop-down list that shows accounts only for the current fiscal year. I will need to keep a record of the POs and their year-specific accounts from past years. I can create a calc field that calculates the correct account number at any time of year for each account, but I don't know where best to…
-
- 1 reply
- 1.1k views
-
-
What I want to do is manually select a word or two and hit a keyboard shortcut that turns the text color to red. I have (on my Mac) Keyboard Maestro, which can select a menu and/or do all sorts of UI tasks. But to change to red you have to select a swatch from a palette. I think the solution will be to make a script that does something similar to TextStyleAdd (red). Then I can just select that script from the script menu. But the script creation window seems to allow only a few commands, none of them related to text. Can I do this?
-
- 4 replies
- 3.2k views
-
-
Hi, I'm looking for some help with making multiple images appear in one portal. I have nearly no experience in database building or FileMaker, so please forgive me for my ignorance. What I'm trying to do is making two rows of images (2x approx. 10 images) appear in the lay-out mode. The way my database is organised, is that there's one table containing names and data of different photographers and the second table consists of front and backsides of photographs in containers. They're related via the photographer's name. The thing is, for one photographer there can be up to 10 pairs of front- and backsides of photographs, which is why I've decided to use 2 tables …
-
- 1 reply
- 917 views
-
-
Hello all I have one layout and I would like to display two portals, each from a different table, to display and enter data. Seems simple but my layout is tied to one of the tables and I would like to display data from the other one. I know they need to be related but not sure what field I need to relate them with. Each table consists of two fields, one is the id field or key.
-
- 1 reply
- 1k views
-
-
I'm attempting to create a database to store id documents for people in a multi-departmental firm for anti-money laundering purposes. People can belong to more than one client files. Client files can have more than one person. People can have more than one piece of id. As I see it, I have a one to many relationship between people and id and a many to many relationship between people and client files. So I have created a join table to handle that. I may not have the relationship mapped out correctly though. Or perhaps it's the field settings. Additionally, I don't understand how to create a layout that will allow the user to make the connection between the person …
-
- 5 replies
- 2.3k views
-
-
I have a field 1 and what I would like to do is set field 2's value list based on the data in field 1. Is that possible? Thanks. Dom
-
- 2 replies
- 1.1k views
-
-
Hello, I'm new here and new also in dealing with filemaker 10. Maybe someone of you experts can help me.... :-) I set up a layout with text and fields on a MAC and there the layout looks fine. But also PC users need to use this layout. The problem is that on the PC fields, lines and text are a little bit mixed up. Do you have any idea, how I can solve this problem? We've already checked the settings of fonts. Everything is fine there. I'm grateful for any help! THANK YOU! Claudia
-
-
- 2 replies
- 1.1k views
-
-
I have a Person table. Associated with that Person table is an Instrument. The data for instruments are held in a separate Instrument table. There are two fields in the Instrument table: Instrument ID and Instrument Name. Of course, the Person::Instrument field is related to the Instrument::Instrument ID field. When displaying layouts of the Person table, I associate an instrument value list with the values from Instrument::Instrument Name, so that the appropriate instrument name shows up in the Person layouts, and not the number from Instrument::Instrument ID. Basic, right? The problem is when I export to Excel. When I export records from the Person table, I ge…
-
- 6 replies
- 4.4k views
-
-
I have 2 edit boxes in my layout. I want the value to be the same as another edit box in the layout. I can not figure out how to make this happen. Seems as though you have to relate it to something in the table to generate the value. Any assistance would be appreciated.
-
- 4 replies
- 1.7k views
-
-
Hi, all: I recognize the wisdom of having a separate table for value lists, but should that one table hold all of the non-custom value list fields, or should each value list field have its own table? For example, say you have three different value list fields: fruit type, countries and company names; they're completely unrelated to each other. If you were to put all three in the same table every record would have at least two empty fields (since each record would have one of its three fields filled with data.) Is that a "don't care" issue, or is it better to have a table dedicated to each one so there aren't any empty records at all to contend with? ...or am I i…
-
- 1 reply
- 924 views
-
-
I haven't been able to find a previous query on this one . . . I have a portal displaying child data, displaying several Fields -- say there are 5 columns in the portal -- and I have little text objects above the portal labelling these fields. Is there a way to turn these labels into buttons that would sort the Portal Records according to that field? Obviously, this is a easy to do when you're doing a list view of a single table -- but is there a means of getting into the portal context to sort them? m I'm not seeing it . . . thanks!
-
- 3 replies
- 1.7k views
-
-
For a database for articles, Each article has multiple tags. I have a basic setup with a portal showing records from the join table between Articles and Tags. I am trying to create a value list for tags that updates itself showing only unselected tags for an article. ARTICLES::cSelectedTags is a calculation=List(ARTICLE_TAGS::TagID_fk)&¶ Then ARTICLES::cSelectedTags is connected to a duplicate TO of TAGS::TagID using a not equal relationship operator. A value list is built using this relationship, would exclude the tags selected in the portal ? Attached images show the relationship graph and setup for value lists. For some reason the value list does n…
-
-
- 4 replies
- 1.3k views
-
-
Forgive me if there is another post referencing this. I tried searching for it but didn't find anything. I have a form that contains a few pop-up menus. Ideally the user tabs into the field, in this case a "state" field presses 'i' and "ID" is populated. If the user presses 'i' again the field value would change to "IL" for Illinois. A drop down menu sort of does this but from a user experience, they are really cluegy. I'm hoping someone can point me in the right direction. Thanks, FM Newbie
-
- 2 replies
- 1.7k views
-
-
Hi, We'd like to try to develop a simple model using levers and sliders. Does anyone know if this is possible in FMPro? The slider would have three positions and graphically represent, Hi Med Lo, with the calcs being some sort of factor. Does this sort of thing exist? I know I can use XmCharts to enter text and use gauges, etc. but looking to move a slider, not enter a value. Thanks
-
- 3 replies
- 1.4k views
-
-
Is there a way in Filemaker Pro 11 to display data from two records that are from the same table on one layout? I thought I could use a portal to display/print the second record's data, but when I try to set up the portal the current table (and all other tables in the database) are grayed out so cannot be selected. It has been a long time since I did more than just enter data in the database, so anything I knew about portals is apparently forgotten. Here is what I am trying to do: The database contains 7,000+/- membership records. Some members are family members to one another. Each has his or her own membership record and membership number, so their records are…
-
- 2 replies
- 1.1k views
-
-
Hi, all: I'm probably making this far more complicated than it needs to be but hey, that's my trademark. I have a text field in my solution, States_Provinces where it looks to an external VL table for their full names and two-letter identifiers. To make the user experience easier/better, what I want to happen is this: 1) Tab or click into the States_Provinces field and be presented with the states/province's full names via a drop-down menu. 2) They can either: (a) Type the first few letters of a state's name to bring up the full name, (b ) Click the state's name from the list, or (c ) enter the two-letter identifier. 3) A calculation or custom function …
-
- 4 replies
- 1.5k views
-
-
Hi guys. Newbie here â�� and I do mean newbie. Humanities major newbie. Iâ��m working on a theater alumni database for a high school. Don't ask why. Iâ��ve got about 2500 contacts. Each record includes a list of the productions that contact was in, the date of the production, and the contact's function in the production (actor, crew member, etc). It's the table to the right of the screenshot here: I'd like to create a button that will show all contacts who were in the same production (similar to the ones that already exist at the bottom of that screenshot, for name and graduation date). To throw a wrench into it: The similarity criteria can't just be the …
-
-
- 12 replies
- 1.8k views
- 1 follower
-
-
Hi all I have a problem setting up a 3 tier conditional value list I want to have 3 fields Region, sub-region and document source the first field is a list of continents then countries and then document sources I have managed to get the second tier working but not the third Their are two tables (main and jurisdictions)- they are linked by Region - the main table has the 3 above fields plus many others - the jurisdiction table contains only the above 3 fields I have the region field in the main table set as a custom value list I have the sub region field in the main table set as a value list to work off of the sub region field in jurisdiction showing only …
-
- 2 replies
- 1.3k views
-
-
I built a couple of fairly simple databases in FMP v11 to catalog some art using one of the pre-made inventory templates. Both databases are used in a multi user environment. The "Insert Picture" button to place an image in the field has this simple script: Go to Field [Product Catalog:Image] Insert Picture [] In the first database this worked just fine. In the second one, the field randomly drops images, even in single user mode. After some searching I found one suggestion which I tried - adding this to the script: Set Field [Product Catalog:Image] Commit Records/Requests [] Still no go. I'm doubting it's an issue with this script anyhow …
-
- 3 replies
- 878 views
-
-
Novice here. Designing a simple database containing info about horse owners (one owner may have several horses), and their horses. I want to be able to set a field in the 'Horse Details' table, that contains the owners surname, from the 'Owner Details' table, where I can select an already existing owner surname from a drop down list. ie adding a new or additional horse against a current owner. This is to be performed on the iPad. Just not sure how to set up the field correctly in the 'Horse Details' table (and any considerations I may need to make in setting up the related field in the 'Owner' table. Any advice appreciated.
-
- 4 replies
- 1.2k views
-
-
I have a home asset table with a item field among other fields. I also have two other tables name category and location with a category and location text field, respectively. In one layout with a tab, I have two portals (see attachment). The left will list my categories and the right I hope to list my items that are located in the location area. I am not sure what relationships are needed to get this to work. Once I get the category to work, I will do the same for the location tab. The layout is based on the category table for now but that is probably wrong i Know.
-
- 3 replies
- 1.2k views
-
-
Hello all, I am using the List View. Based on variables I want to display different groups of objects (buttons, text etc.) in different records (shown at the same time). My first attempt for a solution was to use tabs that I control via scripts. The problem is, that all records in the list view always display the same tab of a tab control. So if I go to one tab in a records all other records also go to this tab. Unfortunatly there is also no hide option that allows to hide groups of objects. Is there any solution? I have filemaker 11 and 12. Altough a solution for filemaker 11 would be prefered. Thank you!
-
- 9 replies
- 2.6k views
-
-
Hi, I have a script that I'm studying. It involves a drop down field that triggers a script on OnObjectModify, then a condition as a result of the value change. This is currently working intermittently, with the drop down still appearing selected. If I deselect it, by clicking in blanc space somewhere on the layout, the condition completes as desired. It looks to me as if I'm forcing a final update on this extra click. I've tried script steps like Refresh Layout, toggling menus, scrolling but I can't find anything to mimic this step. Any thoughts? Giles
-
-
- 3 replies
- 1k views
-
-
Dear All, I have a "nested Value List" solution (value of a field set by ValueList A filters values in ValueList B ) that has worked through a number of versions of FMP upto and including FMP 11. It now fails in FMP12. It's based on using the Include only related values starting from but then leaving the field set to <unknown>. Which was a trick somebody passed onto me years ago. Basically it worked along the lines of : if the valuelist is the product of a relationship, filter by that relationship, reverting to include all values, obviously returns all values. ARe you aware of any changes to this area in FMP12? thanks in advance Giles
-
- 0 replies
- 872 views
-
-
I'm looking into upgrading our FMP11 developed solution to FMP12. For us, key functionality exists around the ValueList feature to DISPLAY one value (e.g. a description) while RETURNING another value (e.g. a UID), into the selected field. I would be interested if you have been able to replicate this feature from the ExecuteSQL() function (I can successfully return a single ValueList item ... having trouble with the above) many thanks in advance Giles
-
- 4 replies
- 2.6k views
-
-
I have a layout where the users can enter text in a text field that is set up without a scroll bar. I would like them to know when to click on a button or just click inside the field which expands the text box so they can see all the text. Next to the title of the field I would place a conditional merge field that would say "to see more click here" If the text fit inside the window they would not see the message to see more. My issue is I have set up a text field with 10 lines of text (due to layout constraints). Some users will type in a paragraph and then enter one or two paragraph returns and then continue typing. The next user who views the layout could end up seei…
-
- 1 reply
- 899 views
-
-
Is there a plug-in or a workaround to FM 11 not recognizing the Windows keyboard "enter" key on the numeric keypad for entering data into an edit box? The edit box holds a list of items which are defined by numbers. However each number needs to be separated by a return. Googling shows this has been a long time issue - I'm hopeful someone has a solution by now? Fingers Crossed!
-
- 1 reply
- 1.1k views
-
-
How can I get a sum of all the values from all rows in a given field of a portal? I have a line items portal on an Invoice layout. I need the total of each charge in the line items to be displayed outside the portal (in the rest of the invoice) and be able to use that in another calculation. In the attached file, it's the "Rental Cost" of the top portal that I want to add up and put into the "Rent" field in the Fee section on the right of the layout. Rental.fp7.zip
-
- 2 replies
- 2.9k views
-
-
Hi, I have a bucket load of hosted databases and am trying to do a new menu layout. I attach a cut-down version of the menu. The previous version had layouts with links hard written onto each layout. In the new version, I've used a portal so when the user clicks on a practice area, the portal displays only those databases for that section. See attached screenshot. I realise I could create a script to open each database, and then create a script along the lines of "if name = {databasename} then run {databasename} script" But am trying to do a more sophisticated way by sending the open event based on filename. It won't open any of the files. I am c…
-
- 0 replies
- 1.1k views
-
-
Hi, thanks for your ideas, time and thought regarding pointing to a certain record in a portal My main layout...MYlayout reference Accounts I have 3 portals, each refer Messages file/// If there only 1 portal... no problem.. done that b4.. I have a script button on MYLayout ..that calculated the Record# that I need to show on one portal When I Open MYLayout All the portals either or at top or at bottom of rec depending my sort http://www.mastar.com/temp/temp1.jpg
-
- 5 replies
- 1.2k views
-
-
Hi, I would like to know how to create Popup menu while moving cursor on any object(To which object i m going to give that onmourseover action) in the layout and from this popup menu i should select one item that should do some actions(Script triggering while select the item from that popup menu). I am using Filemaker pro advanced 12 with windows xp and Mac. Kindly Share your views. Thanks in advance.
-
- 0 replies
- 1.3k views
-
-
I am finding FM12 extremely frustrating as a development platform. While in layout mode some simple tasks are much, much slower than in FMP11, particularly on layouts with lots of objects. Even when working locally on a DB using a fast PC or Mac, when working on a layout with a large number of objects (e.g. Multiple tab objects, buttons, fields etc) simply moving a field by a couple of pixels, then going back to browse mode can take 5 seconds of beach ball time. Dragging objects can also take 2 or 3 seconds between clicking and dragging and the object actually moving to the pointers location. This is particularly annoying as you can easily drag objects uni…
-
- 4 replies
- 2.9k views
-
-
I'm building a contact list and want to have a field that shows ONLY selected values from a list but allows me to select more than one value. I imagine there's a simple solution but I'm just not getting it. I want something akin to the list of tags on a blog post shown at the bottom of each record. Eventually I want to be able to look up all the tags for a given value in another field. For example, look up all the tags associated with records from one organization (another defined list) If this helps, it's for fundraising. I want the tags to correspond to what various funders give to (education, arts, etc.) so I can search which foundations give operating …
-
-
- 3 replies
- 1.1k views
-
Recently Browsing 0
- No registered users viewing this page.