FileMaker Interface Features
-
Apparently 3 days ago all my web viewers stopped working. They won't even load so much as Google now. Regular browser windows work just fine but not web viewers in FileMaker. They get about 40% loaded and then stall. It is happening whether the file is hosted or not, and I've tried various files including creating a new one. I'm using FileMaker 15. Anybody ever see this behavior or have any ideas? EDITED TO ADD: I have verified that this is only happening with FileMaker 15. FileMaker 14 displays all web viewers just fine.
-
- 1 reply
- 1.4k views
-
-
Hi, I’m really Stuck , any suggestions would be most appreciated. Problem : I need to replicate a particular behavior of the PopOver that is inside a Portal. Behavior: When inserting or editing portal Rows via popOvers, the data updates in the portal before “committing”. Solution: Trying to replicate this behavior according to this rules: -. Using Transactions and Data modeling. .- Data not updated at the portal before committing (refreshing portal by trigger or exiting a field doesn't work). .- Data not updated at the portal as inserts or edits are been made (same as above). .- Inserts or Edits are…
-
- 1 reply
- 1.3k views
-
-
Hi everybody, I have the following situation: I have a product table. This table is related to a supplier table and each product can have many suppliers. Now I would like to crate an order based on a supplier. when chosing the dropdown list the products to be shown should only be the products related to this supplier. So I have an order table which relates to to the product table by means of line table (the order might have more than one product) In the the order form I have a portal with the line table. The line table has a pop-up menu with a value list showing the products form the products table. Now I would like to be able to include the value…
-
- 8 replies
- 1.3k views
-
-
I have a layout in list view, the number of entries after the first entry will vary, current layout. How would I go about only showing the first occurrence of an entry under Category, the entries under Item and Sub-Category would remain the the same, desired format. II Capital Hardware (blank) Peripherals (blank) Network (blank) Application Software etc. III Project Expenses Strategic Planning (blank) Consulting: Network (blank) Consulting: Process etc.
-
- 3 replies
- 1.4k views
-
-
I created a database to track permits by building. Each permit type is stored in its own table. The only link between tables is the Building Name which is the physical location where the permit exists. Tables: v_Buildings (fields include building name, ID, building status, address, city, state, zipcode) Air (ID, Building Name, Expiration Date, Days_to_Expiration, Type, etc...) Water Food Elevator ...9 permit types in all, and I will add more in the future Each of these tables has the same fields in common: BuildingName PermitExpirationDate PermitOwner Days_to_Expiration I created a Dashboard layout with the idea that users could select a…
-
- 7 replies
- 3k views
-
-
I'm planning to implement the google map with my contacts module (where single contact have more than one place, example we can say 5 different states) I'll get all those details with the different set of fields - Here what I need is - I just want to show the all 5 places for the particular contact google map. Is that possible with FileMaker ? (using google map API) If yes, then please share some sample idea and google map API with parameters. Many thanks
-
-
- 5 replies
- 15.7k views
-
-
Windows 10. Many layouts I created in FMP 12 do not appear properly in FMP 15 Preview mode. Object against the left margin are cut off at the margin-as if they extend a few points into the margin. However, the layouts print properly.
-
- 2 replies
- 5.2k views
-
-
FMP 2015 Adv. When ever I click on a field or other object in layout mode, the object jumps. I have to re-position the object to it's original location. This is a real pain. Any way to stop it?
-
- 3 replies
- 1.1k views
-
-
I know this is "out there", but I must be muffing the search criteria so my apologies for this being covered elsewhere. I have two related files (by StudentID number), Application and Student Database. I've set up a global field in Student Database where a user clicks on its Menu-style value list to show the names of students in Application; what I want to do is show the names of students (from Application) who don't have an existing record in Student Database. That way, it'll reduce the thousands of records/names our clerks have to plow through to find only the ones that don't have a record in Student Database; after the name is selected, a script trigger will fire …
-
-
- 2 replies
- 1.3k views
-
-
Ok here is my problem. I have created a summary report that pulls together weekly reports for projects under a specific office of work. SO each report generated could be specific to a set area. In the report layout i set it up with a title header for the cover sheet, a sub summary section which shows each sub- group, a sub summary section that has all the project specific text and report, and then the body which has pictures and captions for the project. The pictures and captions are repetitions 1-8 of the same fields. So it is supposed to look like this ------------- title page(area name) Title Header ------------- -Su…
-
- 2 replies
- 1.9k views
-
-
HELP! I am trying to get my FM layout to have a self aware object. The object is named appropriately and the object (For example, a portal) would then use the name to filter with some form of get(name) method. Can this be done? In theory i want singular row portals with the name "Portal 1" to be copy an pasted. When pasting FM will automatically name this "Portal 2" (3,4,5,6 and so on). The filter will then use a "RightValue(Get(Name))" to filter down on this number. CAN THIS BE DONE? I am racking my brains trying to figure a way of doing this and making this layout dynamic >_<
-
- 2 replies
- 2.4k views
-
-
This breaks in 14.0v6 OS 10.11.5 but works when I open it in 15. So this is just a 'heads up' for folks still in version 14 who might use button bars with Hide and popovers. I have a two-button button bar where one button will hide depending upon Type. I provide a 'X close' on the popover for User convenience but when the User switches records, the cursor remains on the button so it does NOT hide and displays both buttons. It only does this if I use a 'X close' popover. I believe my only option is, if I plan to hide a button on a button bar AND provide a 'X close popover' then I will need to script closing the popover so I can include another action such as…
-
-
- 3 replies
- 1.6k views
-
-
Is there an easy way to plot these tracks in Google Maps in a Webviewer rather than a chart? Incidentally, this is a FM13 Advanced file version so not all records get plotted in the chart (apparently there is a limit in older versions, just FYI). Chart_Plotting_Multiple_GPS_Points.fmp12
-
- 6 replies
- 3.5k views
-
-
This is getting frustrating: About ten percent of the time I open a file, all of the layouts are displaying in a font named [email protected] or, less commonly, [email protected]. If I close and reopen the file a number of times, the problem will sometimes self-correct and show the normal fonts (I only use Arial, Calibri, and Times New Roman), but sometimes I have to go through every layout and reset the fonts. This only happens to my FMP 15 files - no other programs have been affected. I have attached a screen shot for clarification. Any ideas? Thanks, Guy Weird font example.pdf
-
-
- 5 replies
- 7.1k views
-
-
I'm working on a timesheet solution where the user selects the "Role" that they're performing from a preset list of values, and then I want to populate a list of possible values for their "Task" based on their role. Role table includes a field called Billing Category (with 5 possible options). Task table also includes a field called Billing Category. My relationship for the value list is Role::Billing Category = Task::Billing Category. Two of my Role::Billing Category options will share the same values in Task. The remaining 3 have unique lists. I tried to use a checkbox for Task::Billing Category, to indicate that one task can have 2 billing cate…
-
- 0 replies
- 1.1k views
-
-
I believe some of the functionality of creating value lists in Filemaker is broken when you want to display values from a second field for a relational database when using Value list subsets created by a case statement. Let me explain. I have a relational database that contains a list of Stakeholders in a table. Some of these Stakeholders are considered to be suppliers (consultants, contractors, etc..). I have a field called “isSupplier” – and is set to either “Yes” or “No”. I can easily create a list of just supplier names using this case statement for a calculated field called “SupplierList” Case ( IsSupplier = "Yes" ; Name) However, when creating li…
-
- 2 replies
- 1.4k views
-
-
I have a major table that I'm trying to integrate into a drop down menu option - get values from field but I need some help with this... The table has 3 fields, Year, Make and Model (Aircraft), so the values look like 1990 Cessna 180, 1990 Cessna 190, 1997 cessna 150, etc etc I'm trying to create a drop down wherein the user first selects the year (menu items calculated from the year field) then once a year is selected, only those makes from that year are shown, then model, only those models from that make is shown. Any suggestions greatly appreciated, thanks!
-
- 2 replies
- 1.1k views
-
-
I am building a customer database. The database will have a primary key. I am looking to make the primary key either a unique integer or a UUID (with 32 chars). The UUID appeals to me due to its ability to sync tables. The primary key will be used for (obviously): Searching and sorting records As a tag against documents eg document XX is linked to customer AA, BB and CC; and A foreign key to link tables My questions are: Do UUIDs adversely affect database size Do UUIDs adversely affect speed If UUIDs retain their full 32 chars, then there will obviously be a disadvantage. However, is FM clever enough to convert the UUID "und…
-
-
- 4 replies
- 3.9k views
-
-
How can I create a merge field that contains the values in portal rows? For instance: Let's say I have 3 kids, and each kid has a list of food preferences, medical conditions, prescriptions. My kids are on a portal on the "minors" layout. Now, I want to put all of the kids data on a report for the parents. Kid1 -- (portal row1) Medical Condition: <<medical conditions>> (portal row1) Prescriptions: <<prescriptions>> (portal row1) Now, how to I list the next row in the portal? Kid2 -- (portal row2) Medical Condition: <<medical c…
-
- 2 replies
- 1.5k views
-
-
I'm using a field-based value list in conjunction with a filtered portal based on a relationship. The filtered portal seems to be working fine. However, "1" and "0" are showing in the value list though neither of those values are in any records. Issue #2 is that unless I include "IsEmpty (fieldname)" in the calculation field used in the relationship, all my portal fields have to contain data or the record doesn't show in the portal. In other filtered portals, I've never added "IsEmpty" to the calculation field and records have shown in the the portal regardless of empty values (see yellow highlight in screenshot). Thanks for any insights on these two issues.
-
- 3 replies
- 1.4k views
-
-
Environment: FM13 with FM13 Server, mix of Windows 7 and 10. Is there a way to set a script trigger on if this portal row is new? IE, a script to run if this new child/portal record is new. We have a parent record, and portal to Children records. The children records have 2 fields: Profile Name and Process type. Our user would like to enter a new child record (profile name and process type). if the process type already exists, we will need to archive the existing record (matching the profile type). There is more bI want to start with this first. I see script triggers to the layout "OnRecordCommit", but no similar script trigger for portals. Any ideas…
-
-
- 3 replies
- 4.8k views
-
-
Hello, This is likely a very easy remedy to this but it escapes me at this time. I have a value list configured as a radio button selection- has two choices - either "no issues" (default value) or "issues". What I'm looking to setup is a script that would open up a popover if the user selects the "issues" radio button. Any quick thoughts? Jack
-
- 2 replies
- 1.8k views
-
-
I need to build a table that totals the weight for a tunnel by the hour. 10 possible tunnels by 12 hours, columns any date. I can do it by filtered portals then loop through and total the weight, but that is 120 portals and scripting. Does anyone have a better suggestion? This data is drawn from an ODBC linked product database. I first do a find for the date then use the portals to filter by the tunnel and hour, then use a script to loop through and total the weights.
-
- 1 reply
- 1.1k views
-
-
When using the Field tool to create a field on a layout, what determines the font size and field height? For me, it’s Arial 12, with a field height of 22 pts. Is there any way to control the default font size and field height?
-
- 1 reply
- 4.6k views
-
-
I'm setting a webviewer with URLs from a separate field. It works fine for most URLs, however, YouTube URLs and Vimeo URLs aren't rendering, nothing shows in the webviewer. Videos play fine if part of a page like http://cnn.com. I have the webviewer in a popover. The attached screen: - fm screen: how the URLs are formatted in a URL field - fm screen2: what the web viewer does with a youtube url - fm screen3: what the web viewer does with a cnn.com page with a video playing - fm screen4: what the web viewer set up looks like. Thanks for any insights.
-
- 4 replies
- 3.5k views
-
-
Nearly everyone knows how to use a web viewer to display a map of an address; especially when the option is built right into the web viewer. (At least in FM10.) Recently, I found a trick to put custom HTML code into the web viewer's url, to dynamically handle your solution's content. (See here and here.) Basically, I'm using the web viewer to handle an embedded google map using the address fields of the specific record. (The embedded map shows just the map and not all of the other "clutter" that maps.google.com gives you.) I'm allowing the user to be able to interact with the web viewer so that they can move the map around and zoom out and such. However, wh…
-
- 15 replies
- 6.8k views
-
-
I can't figure out how to set the grid for my layouts. Major grid spacing and minor steps? Are there any good general rules to follow? Should the spacing be a function of the font size I want to use?
-
- 0 replies
- 1.9k views
-
-
I have a user (only one currently) that is getting portal artifacts. Lets say they have 5 portal records. When they click in one of the fields and change a value, then all the values in that column change. But when they click on the new record at the bottom it goes back to the correct values. I am thinking it is some strange artifact thing but don't know. Thoughts? Windows 7 64 bit Filmaker Pro 15 Thanks Thom
-
- 1 reply
- 1.2k views
-
-
I need your help as I am in a blocking stage and I am struggling to get a solution without success. Windows 7 - Filemaker Pro 11 Advanced I am working on a solution where you can select a Product name from a List of the same Layout and it displayed all details regarding that product. The problem with the solution is when I increase the number of products from 100 units to 5000 units it became extremely slow. I have attached the solution and I would be grateful if you could take some minutes of your time to solve the problem. Product List.fp7
-
-
- 2 replies
- 1.1k views
-
-
I have a Value List with names of our "partners" (each name on separate line). I have a database with a "name" field. I'm just trying to setup a script to run and check if the "name" matches a names on the "partners" value list. But, no matter what I try, it never comes back as "true." Any advise? Does this look correct below? Each time, the result is "0" not "1." FilterValues(ValueListItems(Get(FileName);"Partners");Data Recovery Log Excel export Converted::Name) Thank you for your help! Brian
-
- 4 replies
- 1.2k views
-
-
Hi all, I am trying to "insert from device" a picture into a container field that is inside a slider. There are 8 repetitions of that container used to store photos. I don't want to go through the filemaker go insert menu because i want to restrict the size of the pictures taken on a mobile device to medium. I need a script to get the active repetition number for the container field and then insert from device into that specific repetition. Part of the challenge seems to be the containers placed on a slide control. I have tried several scripts but cant get the repetition number to work correctly. Its been years since writing scripts in filemaker and i …
-
- 0 replies
- 1.7k views
-
-
I am trying to use FMPA13 on my 13 MacBookPro to read a text field and time it inserting the resulting time in a specific field I import the text files from a folder. Each text file has a dffret lenght, My screen is small and certain pages are too large to appear in the text field a I created Is there a way to force the import of a single text file splitting if necessary in a double or even triple column while keeping it with the same field name?
-
- 1 reply
- 1.3k views
-
-
I am new to using the Label layouts. I hoped it would make it easier, but at the moment I feel like I am missing out on certain functionality. I wanted to be able to print either 1 label.. or a series of labels in a found set..(List format) Or mainly, say I want 100 labels on one page of the same record. So far the only way to do this, seems to be to create a layout from scratch to force it. Does anyone know anything about the label printing capabilities in FMP pro advanced 10? know of a tutorial? I have read strange things in the online Filemaker knowledge base (granted they were for older versions), suggesting to duplicate records then delete them…
-
- 4 replies
- 1.6k views
-
-
I have a small table of records, i created.. The operator fills in a field for each record a number between 1-30 That a number represents A Available Unprinted Avery Label.. on a sheet of Avery 3x10 down the sheet mailing labels If operator fills in a field with a number between 1-30, ie 3 and press print... It print that Slot number 3 Avery label Thats easy having 30 layouts printing 1 layout or label at a time.. Then I Kringe thinking of 30 more layouts or any adjustments. What if my table has 6 records.. to print labels, any number of combination... Any ideas... using ver 8.5 Using FM9 conditional layouts, I usually try to be 8.5…
-
- 12 replies
- 3.1k views
-
-
Looking for a way to manage/restrict access to the "Modify Table View" option. Currently, AFAIK, if Table View is enabled for a given layout, any user who has access to that layout can modify the table view. To me, this seems like sort of a bug. I.E., if I have a privilege set that that restricts layout modification, but Table View is enabled, a user can still modify that layout while in Table View. Is that correct? I don't often give users access to Table View, but in this case I have report-style layouts that are set up in Table View for admins so that they can manipulate "columns" on the fly in order to generate custom reports on their own (a la Excel). I…
-
- 1 reply
- 1.7k views
-
-
Can the web viewer be used to display raw html like attached? I put this text into a field and have the web viewer reference that field, however it does not display anything. If I add text like http://www.cnn.com it works just fine. html_sample.rtf
-
- 8 replies
- 2.8k views
-
-
I am having trouble showing all related records in a portal. I have my relationship like this. Issues -> Join <- Products (All products occurrence) _fkIssuesID _fkProductID Product1 Product2 Product3 And so on... I have another Product table occurrence that is filtered by a relationship to some other parameters. A portal of this table would show: Product1 Product2 Product5 Product10 I would like to be able to open products 1,2,5,10 and show a list of all related Issues within that set. The problem im encountering is that the list will not show up i…
-
- 1 reply
- 1.6k views
-
-
I would like to replicate this Excel cash flow statement in Filemaker. Looking for some ideas on how to go about this. I may be making this more complicated than it needs to be. Should I place multiple portals in a list view form or is this all doable with a sub-summary report? The line items would not necessarily be the same for every account, in some cases there would be less or more items. Ideally I would like to collapse the various sections.
-
- 2 replies
- 1.4k views
-
-
Hello, I have a centered text field (actually a merge field <<name>>) and would like to add an image right after the name but only for certain situations. The objective is to show an icon after a name if that person is new. I can add an image to the layout and do a "Hide Object When", but that makes the image location static. I tried creating a container field and then merging the two, but it doesn't show the image in the container field (ie. <<name>><<main::image>>). Another option is to make the merge field left aligned and then add the image directly to the left, but I kind of like having the text field centered on the layout. I…
-
- 2 replies
- 1.2k views
-
-
I have a layout that crashes every time we try to open it, but only the first time of the day. If we open it once and allow it to crash, then open Filemaker again, usually on either the second or third try, the layout opens fine, and works well the rest of the day, unless we shut down FM and restart. This seems VERY odd to me - any ideas? Don't really have any idea where to begin to troubleshoot this one. I do get error messages on windows event viewer - but I cannot decipher the language. Image is attached of these error codes. Any help would be GREATLY appreciated! Darren
-
- 1 reply
- 1.1k views
-
-
I'm using a web viewer to show HTML code showing text from the database held in a field or a variable. The text shows successfully but the text itself appears wider than the web viewer so I have to scroll from left to right within the web viewer in order to see all the text. Is there a way to set the pixel width of the text so that I don't have to scroll within the web viewer? Many thanks.
-
- 5 replies
- 2.1k views
-
-
I have two tables, the first table is the master and the second table is the details. Each record of the Details is related to an ID in the first table. What I want to do is display in a model all the records from the details table. My problem is that instead of display a list of all details records He displays one by page. I have two loops. I've tried a lot of combinations and nothing work. Thanks for your help. Johanne
-
- 1 reply
- 1.2k views
-
-
I have a table named transactions with a field named ipn_status. The status can be either "Verified" or "Invalid". I'd like to make separate table occurrences that will display only Verified or Invalid records. In the past I would do this by creating a global field in the table called something like relVerified, and I would just put the value "Verified" inside this field. Then I could create a new table occurrence of the same transactions table, and I could setup the relationship like transactions::ipn_status = transactions::relVerified. This would get me what I want. Not long ago, though, somebody pointed out to me that this is no longer necessary, and ther…
-
-
- 8 replies
- 7.2k views
-
-
I am trying to create an option for dialogue to show up for users based on input they have provided. Rather than using up space for a merge paragraph on the page of the layout, it would be nice if they could click the help button and show the custom information related to each question based on their own input. When I try to set the button up to have merged fields in the dialogue, I do not see that option. I am using FM12 advanced. Thank you!
-
-
- 6 replies
- 1.7k views
-
-
I've created a FM developer project that outputs an XML file that gets used by a Flash Project. The flash project is published as 'ataf.swf' file which is embedded in a local html web page named 'ataf.html' ataf.swf and ataf.html are in the same directory as the Filemaker project. Everything works fine, however I want this local web page to appear on a layout in the Filemaker project itself (using a web viewer portal), so the user can test if the xml export was a success directly from Filemaker (without opening up a browser). Within web viewer I've tried the URL 'file:///ataf.htm', but it just shows 'file doesn't exist'. I think it's looking in a different…
-
- 3 replies
- 7.4k views
-
-
FM 12. I’m using a value list to insert an id from the first field and to display a related name from the second field. I want to use a drop down list to display the name only. I thought I read somewhere you can place the name field over the id field to do this but I can’t get it to work. Any suggestions? By the way, is there any simple way to refer to a value list that uses two fields?
-
- 7 replies
- 1.4k views
-
-
Last night, I was adding some data, from SQL Server, which is broken down by line-items. It can get pretty long, into 300-400 byte range. Longer at times. A Notes List mostly. I went to add a Horizontal Scroll Bar to the Text Field &...nada. Am I missing something or do we honestly not have an option for Horizontal Scrolling for Text Fields in FM 14? Otherwise, still loving FM 14.
-
- 6 replies
- 2.2k views
-
-
I have a layout that is being designed for use on an iPad, and have a value list for a record type. For a desktop implementation, I would use radio boxes to choose the value. However, they are too small for what I need for the iPad. I would like to create a button that acts like a radio box, most likely based on scripting, however my attempts at doing so with SetField have not worked. Is what I am attempting to do possible, and if so, any pointers on correct programming for these buttons?
-
-
- 13 replies
- 1.9k views
-
-
Hi Does anyone know a function which will convert all fields on a layout belonging to a different table to the same-named fields in the native table? For instance, a set of 6 Address fields. The first image below shows fields copied from a layout of Table X and pasted into a layout of Table Y. At the moment, when I want to change those fields to Table Y's fields, I have to click on each one, select the correct table, then choose the field. I'm wondering if there is a quicker way? A function which instructs Filemaker to look for any non-native fields on a layout, then to look in the current table for identically-named fields and, if it finds them, chang…
-
- 1 reply
- 1.2k views
-
-
I'm using a summary field to count values in portal records. I've placed the field on the layout, but it does not refresh until I click on the layout. I've tried using a script trigger, but again it does not update until I click on the layout. How can I get it to automatically update?
-
- 2 replies
- 1k views
-
-
A client of mine is a courier. they want an estimate of the travel time between a client location and a courier (using a mobile phone that regularly uploads gps co-ords to a filemaker table). Courier may be on a bicycle or in a car. The desire is to prioritize dispatching to people who are in a time-based vicinity of the client. So, you can assume there's a "Trip" table, with client_gps field, and courier table with "current_location_gps" field. and a time_between calculation. Any thoughts?
-
- 3 replies
- 1.5k views
-
-
Hello, Can anyone point me in the direction to learn how to post images of my inventory items in Flickr and have them appear on my layouts and Filemaker 13? I'm not sure if I use a container field or web viewer.When I use the web viewer I can see a Flickr page but I get an error because I don't have credentials in my database to see the photos. So I need to somehow deal with login to Flickr.I would be approaching this from both linking existing photos to eventually snapping a new photo on FMGo and adding it to record.Really hoping for step-by-step instructions to do this- I am stumped! Thanks!
-
- 0 replies
- 1.4k views
-
-
Looking for some direction on how to go about setting up this requirement. I have a set of accounts, each account has an activities plan with 12 or so line items, activities, with dates associated with each activity. Account line items for account Tech Coast.com I would like to be able to consolidate multiple account lines activities into a single 52 week calendar grid (or longer). Calendar Grid If the account line item date falls within a given week date range, the line item "No", a 1, 2, 3 etc., would be placed in appropriate weeks field, with a gray background, to show that it is scheduled. If the line item has been marked as "done" t…
-
-
- 15 replies
- 3k views
-
-
Hi Guys I am new to filemaker and I am hoping someone out there can help me. I work for a small printing company and I am trying to create a stock ordering system. I have a created a database with the following tables Supplier, Stock, Orders ann line items. What I am trying to achieve is to link specific stock items to the specific supplier and then to create an order for a selected supplier to order only sock that is required from the supplier. I have attached the database I am currently working with. ( No management username ) My problem at the moment is linking the stock to the supplier. Hope this all mak…
-
- 0 replies
- 1.1k views
-
-
Hi, I am working with a customer where their "Tab" panel is missing ?? I've attached both screen shots. Any ideas what might cause this ?? Thank you. :-)
-
- 7 replies
- 4.4k views
-
-
How can certain objects in the Body section be grouped together so that they all print on the same page? My document has three "sections" in the body part. Each section has text, portals, and fields. If there is a page break, I would like it to occur so that each section stays on the same page. Thanks
-
- 0 replies
- 890 views
-
-
Just upgraded to Filemaker 14 from 11. Windows users insist that they used to be able to copy text from a website or email and paste it into a field and the field would impose it's attributes on the text. So for example a blue coloured and underline email address would become black text with now underlining. They say this 'feature' has disappeared in FM 14 and now the text retains the formatting from the source. My experience is that it always retained the formatting of the source but many co-workers insist that they used to be able to paste in Windows and the text would take on the fields font attributes. Which view is correct? If it is possible to lose the copied attrib…
-
- 2 replies
- 1k views
-
-
I recently created a CRM that utilizes a single layout for all functions and features. You can view a 5 minute demo video of it here: There is a second shorter video that demonstrates some extreme automation made possible with the CRM. You can view it here: Let me know what you think! Cheers, Gary
-
- 2 replies
- 1.9k views
-
-
Hi Guys anybody know how to sort a numeric value list that is propagated via field values? By default its lists as 1,11,12,13 etc. I would like it list as 1,2,3, etc. Many thanks for any advise
-
-
- 2 replies
- 1.2k views
-
-
Here's what I have so far: 1. Value list of all monsters names 2. Table (monster table) with a record for each monster. Each record contains a variety of fields (monster name (drop down of value list), armor, hp's, attacks, speed, etc., etc.,) 3. Table (encounter table) with a record for each encounter I want to run. In the encounter table I want to be able to do the following: Be able to add multiple monsters. Click/Highlight a monster name and have all their stats from the monster table appear to the right I'm not really sure how to do this... Here's an image of what I'd like to do, in case that makes it more clear. http://imgu…
-
- 7 replies
- 1.8k views
-
-
Is it possible to randomly insert a row in a portal at any point, including between two populated rows? For example, I am working on a recipe database and have created a one to many relationship between the ingredients used in a recipe and ingredients (inventory ultimately). Let's say I have all of my ingredients entered and I discover I forgot to enter something and I want to enter the new ingredient between two other populated rows. I would like to create a button to insert a new row above the row the cursur is current located. Is this possible? Also, can I physically drag and drop a row to a different order in the portal? Thank you, YogiND
-
- 3 replies
- 1.6k views
-
-
I am showing a layout in Preview prior to printing. However once one this layout (in Preview mode) I can not figure out a way for the user to actually print it. 1. I have set the Available Menu Commands to Editing, as I do not want the users to accidentally delete all records. However this greys out the Print and Save as PDF options. This also seems to remove the ability to select File > Print. 2. Additionally because I am in Preview mode I can not add any buttons to the layout without having them appear on the print out. I am want to avoid the work of creating custom menus as there are a lot of files. Printing from Preview mode would seem to be a relat…
-
- 6 replies
- 4.1k views
-
-
Hi! Sorry a bit new to this still, but I have one table which contains several variables: DateOfConsult and ConsultType (InPatient or OutPatient). I have a layout for data entry in Form View and second layout in a List View. In the List View, I wanted to create a dropdown menu showing the DateOfConsult and the list will show all the people who consulted for that day. For the value list I have two objectives: 1. To show only the dates with OutPatient Consults. 2. To sort value list with the dates in descending order. Hope someone can help! Thank you!
-
- 4 replies
- 1.3k views
-
-
I use a filtered portal to display a subset of content from a table. Everything works fine and when I click on a portal entry, I have no problem fetching the corresponding table entry ID and then displaying related content from the specific entry. All that is good. The problem is that I have a script that needs to get the ID for the first entry in the current results. I've tried different ways, but none will return that first ID ... even though I "go to object" ... first the portal name and then the field name. Usually the ID that's returned is the first for the table, as if the portal filter is being ignored. I certainly don't want to build in a duplicate F…
-
- 3 replies
- 1.3k views
-
-
Hello, I want to create a script trigger which opens a layout based on account name ,create new record and put cursor in first field of the new record Now, I was able to direct user to specific layout and also created new record using New Record/Request function but somehow it doesn't put cursor in the first field , instead it selects whole record . Note: I also have script triggers attached to first and second field which runs on exiting the fields. (I don't think they affect anyways , but just mentioned to give idea)
-
- 10 replies
- 5.2k views
-
-
Can the conditional formatting be used to highlight a field when you want to show if a field is plus or minus 5%?
-
- 4 replies
- 3.7k views
-
-
I'm building a database for my coffee roasting. I want to have a layout for storing all the receipts from the green beans I purchase from my vendors. How would I go about creating a layout that lets me keep adding files without creating multiple containers manually?
-
- 4 replies
- 1.5k views
-
-
Anyone had experience using the FM client under Windows 2012R2? I have tried 14 and now 15 (both advanced) under 2012R2 and shortly after launch, the interface always begins to bog down very badly (within 5-10 minutes typically). Popovers open painfully slow (5-8 seconds), button clicks take forever to register, flipping records is chore and even just tying in a field to laborius. Basically anything involving the interface being updated is almost unusable. Searches though are as quick as usual after the pain of getting through the interface is over. Is this a known issue (haven't found any evidence of this) or has anyone else seen this behavior? Thanks …
-
- 4 replies
- 1.1k views
-
-
I elaborated a bit on this technique, more specifically the showing/hiding of things in portal rows based on conditionals. I wanted to show or hide a "delete portal row" button in a QUE_ANS portal on a QUE layout using this conditional statement PatternCount ( QUE::Emps ; QUE_ANS::_Emp_IDfk ) > 0 QUE::Emps is a multi-line field holding Employee IDs. QUE_ANS is a portal on the QUE layout, based on QUE::__Question_IDpk = ANS::_Question_IDfk. QUE_ANS::_Emp_IDfk is a single-line field holding an Employee ID. My challenge is to SHOW the "delete portal row" button on a row in the QUE_ANS portal in case the QUE::Emps does NOT contain the QUE_ANS::_Emp_IDf…
-
- 2 replies
- 2.5k views
-
-
Greetings all, anyone knows the reason why a text appears correct on my Mac and incorrect on Windows? In the picture the text in the print button appears correct on Mac and incorrect in Windows, the same happens in other texts not only in buttons. Thanks in advance
-
- 3 replies
- 1.1k views
-
-
Hi, I am trying to print a layout which has a webviewer on it. However, when printing/previewing the layout, the complete content of the webviewer is not displayed on the print out - I just send part of the content and then the web viewer scroll bar - which is no good. Other than creating an HTML file for the user to print - I am a bit stuck. Any help would be much appreciated. Thanks, Jim.
-
- 3 replies
- 8.8k views
-
-
Hi all After moving to FMP advanced 13 I still don't know how to automatically add a new field in the current layout I work on. Before it was simple but now I always need to drag the icon into the layout in Layout mode. Is there a way to tell the app to ALWAYS add new fileds to the current layout Thanks a lot
-
- 2 replies
- 1.4k views
-
-
Hi All, I am trying to filter a portal using case to display records matching only one condition (the first it match going down), but it looks like the filter is taking into consideration all the options and displaying related records that match any of the conditions. EG: Case ( newA = oldA ; 1 ; newB = oldB ; 1 ; newC = oldC ; 1 ; newD = oldD ; 1 ; 0) I thought the filter would work by only showing me the records that matched the first matched condition, but instead it's showing records that match any of the conditions. EG: if I had a record that had 5 related records, 1 where newA = oldA and 2 where newC=oldC, the portal wo…
-
-
- 8 replies
- 2.3k views
-
-
Hello everyone, My company uses File Maker to keep a record of customers' addresses. When looking at a given customer, I would like to be able to copy the whole address block (as displayed on screen) to be able to paste it somewhere else (for instance, in an email, or on a Word document). You can't do this from the layout for data entry, but we have another layout showing the address block as a succession of merge fields (see screen shot). I added a copy button, all it does is copy what's on screen to the clipboard. The problem is that, even though the layout is separated by carriage returns like this: <<contact>> <<name>> &…
-
-
- 2 replies
- 2.8k views
-
-
Hello everyone, Really excited with everything I have learned recently about FM. But I think I hit a brick wall. I'm building a database for a private book library, and I got to the Author field, which turned out to be slightly more complex than I expected. Most books only have one Author, but there are quite a few with two or more Authors. And some of those are collaborators, not necessarily Authors, but I still want to mention them and their roles. Really complicated (or at least I think it is). So, I understand that the best way is to have a single Table for Authors, where I will enter everyone, either they are main Authors, Co-Authors, Illustrators, etc…
-
- 2 replies
- 1.2k views
-
-
Hi, I'm having some difficulties with my invoice-system. When having multiple pages on print, I want to have my Trailing Grand Summary on a fixed spot. (not trailing) Is there a possibility to have this result? If I would place my fields in the footer, they will show on every page, what is not the intention. Have you fixed this one before OR do you have a solution at hand? Thanks in advance!
-
- 1 reply
- 1.7k views
-
-
Good evening everybody, I am creating an invoice system with 2 tables: the 1st one contains the product lines that are sold and the 2nd one includes the invoices. Both tables are related. Anyway, I created a layout to print the invoices that has a header for each invoice, a portal where are shown only associated products with each one and footer with the final amount (with VAT included and not). The problem is that some of those invoices have more than 30 sold products and I don´t get to do a layout that allows printing it in multiple sheets keeping the header and footer. I am now doing a new layout, but listing products sold. The problem is that all products a…
-
- 10 replies
- 1.8k views
-
-
I want to be able to create a popover that when pressing a specific key it exits to a certain script. This is in a layout where a part is looked up. A variable has been create with the following Set variable [$Gnumber;Value:""] which then displays in a popover which I want the user to enter the number and then press a certain key (like F8 or F9) which then runs a script that assigns that variable to perform a find in the database. My issue is how do I test for certain keystrokes in an easy way, what codes are assigned to function keys or even the enter key? Thanks Paul
-
- 3 replies
- 1.5k views
-
-
Hi I would like to be know if its possible to populate a portal with a recording of field change data" i.e.: my field contains data : 12345 if that fields data changes to 6789 I would like the 12345 to be recorded in the portal, ideally with a timestamp? Also it may be changed more than once, and all changes should be recorded. Thank you for any advice offered.
-
- 5 replies
- 1.3k views
-
-
I'm using FM Advanced 14.0.1 and this strange button appears at the bottom of my pop-us and then disappears. It's inconsistent and only occurs on some of my pop-ups, but not all. Has anyone seen anything like this?
-
- 4 replies
- 2.1k views
-
-
Hi, I have a database of music tracks. Each record has a container field which points to an mp3. I just upgraded from Filemaker Pro 12 to FMP15, and now when I play audio in Filemaker, I can no longer see the progress bar. The only options that I get are Play/Pause and go-back-30-secs. I need to see the progress bar for my mp3s so that I can jump to the middle of an mp3 quickly. Has anyone found any workarounds or plugins that will show progress bars for container fields with audio ? (Mp3 quicktime?) Thank you so much in advance!!
-
- 2 replies
- 1.5k views
-
-
I am working with an existing database file and I am getting reacquainted with filemaker pro after being out of it for the 10 years. I cannot remember and have tried to figure out what the following field? indicates. I know it is from the projects file and it appears like this in a separate file. When I right click on it the specify field is not in the menu. Is this a button, an object. I can't move forward until I know how to use this. Any help will be greatly appreciated. <<Projects::Project Number>>
-
- 4 replies
- 1.9k views
-
-
I am new so please be patient. I am trying to figure out how populate a filed based on a conditional value. I may not be stating this correctly so I will explain. I have created two databases one called "committees" and one called "committee membership". The committee table has the unique id filed "committeeid", "body", and "committee" fields. the committee membership table has the same plus fields for "memberid" and "position". I have created a conditional value list whereby I can choose the body and it will allow a drop down for the committee based on the body. Is it possible to then populated the "committeeid" based on this information? the idea is if I hav…
-
- 2 replies
- 1.3k views
-
-
I have a database hosted by FM Server that catalogs a list of my department's projects and publications (with supplemental materials, like PDFs, etc.). The database is web-published via WebDirect and is linked to from our main website so that users can filter, sort, and search our listings. I would like to be able to pull into our database the number of times a publication has been cited from Google Scholar. Right now, I have a web viewer on the database record for each publication that shows the Google Scholar page for that pub where the information will come from and I have a calculation field that gets the content of the webviewer with this formula where "GoogleSc…
-
- 2 replies
- 2k views
-
-
Hi, I am trying to hide a field in a portal using a calculation on the "hide" behaviour. Based on this article from some versions back - https://www.teamdf.com/blogs/a-very-nice-way-to-format-a-sorted-portal-using-conditional-formatting/. However, I am trying to use Global Variables to achieve this. In short, my portal has a "category" field whose value is repeated. And I want to "GroupBy" it, and only show the first occurrence of the category and hide the subsequent ones. <category> <name> <description> Cat1 ... ... Cat1 ... ... << Hide Cat1 Cat2 ... ... Cat2 ... ... << Hide Cat 2 I tried to hid…
-
- 2 replies
- 1.9k views
-
-
I have a projects database and a meetings database. these are separate files. In the meetings database I want to have one project (from the projects file) and all the meeting associated with that project. At the present time I have a layout (Meetings) with the project number and name. What I want is to be able to create Meeting #1....Meeting #2....Meeting #3. Then each meeting will have numerous topics, minutes, previous business, new business... At this time I have the database set up so that each new meeting has to have a new record which includes the project number as well so that means I have numerous records for the same project. I have a portal that …
-
- 3 replies
- 1k views
-
-
I have a value list that includes the "Personnel::UID" of all managers in my personnel table. (Determined through a self-related table where "Personnel::Manager" = "PersonnelSelf_Managers::UID". I included a screenshot of the relationship.) I want to compare a single value ("Personnel::UID") against the contents of that value list to take action (show or hide some data on the layout) based on whether the person in question is a manager or not. Can this be accomplished with a calculation using ValueListItems? I am having a hard time figuring it out. Is there a simpler way to do it? I am trying to minimize the creation of lots of random fields that could be h…
-
-
- 7 replies
- 2.2k views
-
-
I would like to show my company's twitter feed on the main menu screen of our Filemaker solution. How can this be achieved? Is there a more elegant way than using a web portal to the page on twitter.com ? Thanks! Paul
-
- 0 replies
- 1.8k views
-
-
I have a child table of SKUs which is being shown by a portal on my products table. How can I automate increment after first row? Workflow: I create a new sku: 4444-4444 I create a new row: 4444-4445 is automatically entered. Using auto enter calculation of: GetNthRecord ( SKU; Count( __SKUID ) ) + 1 Last ( SKU ) + 1 Nothing happens though.
-
- 4 replies
- 1.2k views
-
-
I had once seen someone, someplace, attempt to explain what I am asking, but it didn't register with me at the time, and I have not found it since. I have data I want to view in a portal such that records 1 through 3 are across the first portal row, then records 4 through 6 are in the second row, etc. I realize I could probably do something with the related records that would get their sequential number, divide by three and then set it up so the first row would display data from two tables away, but FileMaker says to avoid this. In this case, I think I would have to set up the portal to display records from the child table, then place values from three different gran…
-
-
- 3 replies
- 1.3k views
-
-
Hi there, I hope I'm posting in the correct forum for this; please excuse me if I am not. We have FileMaker Pro 13 running on 6 client computers - 4 at our office, and 2 in our home. All machines are running Windows 10, except for one at the home which is on Windows 7. All are using Chrome as the default browser. We are a housecleaning business, so our original programmer (many years ago) implemented a Google Maps button in order for us to view a client's location on a map quickly from FileMaker. It has worked fine for a long time, and then a few weeks ago we noticed that when we view a map, the left-hand "info panel" is just blank white and app…
-
- 1 reply
- 2.9k views
-
-
Hello FM Mavens, I have an encounter database with a main table that is related to a "clients" table which is related to an "encounters" table. The main table has a portal that displays the clients sorted by the date by which they were last seen. It displays their name, etc, from the "clients table", but in the same portal row I would also like to display the "type of encounter" from the last encounter they had, which is a text field in the "encounters" table. How can I accomplish this? Thanks!
-
- 4 replies
- 1.3k views
-
-
I'm new to Filemaker so excuse my naiveness (although I have programmed in other languages). I have 2 tables that are related in Filemaker and essentially on the form I only want fields from the second table to show on screen or be unhighlighted if the record in the first table is found. For example, perform search for item_no in 1st database and if found display item_no and vendor, once that is found open a new record in the second table for user to add info for the item found. Also if the item is no located in the first table, give user an opportunity to add a new one and then go on to open a blank record in second related table. Any easy way for me to impleme…
-
- 6 replies
- 5.9k views
-
-
Hi Guys, This may not be possible, so I may be barking up the wrong tree. I have layout for a table where I'm making a bunch of master categories. I have created Portal inside this layout, with the current table of master categories. I've then the created a second table occurrence and relating the table to itself via the ID field. The idea is that in the Portal is should list all the categories Field in the current table, but it only lists whichever one is currently open in the record, in other word its not worked. Is it possible to get a 'list' of the Field within the portal if you're working on the currently table? If so, what am I doing wrong?…
-
- 2 replies
- 1.1k views
-
-
I just wanted to ask, Is there a way to have a scroll bar in my checkbox set filed. I have a value list that takes data from a table. So I do not know how many are going to be all the items in my checkbox list. I would like to have the ability to add a scrollbar. I cannot see this in field properties.
-
-
- 24 replies
- 9.3k views
-
-
I have possibly attempted every logical (and many illogical !) combination of portals -> calculation fields -> cartesian relationship links (x) that Google and my own sanity can come up with over the last week with very limited success. Reaching the point that I am well & truly stumped... so much so that I struggled for about 10mins to even come up with a title for this post! They say a picture paints a thousand words so I've attached a couple of screen shots which will hopefully more clearly show what I'm trying to achieve (assuming portals are the right way to even achieve this) Calendar_ByMonth Each displayed 'week' in this layout is a row in …
-
- 2 replies
- 1.3k views
-
-
A lot of my fields are filled with content pasted from websites. In FM11, I never had this problem, but FM12 paste's the font, color, and blue text links. Is there anyway to change it so it pastes just plain text? Thanks!
-
-
- 35 replies
- 36k views
-
-
I have been able to use the Import script step to import pictures from a folder. However, doing the same for bunch of pdf and word document files have not been a success. Is there any special trick to achieve this?
-
- 3 replies
- 1.4k views
-
-
Hi, Not sure if this is the right forum ... I have a client who needs to edit a form letter every now and then. Though I've placed this form letter on the layout itself with merge fields which work great when we print this layout ... however, the form letter is not editable. I've watched Michael Rocharde blog on "YouTube" how he creates this letter by typing into a field and then he inserts these merge fields by clicking on a button . So what I did was copy my layout letter with the merge fields and pasted it into my test fields. When I went into Preview mode the merge fields did not update to the data It just showed the merge fields <<Contact::e…
-
- 3 replies
- 1.3k views
-
-
Hi All, This is more of a theory question than a "help me with my problem" question. We have a number of small databases that we use to generate forms of various types. In most cases these forms are controlled documents. So, for instance, we have an official "Product Approval" form in Filemaker. In that form, a user can fill out the customer name, part number, date, etc... to request the customer's approval of a product. It has certain wording on it in sentences and paragraphs. The form is also given a designation: Form105. We also keep revisions of those forms. So, in my example the form is Form105 Rev A. Now, I want to make a revision to the fo…
-
- 5 replies
- 2.6k views
-
.jpg.7d8c3851fd4ba2f9b9cba3454d96c65e.thumb.jpg.1e80b322ddd26a5225edb12164b14aaa.jpg)
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online