Jump to content

Search the Community

Showing results for tags 'help'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • FileMaker Friday Night Chat's Topics


There are no results to display.

There are no results to display.


  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins
  • Tutorials

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 20 results

  1. I have a parent table with 3 child tables. In the child table, there can be many related fields. I need to export only one row of data for each record in the parent table. This would require that a new column be created for each of the many values related in the parent to the child. For Instance: Noah Justin has 3 Email Address NJ@Test.com, NJ2@Test.com, and NJ3@Test.com When I do an Excel Export from FM I get Column 1 . Column 2 Noah Justin NJ@Test.com NJ2@Test.com NJ3@Test.com I need: Column 1 . Column 2 . Column 3 . Column 4 Noah Justin NJ@Test.com NJ2@Test.com NJ3@Test.com I'm sure it's pretty common and there is an easy solution to this. TIA
  2. I just made a database from the Contact Management starter solution, uploaded some contacts, added a couple of table occurrences for conditional value lists, and everything works....but then I created a user account, and tried logging in and it won't let me! as soon as it validates the username/password, this error comes up: and then it boots me back to login. I cannot open as a guest, or as a user with data-entry-only privileges. I haven't messed with any of the privilege sets! It's the template security settings! how do I troubleshoot this? there must be some script that's running on login that is beyond the user privilege set right?? agh and I'm supposed to be testing this with users this afternoon, and nobody can log in
  3. Hi, I've been lurking around the forums for a while now looking at various topics regarding database schema for Survey applications. However, despite the insight and templates posted on this forum I still cannot get my head round how to create a relational database for my application. Here's the scenario: I need to create a health and safety inspection application which will enable the user to carry out a survey of how well a specific location fares against a bunch of pre-set questions/criteria. So pretty much a checklist where each question is either a pass or fail response. Currently the survey is paper based (I have attached an example to this post) As I understand it from other forum posts, the basic schema of a survey should be Subjects (in my case Locations) --> Responses <-- Questions <--Surveys But I need to have different Sections for Questions as well and i'm having trouble incorporating another table into my schema. Please find the attached zip file with the schema I have so far and PDF of the current paper version of what I am trying to accomplish. Could anyone tell me if i'm going in the right direction with this? (is the schema okay?) I have hit a brick wall and been stuck at this point for a while now! Thanks H&S report Paper.pdf HS FORM.zip
  4. Hi all, Hopefully I 've posted this in the right place I'm new to filemaker and have been developing a maintenance inventory database. I have a 'stock transactions' portal where I can add and remove stock. I am having trouble figuring out how to put a condition on the amount in stock where there can't be a negative amount. So if there is a quantity of 2 items in stock, only 2 can be removed. (if someone trys to take 3 out of stock at the moment, the stock amount would go to -1 for example). Thanks in advance for any help/advice on this issue, I'm still learning so any feedback is greatly appreciated. Thanks Neil
  5. Trying to add a new feature to FileMaker Pro in which you can have a "to do" list set up, to allow easy access to who needs to be called etc. Will appreciate any help not much experience with FileMaker. Thanks
  6. I have a database that we use to update our website inventory. A few years ago we began offering customized merchandise that gets dropshipped direct from suppliers. Suppliers give us data feed files with their inventory levels, pricing, etc. and this file manipulates the data. It takes our current web database, compares values and exports those products with their updated values. Importing the data and exporting used to take less than hour but now it takes several since the size of the web database has grown and the number of suppliers has grown. Everything is automated through scripts. In the main table (web database), the proposed quantities, pricing, leadtime, variations, etc. all use unstored calculated fields to determine the new value. I then have a separate field which is used to flag items that need updating. The major bottleneck of the entire process is the searching of this field. It can take sometimes over an hour to search this field. Other steps like exporting the changes can take a while, too. I have done some things to optimize the database but it still seems that these unstored calc fields are what is dragging everything down. I have tried replacing some of those calc fields with text/num fields with "replace field contents" script steps (or auto entry) but it does not seem to make a difference because of the indexing. The database is not hosted or shared and my computer has decent specs with an SSD HD. I've got a simplified design chart attached for reference. I am not sure that this is what comes with a large complex database file or if my design is flawed. The only two things I can think to try to reduce the processing time is: 1) Rewrite the scripts to update the supplier/inventory table records instead of replacing the records fresh each time. 2) Use a looped set field script to set the "change flag" field and/or the other updated price/qty/etc fields Any thoughts or advice is much appreciated.
  7. Hi Folks - I'm pretty new to FM Pro so please excuse my ignorance! I have a database for my students marks - from the marks I am using a nested if to generate a comment depending on the mark gained by the student - it works fine except for the students scoring <35% which it lists as "Although a narrow fail, this would suggest that major revision, past paper work and making use of Supported Study is a must if a Grade C pass is to be achieved." I can't figure out why it won't work - any help gratefully received Happy New Year to All Edddiec the formula I used is listed below If( GetAsNumber(Prelim 2012 overall %) >= 80;"This would suggest a Grade A pass. Past paper work and Supported Study would help to secure this grade." ; If( GetAsNumber(Prelim 2012 overall %) >= 70;"This would suggest a Grade B /A pass. Past paper work and Supported Study would help achieve a Grade A pass." ; If(GetAsNumber(Prelim 2012 overall %) >= 65;"This would suggest a Grade B pass. Past paper work and Supported Study would help secure a Grade B or possibly achieve a Grade A pass." ; If(GetAsNumber(Prelim 2012 overall %) >= 60;"This would suggest a Grade C/ B pass. Past paper work and Supported Study would help secure a Grade B or possibly achieve a Grade A pass." ; If( GetAsNumber(Prelim 2012 overall %)>= 50;"This would suggest a Grade C pass. Past paper work and Supported Study would help secure at least a Grade C." ; If(GetAsNumber(Prelim 2012 overall %) ≤ 45 ;"Although a narrow fail, this would suggest that major revision, past paper work and making use of Supported Study is a must if a Grade C pass is to be achieved."; If (GetAsNumber(Prelim 2012 overall %) ≤ 35;"This would suggest that Intermediate 1 is too much of a challenge and would suggest that Access 3 would be a more appropriate level for presentation." ;"")))))))
  8. I created a database with a few layouts and one table off of a youtube tutorial and when I tried to customize it a little bit more, I inadvertantly screwed up the relationship between one of my layouts and the table that should go with it. My goal is to have a database for the horses I am training with a tab for the table of training entries I make pertaining to a given horse. I initially created a HorseIDFK field and related it back to the HorseID from the original layout. I wanted to make it so that from the Training table layout, instead of using the ID #, the table used the horse's name but now I've really messed it up. I still have all my training entries, but they are no longer attached to the individual horses (the tabs from the Horse Info layout are empty). Help?! Thank you!!
  9. Hi, I hope this is the place to post the question and that questions are even allowed. I am a complete novice thus needing some quick questions answered that i can not seem to find in any helps. I have customized one of the "starter solution" layouts better suit my needs. I used one of the asset starter themes. I used the assests:Desktop:asset details to customize. My question is this, Is there a way, now that i have the asset details form how i want it, to apply this to all the other functions. Like for the other desktop sub catagories or the ipad sub catagories of themes. I would like to apply my changes to the starter solution to the Ipad "assets" and ipad "asset details" and all thier options. Basically, do I need to change everything in all the different layouts or can i use the one i modified and have it applied to the other layouts for Ipad and its views? Hope this makes sense and i would appreciate any help you all may have. No need to be harsh on a noob, thanks file is here
  10. Thanks for taking the time to look at this and help me out. I am a graphic designer in Miami creating a filemaker database for an online clothing company's website. I am attempting to create an automated system in which our customers will be able to choose a certain "shirt style", "color" and once those parameters are met, they will then be able to choose a "shirt design" to superimpose over their selected shirt style and color. My problems begin when attempting to resize the "shirt designs" to fit to scale on the desired "shirt style" ... Both "shirt style" png files and "shirt design" png files are formatted in RGB and at 300 dpi ... When I attempt to use filemaker to resize any of my "shirt design" files (1000+ and counting) using the CNS Image plugin, the file will automatically resize the file, but ALSO downgrade my "shirt design" png files dpi to 72 making the Art look extremely pixelated on the 300dpi "shirt style" file!!! I do not understand how this could be happening as I am shrinking a 600x600 pixel 300 dpi file (before resizing) down by 1/3 while attempting to keep the dpi constant at 300. If anything the dpi of the file should INCREASE when resizing down! I do not understand why this would happen or if this is a glitch with the CNS Image Plugin - resize command. It is becoming an extremely frustrating problem for me and I would appreciate any help. Thanks again for your time. Looking forward to hearing from you, Mark
  11. Hello, I recently got into filemaker to use for my clients. I run a piano tuning business and I have Filemaker setup so that I can enter the name, email, address, about the piano, and so on and so forth. Now I would like to make it so that I can add service plans to each of my records because every client has a service plan. With my service plan, I want to be able to send an email out whenever the service plan is due. Could someone kinda push me in the right direction so that I can figure this out. Thanks!
  12. Hey Guys, I'm basically looking to extract information from a field. So lets say I have a field called "Tags" and for arguments sake, let's say the field contains color string inside, IE "Red Blue Black Green Purple Orange" Now if I wanted to check if the field contained the word "Green" within the string and if it DOES contain it, then to RETURN that result and set it into a field somewhere? So the result of the calculation would be "Green" I'm sorry if thats unclear, but I need to find a way to do this, to check for and extract a certain word from the "Tags" field which is a long string of text (different words) Thanks in advance
  13. Hi everyone,  I'm  new to Filemaker and have a beginner question about how to structure my tables (ERD'style).  Here's the situation:  I want to create a database in which I connect three entities:  1. Clients 2. Invoices 3. Artworks/Artists  - Clients can have multiple invoices - Invoices can have multiple artworks (however, every artwork is unique!! unlike generic products) - Artworks/Artists: every artwork is unique, and one artists can have multiple artkworks  *I would like to add a feature in which I can connect multiple pieces of art with multiple clients - I call this "interests". To avoid to creating a many to many relationship I created a separate item for this.  In the file I added is a first attempt to create a good relationship model. However, it does not seem to connect properly.  Any ideas on how to structure these entities in a good way are more than welcome. Tips, suggestions, and examples too!  Thank you,  ReepRutger  Â
  14. Hello, I have been given a project to create pie charts for a co-worker. We are in a K-8 school where she wants to chart her teacher observations and show her staff the data from the observations. So, for instance she wants to see how many 1s, 2s, 3s, 4s, and 5s she is giving for each of her indicators of teacher effectiveness. Therefore, the table we have set up has a record for each teacher and then 24 different indicators. Ideally, we will end up with 24 different pie charts which will show the frequency of which my co-worker assigns each number from the rubric. Now, here's my problem. The pie charts not combining like numbers. For example, one indicator "Engages students in learning" has the following frequencies: score of 5: 0 teachers score of 4: 1 teacher score of 3: 2 teachers score of 2: 2 teachers score of 1: 0 teachers score of 0: 0 teachers I would expect the pie chart to have combined the frequency of scores so a score of 4 would be 20% of the pie, a score of 3 would be 40% and and a score of 2 would be 40%. I would then want it to adjust as more teachers get records. However, this is not what is happening. Instead I have a score of 4= 29%, 3=21%, 3= 21%, 2= 14%. 2=14%. I have done some searching on this forum and others and saw something about sorting, but the problem is that each indicator (field) has its own chart, so I do not think I could keep a sort in tact and not affect the other charts. My co-worker who is using this database has no tech background at all and this needs to be fully automated for her use. I am using Filemaker Pro 12 and am relatively new to this, especially charts. I will take any advice you may have to offer. I am having trouble attaching a copy of my DB to this. I don't know why. Thank you! Kim
  15. Hi, Im in deep trouble I need help using scripts I am making a homework managing app for a project and i have created a few fields; date due, subject, task, and task type I need help on how to process this information and show computational thinking I need help in creating POP UPS!! I am looking for something, when clicked on, pops up a screen showing the outstanding work when the user clicks on button 1 which has a date which has past . AND I'm also trying to make a button 2 which shows entries that are close to the next few days please help as soon as possible and suggest any features i can add to the homework manager and how to write the script for the buttons
  16. 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 >_<
  17. HELP How can I Export using a $variable as my File Name I am a new User with Filemaker 12 on a PC. I need to export to a file and have the field "Report Id" be the file name I Exported. Sample " Field Report Id = "Mik01122015" I need to export mt data to "Mik01122015.txt" How can I Export using a $variable as my File Name "$variable= Field "Report#" Export to "Report#123.txt" I am using this script
  18. Looking for a hero. I have searched for an answer to this online and if one already exists, please point me to it. Otherwise, I'm hoping there's a FMrock star out there capable of identifying what I'm doing wrong. Am trying to create three levels for conditional value lists to identify the location of assets. Consider this a library inventory sytsem that tracks: multiple locations where items are held, multiple aisles within each location, and multiple shelves on each aisle. The goal is to enable users to enter an asset record and select from a value list of LOCATIONS. That's a straightforward list from the LOCATIONS table. Works fine. Next the user should be able to select from a value list of AISLES contained within that location, as defined in the related AISLES table. That, too, works through a value list relationship that filters by id_location to only display related aisles in the value list. Works fine. So far so good. Lastly, the user should be able to select from a value list of SHELVES contained within that aisle, as defined in the related SHELVES table. This is where my conditional value list logic breaks down. The value list displays numerous shelves, but not the records related to the AISLE record selected in the AISLES value list above. As perplexing is that when I add a portal to the layout for data entry of the locations, aisles and shelves themselves, the relationships hold up and the layouts function correctly. It's only when I try to take that data and present it as individual value lists during data entry of assets in that layout that the third value list doesn't work, though the first two value lists do work. File with this problem is attached. Looking for a hero to tell me where I went wrong. CVLTest2.zip
  19. Hi there, I am extremely new to filemaker but trying to learn on my own. I am creating a betting pool with my friends for this upcoming football season. I want to calcuate how many picks a person got right based on calculating their weekly record and then calculating their overall record. I know this is simple but I can't seem to figure it out. The fields I want to evaluate in my layout "week 1" are: Winner - Team that covered the spread Scott - What team I picked that week The first thing I did was create a calculation field(Scott Weekly TrueorFals) with If(Week 1::Winner = Week 1::Scott; 1; 0). This told me if I picked the correct team I got a 1 and if I did not I got a 0. Then from there I want to calculate how many 1's (wins) and then how many 0's(loses) there are for the week. This is the part im stuck on. Can someone please help me? Thank you in advance.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.