Jump to content
  • 0

Updating Timestamp info in Table


Question

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.

Link to post
Share on other sites

6 answers to this question

Recommended Posts

  • 0

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.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...