vanderLeest

Thank you both LittleMsGinger and CoopperBackpack so much Once you know these options, it is easy. Sadly enough, I did not find them myself intuitively.

I would like to format the auto-email on submit of an update form as neatly aligned table Vendor Number [@SA_Vendor_ID] Invoice Number [@MS_InvNo] Current Date [@Date()] Total Amount [@MS_InvAmount] Currency (fixed “USD”) SES Number [@MS_SESNo] PO Number [@SA_Purch_Order] How can I make this happen?

The limit for Number fields is 15 digits (including a floating decimal), and 10 digits for an Integer field. A minus sign counts as a digit in the case.

Thanks SunakoChan. to create a rendering of a period between a Start and and End date like Jan '19 - Feb '20, Dmytro and I came up with the following formula (for a formula field), using your substring idea: CONVERT(VARCHAR, (SUBSTRING('Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ', ((Datepart(month, [@field:MS_StartDt])) * 4) - 3, 3))) + ' ' + Char(39) + CONVERT(VARCHAR, (Right(Year([@field:MS_StartDt])+ 1,2))) + ' - ' + CONVERT(VARCHAR, (SUBSTRING('Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ', ((Datepart(month, [@field:MS_EndDt])) * 4) - 3, 3))) + ' ' + Char(39) + CONVERT(VARCHAR, (Right(Year([@field:MS_EndDt])+ 1,2)))

Thanks this works I used: CASE WHEN LEN([@field:MS_InvAmount]) > 0 AND Len([@field:MS_Budget]) > 0 AND Round([@field:MS_InvAmount],0) > Round([@field:MS_Budget],0) THEN '<span style="color:red;">'+cast([@field:MS_InvAmount] as nvarchar)+'</span>' ELSE CAST([@field:MS_InvAmount] as nvarchar) END But sadly, instead of $300,000 in red, I get 300000.00 in both the Result Page as well as in the Details Page of my Tabular Report DataPage.

Hi Jan How can I compare two currency fields - set the Display Only on a Report Details Page - and if the Invoiced value is higher than the Budget value, color the text of Invoiced value red and its background yellow? Thanks for your help

A Report Detail DataPage DP0 shows an overview of Milestone Information, and using the Milestone_ID, I want to open a second DataPage (DP1) unseen; DP1 is based on another View, and should generate / automatically download a one record XML spreadsheet on the PC of the user. The idea is that users click on the link in DP0, and the download should start automatically. NB: The link to DP1 on DP0 will only be visible when all necessary criteria for DP1 are met. Workflow: An in-house team will be the only ones having access to DP0, via group authentication. They will use DP1 to check the completion of the current 'open' milestones. When all reports are approved and a purchase order has been entered, they should be able to download the XML sheet, and mail this template from their PC to the another in-house office for actioning.

'<span style="color:#ffff00;">'+[@field:MS_InvAmount]+'</span>' causes the problem

Thanks , Sadly CASE WHEN [@field:MS_InvAmount] > [@field:MS_Budget] THEN '<span style="color:#ffff00;">'+[@field:MS_InvAmount]+'</span>' ELSE [@field:MS_InvAmount] END is an invalid formula. Will the formula field be displayed as short currency, i.e. $12,567?

Hi, I would like the Invoiced value to be red or have a red background if its is higher than the Budget value. This Image is a snip of a Report Details page, where the fields shown as all Display Only. Both fields MS_InvAmount and MS_Budget are Currency fields. I tried versions of the code above but without success.

I'm happy to answer my own topic. the following script works: document.getElementById("EditRecordMS_FSR_Comment").onchange = function(){ var entered = document.getElementById("EditRecordMS_FSR_Comment").value; if (entered.length > 0) { var currentdate = new Date(); var datetime = currentdate.getDate() + "/" + (currentdate.getMonth()+1) + "/" + currentdate.getFullYear() + " " + currentdate.getHours() + ":" + currentdate.getMinutes() + ":" + currentdate.getSeconds(); document.getElementById("EditRecordMS_FSR_CommDt").value = datetime; } }; And don't forget to set the receiving field to a Text field on the Report Details Page. (if set as Display Only it cannot be updated)

I noticed one error in the script above: the field in the last line before </script> should be referenced as document.getElementById("EditRecordMS_FSR_CommDt").value = datetime; Even with this correction, the MS_FSR_CommDt is not updated

I want to set a Comment Date field to the current date time, when the associated Comment has been entered and/or updated on a Details Page of a Search and Report DataPage. From code found in previous topics, I constructed the following JS script, but sadly it is not working. Any help will sincerely be appreciated (as updating the field via a Table Trigger creates too many cascading actions). PS On the Stack Overflow site, I picked up the suggestion to add an eventlistener statement MS_FSR_Comment is a TEXT (255) field with Text Area on the Details page MS_FSR_CommDt is a Date/Time field <script> document.getElementById("EditRecordMS_FSR_Comment").addEventListener("change", function(){ SetFSRDate; }); Function SetFSRDate(){ var entered = document.getElementById("EditRecordMS_FSR_Comment").value; if (entered.length > 0) { var currentdate = new Date(); var datetime = currentdate.getDate() + "/" + (currentdate.getMonth()+1) + "/" + currentdate.getFullYear() + " " + currentdate.getHours() + ":" + currentdate.getMinutes() + ":" + currentdate.getSeconds(); document.getElementById('MS_FSR_CommDt').value = datetime; } } </script>

Thanks for your reply and idea, Andrew. I've added this suggestion to the Caspio Idea Box, http://ideabox.caspio.com/forums/164206-caspio-bridge/suggestions/39180958-concatenate-filename-for-download-of-search-result Waiting for votes ;-)

I would like to construct the Excel File name as a concatenation of field values (and text). One idea is to concatenate the filename in a calculated field on the DataPage, and then submit this field in the File name textbox on the Advanced tab of the Result Page options https://howto.caspio.com/faq/reports-datapages/how-to-make-the-search-results-downloadable-for-my-users/ (by default I can add a date value to the file name). The search result will be a single record.