Inserting data in WEB problem

[65710_1428638580]

I'm creating DB with help of FMPro6... for now everything seems to be ok except one point: I publish DB on the web, so some people can edit it. For creating new record I'm using simple script like this:

script NewRecord

 New Record/Request

 Set Field ("Date","Today")

In FileMaker it works perfectly, but when I'm trying to do through the browser, in new created record no data is pasted at all .

What can be the reason?

Thank you!

[Steve T.]

Hi, V! I'm not sure I understand entirely so please forgive me if it sounds silly, but I'm wondering if maybe in FMP, you are creating the record by executing the script, while in the web, you are creating the record with NEW RECORD? If so, the script does not execute at all so the SET FIELD is not performed. On the web, you would have to have the script execute in order to get your desired results... but I do not recomend you use a script to create a new record via the web, anyway, though. IMO, you should avoid using scripts over the web in FM4-6.

Try to use FM built-in functions and calculation fields to do what you want, e.g. define field "Date" to auto-enter Creation Date. I know you were just testing, but try to avoid scripts for web use unless you are prepared to spend a lot time to get them to work consistently.

--ST

[65710_1428638580]

Ok, thanks, I'll try...

just at the end of yesterday's day I've read, that FM (at least ver. 6) restricts number of script steps and script commands available when publishing on web

Anyway, thanks for advice!

[Vaughan]

Use Status(CurrentDate) instead of the Today function.