Shows the number of tables (occurrences) found in the database referenced under attribute. Shows the number of base tables found in the database referenced under attribute. Time string based on the system's locale.Ĭontains the creation time of the report.
Items new to FileMaker Pro 15 are displayed in this color. The DDR XML format is useful for advanced users and developers who want to create tools that analyze or process the structure of databases. This document describes the FileMaker® Pro 15 Advanced Database Design Report (DDR) XML output grammar. Set Variable ($PaymentInfo FORM::PaymentInfo)Īnd you should be back, ready to search for Contacts, Events, and "Submit" the form to create more RSVPs.FileMaker Pro 15 Advanced Database Design Report XML Output Grammar Contents # Get the payment info that has been entered If(isEmpty($$ContactID) or isEmpty($$EventID) # Check that a contact and event have been selected Set Variable ($$EventID Events::EventID)Īdd another button to the layout and a new script. Set Variable ($$ContactID Contacts::ContactID) This should refresh the portals and show you the related records you're interested in.Īdd a button to each row in the portals and call a script that sets a global variable to that portal rows ID.įor example: Script: Set Selected Contact ID Write a script, or use a script trigger, that refreshes the layout whenever one of those search fields is Exited/Modified. Add the PaymentInfo field.Īdd two PORTALS to the layout, one for the Contacts table, one for the Events.īy default you should see all the records in each of these portals. In the relationship diagram, connect the tables like this: FORMĬreate a layout called FORM based on the FORM table.Īdd the fields ContactSearch and EventSearch to the layout. This means that the cMatchField for Contacts will look something like this: John RSVPĬContactMatch = Calculation, If(isEmpty(ContactSearch) "ALL" ContactSearch)ĬEventMatch = Calculation, If(isEmpty(EventSearch) "ALL" EventSearch)Īdd the following fields to the Contacts and Events tables: ContactsĬMatchField = Calculation, Stored, (FirstName + NEWLINE + LastName + NEWLINE + ALL + NEWLINE + Firstname LastName)ĬMatchField = Calculation, Stored, (EventDate + NEWLINE + EventDetails + NEWLINE + ALL) Let's say you have two tables like this: Contacts EventsĬreate a new link table between them that also stores the extra RSVP information you want. I'm fairly experienced in MsSQL, so I do know this and that about database management in general - just not in FileMaker.
I've tried to read the documentation, but I haven't been able to find any tutorials that take me closer to my specific needs. Note: I have no previous experience with FileMaker. And then we haven't even mentioned that the cost would probably increase, as developing a new app from scratch would take much longer time. If so, how do I sell this to my contractor? As this would in that case be my first commercial application, there is obviously a "safety factor" that speaks in favor of an established product. Would a better option be to build a new, custom app using for example C# and MsSQL? Is there really no way to get closer to my vision using FileMaker?
The closest I've gotten so far is a form where the user can enter a ContactId and EventId manually, which means that he/she first has to go to another view, search for the records, and copy/paste the id numbers. What I would like to use is some kind of form where the user gets to search for a contact (any combo of first/last name) and an event (any combo of name/date), select each from two respective lists (where all other information is displayed as well, to distinguish the results), add some extra information and hit submit. The application will handle contact information, some information about events hosted by the organization and - and this is where I'm currently struggling - RSVP information that link the contacts and events, as well as stores some data about payment. I have been asked to look into FileMaker for creating a pretty simple database app.