Jump to content

Fleshzombie

Members
  • Content Count

    6
  • Joined

  • Last visited

  1. @Vitalikssssss Thank you, I was able to figure it out and get it working.
  2. Thank you for the reply, Unfortunately our account does not have access to triggered Actions but that does look like it would be the easiest method to set this up. Also seeing your logic above I probably have to add another condition to the IF statement that keeps it from updating if there is already a value in the Cancel_Notification_Date field like you did. I have been looking into it a bit more and it seems that it may have to do with an update to the javascript/caspio bridge and ajax loading being the reason the code above doesnt work. Do I have to change document.getElementById("caspioform").onsubmit to something including document.addEventListener('DataPageReady', function (event)
  3. I am trying to get a timestamp into a field "Cancel_Notification_Date" when the dropdown for field "Auction_Status" is set to "Cancelled" when the changes are made on a details page for a report, the script is currently in the footer. I have modified a script I found to what is shown below but it is not seeming to submit the data to the table when the form is submitted. The field type for Notification_Date is Text and it is in the details page as a text box currently during building of the page, eventually to become hidden when I get it to work. Anyone know the reason it is not pushing the timestamp into the table? <script type= "text/javascript"> function getT() { if(document.getElementById("EditRecordAuction_Status").value == 'Cancelled') { document.getElementById("EditRecordCancel_Notification_Date").value = '[@cbTimestamp~]'; } } document.getElementById("caspioform").onsubmit = getT; </script> Thank you for the help.
  4. Seems to be an issue with the AND statement, when I remove that I do not get an error. And was successfully able to get results using it like this: CASE WHEN Datediff(day,[@field:DOH],GetUTCDate()) <= 30 THEN '0-30' WHEN Datediff(day,[@field:DOH],GetUTCDate()) < 61 THEN '31-60' WHEN Datediff(day,[@field:DOH],GetUTCDate()) < 91 THEN '61-90' ELSE '90+' END Seems it runs in order, so I do not need the extra operator Looking at it again it may be because I did not include Datediff after the AND.
  5. Trying to do a case statement with results depending on # of days but get invalid formula Incorrect syntax near (. Is it something simple I typed wrong or is this something that I cannot calculate? This is for a calculated field in tabular report. CASE WHEN Datediff(day,[@field:DOH],GetUTCDate()) <= 30 THEN '0-30' WHEN Datediff(day,[@field:DOH],GetUTCDate()) > 30 AND <= 60 THEN '31-60' WHEN Datediff(day,[@field:DOH],GetUTCDate()) > 60 AND <= 90 THEN '61-90' ELSE '90+' END
  6. I have an inventory log which has a running log of items and is timestamped when a new entry is submitted. Because it is a log it has multiple entries for each item (when the particular item switches hands for example) I am trying to create a report (using a table with calculated field) which will show the list of items and the last timestamp associated with each item. I created a calculated field and tried: SELECT TOP 1 Date FROM tbl_Tablet_Inventory_Log WHERE DeviceWirelessNumber=[@field:DeviceWirelessNumber] ORDER BY Date DESC Date is the column from the tbl_Tablet_Inventory_Log with the timestamp, DeviceWirelessNumber is the column name of item I am trying to match on current table with the calculated field I am getting error: Invalid formula: Subqueries are not allowed in this context. Only scalar expressions are allowed. Completely new to sql and would appreciate any help Thanks!
×
×
  • Create New...