Data Analysis

I have a list of IDs that I'd like to find. How do I search for all that are in the list, like a SQL "WHERE IN" search. Thanks. sorry this seems to be a duplicate of (can't see how to delete this most recent question)

I inherited a database to track departmental requisitions including a calculation to add sales tax to the sum of subtotal and shipping. The local sales tax increased from .078 to .079 the first of April. I would like to modify the calculation such that it calculates the correct sales tax going forward without changing the previous records. Can someone help me with the syntax? I am a machinist, not a developer. The starting DEPT_REQ# for the new tax rate is 11507. This is the existing calculation: Unstored,=Let([@Prior=If( GetAsNumber(DEPT_REQ#)>10980; Shipping+Subtotal; Subtotal)]; If(IsEmpty(Override);@Prior*.078; Override))

Please can beg for some FM18 help! I have 2 tables TPTable::date that is linked to HLTable:HL::date. I need to automate the look up of 2000 TPTable records to the closest match HLDate (80 records). I know there must be a way, but it has alluded me thus far! Thanks

Tableau conference starts tomorrow and is FREE this year https://www.tableau.com/community/events/conference We're moving more and more of our FileMaker data viz to Tableau -- there's bound to be some interesting stuff here even if you've never tried it.

Hello, just want to invite you to join to the series of web casts which I plan to start in this/next week, if anyone is interested, I will adapt to the majority time zone, videos will be uploaded to YouTube for people who will not be able to participate. I have opportunity to develop simple solution for FileMaker database synchronization, which replicates data from FileMaker to PostgreSQL database. I'm not an expert and not here to teach you, the purpose is to develop together this solution so it becomes useful for others. I spent a lot of my time on dbs replication, FileMaker is first which I want to start to work with public. Node-RED is l…

Background I work at a dealership/repair shop and I'm working on a Solution to manage money received, paid, and anticipated as well as other things from customer management to inventory management. I'm a beginner learning from researching as I go, I have a table to input Invoices we receive from vendors so we can reconcile at the end of the week or month we will print a report showing the invoices that where received and entered in the table to the payments paid on the company credit card. Issue I ran thru a Invoice validation issue we have more then 50 vendors and receive a lot of invoices I'm trying to prevent employees from entering duplicate invoices s…

Good Morning Everyone! My file has over 500,000 stored .pdf's that I am required to keep by law for 5 years. Most of these are about 500kb in size. I am in the process of moving my database to a cloud AWS server and I wanted to optimize/reduce the size of my database as much as possible prior to the move. Do you know of a plug in or program that I can run to optimize these .pdf's and potentially shrink their size?

If you're only using your database to keep track of your stuff, but not to decide what to do next with your stuff, you're falling behind. The "big data" hype has been droning on about the value of analyzing data for more than a decade, and there's no reason FileMaker can't play, too: statistics, business intelligence, data visualization, machine learning, or whatever other flavor of data analysis you want. I concede that the FileMaker community has some catching up to do relative to other software tools — and we should be ashamed of ourselves for it. Some folks might think it's FileMaker Inc.'s job to build better data analysis features before we can do anything interest…

