Jump to content

Joemac

Caspio Ninja
  • Posts

    47
  • Joined

  • Last visited

Everything posted by Joemac

  1. I keep having an issue where when I have an ampersand (&) keyed into a caspio submission form it always removes the ampersand and all text that follows. Any ideas?
  2. @Tubby - very cool thanks.
  3. I've noticed my Caspio app has had performance hiccups lately and I'm not sure if its my setup. Sometimes it runs quick and other times is runs slow and/or needs to be refreshed to work. Are there any guidelines on how to get the best performance out of my application? I have 100+ datapages and over 6GB on storage so far - not sure if that affects speed.
  4. @Tubby - duh! I knew I saw that somewhere before.
  5. Does anyone know how to remove the record counter at the bottom of a tabular datapage? See below.
  6. @TellMeWhy - thanks for taking the time to write this for me - much appreciated. For some reason I can never add in the fields and get these to work, I cannot get the syntax down. So just looking at the start button I'm hoping you can walk me through this. So I'm in a Single Record Update DataPage. The field is a date field called ink_start from the table called tbl_drops. So when I use the field picker it looks like this [@field:tbl_drops_ink_start*] So based on that what would the code below look like once I added in the information I need to get this working? I'm thinking I'm not writing the correct thing under the "InsertRecordFIELDNAME" <script> document.getElementById("button1").addEventListener("click", function tx(){ var date = new Date(); document.getElementById("InsertRecordFIELDNAME").value = date.toLocaleString("en-US").replace(',',''); document.getElementById("button1").removeEventListener("click", tx); }); </script>.
  7. Can someone help me create a button that when clicked it timestamps a date field? I have the start and stop fields below and my users have to key in the time and keep forgetting to add the time or remember to select AM or PM. Thanks!
  8. I'd like to filter based on records that are 14 days past the prod_complete_date field below. Is there a way to do that within the set up below? Not sure how to write that out.
  9. Hello. From time to time users within my Caspio App will need to import address lists that range from 10 to 100 addresses into an existing table. Instead of importing them through Caspio bridge (or entering them one at a time) is there a way to import them in thru a DataPage? With my old Access Dbase they would just copy and paste into a dataview. Thanks!
  10. @CoopperBackpack - thanks for your help - I used the first one and it works! However it doesn't subtotal the groups (see below). Any idea on how to fix this?
  11. Hello. I have an aggregate function on a datapage to sum up all minutes keyed into a number field. I need to figure out how to convert that total number into hours/minutes. For example if the total number is 75 minutes I can divide that by 60 and get 1.25 but I'd rather it say 1.15 or 1 hour and 15 minutes. Thanks for any help.
  12. @kpcollier thanks for the recommendation. @LWSChad Can I contract you to do this for me?
  13. @kpcollier - Can I hire you to build this out for me?
  14. @TellMeWhy - not sure if this is allowed to ask in here but can I hire you to help with this type of stuff and also create some automated emails through Caspio?
  15. We’d like to create a set up where on an iPad we can navigate to a project in Caspio, take a picture of something with the iPad and have it automatically attach it to the record. Does anybody know if this is possible?
  16. Not sure if this is ok to ask here but I'm looking to hire someone to help create automated emails through Caspio. Anybody out there that can help?
  17. Hello all. I'm looking to create a field that counts how many associated records are in a separate table. For example I have a client_table and jobs_table that has a one to many relationship. I want to calculate how many total jobs each client has. Any ideas?
  18. @TellMeWhy - I'm doing a single record update form. The field called design_status is a drop down field on the datapage. Maybe thats the issue?
  19. @TellMeWhy - sorry I have almost zero understanding of JS. Here is what I updated it too and it still doesn't work. <script> document.addEventListener("input", function colors(){ var field = document.getElementById("InsertRecorddesign_status").value; if (field == "Proof Approved"){ document.getElementById("InsertRecorddesign_status").style.color = "red"; } if (field == "Need to Proof"){ document.getElementById("InsertRecorddesign_status").style.color = "green"; } }); </script>
  20. design_status is the field name Out on Proof and Proof Approved are values that could be entered into that field.
  21. @TellMeWhy I tried and couldn't get it to work. Here is exactly what I wrote. Any help? <script> document.addEventListener("input", function colors(){ var field = document.getElementById("design_status").value; if (field == "Proof Approved"){ document.getElementById("design_status").style.color = "red"; } if (field == "Out on Proof"){ document.getElementById("design_status").style.color = "green"; } }); </script>
  22. @TellMeWhy - thanks for your help again
  23. @TellMeWhy - Cool thanks! So if I wanted to recreate this in my Caspio I would copy and paste this into the header of that datapage right? Also I just change the InsertRecordTitle to my actual field name right? Anything else I need to change on my end (aside from the colors).
  24. I've mostly worked in Microsoft Accces where I'd use conditional formatting on fields to change the color of the text in a field if it equaled a certain value. I have found a way to do this in Caspio with check boxes but not with regular fields. So for example if a field = Proof Approved I'd like it to be in red, if anything else have it black. Any suggestions?
×
×
  • Create New...