Updating Timestamp info in Table

[maverick]

I have a table of 3000+ records which has a timestamp field in it. The Table is setup to capture the timestamp on "record creation" & "record update".

However when I Import the Excel spreadsheet, the timestamps are no populated on record creation. They will however update if I make any changes to the table from within the bridge.

I have some pricing data in the table that will be updated on a daily/weekly basis. I was planning on updating the Excel spreadsheet with the latest prices daily/weekly and then importing it into Caspio with "Replace existing Table" option. This way I could do a bulk update of my records. But I need the timestamp to reflect the update. How do I do this?

Thanks for your help in advance.

[MayMusic]

Time stamp only triggers upon each page submission :? :? :? You need to update the date in the excel sheet you are importing as you mentioned your self which is easy in Excel :!:

[maverick]

Thanks for your response MayMusic.

I should've mentioned that the price field can also be updated via individual update form submission. So do you know if I can update the _SAME_ timestamp field in Excel (and upload) and also have it auto-update later when the record is changed via form submission.

[maverick]

Just tried it out and it works!

Thanks again MayMusic!

[maverick]

By the way, there's an easy way to auto-update timestamps in excel. Thought somebody else might find it useful too.

http://chandoo.org/wp/2009/01/08/timest ... mula-help/

[MayMusic]

Thank you

[julataylor]

thanks from me too...i was stuck in problem for long time.