Jump to content

Cynthia Heyman

Members
  • Content count

    15
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Cynthia Heyman

  • Rank
    member
  • Birthday May 26

Profile Information

  • Gender
    Female
  • Location
    SLC Utah
  • Interests
    Dog Sports and Training. Knitting, Camping.

Contact Methods

  • Website URL
    http://tiptail.com
  • ICQ
    10306498

FileMaker Experience

  • Skill Level
    Novice
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    Sierra

Recent Profile Visitors

323 profile views
  1. Exporting to Excel with Formatting

    Okay, thanks. Looks like that post also suggests plugins but doesn't recommend any specific plugins. Also, I was able to export my records from my portal, using Go To Portal Row and then Go To Related Record, but this option exports all the fields in the portal table, and I only would like the fields specified in the portal to be exported.
  2. I am looking for a way to export to Excel format where I can control a great deal of details about the output formatting. I want my output to resemble this spreadsheet that I put together by hand. But I'd like it automated: https://goo.gl/GrNDDp So I'd like to be able to control row height, skipping rows, shading, etc. (I'd also like very detailed exporting to PDF too.) I'm assuming that I'll have to use a plugin to be able to do this? I Googled a little bit for plugins but wasn't sure if any of them do exactly what I want, so I thought I'd ask and get some opinions about plugins. Also... I also would like to be able to export fields based on sorting and filtering. I have tried using a portal, but it seems to export all the data, and doesn't take into account the sorting and filtering I use to create the portal. I've also used a Layout List View, and while the sorting works fine and seems to export okay, I don't see where I can specify filtering in a Layout List View. Perhaps these things would also be controlled by a plugin? Or are there things with FileMaker I'm missing? I'm very new to Filemaker and I'm sure I don't know 25% of what it can do. Thanks!
  3. Thanks for your reply. After talking it out with myself I figured out what I wanted to do.
  4. I wasn't sure where to post this so please move this topic if a better forum would be appropriate. I have an application that I'm working on that will have multiple Event Weekends, for a type of sport. I need to know what the Current Event Weekend is that the user will be working on. The Current Weekend can be changed depending on which weekend the user needs to add entries to. I'm not sure how to set this up... Option One: I thought maybe having a CurrentEvent table, where there is basically only one record that the whole application can access, that tells the application what the Current Weekend is. (it can just be a number field that is linked to the Event Table). However, if I do this, the way my database is laid out, the table that is a bit of a distance from the CurrentEvent table is not reaching the table with that field. Perhaps I need to modify my layout. I'm not sure. Option Two: I could have a CurrentEvent field in the 3 tables that need to know what the CurrentEvent is. These include the Event Table, the Trial Table, and the Run Table. (Each Event Weekend can have multiple Trials. And each Trial can have multiple Runs.) IF I did Option Two... each table has multiple records (IE there can be many Trials in the Trial Table), and so I would probably need to update every CurrentEvent record in that table. I'm not sure how I would script it so that every CurrentEvent field in the Trial Table is updated to reflect, say, Event 2. (I've played around with pasting in the value, or using Replace Field Contents, but I couldn't get those to work correctly.) Option Three: Have a Global Variable that carries the Event Weekend Number always throughout the application so that all the tables can access it. (Or maybe a Global Field? I have a read a bit about Global Fields but don't know if this would solve my issue or not.) I'm a pretty major Newbie at Filemaker, this is my first application, and would appreciate any help. Thanks!
  5. Add Record Button passing pk/name

    Thanks for your reply, and that works! I really appreciate it. Just read over the new Card feature in Filemaker 16... and maybe I'll see if I can get that to work instead, I like that idea.
  6. Add Record Button passing pk/name

    Filemaker doesn't let me type in the last line of your code.... Set Field [ Dogs::OwnerID ; Get {ScriptParameter) ] It seems to delete it when I click off the text... how can I get it to keep the text? I'm assuming it's not letting me because it's not a premade script item.
  7. Add Record Button passing pk/name

    Thanks I'll read that over. I've been able to pass the record to the Dog Details Layout... but it passes everything, and I only want the Person passed, not the dog information.
  8. I have a layout where it shows a Person's information (name address etc), and it includes a Tab Control that lists all the dogs that are related to (owned by ) that particular person. I want to be able to click on a button that allows the user to add a new dog that is connected to the person showing. I have a Dog Details layout, I just need to pass the person key/information to the Dog Details layout so the dog is automatically added to that person. I've attached a screenshot of the Person Details layout with the Tab Control, and the Dog Details layout, where I'd like to have the Owner field automatically filled in when added a new dog. In my button control, I've tried a Single Step and the Go To Layout, and adding the Optional Script Paramater, using the Primary Key from the People Table, but it doesn't seem to be working. I'm very new at this and I'm sure there is an easy solution for those experienced users. Thanks! Cynthia
  9. One header for all layouts

    Thanks, that is pretty much what I've been doing. Cynthia
  10. Creating an Application

    Okay thanks.. that's a bummer for those who don't want to invest in an other computer with the other operating system. I do have a Windows computer, but I'd rather use the Mac.
  11. I'm not sure where to post this, please feel free to move this post to the appropriate forum if needed. I'm starting my first desktop application and it's pretty basic, but I wanted to see if I could deploy it so that I can run it, standalone, on my windows computer. I'm developing on my Mac. I don't have FM Pro installed on the Windows computer so would need to be able to create a runtime application, I think, with an installer... at least from what I've read. Is there a way for me to create a runtime application for Windows, but do it from my Mac? Any help with this would be greatly appreciated. Thanks!
  12. Left Menu Area for Navigation

    Great thanks, I'll check that out.
  13. Left Menu Area for Navigation

    Okay thanks... I'm actually learning about Top Header Navigation Parts. That would be fine for me, though I'd prefer it on the left, I can manage with something on the top. It still looks like I need to copy and paste the button bar into every layout that I want it to be in. I'd love if it just would automagically appear.
  14. I'm brand new to Filemaker. I'm trying to figure out how to make a left menu area that will appear in all of my layouts for navigation purposes. To switch from layout to layout easily for the user when my application goes live. I'm not even sure if this is possible, but from what I'm reading, it looks like it may not be. Would there be a way to split a layout into two vertical sections, the left one being the menu (which I can duplicate on every layout if necessary, though that would be a pain), and the right area where the actual program interactions appear? I'm so new that I'm not even what the correct terminology is. Thanks!
  15. One header for all layouts

    This is what I'm looking for as well... a left "Menu Bar" type item that the users can switch layouts quickly and easily, that I can include in all my layouts. I've been googling as well but haven't found what I'm looking for. I'm brand new to Filemaker and it's a big learning curve for me. I'd also love to see a screen shot of what you are trying to do. Is there a way to have a layout split into two... so that the left area holds a menu type item, and then the right area holds the meat of the program? I'm so new I don't even know the correct terms. Thanks!
×

Important Information

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