noamb

Hey all! I’m returning to FileMaker after many years away, and my brain is still dusty. I’m trying to figure out how to solve this problem: I have a table called Recipients, full of people I’ve emailed a drip campaign. Besides their name and email address, each Recipient record contains a set of fields that indicate the date when each stage of the drip campaign was emailed to them. These fields are named Date Sent 1, Date Sent 2, Date Sent 3, etc. When a person responds to an email, I want to manually enter the nature of their reply into a text field called Response. As soon as I edit the Response field, I want the Response Date field to automatically get filled with today’s date. How do I do this??!? Thanks! :-)

Thanks, that's helpful! Any suggestions on resources for how to name TO's?

Ray's paper does indeed look very useful. I'll take a look! I've already watched Todd's video on Selector Connector and I imagine I'll come back to it again after reading Ray's paper. I downloaded and investigated Todd's sample file but I found it was so full of many varied kinds of techniques that I couldn't figure out which was Selector Connector and which was other stuff (like Master List, etc.). Thanks!

Nope, I'm in v14 Advanced.

Hello everybody, I'm just returning to FileMaker development after years away. The last time I developed in FileMaker was... version 6!!! Wow, has a lot changed, and thank goodness it has. I'm trying to understand FileMaker database schema design. I have a decent knowledge of normalized database forms, but the concepts of having multiple Table Occurrences, and Table Occurrence Groups, are quite foreign to me. I understand what they are on the Relationship Graph, but I don't yet understand how to plan and use them while constructing my solutions. Can you direct me to some good tutorials on these topics? I imagine I'll need to examine more than one tutorial (and sample files) in order to truly grasp the concepts, so the more the better! Many thanks!

Hi all, I set up IWP on Filemaker Server 9 Advanced, running on OS X Server 10.4, and it serves pages just fine. Now, I'd like users to be able to type in the domain name (let's say www.example.com) and be redirected automatically to the IWP database URL -- www.example.com/fmi/iwp/cgi?-db=database_name&-loadframes. I've figured out how to do this using a META tag in an index.html document at the Apache site's root folder, but I'd rather use an Apache Redirect or RedirectMatch command via an .htaccess file or via the Server Admin site setup screen. I've tried redirecting / to the above URL but it doesn't work: it gets into an endless loop of redirects that eventually gives a browser error. For example, if I redirect / to www.example.com/fms/iwp, the browser loads www.example.com/fms/iwpfms/iwpfms/iwpfms/iwpfms/iwp... on and on until it fails. What's the correct way to get this working? Thanks! nb