[FMP-CurrentDate] revisited (newbie)

[wavegirl]

I'm trying to make a little helpdesk database that can be accessed through the company Intranet. In the filemaker database I have a date field which enters the date automatically and prohibits any other input. I want to be able to do this via the html/cdml interface as well. What I have is:

<P ALIGN=right>date:</P>

</TD>

<TD>

<P><INPUT TYPE=text NAME=date VALUE="" SIZE=30></P>

Okay fair enough. So I tried putting the value in as [FMP-CurrentDate] but this only shows up as [FMP-CURRENTDATE] in the browser. If I try to remove the INPUT TYPE and just have it show up as the date it just shows up as [FMP-CURRENTDATE: short] - but even if this worked I'm not sure if it would update the date field in the database. In fact I can't get get the [FMP-CurrentDate] replacement tag to work at all. Does anyone know what I'm doing wrong? By the way I'm using the Claris HomePage 30 day demo to generate the CDML/HTML if that's any help.

[Jeff Spall]

Hi, what you're trying to do will work fine. the field code is just like you had it:

<INPUT TYPE=hidden NAME="the_date" VALUE="[FMP-CURRENTDATE: Short]">

BUT you must call that page through FileMaker like:

"mydomain.com/directorypath/FMPro?-db=mydatabase&-lay=web&-format=mypage.html&-View"

if you just call it as

mydomain.com/directorypath/mypage.html

then that field doesn't get substituted with a value.

regards, jeff

[wavegirl]

That was pretty much it, though I never did manage to get the path right, but as the DB was in the same folder as the html/cdml pages I stopped trying and just got rid of the path altogether, which worked. Now if I could only get the access privileges sorted so it actually creates a new record....

Thanks for the help, very much appreciated!

[Jeff Spall]

Hi, If you're webserving direct through FileMaker, then it thinks its root path is the inside of the 'web' folder which should be in the same folder where the FileMaker application sits. FileMaker doesn't care where the databases are located, only the html pages and in fact it's best to have databases in a directory 'above' the web folder level or even a different partition.

So:

http:mydomain.com/FMPro?-DB=stuff&-format=homepage.html&-view

will call 'homepage.html' if it is sitting on the top level inside the FileMaker 'web' folder whilst:

http:mydomain.com/thefolder/FMPro?-DB=stuff&-format=homepage.html&-view

or

http:mydomain.com/FMPro?-DB=stuff&-format=thefolder/homepage.html&-view

will call it if it is inside 'thefolder' inside 'web'

the first form of the url is much better because it makes writing relative links within the page html simpler.

What's the problem with creating a new record?

regards, Jeff