You mention Instant Web Publishing which implies you are using an older version of FileMaker. What version of FM Server are you using?
It's not the 'name' of the client computer, but would the IP address suffice? "Get(SystemIPAddress)" should return the IP address of the network connection used to connect to the server.
Yes, we are using version 12. Although I would prefer computer name, IP will suffice. So now the million dollar question:
Do I just type "Get(SystemIPAddress)" into the body of the email that FM will generate?
Pretty close, but not exactly. "Get(SystemIPAddress)" is a FileMaker function, thus it can only be used or evaluated in the context of a Calculation window. These windows come up all the time in FileMaker - e.g. the field definition box, the DataViewer 'Watch' list, the "Set Variable" script step, etc.
How are you defining the email body? Are you using the 'Send Mail' script step, 'OpenURL' with a "mailto:" URL, or something else?
Generally, you would include your body Text and the function result in one calculation. Here's what it might look like. The stuff in double quotes is basic text; then the double quotes are ended and the FileMaker concatenation operator ('&') is used to concatenate the result of the function call to the basic text on either side.
You are sending this email from " & Get(SystemIPAddress) & " computer.
It is using a Send Mail script step. I was able to successfully get it added HOWEVER the email is showing the IP address of the SERVER where the database is hosted. I need it to show the IP of the CLIENT computer where the record is being initiated. Can this be done?
Thank you so much,
Hmmm...well, you could try:
In my tests those were device specifc, unlike just the get(SystemIPaddress). Or I should say...I tried them from two devices and got two different values.
Are your users logging in with unique accounts to log into your system? You could use:
...if they are. But if they are all sharing the same account, that won't help you much.
I tried get(persistentID) and get(username) and neither gave me the desired result. Is there some external call that could be made within the script step? I did not try get(accountname) because the URL to access the DB via web browser is programmed to use one user name and password everywhere.
Thank you so much,