Jump to content

bookish

Caspio Ninja
  • Posts

    60
  • Joined

  • Last visited

  • Days Won

    5

bookish last won the day on March 25

bookish had the most liked content!

1 Follower

Recent Profile Visitors

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

  1. HI @CoopperBackpack, I used your second script (pop-up message instead of browser alert). It worked! I just had to put the code because if the one booking typically uses CAPS then the form will submit. const nonDietRegex = /room|floor|bedroom/i; if(nonDietRegex.test(textField)) {
  2. Thank you so much @CoopperBackpack I confirmed these worked: Using Calculated Value Hide Field However, the formula must be in between ' ', that is '[@field:ID]' + '[@field:ACTIVITY_TYPE]'
  3. Thanks so much @CoopperBackpack I will let you know how it goes !
  4. Hi everyone! I hope you can help me. The deprecation of the option to disable AJAX loading will affect this code that needed a table tag <table style="display:none;">. What would be my alternative so that I can still have no one see the combination created after every form submission. <SCRIPT LANGUAGE="JavaScript"> var iID = document.getElementById("InsertRecordID").value; var iACTIVITY_TYPE = document.getElementById("InsertRecordACTIVITY_TYPE").value; var combined_ID = iID + iACTIVITY_TYPE; document.getElementById("InsertRecordcombined_ID").value = combined_ID; </SCRIPT>
  5. Thank you so much @CoopperBackpack! I will try it soon (this weekend) and I will let you know how it works for my programs!
  6. Hi! Would anyone help rewrite this script now that onsubmit will not work anymore (re disable ajax loading)? Thanks in advance!
  7. I am looking for this. Thank you @wgalliance When you say Webpage, do you mean the datapage has to be embededded somewhere? Will it not work in a deployed caspio URL?
  8. Thank you very much @Volomeister I will use this in similar needs in the future!
  9. Thank you very much @Ilyrian and @Volomeister for the proposed solutions. The solution not to use a Javascript did not work for me. The Calculated field was not working. And as the View Details link still appeared, I thought I should choose No in "Do you need a Details Page for each record?" But the Calculated field seems to require a new datapage for which I don't have any more allowance in my plan. I went back to the topic which I started, use the solution of @DefinitelyNot31337 and it worked with my LIST type of report I just replaced all pertinent words with DetailsLink.
  10. Thank you! It worked with a tabular report datapage, however I am using List. Is there a portion of the script I need to change?
  11. Hi, I use Filestor in my plan and in creating the Task that sends an email message that must have a file (schedule or program of activities), this is what I did: -I created a schedule text field inside my table. -I filled it with the URL address of the file https://xxx.caspio.com/XXXXXXX/folder_name/filename.png. The triggered email showed the entire URL in hyperlink. I have checked that the link is a live link (showing my schedule image/screenshot). I put this experience here if it could be useful to anyone.
  12. Hello! Is there a way to disable the "View Details" record action if a certain [Field:Name] = "Test1" I already have datapages where the link to the details page is through a html block, and that is easy to hide based on a condition using javascript. Thanks in advance !
  13. So this is what I did now, and it's working 1. Calculated field: not hidden at all CASE WHEN [@field:Schedules_ACTIVE] = 1 AND [@field:Schedules_Enddate] < SysDateTime() THEN 'Code C' ELSE NULL END 2. Footer to change record background <script> document.addEventListener('DataPageReady', colorHandler); function colorHandler() { let lines = document.querySelectorAll("td:nth-child(5)"); // 5 is the column order number lines.forEach(line => { if(line.innerText.startsWith('Code C')){ line.parentElement.style.backgroundColor = '#FF5C45'; } }) document.removeEventListener('DataPageReady', colorHandler); } </script> Happy for now Thanks @Ilyrian and @CoopperBackpack
  14. After the change in the calculated field and the proposed change of @CoopperBackpack on the single =, everything you said here worked including hiding the column. Thanks so much! I am just hoping for the tweak of my script if possible .
  15. Thank you so much! That was simple and brilliant, esp for a non-programmer like me But does it mean that this script (the second condition in particular) won't work in this case? I truly appreciate the solution by @Ilyrian but I am still hoping there is a simpler solution. Could this script be tweaked? Once or twice it worked but it didn't after, when I previewed again. There is something that is not reliable in this script. <span id="[@field:Schedules_Enddate*]changeColor3" style="color:white; background:red"></span> <script> if("[@field:Schedules_ACTIVE^]" == "Yes" && [@field:Schedules_Enddate] < SysDateTime() ) { document.getElementById("[@field:Schedules_Enddate*]changeColor3").innerHTML='Code C'; } </script>
×
×
  • Create New...