Solved

Problem with global fields getting wiped out..??

Posted on 2014-01-13
1
582 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

752 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