Jump to content

Mikey

Caspio Ninja
  • Posts

    31
  • Joined

  • Last visited

Everything posted by Mikey

  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
  15. Maybe I can just do something else here... is there any way to set a default image to a submission form into a file/picture field. Would be great to set up a random file from a directory but to be honest if I can just get a default image to be added to a table without the user needing to select it.. I have a form submission for new user.. they enter their information and the system adds a default picture to the profilepic field.. seems simple but not that I can find... any suggestions?
  16. Thank you for taking the time to show this however how would you ever use this in a submission form to select a picture to add to a file field??
  17. Howdy kpcollier, Can you post the code you used for each button so I can look at what you did to create a custom caspio submit and next button. I am doing the same thing and want one button to be a quick add (submit) button and the other to be a next button which passes parameters to a update page to add more info for the user... any help would be appreciated! Thanks
  18. The title does not explain I am sure.. I bulk uploaded a bunch of .png files to a folder in the structure. I created a data page for new contacts as a submission form. I want the user to select a profile pic from the uploaded pics. It works as expected but is there a way to let the person who is selecting the profile picture to get a preview of the pic vs. a list of the filenames? Hope that makes sense, TNANKS for the help and any suggestions!
  19. I will check it out a little closer... thank you for trying to point me in the right direction...
  20. Sorry I did not submit quote properly.. yikes, lol
  21. Hmm, I am not sure what tool you are referring to. The link went to Integromat website which allows for services to interchange. I get that if I had a SQL database elsewhere, created a web upload to the sql, I could then sync back to caspio table with zapier or integroamat.. I am wondering what tool you are referring to within integromat.. what did integromat connect to that then sync'd to caspio table? FYI - thank you for trying to help!! I do appreciate the community of folks that helps us new people!
  22. Hmm, I am not sure what tool you are referring to. The link went to Integromat website which allows for services to interchange. I get that if I had a SQL database elsewhere, created a web upload to the sql, I could then sync back to caspio table with zapier or integroamat.. I am wondering what tool you are referring to within integromat.. what did integromat connect to that then sync'd to caspio table? FYI - thank you for trying to help!! I do appreciate the community of folks that helps us new people!
  23. Hello, all that told me was to use a third party tool to sync to capsio using integromat which is like zapier.. anyone actually do anything like this?/ You know, click a button on a page (some third party tool etc?) to upload a excel or csv into caspio table? If so which third party service did you use?
  24. Newer to caspio and building out an app. The users need to be able to csv and excel import their contact lists to a table. It does not seem that we can allow a user (not back-end import) to import via a web page. Has anyone set this up with 3rd party tools and zapier or something? Or maybe there is a way to do this that I cannot find.. seems pretty basic to allow a user to import their data to a table for them.. got to be a way …. Thank you!
×
×
  • Create New...