Arbs001 Posted November 17, 2015 Posted November 17, 2015 Hello, New to Filemaker. Is there a way that I can create a table, or log, of entries inside a file? So, for instance, there would be a button for a "new entry". This then brings me to a couple fields, such as date, time, and notes. You fill them out, click accept or submit or another button, and it logs it on the file. This is useful for a log of times contacted someone, for example. Ideally I would then run a summary over the number of log entries and have that data analyzed by another program. I would also like to have it visible, populating a background with each new entry. Thank you
GisMo Posted November 17, 2015 Posted November 17, 2015 Using "Manage Database", Create a table, add the fields you need. Find the newly generated layout, Edit it, and turn it into the list view or form view(View As..) This is one of the MOST basic uses of filemaker. You can use the toolbar to add/delete/search records. Take a stab at it!
Fitch Posted November 17, 2015 Posted November 17, 2015 I'd suggest you try File > New From Starter Solution... Choose a starter solution that seems closest to your needs, and go from there. I would also suggest you try Help > Product Documentation > Getting Started Tour. As GisMo said, you're asking about fundamentals of FileMaker. Try to get started, and come back here with specific questions if you get stuck.
Arbs001 Posted November 20, 2015 Author Posted November 20, 2015 Well, that's embarrassing. It was pretty simple. Well, simple in the grand scheme of things. Wide eyed and innocent me had to reverse-engineer the Personnel starter solution's Time off portal to understand, but I have a good grasp of it. Thank you guys for pointing me in the right direction
Arbs001 Posted November 20, 2015 Author Posted November 20, 2015 (edited) Ok, followup question. I have this portal, and it has the rows for each contact log, sorted by latest date first. I want to be able to count the number of entries, and display it in real time. So far I've tried a script trigger on a field (date field in the log) when it validates, saves, exits that summarizes the number of non-empty date fields and puts it, visibly, on the form. But it doesn't update in real time. Help please Got it. Nevermind Edited November 20, 2015 by Arbs001 Fixed it
Kunal Oogorah Posted November 20, 2015 Posted November 20, 2015 Will you be able to put the portal here? I can try and assist you. From what I know, you need to create a calculation field and set it as do not store calculation result. It will then always calculate using the latest changes.
Recommended Posts
This topic is 3360 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now