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)

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))

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.

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 so I thought about making the Invoice number a unique value but at the same time it is possible to run into an issue where the same invoice number could be used by more then one vendor but not twice by the same vendor .

How can I prevent this from happening?

I thought of validating it this way but I don't know how to accomplish it if <<Vendors::Company Name>> has an existing <<Invoices::Invoice Number>> that matched the <<Invoices::Invoice Number>> that is being inputted --> Message [ The invoice your trying to input already exists for <<Vendors::Company Name>> received on <<Invoices::Invoice Date>> for <<Vehicle::Description>> and the amount is $<<Invoices::Invoice Amount>>, Please Verify.]

unless there is a better way to go about this please advise.

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?

Some folks might think it's FileMaker Inc.'s job to build better data analysis features before we can do anything interesting. While that would be helpful, it's unreasonable to expect FileMaker's in-house engineering team to catch up with other tools. The standard data analysis tools for other languages are not built-in features of those languages, but add-ons built by the communities of users of those languages. It's up to us to make FileMaker useful for non-trivial analyses.

Some folks might think "big data" is too big for little FileMaker to handle. First, "big data" is not a well-defined concept, but it usually has something to do with any data analysis task on enough data to be difficult to handle with the tools at hand. "Big data" is hard for everyone else, too, no matter what tools they're using, or else it wouldn't be called "big data." Second, there's no reason your data have to be "big" for an analysis of your data to be valuable.  Granted, more is often better, statistically speaking. But some of the best minds on Earth have spent the last century or so extracting as much insight as possible from as little data as possible. They came up with some really good techniques. The techniques that are still most common today were originally designed to be executed with pencil and paper at a time when "calculator" was a job title rather than a pocket-sized electronic device. We have FileMaker, so we have no excuse. The "small" and "medium" data in our FileMaker applications are just as worthy of analysis as anything Google has.

"Big data" gets all the news coverage, but most data analysis is not big data. FileMaker's biggest competition, market-share-wise, isn't Python or R or C++ or Hadoop. FileMaker's biggest competition is our ancient arch-nemesis, Excel. You're not going to let the rival team have a leg up on us, are you!? We can do better than Excel.

FileMaker presents some advantages for data analysis that have been neglected for long enough. The most sophisticated statistcal analysis in the world is useless to an organization that fails to act on the conclusions of that analysis. Analysis has to feed back into operations. Conventional analysis workflows have to export data out of operational systems and import it into separate analytically-oriented data warehouses after excruciating conversion processes, then data are analyzed by another menagerie of separate tools, and finally those results have a long trip back through layers of strategy meetings and bureaocracy to influencing action. Data clean-up and conversion as it passes between each of these systems is the overwhelming majority of the labor spent on "big data" projects. That's lame. Our operational data is already in FileMaker. Doing analysis in-place in FileMaker spares us the most expensive problems of "big data," making us more nimble. The results of our analyses can immediately feed back into operations.

Some folks have suggested that FileMaker may just not be the right tool for most analyses. Why skin a cat with FileMaker's multi-tool when you could use R's bowie knife? Because "the right tool for the job" is often whatever tool happens to be in your hand. FileMaker is the tool in our hands (or else what are you doing here?), and we could do a lot worse.

So what help do you need to add data analysis features to your FileMaker applications? Have you done anything cool to show off? The administrators of this site saw fit to grace us with this forum to discuss such issues. (Thanks!) So start talking already!

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. 

This works fine when I sell a puppy or dog and I have no problem with assigning more than one dog to an owner (some owners have several of my dogs) but...

Sometimes a new home doesn't work out and I buy the puppy or dog back and resell it to different owner.

What I can't work out is how I can keep records of all the owners (active or not) whilst transferring a dog from one to the other, I don't want to delete an owner as I need to keep a record who has owned my dogs in the past but I also need to produce a file of information for the new owner using layouts for Insurance Cover Notes, Microchipping, Registrations etc.

i have tried deleting the  DogOwner Unique ID No. from the record (which I thought was the only link between dog and owner) but somehow all layouts still display the original owner.

I just can't get the database to recognise the new owners - the old owner's data is displayed on every layout - including the new Agreement of Sale which I need to send to the new owner.

It is rather like a serial numbered product being returned and resold so there must be a way of doing it.

I have just installed (yesterday) FMP 16 - upgrading from FMP 12, running on a Mac.

Sorry if I haven't explained this very well.

For example I would like to summarize sales by category by month and import that into a new table.  

Any insight would be greatly appreciated.  

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?  What structure do you use?  Goings from the easiest to the more complex problems first, or using comparison methods?

I really could use a suggestion here.  It feels like I am doing a simple DB and getting stumped consistently.

Thanks,

Phil

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 solution(does filemaker integrate with either of the above languages)? 

I  was hoping to include the API as a calculation, referring to a text field in big dataset i currently have arranged in filemaker.

Regards,

Mike

 

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 subforum the entire dataset is taken from, and the &t=63898 is ID of the topic. The last two must be page#, but i am actually not sure of that.

 

However, is it possible to make a calculation, using one of the text functions in Filemaker, to get the value of the &t=63898 ?

First off, i would have used Left / Right functions, but the number of digits varies from 4 to 6, which makes it very complicated...

 

Is there some sort of search function that returns everything between "&t=" and "&p=" or in some of the cases nothing at the end..

 

 

Any help will be much appreciated!

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 moment, but am working on it!!

Pupil_Class_Assess_Join

This is the table where the individual record of present, absent, grade%, notes and date go for individual pupils.

I ought to rename it but haven't been inspired with a better name yet - MarkSheet? any better ideas?!! 

Any road up, I'm getting to the stage where I've got easy access to lots of data which makes writing end of term reports far easier (I've got those in another separate table), but there's potential a whole lot more I can do with this data:

For instance (getting harder!):

• Could I have a notification pop-up when I open a class to inform me which kids are under / over-achieving (or if any have birthdays today!)
• Could I somehow spot trends of over / under achievers. - do scholars do better? Kids born in October? Girls? (actually, they will - we're a girls school!) Violinists?
• Could I predict likely potential future achievement in public exams based on previous cohorts?
• Any obvious opportunities I've missed?

And then - what's the best way to present this?

• A dedicated data crunching layout
• A spot on pupils layout
• On the class layout

Sorry to be so nebulous - but I really have no idea what I'm talking about; what's possible what's not, and how to achieve the possible!!

Cheers,

Mike

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 their slides are in the blind behind a random code - that of course resolves back to the lot behind the scene.