The Left Brain

Hello all, I am truly curious if this is possible - emphasis on "possible". Can two separate business entities, say Charlie's Boat Rentals and Jane's Art Gallery use the exact same database and run their respective businesses with the same FileMaker Database Solution with no interference or knowledge of the other business existence? Imagine Charlie and Jane are married and they MUST keep their business records completely separate for financial and sanity reasons. They should be able to each login and simply see what is relevant to their particular business. Is this possible? SOME THINGS I THINK ARE REQUIRED A table that could be called "BUSINESS D…

hi how can i put photo and name of staff in calendar for their day off? thanks in advance

Hi Math Gurus, I was wondering if anyone knew how to smooth out data in a curve. Here is what the data looks like on a graph as it is. kinda lumpy. it should look more like one on the right. Note they're different data sets. But the effect is that it should not have chunky abrupt transitions. I have attached a text file with the data for the left curve. These are calibration aim files for an imaging device. They have 26 steps x3 for red, green and blue. The end steps spread naturally in the process so thats normal. Searching google, I cant find a good way (or any way) of doing this in FileMaker. Any ideas? Thanks! Dat…

Hi, all. I was using fmp's send email function for long long time without any problem. But 4/24 - all of sudden it started not working. I use Gmail. And. It said "authentication failed." Anybody have an idea ?

Any one have sample file for exporting KML file to google earth

I have a Random Number Generator but was wanting to jazz it up with something like a Wheel of Fortune spin to it as it cycles through numbers for a few seconds. I am retired and have FM from 3.0 up to 18 now and my skills are so I have been told here " you don't know how to program" yet I am still at it falling all over myself trying to get something clunky to work. SO! I help with a Church Scouting Group called Royal Rangers. I made some give aways out of wood and we pulled numbers out of a hat to give them away. I wanted a virtual way of picking random numbers that can be displayed up on a screen to add some excitement. Right now I am just switchi…

I oversee a database at my university that I developed several years ago. Last year our university stopped permitting Send Mail via SMTP if the script was being invoked from a client. I could now invoke SMTP only from a recognized server within the university. I was able to save the functionality for scheduled scripts, but I lost a lot of functionality on the client side. I can still send emails using the client's email app, but some of the database's client-side email tasks are much less cumbersome if they can be performed using Send via SMTP. I am working right now on recovering that functionality through Perform Script on Server (PSOS). I can successfully send an…

I am adding a field to a portal by widening the portal and creating a space for a new field. I then add a field to the empty space. But the field doesn't show up properly in the portal. In edit mode, this is how (part of) the layout initially looks: And in display mode: I then created some extra space next to the second field: I copied and moved the second field to the empty space beside it. I plan to replace the third field with a new field from the same table, but just to make sure everything is working, I simply duplicated the second field to the third position in the portal: The third column in the …

I am doing a new project and I am stuck with this for over a month, here is the scenario, Please help me. I have a filtered portal, wherein a user will select lengths to be used for the calculation. For the given data from excel: length, half length. I need to determine the combination of the user selected lengths to be used to minimize excess for the total lengths in the portal. Am I making any sense? hehe. Please the portal table below. I need it to be automatic. If I add the half lengths of the previous row or next row with the lengths. The calculation will be able to determine the lengths used and if they are connected via the half lengths. Thank…

