Jump to content

Search the Community

Showing results for tags 'timestamp'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Caspio Bridge
    • Caspio Apps for Ukraine
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


MSN


Website URL


ICQ


Yahoo


Skype


Location


Interests

Found 11 results

  1. I am planning to use the tomorrow's or yesterday's date into a button as a query parameter using the [@cbTimestamp*]. I tried using DateAdd(day,1, [@cbTimestamp*]) function but it displays just the text of the function and not a date.
  2. I want to set the default search value for one of my Tabular reports to be today's date + 7 days. When I set the default value today, I usually tell it to receive [@cbTimestamp*] on load but I don't see how I would make it today + 7 days. Any ideas?
  3. I'd like to be able to timestamp when each individual column is updated. Basically, when column "x" is updated, the column "timestamp_x" is updated with the time "x" was updated and when column "y" is updated, column "timestamp_y" is updated with the time "y" was updated and so on. Is there a way to do this with a trigger? Or within the datapage with HTML or with a calculated value? Let me know if you know a solution! Thanks!
  4. Hello guys, How can I use the timestamp as a default or initial value of my DateTime field in a Details page? I set the Form Type to Text Field, but I can't see the On Load option in the Advanced Tab. If I set the field as Hidden, I get that On Load option, but at the expense of not being able to edit it. Please help. -dspolyglot
  5. Is there a way to retain the original format of timestamp date when exported? In the table the format is mm/dd/yyyy but when data is exported it changes to m/d/yyyy. This is the format in the table. While this is the format in the exported file. I need to have the same format(mm/dd/yyyy) for my exported file.
  6. Hi I've tried using this on my footer but it does not work. My datapage is a results page with inline edit set to yes. Below is my script: <SCRIPT LANGUAGE="JavaScript"> function setTime(){ var v_chk=document.getElementById('EditRecordConfirmed').checked; if(v_chk==true) { document.getElementById("EditRecordDateConfirmed").value="[@cbTimestamp]"; } } document.getElementById("caspioform").onsubmit=setTime; </SCRIPT> Thanks. Ivy
  7. Hello! This might be an unusual request, but I am looking for a way to create and stamp a new submission ID on multiple records each time a bulk edit is submitted for a particular DataPage. The ID needs to be unique to other IDs, but it will be stamped on multiple records in the table at the point of submission. My thought was to create a hidden field with a default value, which would be a combination of a prefix (i.e., WO-) and then a system parameter (i.e., [@cbTimestamp]). The problem I'm running into is that I would like the date to be broken down into a numeric string instead of having spaces and punctuation, such as dashes and colons. This is what I'm currently getting: WO-08/30/2017 11:34:46. I would like to get this instead: WO-1504110886. Any ideas on this? I very well may be overthinking things, so I welcome suggestions. We don't have to use the timestamp at all, but it was just an idea for how to create a unique ID at the point of submission.
  8. Hi, would appreciate some help We have customers that ship packages, we would like for the results page tabular, to when a customer clicks on ship (which is a yes/no field) that it marks the current date (NOT the time) so then we can see which package he selected to be consolidated. Afterwards we can make another database where he can click on the dates and see what he requested to be consolidated. In essence clicking YES would put a date in the table. Thank you sooo very very much!
  9. Hi there, I would like to timestamp a field (Test_Completed), but only if it hasn't already been timestamped and only if a different field (Actual_result) has content. I found a forum answer about timestamping a field, and have tried to modify it to include my conditions, but I am not too good with JavaScript! This is what I've done, can anyone help?? <SCRIPT LANGUAGE="JavaScript"> /* Declaration and initialization */ Stamp = new Date(); var v_TimeStamp; Hours = Stamp.getHours() Mins = Stamp.getMinutes(); /* Construct the value of the v_TimeStamp variable in the format m/d/yyyy hh:mm */ v_TimeStamp=('' + (Stamp.getMonth() + 1) +"/"+Stamp.getDate()+ "/"+Stamp.getFullYear() + ' ' + Hours + ":" + Mins); if ('[@field:Actual_result]' === 'input.length >1' && '[@field:Test_Completed]' === "") { document.getElementById("EditRecordTest_Completed").value=v_TimeStamp; } </SCRIPT> Many thanks Nikki
  10. I have a Single Record Update form where once a user has submitted data on Record #123, I want any other users subsequently trying to update Record #123 to be "locked out" from submitting via that form. In other words, I need to be able to disable a form after it's been used once, or when Some_Field = Whatever. You could just disable it with Rules, but if 2 people arrive on the form before either has submitted, then the 2nd User rewrites over the 1st User's data. I need to prevent that from happening. Caspio Support recommends: In order to prevent the next users to submit/edit the same record, the "timestamp check" should be done upon form submission. A solution would be to write a JavaScript function to perform the "timestamp check" and then call the function on the form submission event. Can anyone please assist with this? I'm JavaScript illiterate. Thanks!
×
×
  • Create New...