Solved

Problem with global fields getting wiped out..??

Posted on 2014-01-13
1
578 Views
Last Modified: 2014-01-13
I'm working with a bunch of scripts in FileMaker that make calls to a web host online.  This particular solution is going to be used by different companies, so I'd like to make the domain of the server the scripts are using dynamic so anybody using the solution file can quickly update it.

I created a new table called Global_Config and I added some fields to this table including one called domain.  Then within my scripts I'm pulling the value from this so we can easily change it from the config if/when the domain ever changes.  

It works just fine as long as the value is filled in to my Global_Config fields, however, for some reason all of those fields keep getting wiped out.  I can't figure out why it is, but suddenly the stuff stops working, I run a quick test and I see that it's trying to hit www./something (leaving out the domain.com that would be pulled from the config table.)  

So then I go back and look at my Global_Config layout and the fields are all empty.  

Any information on what could be causing this would be greatly appreciated.  Thanks!
0
Comment
Question by:Andrew Angell
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 25

Accepted Solution

by:
Will Loving earned 500 total points
ID: 39777014
Global fields are not only global to all records in the table but they are temporary in that the values placed in them only exist for the duration of the user's session. The moment you close the file, any values placed in them during your guest session to the server are lost. This allows multiple guest users to place values in those global fields and not affect each other.

In order to have global fields initially populated with a specific value when the file is opened, you need to either 1) populate it on file open via a script, or 2) Stop FileMaker Server, open the file(s) directly in FM Pro, populate the field, close and then Restart the database in FM Server.

If you do the latter method, any values that were placed in a global field when it was in unhosted, single-user mode will be the initial value when a guest opens the file from FM Server. The guest can of course change the value in the field if they have the privileges, but regardless of whether the field is initially populated or blank, any changes made by a guest are lost on opening.

If you are interacting with the file via Custom Web Publishing (CWP) or Instant Web Publishing (IWP) and you want certain values to be in the global fields during those interactions, then you need to use one of the methods above to set them, most likely the second method described.
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question