Hello: here's what I've got: 1) a table (AppPrefs) with 1 single record with the Fields "IsUsingExt", "G_IsUsingExt", "ExtStart", "G_ExtStart", "UserDigits", and "G_UserDigits" the "G_" variants are global fields that get their values from from their non-global counterparts. 2) A Layout based on (AppPrefs) with 3 fields that use the non-global variants of the fields; the fields are "Are You Using Extensions" (yes or no from a value list), "What digit should all extensions start with" (PopupMenu from value list with custom values of the digits 0-9 called "digits"), and "How many digits should an an extension contain AFTER the start digit?" (again sam…

Trying to calculate the estimated arrival date of a shipment. I believe I am overcomplicating it We ship same day before 3 pm otherwise, it ships on the next business day if it's Friday then Monday unless priority Saturday delivery is elected. Would like to make this more reliable. Grateful for a better approach. Let ( [ id = Method ; shipOn = Case( status = 0 ; Get(CurrentDate) ; INVOICES::Invoice_Date) ; w = DayOfWeek ( shipOn ) ; cutoff = Case ( Hour ( Get(CurrentHostTimestamp )) > 15 and w = 6 ; 2 ; 0 ) ]; shipOn + cutoff + Case ( //3Day id = 118 or id = 119; 3 + Case ( w ≥ 4 ; 2 ) ; //2Day id = 106 ; 2 + Case ( w ≥ 5…

Over the years I saw in some answers that the use of an arbitrary high number [like in calculations] could not be a good practice. Why not? What could/should be the alternative? While I see in several custom functions the use of it.... Any example of the use of an alternative would be welcome.

First off I am not a programmer. I am a woodworker that gets clunky stuff to work. GRIN! So I have a calendar in my Church Boy Scouts Program called the Ranger Database. I am not for profit but have been doing this since Filemaker 3.0. I enjoy making clunky stuff that serves the needs of our Royal Rangers. I am using FM 18 Advanced and still publishing solutions. My eyes are bloodshot looking for a idea on how to make a date like 01-28-1959 automatically show up each year by only one data entry. Have a field next to the date field that says Annual date and it would then create on the fly that same date for the next 10 years. I would appreciate a nudge …

I have created onedrive webhook subscription but still I am not getting onedrive notifications while updating and deleting the files. I also have defined the scopes for the application but still not working?

Hello: I'm trying to accomplish the following: 1. If not registered, delete all user data on application exit else preserve it: I think I've got this one figured out. 2. Offer the user a chance to choose to register and validate the serial number based on a calculation. If the user clicks "OK" with no data in user name, user org and serial number, proceed as if no attempt at registration had taken place. If canceled proceed as if no attempt had taken place. If the user has filled in all three fields, or just name and serial then update a global field that will remain set no matter what and keep the auto-delete from happening on close. …

Hi I have "amount" field in portal . to sum amount in portal I make S_Amount a summery of total of amount field. which total all amount field in portal. but how do total of S_amount ( I need total sum of summery ) also i make sub summery part which display monthly total of S_Amount , how it do that too.

I have these fields amount 1 Currency 1(value list USD; CDN) amount 2 Currency 2 amount 3 Currency 3 amount 4 Currency 4 total CDN ; Total USD which function I used that when in put on amount 1 and select any currency (USD or CDN) it's to add in currency I chose. please some one help

Hi all, I am wishing to plan a development path as follows in order to reach certain levels of accessibility to a database built first with FileMaker: 1. DEVELOPMENT I'm currently building a database in FileMaker Pro 16 Advanced. I could upgrade, but have no need at the moment. I am unaware of something that would cripple my goal of providing accessibility via internet means down-the-line if I continue using FM Pro Advanced 16? I believe I should first get a properly functioning database working within my means of development, and with intermittent help from those knowledge either via forum posts for help. This will leave me with areas not functioning …

SITUATION: A PARTY can have many PARTY NAMEs. Each PARTY NAMEs must be classified by a PARTY NAME PURPOSE TYPE such as “Legal Full Name”, “Common Name”, “Preferred Full Name”, “Nickname”, or “System of Record Name”. I wish to record the many PARTY NAMEs a PARTY can be referred by. EXAMPLE: *John James Doe “Legal Given and Family/Surname Name”; *John James Doe “System of Record Name”; John Doe “Preferred Full Name”; Johnny “Preferred Given Name”; Big John “Nickname”. * Notice these two names above “John James Doe” are identical, but their PARTY NAME PURPOSE TYPE is different. This is acceptable and important: It is good to kn…

is there a trick to create a dynamic variable name?

My question is about using the 'open new window' command. I have no problems with the new window opening and giving it new (smaller) dimensions. My problem lies with the original window in the background that was already open. It seems to resize (it actually downsizes) automatically when the new window opens. How can I prevent that from happening? I can script in a 'maximize window' command for that window, but I think something else is going on and would prefer to prevent it from happening in the first place. Any suggestions? I'm using FM 7. Thanks for any help.

Hello forum. Trying to modify a formula to solve for a different variable. Consider this formula which I am using and works fine: x*(y/100)^.5 Here are the fields in the database. Round(PUMPPRESSURE::gNozzSize*(PUMPPRESSURE::gOldPress/100)^.5;2) In this case when x=.75 y=145 The answer is rounded to .90 Works fine. The first part of my question is this... What I am trying to figure out is a formula that uses the previous result of .90, and if I change x to .65 get the new formula to provide an answer that calculates for y. With the above numbers, when I change x to .65 in this new calculation, solving for y should equal 190. I ca…

I am working on a custom function to mimic some of moment.js tokens. If you have a moment, please let me know if you can find any bugs of efficiencies thanks. /* MOMENT.FM ( dateTimeStamp ; formatString ; relativeDate ) reformat date, following moment.js tokens Token Output =============== Month M 1 2 ... 11 12 Mo 1st 2nd ... 11th 12th MM 01 02 ... 11 12 MMM Jan Feb ... Nov Dec MMMM January February ... November December Quarter Q 1 2 3 4 Qo 1st 2nd 3rd 4th Day of Month D 1 2 ... 30 31 Do 1st 2nd ... 30th 31st DD 01 02 ... 30 31 Day of Year DDD 1 2 ... 364 365 DDDo 1st 2nd ... 364th 365th DDDD 001 002 ... 364 365 Day of Week d 0 1 ... 5…

Hello all, I need your help debugging a script I created.(Filemaker Pro 11) The premise of the script is create an unique folder with a sub-folder on my "c:" drive and save the current record as a pdf in the sub-folder and save the current record as a pdf. The maybe multiple unique pdf's records being saved to the same sub-folder. I also need the script to over write any existing pdf file with a new one if the pdf file name is the same in the same sub-folder. Below are the field names included in the script and their definitions: Main::AA File Path (Text Calculation)= "Dynatect/T&M's/" & Main::AA Product Code & "/PDF/" & Main::AA Quote No &a…

Hi all, I wonder how can add an extra touch in the visitor system in terms of a count number of visitor per week and month through dashboard. Script (Check-in ,Check-out and total)

While this may seem slightly of topic from pure FileMaker it may come in handy for creating and exporting .ics-files. To build an .ics-file which works across timezones they have to contains timezone components. Two of them are TZOFFSETFROM and TZOFFSETTO. While there is an official description here: https://tools.ietf.org/html/rfc5545#section-3.6.5 [Page 65] I can't wrap my head around the meaning and how to calculate it. I'm looking for a profound explanation what exactly the difference between both of them is and how to calculate/use it. I have a list of all timezones and their related UTC_offset_StandardTime and UTC_offset_DaylightSavingTime but there …

In a given field there is a body of text: ignoring any formatting if the active selection was the word fox and the active selection contained a leading and or trailing space. _fox or fox_ or _fox_ I would wish to trim the space just to the word fox and reset the active start and end selection before my script continues. Right now I have 3 very verbose IF sections in the script one that tests if there is a leading or trailing or both.

Hi all, Found the forums recently. In my spare time I've been attempting to decode the FileMaker formats (FP3 through FMP12) so that the tables can be extracted for use in other programs. The open source project is here: https://github.com/evanmiller/fmptools The project includes basic command-line tools for converting to Excel (XLSX), SQLite, and JSON - all without FileMaker installed. It seems to work well in my testing, although I haven't quite figured out how FileMaker encodes Unicode characters. I'm at the point where I'd like to test on as many files as possible – this seemed like the right place to ask. So I'm looking for your oldest, crustiest,…

Hi Everyone, In short, I'm trying to get portal records from one FMP file to another. The devil is, however in the details. I'm trying to repurpose a couple of template files from v18. "Estimates " and" invoices". I set up and customized the invoices.fmp12 and everything went pretty great- now we've decided to take the process to the next level and are trying to do the same thing to estimates. They seem a good fit for each other but because we wanted to have estimates independent from invoicing (invoice numbering and PO reasons basically) I thought it would be a good approach to have a button (& script) to 'commit' an estimate to an invoice once appro…

Sorry... I am sure this calculation is in the forum somewhere and it's super simple. Sample Text: 123 Main Street, Boston Need the copy to the left of the comma..and then the copy to the right. I think its a LEFT calculation...?

Anyone have a suggestion on how to compensate for the substitute function being case sensitive? I'm trying to create a simple text highlighting feature in a database. I don't want to alter the original source text field so I'm creating a calculated field that references the original field with a simple substitute function to highlight text: Substitute ( Data_Parts::Content ; Data_Parts::Part_Filter_Value ; TextColor ( TextStyleAdd ( Data_Parts::Part_Filter_Value ; HighlightYellow ) ; RGB ( 0 ; 0 ; 0 ) ) ) A user enters search text in the Parts_Filter_Value field and that's passed through the substitute function to the calculated field to highlight the ente…

Would some kind person please open my attached FMPro file in FMPro 16, and then try to add Records>New Record (Cmd-N). This worked perfectly for me up to maybe 10 days ago, but when I opened it yesterday and tried to add a New Record I got the "spinning pizza/beachball of death" (in other words my computer hung). Using Macintosh MacOS 10.13.3 (High Sierra) and Filemaker Pro 16. The only way I could get out of this was to use "Force Quit", which showed "Filemaker Pro (not respoding"). If this file opens for you and you have the same problem when adding a New Record, then the problem may be that the file has become corrupted. If you don't have any pro…

So I watched a documentary on the Newcomb- Benford’s law and I was curious what practical application it could have on datasets contained within our files? Would any thing meaningful be derived from say comparing how long sales people are on the phone in a given month or number of calls they made or sales amounts or number of sales?

Hi, I’m looking for a way to add a script in FileMaker 19 pro advanced that would communicate with my amazon seller account by syncing my FileMaker inventory updates with Amazon. I do understand that the Amazon AWS platform uses JSON and would like to know which plugin is best to use and how to establish a proper communication with the ability of sending updates using my Amazon api developer credentials. Any help is appreciated. Thank you.

Anybody out there made a set of calculations to convert from the Julian calendar to the Hebrew calendar...? I am making a database to manage my synagogue's member database, and it would be oh so cool if you could just plug in the Julian date and out pops the Hebrew date. Many programs/websites will do this for you, but I would like to have it be part of the database. If anyone is interested in a complex conversion problem, I have attached a one page document that explains the conversion... UltimateJewishCalendarV2ENG.pdf

Hi I would like to know if someone could help me out on this , sounds simple but unsure what i am missing. Basically a have a table where i create products - each has a unique lot number. i have another table which is the packaging lines - i hav another 3 child tables each is a packaging line. What i want is be able to apply each lot to a day of packaging and on which line. I create a page which is the packaging page for Date X , on it i put 3 portals one for each line. I am adding the lot numbers to each line by using a dropdown on the portal. What i am tring to achieve is that the drop down should filter the lot # which have been …

Hi, I am trying to create a script or function that will take an input of 3 numbers, min, max and count. The function would then create a list of numbers, lets say 256 individual numbers, evenly spaced (or linearly if that’s the correct word) between the min and max values. For example the beginning number would be 109 and the ending would be 3394. I would need to fill the 254 numbers between them. I really have no idea where to begin. Math was never my strong subject. Thanks for the help!!

Gents, is it possible to ask Filemaker to extract volume and weight data from the Naming field and put it into corresponding fields? price.fmp12

I'm trying to populate a virtual list table using ExecuteSQL, to show the most recently logged foods by the current user. I need to show several fields (FoodID, food_name, portion, unit, calories, log_date, etc) but only want distinct values based on the FoodID field. For any duplicates, I want to show the most recent one. For example if the data set is: 1, apple, 1, ounce, 10, 2020-06-10 1, apple, 2, ounce, 20, 2020-06-09 2, orange, 1, piece, 30, 2020-06-11 I would want it to return: 1, apple, 1, ounce, 10, 2020-06-10 2, orange, 1, piece, 30, 2020-06-11 I assume I need to use an inner join in the ExecuteSQL function, and…

Is there a way of keeping the keyboard enabled with a list view 'filter as you type' in FM Go? When it performs the find it disables the keyboard, and then of course it enables in on the 'go to field' step...so it pops up and down on each keystroke. I'd be okay using a portal instead if needed.

I'm building a meal tracking app (similar to MyFitnessPal). The list view layout where the user views/edits the selected day's log has sub-summaries when sorted by meal name (breakfast, am snack, lunch, aft snack, dinner, etc), which appear above the body. In most of the meal tracking apps I've seen, these headings show whether the meal has foods inserted into it or not, which is the behavior I want for my app. Is there a way of achieving this in list view when the meal has no records (foods) in it? I don't like the idea of using portals since they won't expand/shrink to fit the data, and other misc reasons. Here's a screenshot of my app (left) and an example of …

The Situation: We have hit a road block in development and I am looking for ideas how we can accomplish a task. Currently we have designed a testing platform in file maker pro for students to do entry exams. One of the components of the exams is listening. The rules of the test are this. 1. A student can hear a mp3 file twice only and no more. 2. Once the audio file is playing the student can start answering multiple choice questions about the audio file 3. There are no controls allowed on the audio file except either autoplay or play. (no pause, stop rewind) 4. Students dont have access to file maker its done on webpage only …

I have some elderly users that are challenged by doing a right-click on a container field to insert an image. How can I attach a button to the container field so whenever they click on it a dialog pops up that prompts them to select an image from their hard drive? The users are all on Macs.

This post is to helps someone who asked a question on facebook. I'm posting it here so i can share the file. Dates.fmp12.zip Dates_v2.fmp12.zip

Hey... thanks in advance for reading. I am using portals to display "Active" projects in my office. When you set up a portal, naturally, you set up a relationship and then you might set up a sort order, in my case, I am sorting by "Job Number." Unless, I am missing something or having a brain aneurism, which very well might be the case, I want to make a button to change the sort option on the fly. In my case, I would love to sort by "Due Date, Job Number or Customer" and perhaps with a button, but I just don't think that can be done...right? You set the portal up and the sort value is what you choose in the set up phase only. You might winding up telling me how …

Hi, I have a list, return delimited of Hex values. I am trying to figure out how to convert them to decimal. I found a custom function that does a great job of the conversion but only for one line. Case ( IsEmpty ( _hex ) ; Let ([ _result = $cf.hex.result; $cf.hex.result = "" ; $cf.hex.depth = "" ]; _result ) ; Let ([ _alpha = "0123456789ABCDEF" ; _hex = Case ( $cf.hex.depth ; _hex ; Filter ( Upper ( _hex ) ; _alpha )) ; $cf.hex.result = $cf.hex.result + ( Position ( _alpha ; Right ( _hex ; 1 ) ; 0 ; 1 ) - 1 )* 16^(0+$cf.hex.depth) ; $cf.hex.depth = $cf.hex.depth + 1 ]; hex2num ( Left ( _hex ; Length ( _hex ) - 1 )) ) ) I cant figure…

I want to move the contents (grafx) of 1 container fields to another container field with a calculation. No luck using a Case function.

Hi! I have a database with 7 columns and several rows containing numbers (see the picture). I would need to find the biggest numbers in whole found set below 6000 (1000 - 5999) and above 6000 (>6000). For example 1017 and 6037. I've tried different approaches but now I have to give up. Probably the solution is vey simple but I just cannot figure it out now.☹️ Any ideas?

So I'm in need of calculating a Timestamp field that will give me the next Wednesday date. Here is the calc that I started using GetAsDate ( Date ) + Mod ( 4 - DayOfWeek ( GetAsDate ( Date ) It works, expect now I need worry about the time. If the time is after 12pm on a Wednesday I need to return the next Wednesday and not the current Wednesday. Examples 10/16/19 2:04:35 PM --> 10/23/19 10/16/19 8:23:55 AM --> 10/16/19 10/15/19 4:26:35 PM --> 10/16/19 10/18/19 6:14:17 PM --> 10/23/19

I'm in need of some help in what might be the best way to go about solving my issue in how it relates to Filemaker. I've got a table that is using 3 fields "Sqin", "sqin.s" and "PercentUsage.c" Sqin = number filed sqin.s = Summary - Total of Sqin PercentUsage.c - Calculation (Sqin / sqin.s )= This give me the exact percentage of each record.. Issue is I now need to export the data to another system, but it only allows for 4 digits.. ( 0.1234). Due to simple rounding when you add up the values you may get less then 1.0 or more then 1.0. Doing some google searches I came across this site that I think explains the issue pretty good and how to g…

Just reading a review of Hot Chips 31 and saw this article: https://www.anandtech.com/show/14750/hot-chips-31-analysis-inmemory-processing-by-upmem It is about a memory technology that does some calculation tasks directly in memory. They mention 18x speed up for database tasks + the CPU is more lightly loaded. I wasn't sure if, to use this, revisions in Filemaker itself would be needed or if the technology could be used by an end user. It appears that the FM plug-in SDK does expose SQL actions to maybe it could be used. It says the memory is a drop in replacement for DDR4. Reading the comments, especially this one: https://www.anandtech.com/comme…

I am building a database that includes one table for lookup data and another table acting as the user interface, containing all of the calculations and scripts. The lookup table contains 304 records where the primary field can be one of 38 different values and 3 other fields can each be one of 2 different values. In other words, there are 8 records for each of the 38 primary values depending on which option is listed for the other 3 fields. Each record then contains 12 fields of lookup data I need to be able to lookup from the main UI table. Two of the 3 fields in the lookup table are related to fields in the UI table since their values can be changed by the user. I…

Hi, I started this project using transaction to interact with the data, I used the transaction module from KarbonFM to do so. I have a situation where one of the script called during the transaction fails because it want to validate that a record exists before doing what it has to do. Because the said record is created as part of the same transaction, the script does not 'see' the newly created record via the relationship because it is not committed yet. Is there any way around that? Thanks for your help

Hi, I'm sure I'm being a bit stupid, I hope that someone can help. I have 4 tables "estimate" "orders" "Delivery Notes" and "invoice" I need to have many estimates but not all estimates become Orders, 1 have resolved this by using this script:- set field [orders::__fkEstimateID = Estimate:: _pkEstimateID Which gives a unique order record related to just one specific estimate record My problem is that now I have to take that order information including all data for the related estimate table and show it in multiple delivery notes (i.e. each order may have many delivery notes relating to just one order) I think the Invoice should be more strai…

I recently gave a demo of my FM software to a future user and ran into problems I never did before, problems that wouldn't have come up under normal circumstances: error messages from FM or a window that should have remained hidden replacing the window that should have remained on display. (I wasn't able to take screenshots or record details at the time.) I tried to reproduce the problem later but was not able to. It did strike me that the one thing unusual about the situation was that I was also demonstrating another completely separate database, written by somebody else, that the user would also be using in the future. My question is whether having two databases open at…

This is probably one of those questions which separates me from people that make money as developers and those that don't (that would be me). I have a simple script that compares two variables. The variables are populated with text (Peoples Names). Basically, if the the two variables are TRUE (the variables are equal) I want to stop the script. Despite the two variables being equal - the IF continues. I have noted when I use the same numbers to populate the variables - the script works as expected. Please tell me Filemaker is smart enough to evaluate text in variables. Below is the my script and attached is a screenshot of my debugging efforts. As always -…

Hi all, I need to go to different layouts depending on device and parameters and while the script functions fine for the desktop I can not get it to go to the correct layout in the iPhone. What am I doing wrong. Sorry all, found my level of stupid and answered it myself.

I have been trying in vein to push a feed up to MWS every time i get errors about the MD5 not matching then i try to base64 encode things but then that will end up with == at the end of a string and that creates it own error. Has any one successfully pushed feeds up to MWS thru their API or have a third party remedy?

Hi... I am probably missing one silly little simple thing, or maybe there is a better way to get from point A to point B. Very simple script to clear a field. I added "Show Custom Dialogue" step in the script in hopes to stop the script dead in its tracks if I you hit the "cancel" button, but the script still continues even though the check mark to commit is not checked. Thoughts appreciated. I attached a simple database to show you what I mean because, after all, we all love to download filemaker uploads that have problems and fix them. Thanks in advance, you all rock! Mike Dialogue.fmp12

Hi there I implemented a sales chart into a Runtime Solution. No chart is displayed when I open the runtime solution. However, when I use FM Pro to open the Runtime solution, it works perfectly. Bars are displayed accordingly to the sales. This database is not set with privileges. Any help is welcome

I'm trying to make some kind of tutorial. I have a container field with different icons (let's say copy, paste, bold…). I have placed that global field (ten repetitions) in the layout and right underneath the text field where to explain the routine... What I want is (and I ask if it's posible), clicking the icon I want, paste it into the text field to show what I mean (go to this icon…). Any idea about how to accomplish this? Is it possible or am I going to the wrong direction? Thanks in advanced.

Hi everyone! I have a text field, with each sentence separated by ¶ . I would like to create buttons for each line in this field, so that I can copy each line individually (and paste manually in different application for example) I assume that it's easy to do in calculation with GetValue, and make a script using Get (ScriptParameter) = line number in that field, for each button. ( I ll need only 7-10 lines max). 1. I can't figure out what script function I need to use to make a selective copy... 2. If one of the option is Set Selection function - how would it work in my case? Thank you!

is there any way to enter calculation into the object name of the field table name - CONTACTS filed name - CLIENT NAME name of the object to be - entered clients name is <<contacts::client name>> in object name filed is it possible trying but not getting the result is there a way or its impossible hope u understood

I have a friend for whom I've done a bit of consulting helping him build some project tracking tools in FileMaker. Helped him through the basic stuff around relating tables together, doing a bit of scripting, creating some basic reports based on data he's entered... Well, now he's hooked! And would like to do everything for his business in FileMaker. His current partner does everything in Excel, and has over the years developed a project management spreadsheet he uses to track project funds, activities and generate a financial summary for their clients... Well, now I've been asked to see if it can be redeveloped in FileMaker, because my friend doesn't want multitudes …

Hello Left Brainers - I have a solution that schedules 230 campers (we are a summer camp) into six activity periods each day. There are several conditions that must occur for a class to be scheduled. For example: The class must be open, the camper must be in the appropriate grade, the class must have space - and there are others as well. When all the classes are scheduled there are always kids that have blanks where the scripting could not put a class in their schedule for various reasons. We are able to fill the blanks by manually looking at ALL the kids schedules and moving things around to allow everyone to have a full schedule. Example: Sylvie wa…

Hello, is it possibel to switch words in a text Field with a CF or Scipt ? TextField: a brown Fox with a black chicken a brown Color is nice this wall has a brown color now i want to switch brown with the next word : ( there will be more words in the real Txt File .. brown,yellow,...) a Fox brown with a black chicken a Color brown is nice this wall has a color brown any suggestions welcome 🙂 Günter

Hi! Is there a way to calculate the GCD (greatest common denominator) of two integers in FileMaker Pro without the use of a custom function? (I don't have Filemaker Pro Advanced) i.e. The GCD of 1920 x 1080 = 120. How can I use Filemaker Pro to get to this 120? For Context: Standard 55in LCD Monitor Resolution = 1920 x 1080. The Aspect Ratio is 16:9 Which means that 1920/120 = 16 and 1080/120 = 9. I'm trying to calculate the aspect ratio for other monitors that aren't the standard.

I have a customer that keeps seeing this type of message, "This Person (TP)" is modifying this record. You cannot use this record until "This Person (TP)" is finished". I continue to tell them that "This Person" must be on the record while they swear that "This Person" is not. So I say that this person must have exited the application improperly were the server still see them on the record in question. I just received this message from a recent communication with me and the client at 9 o'clock in the evening, nobody was on the record other than me and the customer yet we got this message. The person the message was referencing was logged into the server but h…

Hello With small to big changes made as often as customer requires and age hitting hard on me , I've come to think about noting somewhere these changes, keeping a log file of them. I think some of you might already have in place such practices. So, what are your best methods in keeping track of what has been done through the years? Thank you, Toni

On one of my layouts, I can't view it as a form because in the Browse mode the View as Form is grayed out. On other layouts, it is not grayed out. How can I fix this?

I would like to set up a solution that keeps track of account financial data. The primary table has the account name and other data. The related table has three fields: deposits, withdrawals and balance. I would like to calculate the total deposits, total withdrawals and current balance, and display them in the primary table.

Hello This might be a math combination problem or alike (I can not come with a better expression in english). I would want a set of random numbers to be matched to a sum. For example I have numbers: 9,17 and 4. Then there is another set with sum = 29. The first set has a sum of 30 while the second is 29. What I want to do is fill the second set with numbers from first until there is no more room. So in this example I would use only number 9 and 17 and leave 4 out. The remainder from set two is 3 (29 - 9 - 17 = 3). I would want this remainder to be the smallest possible. To achieve this I thought of ordering numbers in descending order, higher numbers at the…

So I have an order entry solution that I am working on where the items can have "options" that effect the item's pricing. Basically I have orders --- > orderLines ---> items ----> options. In a basic invoicing solution I could easily just goto related records on the order lines and print an invoice type document. What I need to do is add these option lines to that type of print layout. I have seen a very similar post in the forum, but was wondering what else I could do to print these "option lines" on the invoice. I feel like I am missing something simple and obvious.

I am working with the Content Management template to create music catalog. Using the GetContainerAttribute to load the metadata from an mp3 or m4a works great. However it does not work with .aif or .wav files. These files have exactly the same metadata when imported into iTunes, but FMP does not recognize them. In fact if you convert an aif to an mp3 (from iTunes) then import the mp3 into FMP it works just fine, but the aif imported directly does not. The catalog is going to be a mixture of all four formats, so converting them all is not going to be a workable solution. Does any one have any experience with a workaround to try to extract the metadata? Thanks, David …

I have created a database that contains several tables including the following . Children Observation Records I need to be able to track the observation records and compare them to a criteria that counts the number of observations and when they reach a threshold "stamp" the record. Example: The Child needs to reach 10 observations overall. When 1st observed - stamp "Just In' and the date it was achieved When 7 observation records achieved - Stamp "Comfortably in' and the date it was achieved When 7+ achieved - stamp "Securely in" and the date it was achieved This then needs to be tracked so that progression can be tracked o…

FM 12 Adv, Win 1. I down loaded a plug in but don't know what to do with it. I tried storing it in the Filemaker Extensions folder, but it does not show up in Plug in management. How do I install it and where do I store it? Will the plug in be available in all solutions or only in one file? Does it need activation?

Hello, I'm have an issue sending emails via SMTP Server using a calculation field in the "To:" field. When I use the calc my outgoing emails are filtered as spam by the hosting service. If I put the Email Field in the SMTP To: emails are sent successfully. Here is the setup: I have a Parent Table with the fields Email_Parent1, Email_Parent2, Email_Parent3 and a related SuperParent_Email. Parents can opt-out/in of mailings by selecting flag_P{1-3}_Mailings. I'm trying to to get the field Email_List output to look like this: [email protected]; [email protected]; [email protected]; [email protected]…

Hi to All, I am creating 1 batch script to automate my manual task. in this task i have to copy 5 csv files from 1 location server to another location( my filemaker server documents folder). I am able to copy single batch file to put on another location but not able to copy multiple files and put all in single batch script even after googling. Lets say my files name are A.csv, B.CSV, C.CSV, D.csv, E.CSV Below is my code. Please do help/correct me where i am wrong . /log="D:\Program Files\FileMaker\FileMaker Server\Data\Documents\XYZ.log" /command "open XXX_Test" "get "/home/ge00/TEST_SFTP/A.csv ""D:\Program Files\Fi…

Hello Guys, I have around 16/17 automated schedules that run from server and as we know that after completing of every schedule we get notification about that Schedule status like Run successfully or with abort status or kind of error status . I am giving few examples Case 1: Successfully run "Schedules 1-ABCD" completed. FileMaker Server automatically sent you this email. Contact the administrator if you no longer want to receive these notifications: Contact information not specified Case 2: Error occurs: "Schedule 2 XYZ" completed; last scripting error (101). FileMaker Server automatically sent you this …

Hello Forum. I came across this blog post about synching with Dropbox. http://www.filemakerbloggen.se/post/demo-very-simple-synchronization-using-dropbox/ I was hoping to obtain, or even purchase a sample file from the author but had no luck. I commented on the blog post, saying things like 'well done' and 'thanks for sharing', but the comments were erased. Then I sent an email to the author about the availability of a sample file (either share/purchase) and never received a reply. It appears to be an easy way to sych and perfect for my situation-one user on a desktop, who sometimes need the data on the road via an IOS device. Seems much easier tha…

OK Here goes an question that I hope makes sense. The small POS that i am working on is progressing however, I have just noticed an issue with a popover portal display that i am not sure is correct or how to work around it. I will try and explain. If I create a new transaction record and dont put any data into the portal where the dummy product is In the image i.e. it is blank then when i click on the Green fruit /veg button to the right and the popover displays, i get a blank portal display. whereby i am looking to get When the popover displays. The popover is 7 portals side by side to form a grid. It works absolutely fine if a product has…

Hi all not sure if this is the right area for this post however,any Help appreciated in a design that i am working on for a small point of sale i have an issue (or challenge) the normal price is set as a Retail Price (all good) however I have been asked to now fulfill this next part. A Multi-buy concept. so e.g. a bottle of wine would normally sell for $12.99 however there is a promotion where you can get 2 for $20 ea (or a breakdown of $10 ea) Now I have put a field in inventory table for multi buys i.e. fields 1. a checkbox for whether it is a multi buy item. 2. a field which indicates the qty of item that is applicable as in the above example 2 …

Good morning, I wrote a small routine last week to report on some dates and had it working nicely. Stupidly, I fiddled with it and broke it - now have no record of my earlier work. What I have/had did this: A client attendance range: Client_From (date field) Client_to (date field) A reporting range: Report_From (date field) Report_To (date field) For example, how many days overlap with these two periods. Client_From = 10/5/2016 Client_To = 13/6/2016 Report_From = 1/6/2016 Report_To = 30/6/2016 Overlap is 1/6/2016 to 13/6/2016, so result is 13 days Client_From …

Hey All -- The solution is eluding me, so I'm hoping it is as simple as I think - I just can't get step one completed. I've created a variable to set the current date minus 60 days - Get ( CurrentDate ) -60 = $RecordsGreaterThan60 now I wish to use that to find records that are less than the variable and have a second script run on the found records Enter find mode [] Set Field [mydatefield; < $RecordsGreaterThan60] - but of course this does not work Perform Find [] I feel it's a simple thing - but alas I've got no hair left to pull out anyone, anyone....Bueller, Bueller.....

Hi all We have the following concept for receiving customer feedback: Staff close a support ticket and then click 'request feedback' Email with 3 feedback links (i.e. good, bad, average) is sent to customer They click one of the links A new record is created in our database, including both the feedback, and the associated ticket ID. Does this sound possible? Thanks

Why am I getting a return character add to the end of value returned using this calc. This only happens when the shortList = 1 part. Let ( shortList = FilterValues ( "Shipped¶Not Shipped¶Not Fully Shipped" ; List ( LineItems::ShippedStatus ) ) ; Case ( ValueCount ( shortList ) = 1 ; shortList ; not IsEmpty ( FilterValues ( shortList ; "Shipped" ) ) ; "Not Fully Shipped" ) ) I went ahead and changed to move the return. But maybe their was a better way. ValueCount ( shortList ) = 1 ; Substitute ( shortList ; "¶" ; "" ) ;

I am trying to convert a decimal to a fraction and display the result as text. I found a custom function "DecimalToFraction ( number )" that does this but I am not getting the desired result. It's converting .6666666 to 43/64. I want it to return the result as 2/3. Can someone please tell me the correct FileMaker formula to achieve this?

For all those who love math problems ;-) Given a phone keypad as shown below: 123 456 789 0 Need to generate random 5 (or variable length) digit numbers with the following constraints: 1. Has to be done completely in FM 2. Each number has to be with in within one movement on the keypad including it's self. ie #2 could possibly be followed by the numbers 1,2,4,5,6,3. While #3 could possible be followed by the numbers 2,3,5,6. 3. Repetition of numbers are allowed as long as the same number is not repeated consecutively more then once- 12123, 44588, 78853 are all valid numbers, 98887 is not. Any takers?

I have two tables. A Department table and a Job Position Table. Elsewhere in the solution I have a TO of each table that are connected through a "departmentid" key. Through this relationship is also set to delete any related Job Positions if a department is deleted. I have a second TO of the Department table that is not related to any other TO. A script I am writing goes to the layout showing records from this TO, deletes all the records and imports a new set of records. However when the Delete all Records script step runs, all the related records from the Job Position table are also being deleted. For the life of me I can't work out why. It can't be to do with the …

Hi I am designing a very simple proposal with stages of the project in text which is held in a repeating field with 50 repetitions. Next to each I want to show a number but the number list should correspond to the number of repetitions that contain data Here is an example of what I am looking for The fields are LineItemsCount and LineItemsDescription, both are repeating fields with 50 repetitions This is how it should print Item Description 1 first item 2 second item 3 third item The description part works perfectly and only shows the repetitions were there is data (and as this has to be printed, t…

I am trying to create a field that will generate a list of phrases according to a criteria. It is based on input from a questionnaire, and designed to pull up the phrase whenever the answer to the corresponding field was higher than a one. Even though I set all the questions to two or three, the only one that is working here is the first one. In the merge field, it should list all of the phrases in quotes, but it only gives me "functional math." Can anyone see what is going on here? I am self-taught and really a novice on the calculation side of things. Thanks so much. If (Functional math deficits >=1; "functional math”,If (Functional reading deficits …

Hi all With the amount of scripts and users I now have it's time to look seriously at record locking implications. Any pointers greatly appreciated! I have a Labour, Items and Invoices table (Labour and Items are actually in the same table but are generally treated as though they were in separate tables). A Labour record has multiple Item records assigned to it. Items can only be added via a portal within the Labour record layout. Labour and Item records are assigned to an Invoice record via the Invoice_IDF field. The assignment process is done by a script that is run once a month, this script is run when everyone (apart from the user running the script) …

Not quite sure if this is the best board - Lee, feel free to move if you can think of a better place. We've got several FileMaker solutions within our organisation, all at different levels of maturity, and generally each running on their own server (we've got three production servers) There are a number of reference tables that are replicated in each of them - let's use a list of Countries as the example, which is simply the ISO Country list of 250-ish countries with their 2 letter code and their name. So, this information exists in multiple places, and is (accordingly) more or less accurate, depending on when/if the list gets updated. What do people t…

What is the difference between a "Moron" and an "Intelligent Moron" ? Well, a "Moron" doesn't even know they're a moron, while an "Intelligent Moron" comes to the discovery that hey I'm a "Moron" wow! In this glorious moment, the "Moron" tries to apply this new found intelligences but since they're still a moron who lacks "Wisdom ( Meaning )" any application of this intelligence goes to the way side and the moron remains at whatever level the moron was before discovery was made, even though there is all this new found intelligence all around him. Everybody is ignorant within the proper context :-) The underline failure of this "Forum" and all other "Forums…

In my FileMaker solution, I would like to automatically translate certain fields from my "Products" table into fields in my "Products_2" table using a dictionary stored in my "Dictionary" table. I suppose I should somehow use the Substitute function, but how do I retrieve (all) the values from the "Dictionary" table?

I have an instance where a container field is occupied by an image of unknown type. It might have been inserted or pasted in ... or imported. It will be accepted for further processing only if it's a PNG. How can I easily determine that? When I look at the actual header bytes of the file (after exporting it), "PNG" is clearly visible. Yet I wasn't able to get those first 4 bytes with a Left ( text ; 4 ) directly from the container. Is there a way to do that? Thanks in advance for any help.

I have come across a situation where I require 2 separate entities to be available for viewing in the same list of records. This may be best explained with an example: 2 tables: COMPANIES, CONTACTS CONTACTS are individual People. COMPANIES are business entities with 0 or more related CONTACTS. ROLES are assigned to COMPANIES or CONTACTS... for example - 'Client' or 'Supplier' When I am creating a Job it is to ask for all Clients to select from. Some of these are evidently COMPANIES and some CONTACTS. This part is not an issue, as using a virtual list and ExecuteSQL I can query both tables, join them together and display these in a portal for the u…

I have a client that has a server full of image files (jpgs, pdfs, tiffs, etc). They have a FM14 database being served on FMS 14 (Windows Server 2012). They are accessing the server from FMP 14 clients on Macs and Windows. They want to link records in a database to the image files. The want to start from a record in their client FMP, open up a dialog that allow them to search the server machine and choose a file that will be linked to that record. Later they want to go to that record and view the file. Storing the files as containers won't work as the files will be edited (but their filepaths and names won't change). And the filepaths and names have a strict nam…

What I am trying to do: I am importing transactions from a bank file, each transaction descriptions look like this: Recur Pymnt 09/25/13 18:44 6901 NETFLIX.COM NETFLIX.CO NETFLIX.COM CA 160599 POS 09/20/13 17:05 6901 USPS 0525270026 SAN DIEGO CA 005030 POS 10/07/13 18:16 6901 COSTCO WHSE #108 SAN MARCOS CA 176242 POS 10/02/13 14:23 6901 OFFICE DEPOT 00 SAN DIEGO CA 051103 I am trying to replicate something that Quicken did where once you edit the string and change the USPS to US Post Office then all subsequent imports will translate the values. The original imported description field remains intact un-modified, and there is another field…

Ok Guys, I hope the wizards of fmforum can help me with this as my brain is just not getting there. Problem (Challenge) I am working on a POS which for the most part is sailing along nicely. I have a stipulation that there must be the ability to print on the receipt an offer if criteria is met. eg Spend $30 in store get a free coffee in the café. I have set up a table which is a promotions table which allows for the entry of the promo ie description, barcode, icon(for receipt), value, start Date End Date, active etc and have related that to the sales table (trusting this is correct) I can get it to the receipt except for the icon(I'll work on that) but I now need it to b…