Jump to content

Recommended Posts

I have a small Filemaker Member's database (less than 1,200) with some 650 existing members but I am not the Membership Secretary.  The Membership Secretary uses Excel to record who joins and resigns, and each time there is a change in membership (joining or leaving) the Excel file on Dropbox is updated and I am notified.  I therefore have to import that data into my Filemaker Members database each time there is a change to the members (new member, change in personal detail or resigned member). 

However I am in control over the data of the existing members who also join our web membership (at present less than 100).  The web members have to be manually activated when they join the web membership and I have to check that each person is a member before I activate their web membership.  So far no problem.  I record in my Filemaker Members database the following data in respect of each member (in addition to their personal data) - the date to which they have renewed their membership, the date they resigned, the date they became a web member and whether their web membership has been activated or deactivated.

It is important that their web membership is deactivated when they resign their membership, so they no longer have access to the members section on the web.

I therefore want to set an alarm that alerts me each time I import from the excel file or when I open the Filemaker database, that if any member is now recorded as having left, and is also recorded as having an activated web membership, I must deactivate that member.  Thus, in respect of each member, if the field "Date Left" shows a date AND the field "Activated" is Yes, a warning is raised and that warning remains until the field "De-Activated" is also Yes.  I know I can achieve that by conditional formatting, but I can only get about 28 members per page, so will not be alerted unless I scroll through all members.  I therefore need to get a warning in the Header Space.  Can that be achieved?

Link to post
Share on other sites
1 hour ago, wdrspens said:

if the field "Date Left" shows a date AND the field "Activated" is Yes, a warning is raised

There are several ways you could approach this, here's one that wouldn't require adding anything to your schema: find the records that meet the stated criteria. You could do this in a new window, so that your existing found set is preserved. Then, as long as the new window shows any records, you have records that need to be handled.

 

1 hour ago, wdrspens said:

if any member is now recorded as having left, and is also recorded as having an activated web membership, I must deactivate that member.

I wonder why you cannot automate this part.

 

Link to post
Share on other sites

You "wonder why I cannot automate this part".  I am not clever enough to automate it as I first have to open the Word Press website, find and deactivate the member, and then, only after I have done that, do I have to record in my database that that is what I have done.

My problem is nearly resolved following the idea you gave me, by writing a script to import the updated data from the excel file, and then displaying it only where there are records that need to be handled, as per your suggestion, but I am stumped by what happens if there are no records that need to be handled.  I want to use an "If...Endif" script, but do not know how to record a blank result where no records need to be handled,  i.e when I get a message saying "No records match this find criteria".  I can live with that, although it would be nice to avoid it.

Link to post
Share on other sites

Try something like:

Enter Find Mode [ ]
Set Field [ Members::Date Left"; "*" ] 
Set Field [ Members::Activated"; "Yes" ] 
Set Error Capture [ On ]
Perform Find [ ]
If [ not Get (FoundCount) ]
  # DO SOMETHING
Else
  # DO SOMETHING ELSE
End If

If you want to be more precise, you can use:

If [ Get (LastError) = 401 ]

 

Edited by comment
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Similar Content

    • By Nick Lightbody
      My new piece on Medium - with an in depth performance analysis between different types of deployment for FileMaker Server.
      Deployment in a Docker Container on a powerful cloud server comes out as a standout option.
      It will be fascinating to hear your own experience - does it differ from what my testing reveals?
      It will also be fascinating to hear from Wim how the results he gets from his new Punisher performance tool compare with what we get with dsBenchmark?
      Cheers, Nick

      https://nicklightbody.medium.com/claris-filemaker-server-19-a-performance-test-of-linux-v-windows-4bb007b5e2d7
       

    • By Don_Macaroni
      I have a regular text field with a height of 20 px in Layout mode. In Browse mode that height is respected. But when I select the field, the height seems to triple and a blue border is added. How do I get rid of this behavior? No doubt it has to do with the stupid Themes thing, but how do I edit that? And is there a way to completely remove the Themes/Styles from a database? This feature has zero usable themes as they are ALL UGLY. I create a nice pro look and copy paste fields, Filemaker Themes/Styles s*ck.
    • By Mafia2020
      I have a calculation that goes like that, I input a number on "Base Imponibile" (say 100), it adds 15% (it gets me 115), it then calculates 4% to the previous result (115) and it gets me 4,60, I then add 2 and the total is 121,60 which is perfect.
      And that's the part that works just fine. But I then want to make a reverse calculation, where I input the expected result of Total Calculation and tells me all the other values and here it's where things go awry.
       
      I'm attaching the initial calculation that works as a reference and the reverse calculation which doesn't work as an example. The "2" that gets subtracted in the reverse calculation is a fixed value of a small tax that I have to deduct (imposta di bollo).
      I have a feeling that the reverse calculation goes crazy because of some unwanted rounding somewhere, but I am not to sure, so I seek the opinion of more calculation versed persons around.


    • By Mafia2020
      I know the solution is probably very easy but it escapes me. I got this database, which I use to create invoices, year after year, I created a report page where with a neat summary field I get the "lifetime revenues", "lifetime general expenses", "lifetime total taxes" and "lifetime total invoices number", which is handy, but I need to have the same data broken down by year, and I can't figure out how to achieve that.
      In another post I have been suggested to consolidate the three tables I had (Invoices 2018, Invoices 2019 and Invoices 2020) into a single table (Invoices) and then use a "subsummary" which would give me the data I want based on how I sort the records but I am not sure how to use subsummaries nor I am sure I want something where I have to multiple click to re-order records to get data one at a time; I'd rather prefer a report where a calculation of some sort would make a sum of the total revenue of my invoice records broken down by year, as I exemplified in the database I'm attaching, is that possible in an easy, possibly not involving complicated subsummaries way?
      I'm beginning to get desperate on the subject, please have mercy.
      Invoices Demo.fmp12
    • By Mafia2020
      I'm not even sure to describe under which category my specific problems fall into, I can only advance some hypothesys, so I'll just describe it and let the wisdom of others guide me.
      I have a DB with several tables, I use them to make invoices. With every invoice I input the desired price and it adds automatically 19% taxes and produces a neat invoice which I can print, these three tables are called:
      Invoices 2018
      Invoices 2019
      Invoices 2020
      Now on to my problem. I wanted to create a forth table where from every previously listed table it would calculate the total revenue of the year in question, broke down like this:
      - Total Net price paid for 2018
      - Taxes for 2018
      - Total revenue for 2018 (net+taxes)
      - Total Net price paid for 2019
      - Taxes for 2019
      - Total revenue for 2019 (net+taxes)
      - Total Net price paid for 2020
      - Taxes for 2020
      - Total revenue for 2020 (net+taxes)
       
      I am unsure how to proceed, I tried creating a forth layout and a new table but I have problems brining the summary field from each year's table into the forth table/report/layout.
  • Who Viewed the Topic

    2 members have viewed this topic:
    darylh  Gabriel 
×
×
  • Create New...

Important Information

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