1 2 3 Previous Next 160 Replies Latest reply on Dec 20, 2012 9:44 AM by philmodjunk

    Entering New Record off a portal

    MikeProcopio

      Title

      Entering New Record off a portal

      Post

           I have a basketball database in which I have a layout for game scouting reports. I have a portal in the layout where when I select a player there is a portal tha pops up with all of their teammates. I would like to setup a button in the portal when I click on it that player is the new record that is created in this scouting report.

            

      Screen_Shot_2012-11-05_at_10.04.07_AM.png

        • 1. Re: Entering New Record off a portal
          philmodjunk

               Set Variable [$PlayerID ; PortalTableOccurrence::PlayerID ]
               Go to Layout [//select layout based on scouting report table]
               New Record Request
               Set Field [ScoutingReport::PlayerID ; $PlayerID ]
                

          • 2. Re: Entering New Record off a portal
            MikeProcopio

                 For some reason it creates a new record for the current player. Here is a picture of the scouting report. Maybe its not possible

                  

                  

            • 3. Re: Entering New Record off a portal
              MikeProcopio

                   So I enter a new record and select a player from both teams so I have their roster of players that are on both teams. I want to select an ID number from the portal and then a new record appears with the selected player's ID etc .

              • 4. Re: Entering New Record off a portal
                philmodjunk

                     It's very possible, I use this method all the time.

                     Is the button that performs this script located in the portal row? That way the mouse click on the button also puts the focus on the desired portal row so that the set variable step copies an Id value from that portal row record.

                • 5. Re: Entering New Record off a portal
                  MikeProcopio

                       The button will be on the player ID located in the portal row.

                  • 6. Re: Entering New Record off a portal
                    MikeProcopio

                         Here is my script

                    • 7. Re: Entering New Record off a portal
                      philmodjunk

                           If you enter layout mode, what text appears in the lower left hand corner of your portal?

                      • 8. Re: Entering New Record off a portal
                        MikeProcopio

                             You got me, totally had it linked with another table. I'm getting better, but its a process. 

                              

                             On another note got interviewed by PR made sure you were mentioned.

                              

                             Just got FM 12 late to the party but very impressed. What are some new features like Dashboard. WOuld that help me and is it easy to setup??

                              

                             I saw something where you can have instructional videos for your solution off of a container fiels. FLoating windows I think? Are they effective??

                              

                             Thanks Phil

                        • 9. Re: Entering New Record off a portal
                          philmodjunk

                               Dashboard is a specific type of layout that is not unique to Filemaker 12. it's just a layout that is designed to be the Main Menu or the "control center" for your database solution. Typically, it displays summary type infor about your database and provides buttons to take you to different parts of it.

                               You can insert videos into a container field fo nearly any version of Filemaker, but with FileMaker 12, you can optimize the container field for interactive contact which gives you some nicer options for playing back an audio or video file or for flipping through the pages of a PDF file--all without having to open the file in another application.

                               Filemaker 12 is definitely a mixed bag--not something to transition to linghtly as it offers some significant advantages, but the version also introduced a great many bugs--some of which have been resolved by the release of the 02 and 03 updaters, but the 03 updater also introduced a new bug not found in the original version and many others have not yet been addressed.

                               Whether those bugs will create significant issues for your solution or not requires careful evaluation.

                          • 10. Re: Entering New Record off a portal
                            MikeProcopio

                                 Phil how do you use a floating windor? Or is it alled a floating lqyout?

                                  

                                 As far as a Dashboard how do you set that up? I setup dashboards in the past, but basicall just making a blank layout and filling it with portals, but if there is a better way I'f like to explore it.

                                  

                                 Last thing is on the container field. How would I set up a video to record a note to remind myself to do somehting on the database? I'd like to have a button that I can push and the bideo appears. ANything special that I need to do for that??

                                 '

                            • 11. Re: Entering New Record off a portal
                              philmodjunk

                                   A floating window for what purpose? In all recent versions of FileMaker, you can open multiple windows by using the New Window script step. What's new in FileMaker 12 is that New Window can now specify some additional window properties such as "modal" which locks the user into working only with the newly opened window unttil it is closed--just like you get with a modal dialog such as the Print Dialog.

                                   That's all dashboard really is, a blank layout with lots of buttons. I often define a table with zero or just one record for use as a Dashboard or main menu layout.

                                   You can record an audio file into a container field in at least FileMaker Pro, if your hardware includes a mike, I believe, but don't know if FMP 12 added that capability. There is no built in capability for recording videos.

                              • 12. Re: Entering New Record off a portal
                                MikeProcopio

                                     Phil the reason for the floating window is to remind me of new procedures for my database . I actually had a file from a class that I took. It worked great as far as a small video that I made recording my screen to remind me.

                                      

                                     i made a dashboard a year ago for my solution although I usually have a lot of records in that layout for some reason. I didn't know if I was doing something wrong or not 

                                • 13. Re: Entering New Record off a portal
                                  MikeProcopio

                                       Phil,

                                       WHen making a dashboard what table do I associate it with? I've been associating it with the main table withmost of the information is. Is there a better way?? I have most of the functionality that I want with it exept a couple of things. I keep notes on players like intel that is in th enewspaper. I want to set a portal up that gives me the list of notes on all players and sort it by date, but since the layout is associated with the player Table that it only gives me info for the record number that the dashboard is on and switches everytime I click to a different record.

                                        

                                  • 14. Re: Entering New Record off a portal
                                    philmodjunk

                                         It doesn't much matter what table you use as long as your interface design is solid. You normally wouldn't want a user to be able to create a new record in your main table by selecting new record from the records menu or pressing the keyboard shortcut for the same while on the dashboard layout.

                                         A custom menu can prevent his.

                                    1 2 3 Previous Next