All Activity

FileMaker natively provides us with some really nice tools for user feedback. We can use the Show Custom Dialog or even create a dedicated dialog using a Card Window and Layout. There are, however, times when you need something a little more subtle. Just a simple message on screen will often suffice. The next question is whether you need the user to interact with that message or not. The solution is simply to provide both options of course. In this video and technique file, we explore a super simple method for providing user feedback via a simple message which is shown using a dedicated Butt

FileMaker natively provides us with some really nice tools for user feedback. We can use the Show Custom Dialog or even create a dedicated dialog using a Card Window and Layout. There are, however, times when you need something a little more subtle. Just a simple message on screen will often suffice. The next question is whether you need the user to interact with that message or not. The solution is simply to provide both options of course. In this video and technique file, we explore a super simple method for providing user feedback via a simple message which is shown using a dedicated Butt

That is a correct conclusion. I am afraid that's all I understood from it. In general, if you want to count (or sum, or any other aggregate operation) related records that meet some condition, you need to add a calculation field to the related table that checks the condition and returns a corresponding result. Then apply the aggregate function to that calculation field. For example, to sum only child amount that are above 100, you would add a cAmt calculation field to the child table = If ( Amount > 100 ; Amount ) and then in the parent table do: Sum ( Child::cAmt )

With regards to the second calculation: Sum ... Sum (Case ( Nominations::DateNomination ≠ ""; Nominations::CreditorClaim; Nominations::DateNomination = ""; 0;0)) + Case ( DateNom ≠ ""; ApplicantClaim; DateNom = ""; 0;0) The second part of the formula works correctly -> + Case ( DateNom ≠ ""; ApplicantClaim; DateNom = ""; 0;0) This second part returns the correct value whether the date value is empty or not. 0 if DateNom is empty else Value of ApplicantClaim if a date exists. The first part (values from the portal rows) just does not work -> Sum (Case ( Nominations::Da

It's been almost 18 months since the release of elemental_ux , and we haven't been resting.... elemental_log is our take on audit logging. Built to be super fast to log changes and even faster to integrate into your own solutions. In just a few minutes you can add a full JSON based audit trail to your solution that can track changes to whatever fields you want. We've also included an intuitive configuration tool for choosing what to log - no hard coding required. Other Features include: • Fast - We've put a LOT of effort into making this as fast and scalable as we can, a

Hi, Thanks for quick reply. Yes, these files are stored in a folder on local machine. They are being created daily, and they have unique names. I'm fine with keeping the copies for history log in case i would need to validate some uploaded data. I want to leave it running on scheduled script without any user interaction, it FM runs on a VM. I would say even if i delete these csv files after upload that would work for me as i would still have these on ftp backup (if it's easiest way to just upload/delete files). Thanks

Many thanks @commentfor your reply. I had successfully used the Count() function but on the wrong field. My new working version is: (The Case() function is counting the Primary Table value if relevant) Count ( Nominations::DateNomination) + Case ( DateNom ≠ ""; 1; DateNom= ""; 0; ) Just to explain further - I tried to make my original post as detailed as possible but I neglected to add the purpose There are Two Fields to be calculated and displayed on the Primary Table list. Namely: 1: No of Votes (Support) and 2: Total Sum of ALL Claim Value (Currency) My Approach t

https://firesidefilemaker.podbean.com/e/going-vertical/ Developing a vertical market FileMaker solution is something that many developers have wanted to do but few do it because they don't have the depth of knowledge as to how to go about it. In this fascinating conversation Michael Rocharde & Marc Larochelle, both of whom have developed successful vertical market solutions, talk with John Mark Osborne about all the different things that have to be taken into account. Using case studies we disect the different methods of deployment, how you find a niche market to develop for, the impo

At this Virtual Bar we may not have drinks to share but we do have FREE sample files: https://bit.ly/3pfxyed Join Kristian Olsen as he wraps up how Virtual tabs further demonstrate the power of the Virtual List technique. Future live streams: https://fmtraining.tv/#LIVE support@rcconsulting.com www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com

Hi Larry, As long as the users have separate authentication credentials (i.e. separate emails addresses and thus separate inboxes) then you may not even really need to have a users table unless you need to associate those users with particular emails. I'm thinking that you could have a "connect" button in the interface which opens a window and prompts the user for the email address and password. These values can then be put into the EmailConnectIMAP/SMTP functions (assuming hostname and SSL/TLS requirements would be uniform across users) which would allow the users to connect to the indiv

In fact it must be something in my system since I asked a friend who has FMPA v18.3 and macos 10.13.6 to convert the excel file you useed and the result he had was the same as yours. Thanks......

I convert your file in my system and get a different result than yours, I get this (77.989999999999995) I'm using FMP v19.1.3 under macOS 11.0.1. It could be something in my system 🤷‍♂️ Anyway thank you so much for helping me.

In the past I've deployed the Email plugin to receive email for a single email address. Now, I am asked to build a basic email client app in FileMaker. What I want to do is set up a way to allow each user to only pull/receive mail from their unique email account across a single domain name, and possibly sending from their own account. I'm thinking the best way to store each account's specific email address is to create a users table. Then on login, then on the receive or connect functions/script step, pull the user's email address from the users table. Would this be the best way to do th

I don't see how this helps move us forward. Here's the file I used for my attempt, and the result of converting it using FMP version 18.0.3.317 under macOS 10.13.6. If you convert the same file on your system and get a different result, then there is something different about your system. If you get the same result, then there is something different about your file. source.xlsx source Converted.fmp12

.

Hi Jadzas, To give you the best answer, I would need to know a little bit more about your solution and set up. Are these files being stored in a folder on your local machine, or are they being stored in FileMaker as well? Are these two csv files being created daily, and do they get new names or is it the same two files just being updated? Are you trying to keep copies of every csv that is generated, or are you interested in removing them locally after they are uploaded? Are you looking to automate this process so it runs as a scheduled script, or will there be any user interactio

Thank you!! Helps alot.

I wasn't able to reproduce the problem.

Hi jkrier, When it comes to recurrences for events, the ability to set a recurrence pattern for an event relies solely in the Recurrence Pattern function calls. On the event, the "IsRecurring" field which you can see in the demo file is purely a true/false Get field, meaning it cannot be edited (this is why the field is grayed out and not editable). To create a recurrence pattern, once you have defined the normal fields for the event, you would call the PCEM_RPOpenRecurrencePattern function to open up the event's recurrence patterns and set the Recurrence Pattern fields for it

Hello, I don't understand why FileMaker changes the value of a number when converting an Excel file to FileMaker. Please help me understand... Thanks in advance

I am afraid this is rather confusing. If you want to count the related records, you can use the Count() function to count some field in the related table that cannot be empty - for example: Count ( Nominations::MatterID ) Well, then count the Nomination Date field instead. Blank fields are not included in the count. I am afraid that's all I understood from your post.

Hi, I have FM file converter that converts excel files into two csv files that needs to be uploaded. Ideally i want to leave it in the background, i know how to upload a specific file to ftp, but can't figure out what i need to do so it scans the folder and only uploads new files in that folder? Any help/tips appreciated.

Hi Group how can i copy a parent record and all the child portal records in it into a new parent record with a new parent id number with all the copied portal records updated with the new parent id number? Fluffy

Greetings. Reaching out for help as I'm staring at a brick wall currently. The more research I've done the more lost I've become. Primary Table is a List of ALL Active Matters. Each Matter is Unique. Portal is a List of Related Nominations. Relationship is the MatterID Two calculations are performed for Every Matter & Displayed/Saved in the Primary Table (Save Preferable) 1.1 Count the Number of Nomimations For the Matter (SUPPORTCOUNT). 1.2 Add the Value of each Claim per Nominations (SUPPORTVALUE) The above Calculations are for the Primary Table & Preferabl

You won't need an ID to enjoy these Virtual Bars! join Kristian Olsen as he explains how Virtual tabs further demonstrate the power of the Virtual List technique. Future live streams: https://fmtraining.tv/#LIVE support@rcconsulting.com www.fmtraining.tv www.fmstartingpoint.com www.rcconsulting.com