Change of Ownership I have written a database which manages my dog breeding activities, I am not great with databases - it was never my day job - and I have have hit a snag with which I would be grateful for some help. I have a three tables; One contains all the dog's (puppy's) details that I need (Dog's Unique ID No., DoB, Sex, `Sire, Dam, etc...). One contains all the Owner's details ( Owner's Unique ID No., Name, Address, Phone Nos, Emails address, etc... One Join Table which uses the Dog's Unique ID No. and the Owner Unique ID No. as foreign keys and links the two tables together using a DogOwner Unique ID No. Th…

On a separate thread I asked Bruce Robertson if the new FM16 JSON functions could be used together with the virtual list technique he created. I haven’t experimented with it but I wonder if JSON adapt well to this great technique. Any thoughts? thanks!

We have been using FileMaker for reporting for several years now. We basically import invoice lines ( and several other KPI fields from related tables ) from our point of sale into our reporting program nightly. Basically what we have is lots of historical data that is not summarized. Most of my reports use summarized aggregate data, a few actually need the line details. What I would like to do is create several summarized tables from my main data table so I can have several summarized data cubes basically. What would be the best way to import the summarized data from the existing table? Is it even possible? For example I would like to summarize sales by ca…

Hello, I'm having a problem that I've been unable to wrap my head around. I have a database that records defect data by trial number. For example, Trial 1 may include 6 samples that I'm inspecting. Currently, I have a chart layout that I can chart the defects of individual trial against another individual trial. This layout has charts that compare the specific defects recorded. Some of the trials share project names (for example Trial 1, Trial 2, and Trial 3 are part of the New Additive project. What I'd like to be able to do is to chart the combined defect data for one project against another project as selected by the user. I'd like the user to be able to choose the …

Hi, I am new to Filemaker and learning on FM-Pro14-Adv. I am reading 'The Missing Manual' book and also following Udemy's free Contacts Database FM video tutorial. I am building my second DB which is a more detailed contacts list. My first is a simple inventory DB I am using at work. My frustrations are coming with troubleshooting problems that come up. As I follow along on the video, I am getting different results then what is shown. I am not even sure how to troubleshoot the problems. I am an engineer and very systems oriented and obviously I do not know the program well nor the structure. Does anyone have suggestions on how they troubleshoot problems? …

Hi guys, First of all I want to let you know about: www.monkeylearn.com which is a online free tool for conduction sentiment analysis on text data(they are not paying me to say that ). Having looked through the page, i appears that you can create an API for your algorithm, and then either paste som text in a field on the webpage itself. Or you can paste the API-code in your own script, and make it work for you even smarter. I it looks like they support the following languages for export of an API: CURL(The terminal command), Python, RUBY, PHP, Javascript, Java & .Net However, is it possible for me in any way to include this API in a filemaker solut…

Hi,  For my bachelor thesis i have a rather large dataset which i have chosen to arrange and "clean" in filemaker, before further analysis.  The data origins from a forum, with 36.000 topic replies, including the topic starter itself, in the same form as the replies.  I've found out how to separate topic starters from the others, via a dummy variable, returning 0 if topic text has RE: as the first 3 chars, and 1 if not. However, as my data seem to have been damaged, I have a lot of empty topic fields, but with the original URL, looking like this: http://www.lydmaskinen.dk/viewtopic.php?f=1&t=63898&p=553224#p553224 The first f=1 is the ID of the s…

i have several records in a db that contain a state value (i.e. ca, va, hi, co...) i want to create a calculation field that populates the value 'east' and 'west' depending on the values in the state field... ca, hi, co, or, wa, return 'west' ga, va, md, dc return 'east'

Hi folks, My music dept database is used to record grade % and attendance in class lessons and attendance in ensembles (choirs, orchestras etc). It includes following tables: Pupils Inculdes Overall_avg, This_academic_Yr_Avg, Age, MusicScholar, AcademicScholar, SpecialNeeds (a text field describing dyslexia etc) fields amonst others. Assessments The table for generic info about assessments - so different classes can use the same assessment (e.g. Y7 end of year exam etc) Class With class_avg, Academic_Year, Year_Group, Class_Attndance_Avg, Lesson_Day, Lesson_Time Assessment_Class_Join Self explanatory? I can't think of a more useful name at the mom…

Just started a new project for a Lab, and they manufacture slides from cuttings from tissue. The way it was explained to me is that they need to generate a random sampling of cuts for quality control. it was mentioned there is higher failure rate at the end of the block or at the beginning of the block vs the middle of the block during the person shift. Trying to determine the proper math needed to generate random sample size for the lot so that the system can assign random code to a slides from the lots so the a QC tech can pull the slides from the cold storage and test them. The goal being the QC tech isn't the same person that cut the slides - or at least th…

I'm currently using a new version of FileMaker Pro. I've used it before, and have a database saved in .fp7 format. I'm trying to use the old database with my new version, and have tried converting the old file to the .fmp12 format, but every time I try to open the database, I get the error: "The database file isn't in the correct directory, this needs to be corrected to continue." The database was copied from an older computer that has since passed on, and I can't remember which directory it was in. Is there any way around this?