7 Replies Latest reply on Jul 7, 2011 10:18 AM by aammondd

    temporary work tables for multi-user solutions

    med

      Title

      temporary work tables for multi-user solutions

      Post

      In my solution I am extracting data from an appointment list table to arrange it in a temporary table and display it as a grid (using a portal) for an appointment scheduling application. The reason for this is that I like to show a grid with columns for different teachers and lines for different times of the day and the order of the teachers columns or their selection can vary according to the user option.

      The solution works fine where the temporary table containes selected data for one day and for a set of teachers which I change with a scripted button that repopulates the temporray table and re-displays the screen for the new day or the new set of teachers...etc.

      In my solution I have all the data tables in other files (.fp7) separate from the solution file which contains the layout, scripts, table occurances AND THE TEMPORAY TABLE (using FM11 Advanced)

      If I want to extend the solution to multi_user I have to somehow create this temporay table in each users computer and use an occurance of it in the solution file. BUT I know the idea and I only need some body to tell me how to implement this idea (the mechanics of doing it)

      ALSO how to solve this issue If I have to use IWP to allow people to book over the internet.

        • 1. Re: temporary work tables for multi-user solutions
          philmodjunk

          To use your temporary table, you'd need to add a field that records the current account or user name, then filter out all records that don't have the current user's user or account name. If this table is displayed in a portal, that means your portal or the portal's relationship can filter out all records not marked with the correct name. In a list or table view, you'd perform a find for this. (Or you may be able to start with an empty found set and then the script that creates each new record whether by Import Records or in a loop sets up a found set only the newly created records--which will only be visible to the current user...)

          A temporary table, however, isn't actually necessary for such a cross tab report. There are ways to use portals in a list view to get your columns of data without physically copying the data into a temporary table.

          • 2. Re: temporary work tables for multi-user solutions
            med

            Thank you for the reply i will try to implement that.

            When you said a temporary table is not necessary...

            I like to add more info ....  it is not just a cross tab report I actually have invisible buttons over every cell of the grid (portal contents) so when the user clicks on it the program knows which teacher and which time is selected for booking ar otherwise. And also I use conditional formatting to color each different type of appointment (I know conditional formatting is slow but I know of no other way).

            If you still think I can do that without using a temporray table I would love to hear your ideas.

            Thank you again.

            • 3. Re: temporary work tables for multi-user solutions
              aammondd

              As a side note not directly related to the layout your are  trying to create

              I  tend to use tables of global fields with a non global userID field. When entering the layout I find the record that matches the accountname (or add a new one if none are found and populate the account name)

              As to Phil's comment I use the temp tables when I want to write out to multiple tables and to control the "save" of information. I can perform complex validations etc. While you may not need to use a temp table it can be useful.

              • 4. Re: temporary work tables for multi-user solutions
                philmodjunk

                It all sounds possible, but I don't know the structure of your data nor the table you want to produce here. As always, the devil is in the details. Likewise, it's crucial to know whether you are using FileMaker 11 or not as the portal filter feature newly added in FileMaker 11 can be very useful here.

                • 5. Re: temporary work tables for multi-user solutions
                  med

                  Let me try more on my own  and if I do not succeedd I will forward the structure and more info to ask for fufther help if you have the time to spend with me. and yes I am using FM11 advanced.

                  For now you idea of filtering using acoount name will do, but eventually it would be more efficient not to use temporary tables.

                  • 6. Re: temporary work tables for multi-user solutions
                    med

                    hi aammondd

                    Thank you for your note but in my case using global fields will not help because I generate many records for each case so I need the records to contain different values not to be global. Unless I am missing your point.

                    • 7. Re: temporary work tables for multi-user solutions
                      aammondd

                      nope you are correct. I use globals when I can though as you state in your case you cant. Temp tables, global or otherwise, have their uses. Mostly to control changes in the  database though.