Jump to content

Mikey

Caspio Ninja
  • Posts

    31
  • Joined

  • Last visited

Recent Profile Visitors

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

  1. Hello and thank you for the response.. Those posts are if you have a date field you want to extract etc. I want a triggered action to timestamp without the time included. I tried adding a field in the table to get a "current" date with a formula but cannot do that.. Not sure where to go...
  2. Hi, I have a triggered action and I need to have it only add a date to a field NOT the time with it.... ANY HELP would be appreciated!!! The timestamp option adds the time.. just want the current date only THANKS!!!
  3. Hello, I have a drop-down field in a form that is using the user table as the lookup to assign a task. The form works as expected, but I want a way where the default item in the drop down list (the drop-down uses the user table for values) is the user who is selecting the task assignment. They can change it of course to someone else, but by default I want it to show their name from the user table.. Any suggestions?
  4. Thank you so much!!! That was it! You rock as usual!!!
  5. </div> <script> var isi = document.getElementById('visi[@field:MarineID]').parentNode.parentNode; if('[@calcfield:1#]' > -31){ isi.querySelector('td:nth-child(8)').style.backgroundColor = '#CC6666'; isi.querySelector('td:nth-child(8)').style.color = 'white'; } else if('[@calcfield:1#]' > -61 && '[@calcfield:1#]' < -30){ isi.querySelector('td:nth-child(8)').style.backgroundColor = '#FFFF99'; isi.querySelector('td:nth-child(8)').style.color = 'black'; } else{ isi.querySelector('td:nth-child(8)').style.backgroundColor = 'grey'; isi.querySelector('td:nth-child(8)').style.color = 'black'; } </script>
  6. Sdly no go.. it is either the redish color or grey.. nothing for the inbetween numbers:
  7. I must have the else if statement wrong
  8. I removed the quotes, and basically same thing, although now it is either the > -31 color or grey.. the issues if getting it to determine the elsi if between 2 numbers... else if('[@calcfield:1#]' > -61 || '[@calcfield:1#]' < -30){ isi.querySelector('td:nth-child(8)').style.backgroundColor = '#FFFF99'; isi.querySelector('td:nth-child(8)').style.color = 'black'; }
  9. Hi, I have a tab report and can color the background of a specific column based on values. If I add > or < i can only get two options.. what I want is style a specific color between two numbers and then everything else grey. Here is what I have so far. calcfield1 > -31 specific color calcfield1 between 2 numbers specific color (between -61 and -30) everything else grey </div> <script> var isi = document.getElementById('visi[@field:MarineID]').parentNode.parentNode; if('[@calcfield:1#]' > "-31"){ isi.querySelector('td:nth-child(8)').style.backgroundColor = '#CC6666'; isi.querySelector('td:nth-child(8)').style.color = 'white'; } else if('[@calcfield:1#]' > "-61" || '[@calcfield:1#]' < "-30"){ isi.querySelector('td:nth-child(8)').style.backgroundColor = '#FFFF99'; isi.querySelector('td:nth-child(8)').style.color = 'black'; } else{ isi.querySelector('td:nth-child(8)').style.backgroundColor = 'grey'; isi.querySelector('td:nth-child(8)').style.color = 'white'; } </script> with this script above.. anything over -31 is correct color #CC666, but everything under -30 is the #FFFF99 color.. but if the number is say -100 it is still #FFFF99. Just need help getting the between numbers working.... Any suggestions. Again, it works when I do not have the else if between.. thank you!!
  10. Anynone know where the styling options for the alert box that pops up for deleting records? Thank you!!
  11. howdy! I have tried your code vitalikssssss and it refreshes the screen but does not delete the record. I am sure it is something I am doing.. but any suggestions why it does not delete the record? Do I need to change any of your code? Also, this is a report list.
  12. I am needing a toggle switch style vs. check box on datapages.. anyone have an easy way?
  13. Hello Kpcollier, how/where did you remove the cbsubmitcontainer?
  14. Anyone have any idea to create a script that will add a profile pic .png file to a submission form on a file field. I am trying to randomly create a profile pic when I add a user to a contact list. The form captures name emai, etc etc and I can add a profile pic field which they can then select from a drop down of files in a folder etc.. BUT I want the system to auto add a random profile pic to a file field. I have noticed that the file field to upload a profile pic in a submission for does not have the option to hide ?? so I found a script in the help pages that hides fields. I assume I can put the script above and below in html blocks to hide the option for the user to see the profile pic options, but want a way to add a profile pic. I cannot get this to work even if I know the exact file I want to add, the random part was just a thought.. maybe? Any suggestion from you caspio/script experts? THANKS
×
×
  • Create New...