Jump to content

bleyden

Members
  • Content Count

    12
  • Joined

  • Last visited

Community Reputation

0 Neutral

About bleyden

  • Rank
    member

FileMaker Experience

  • Skill Level
    Novice
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
    Mac
  1. Hello all, I wanted to check in, as I'm quite done clicking the remind me later button on my mac to install my Catalina update, and wanted to check in and see if anyone has run into any issues with FM16 Pro Advanced and OS Catalina. I don't have a server, just using the database on my own computer, no plugins, etc. just a bare-bones license of FileMaker. Thanks!
  2. Sorry, I'm on the struggle bus with this and not understanding I'm basically trying to copy this: On the Y axis, I will have all of the program names, but if I pull program names from Programs::Program Name, I don't have any values pulled. If I pull the program names from Leads::Program, then I get one item for each lead, and the programs are duplicated if they have more than one lead. Let's just do this for a record count for today. I attached a sample file that should have all of the necessary pieces and tried to recreate it and start from scratch to see if I could make my brain work, but still tumbleweeds. All aboard the struggle bus! Chart Sample.fmp12
  3. Perfect, that cleared that up! I now have the appropriate value types, etc, and that worked. Now on to the chart... this is what I assume I would have and it is not what i want (otherwise i wouldn't be here lol) I created these 4 dummy leads: Here are the two questions I have: Is it better to have one chart for each time frame (day, week, month), or combine them on the same chart, which will obviously save room? The chart I was trying to do was just for Day, so it should have come up with two leads for Asking the Question, and 1 lead for QuickLook, but that is not how it worked. Thanks everyone!
  4. When I set it up, I followed this tutorial, and it seems like the week and month fields are working, but the current day count is not. Here is the relationship graph I have, and I also attached a PDF of the fields from the Leads table showing their calculation and other information: I think once I can figure out the "today" count then I can move on to the chart issues... I don't have much brain space left! Lead Count.pdf
  5. Hi All, I'd like to get a count for how many records were created today, this week, this month, and possibly this year to display on a marketing dashboard (Leads). I've tried a couple different tutorials but nothing is seeming to work quite right (and are a bit out-dated). I'd also then like to chart how many leads were generated today for each program (programs on Y axis, today-count on X axis), but i'm having trouble getting it set up since the counts are messed up. What other details would be important? Thanks!
  6. Great! To add a view button to the portal, would I make my script something like this? If DocType = "MSE" Go to related record from Subform|MSE using window _________ Else If DocType = "DA" go to ..............
  7. Hi All, I'm going to try and explain this as best I can, so feel free to ask questions if something is unclear! I am building a database for clinical mental health. In working with clients, users will need to document a variety of forms using different measures, like an MSE, PHQ, DA, and other "forms" (the abbreviations shouldn't be relevant). On the client's dashboard, I'd like a portal showing all of their documents/forms that have been entered, but I dont want to have individual portals for each type of form, I'd like them to all be shown on the same portal. What would be the easiest way to do this? Is the best way to add fields from ALL of the forms to one table, and then filter which fields are shown during creation based on the form the user wants to add, and then just show timestamp, user, etc, on the portal? Or is there a way that I should make each form its own table, and if so, how would I get all of those to show on the same portal? Looking for ease of use for the users and whichever will preserve the solution's performance. Thanks for the help!
  8. Hello! I want to have an "on record load' script that will add a record to my audit log when an Individual record is viewed/edited, but I am finding that it is getting stuck in a loop since I have the script return to the individual detail layout/original record, so it bounces back and forth between the detail layout and the layout where the audit log record is created. any thoughts on how I can get this loop to stop? Thanks!
  9. That script works perfectly!!!! Thank you!
  10. Oh duh, perfect! And that works even if data is not contained in a portal? Thanks!
  11. I want to be able to delete a record from Table A, but also have all of it's related records from Tables B and C deleted as well. Is there an easy way to do this, or do I need a delete button or menu option to go to a layout of each table, find the records based on the ID from Table A, and delete them? Thanks for the help!
  12. Hello! Came over to this forum since FM screwed up the community, so feel free to move this post around if I have it in the wrong place! Is there a way that I can put a transparent button over the body of my list layout, but only allow it to be clickable of the user first clicks to make that record the "active" record? Essentially, they would then be able to click to make the record the active row but remain on that layout, but then a second click would direct them to the appropriate layout? Can the button only be shown when the listed record is active? If so, what would my "Hide object when" formula look like? Thanks for the help, here's to hoping this forum makes up for the new FM Community!
×
×
  • Create New...

Important Information

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