Jump to content


Caspio Ninja
  • Content Count

  • Joined

  • Last visited

  • Days Won


vanderLeest last won the day on January 7 2019

vanderLeest had the most liked content!

About vanderLeest

  • Rank
    Advanced Member
  • Birthday March 4

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Thanks so much LittleMsGinger, Three questions: 1. Can you describe the whole process, and how these DataPages each play a roll? 2. What are the DataPages you point to as the value for window.location in the javascripts, for both the Acknowledgement Email and Standalone Login Screen? 3. How did you finish the Details Page (at step 6) ? Does direct to the original/intended destination page? Floris
  2. Thanks CoopperBackpack, your solution worked (almost perfectly). I put your JavaScript in the header of the DataPage, and changed the option around, as title == title1, the innerHTML of the H4 header should read "Add your Invoice and Financial Statement Report". Floris
  3. Hi CoopperBackpack, I will definitively give your suggestion a go (next week) and let you know how I go. Floris
  4. I want to change a header of submission datapage based on a comparison between two virtual fields on the page. The virtual fields are fixed values for the record drawn from an underlying query, using dropdown values. If Virtual 2 <> Virtual 3 a section with a submission field for the Financial Statement Report is hidden (via Rule 1) , and if Virtual 2 = Virtual 3 the same field is set to be required (via Rule 2). I did not create the header, but it looks currently like this: <div class="container mt-3 mb-3"> <div class="row"> <div class="col mb-3" style="display:inherit !important;"> <h4>Add your Invoice and a Financial Statement Report</h4> <a href="https://c4ffn695.caspio.com/folderlogout" class="ml-auto btn btn-secondary">Logout</a> </div> </div> <div class="row"> <div class="col"> If Virtual 2 <> Virtual 3, I want to header to read 'Add your Invoice' and if not 'Add your Invoice and the Financial Statement Report' I tried (to no avail) - with different header values - the following script in the Footer <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { if ("[@cbParamVirtual2]" == "[@cbParamVirtual3]" ) { document.querySelector("h4").innerHTML="Some title"; } else { DataPage, you may try document.querySelector("h4").innerHTML="Other title"; } }); </script> But I am no JS expert Any help sincerely appreciated Floris
  5. The issue resides within an incorrect table name in the join statement in both select queries: The join is pictured with the (alias name of the) T_PA_SubAwards_1 table, it should be with (the original) T_PA_SubAwards. To me this is counter-intuitive (as the line above 'defines' T_PA_SubAwards as T_PA_SubAwards_1), that said, somehow it makes more sense too. ;-) The pictured task will update the SA_Last_MS field in the table T_PA_SubAwards with the Max value of the field PeriodNo in the subsidiary T_PA_Milestones table, but only if that MAx value is different than the current value, or if SA_Last_MS is still blank.
  6. I want to update the SA_Last_MS field in the table T_PA_SubAwards with the Max value of the field PeriodNo in the subsidiary T_PA_Milestones table. The two tables are linked via the fields SA_RecNo and MS_SA_ID. The task pictured runs but gives a value of 2 for all SubAwards with Milestones, and that is correct for most of them, although two SubAwards have 4 and 5 milestones, and these are erroneously set to 2 too. Can someone tell me what is going on?
  7. 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.
  8. 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?
  9. 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.
  10. 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)))
  11. 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.
  12. 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
  13. 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.
  14. '<span style="color:#ffff00;">'+[@field:MS_InvAmount]+'</span>' causes the problem
  15. 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?
  • Create New...