On Line Forms

[Lee J]

I'm currently using FMpro 5 to serve up an Online submission form internally.

I have two DB's

Fsubmit.fp5

logintrack.fp5

I'm using the Web Security DB along with custom web pages.

My issue is as follows;

A user get's to a login screen which creates a new entry in logintracker.fp5. This stamps the following details

DateIn

TimeIN

LoginID (user name)

IP address.

I then use a URL to load up the next webpage which creates the main menu for submisions in the DB Fsubmit.fp5

When they are finished they click Logout on the main menu From here I'm trying to write back to logintracker.fp5 the DateOut and TimeOut stamps.

I have used the -RecID tag but this is only good for single entries, the minute I get several people accessing at the same time this seems to get lost.

Q: How can I store the record ID so that it updates the correct record in logintracker.fp5?

cheers in advance

[Lee J]

Cheers hadn't thought of the TOKEN tag

My -New url is;

FMPro?-DB=logintracker.fp5&-Format=home.htm&-Token=[FMP-CurrentRecID]&-New

now I having diffculty writing back a 9FMP-CurrentTime:Short into the associated field.

How should I pass this back?

[Keith M. Davie]

Perhaps I am missing something here. Why are you using a -new action tag to logintracker? I thought you already had a record there. Wouldn't an -edit action be appropriate?

FMPro?-DB=logintracker.fp5&-Format=home.htm&-Token=[FMP-CurrentRecID]&dateout=[fmp-currenttime: short]&-edit

Peace

Keith M. Davie

[Lee J]

Sorry I missed a line out,

The -NEW tag is used when they click the Login URL, a new entry is made into the tracker.fp5 DB and then I move them to start entering details into the second DB submit.fp5.

If the user clicks the Logout, I want it to append (-EDIT) the initial record in the first DB tracker.fp5 and stamp a field with the current time.

I hope this makes it a bit clearer.

[Anatoli]

Use Token(s) for transfering values between pages.

[Lee J]

Ok i See know, it didn't realise you need to carry this across, but for this to work are my URL's from the previous post correct?

as the CDML reference manual is a little low on good descriptions.

[Lee J]

My login button issues the following commands

<a href="FMPro?-DB=logintracker.fp5&-Format=home.htm&-Token=[FMP-CurrentRecID]&-New">

My Logout button issues the following commands

<a href="FMPro?-DB=logintracker.fp5&-Format=exit.htm&-RecID=[FMP-CurrentToken]&Timeout=[FMP-CurrentTime:short]&-Edit">

in between these two functions the users are editing and managing data in the other database and I do not use the Token command again.

The results I get when logging out is Record not found, so my guess is it's lost or reset the link.

what am I doing wrong?,

thanks for your patience

[Anatoli]

You must "carry" tokens through all pages. Then it will be OK.

[Anatoli]

I am using URLs like:

FMPro?-db=prtiskzpr_.fp5&-format=search.htm&-token.1=[FMP-CurrentToken: 1]&-token.2=[FMP-CurrentToken: 2]&-token.3=[FMP-CurrentToken: 3]&-token.4=[FMP-CurrentToken: 4]&-token.5=[FMP-CurrentToken: 5]&-view