Jump to content


Caspio Rockstar
  • Content Count

  • Joined

  • Last visited

  • Days Won


kpcollier last won the day on October 25 2019

kpcollier had the most liked content!


About kpcollier

  • Rank
    Advanced Member

Recent Profile Visitors

530 profile views
  1. If you go to their HowTo page > Troubleshooting > Known Issues you will find it. Yes, you have to dig pretty far to even see it. I agree they should've sent out a message. I spent an unruly amount of time trying to fix this issue. Not only, but I was talking to Live Chat about this issue, and they had no clue about the issue until I pointed them to the post on their HowTo page...
  2. The attachment tab already has this feature. If there is an attachment box on your form, you can drag a file to it instead of clicking browse. Maybe mess with the css of the field to make it bigger to let users know of the feature.
  3. Hey all. I am working on this Back button. Two different levels of users for this app - Users and Editors. They both use the same details datapage for records. I have a back button that takes the users back to the Tabular Report results page, however this is where I need to redirect the users based on an auth field. Here is what I have. It does take you back to the Users Report version, but when the auth field is true, it does not take you to the Editors Report version. Any help is appreciated. <input type="button" class="rsAddNew" name="drop" id="redbutton" value="Back"> document.getElementById('redbutton').onclick = function() { if ("[@authfield:Employee_Table_ResourceCenter_Editor^]" == 'Yes') { window.location = "https://00000000.caspio.com/dp/e750500039f-------------"; } else { window.location = "https://00000000.caspio.com/dp/e7505000ba817---------------"; } return false; }
  4. If anyone could help me out with trying to format this, it would be great! ALL of my JS calculations are coming out as just a number. (i.e. '12345.678' instead of '12,345.68'). I think it is because I am manipulating the numbers through the js script above, so it is just ignoring the formatting options. I am not sure. All of the Totals fields are currency datatype, but they still show up as just a number. If there is anyway I can format it as USD currency, that would be great. TIA
  5. I couldn't get it to work. Maybe it is because I the values in the fields I am trying to format are involved in custom js calculations? I am taking an inputted number, multiplying by a few different percents, and the total of that is the value to these fields I am trying to format. They still spit out a number with 3 digits after the decimal point and no ' , ' after 3 digits. To see the custom js calculations, go here. Vitaliks had also helped me with some bugs in that code.
  6. I could also use a currency formatting option for multiple fields. Having a field type and/or format set to currency in the wizard doesn't work for JS computed numbers.
  7. I was originally using calculated fields for this page, but because I have so many of them, it made the loading speed incredibly slow. This is used for estimating so I need a ton of dropdowns and calculations on a single form. Thank you for the updated code - I greatly appreciate it!
  8. There is a post about this in the ideabox here. Not sure how often they actually check that page but it might help somewhat. I want this feature as well.
  9. IMO, It is still unbelievable that the 'leading' no-code platform does not support a document/pdf style datapage. All these work-arounds to get a page to go to PDF/make a document really shows the age of Caspio's infrastructure.
  10. Also, I have read that parseFloat is not good practice for calculations. However, when I try parseInt or anything else, it just adds up the fields like strings. So 2000 + 1234 would be 20001234 instead of 3234.
  11. If someone could help me with a couple of things: 1). When the page first loads, all of the Total fields start with NaN. Is there a way I can start them out as blank, or 0? I tried putting in a placeholder, but it still doesnt work. 2.) I cannot seem to figure out how to get the currency format to work on these Total fields. The SubTotal ends with 1 digit after the decimal point, and the County Tax Total often has many digits after the decimal. Is there a way I can format all of these Total fields as currency? They are already set as Currency DataType and I have the app localization set for currency as well, to no effect Thanks again. //Virtual 13 is the new subtotal after calculations document.addEventListener('DataPageReady', function (event) { function calculate() { var subTotal = parseFloat(document.getElementById("InsertRecordSubtotal").value); var markUp = parseFloat(document.getElementById("InsertRecordMarkUp").value); var countyTax = parseFloat(document.getElementById("InsertRecordCounty_Tax").value); var miscPerc = parseFloat(document.getElementById("InsertRecordMisc_Percent").value); var freight = parseFloat(document.getElementById("InsertRecordFreight_Total").value); var markUpTotal = document.getElementById("InsertRecordMarkUp_Total").value = (subTotal) * (markUp); var countyTaxTotal = document.getElementById("InsertRecordCountyTax_Total").value = (subTotal) * (countyTax); var miscPercTotal = document.getElementById("InsertRecordMisc_Percent_Total").value = (subTotal) * (miscPerc); document.getElementById("cbParamVirtual13").value = (subTotal) + (markUpTotal) + (countyTaxTotal) + (miscPercTotal) + (freight); } setInterval(calculate, 1500); });
  12. Pictures of the Material and Labor fields for better understanding.
  13. I work in a subdivision in Construction. We bid on construction jobs. I am trying to add an estimating app to our fleet of Caspio apps. The problem I am running in to is my Estimate_Table is friggin' huuuuge. First, we need at least 10 spots to list out the materials we are planning on using for the job. So, we have a field to list what material it is (x10), plus a field for the currency total of how much the material costs (x10). This takes up 20 fields, plus a final 'Total' field to add the sum of all together. Now, the big part. For each material listed, we have to list labor charges to fabricate and install the materials. So, in reality, I would need 20 labor fields to cover the Install and Fab of each material. It would go like this: Material 1: Glass Windows, $2000. Labor 1: Glass Windows, FAB, $1000. Labor 1: Glass Windows, INSTALL, $1200. However, with each Labor field, we don't just put in a currency number for the total. We do it by how many hours it will take x the currency rate of the labor. Meaning each labor line will have 5 fields each. a Labor field to choose what material it is for, the phase (install or fab), the hours needed for the labor of this material, the rate charged, and the total. The labor lines alone would take up 100 fields. Material 2: Aluminum, $2000. Labor 2: Aluminum, FAB, 10 hours x $45, $450 total. Labor 2: Aluminum, INSTALL, 12 hours x $50, $600 total. Please keep in mind - the actual material values are coming from a lookup table already. So, the Materials fields mentioned above use a lookup table to get its material value. I am also trying my best to keep this on ONE submission form - not a multi step form. The reason for this is because our estimator will need to be able to look at the material section and the labor section simultaneously while he is doing his work. I am using collapsible sections to keep the form smaller in size. I am also using making all calculations with custom JS. I orginially had it with calculated fields, but the load times were around 2 minutes. Changing it to all written JS improved the times to 30 seconds, which is still way too long for me. I believe the reason my app is so slow is because my main table has 150 fields in it. Sorry for the long post. Just looking for some insight if anyone has made something like this and could give me some pointers on a better way to build it.
  14. kpcollier

    Estimate app

    Over a year later, I am finally coming back to this. My problem with this is that in my line of work, we have a TON of materials that can be included in our bid. Different types of metal, glass, frames, etc. My Estimates table has over 150 fields in it. The submission form needs to have access to most of these fields. I need more-than-enough input fields because the sizes of the jobs we bid range from small to very big - so wee need access to as many inputs as we can get. At first, I did the entire sub form in calculated values to get it to work. It looked awesome, the function was great, but the speed of the page was horrendous. Every number change you made would take ~3 seconds to update the page. Definitely not user-friendly. So, I tried changing the calculations to JavaScript. There is a ton of calculations, to remind you, so I haven't got through them all (probably about 80% of the calcs are now through JS) but this really hasn't helped the speed of the page. It still takes over 3 seconds to open it. One thing that would help a TON is if I could somehow find a way that my internal users could upload an excel sheet (the way estimates are made as of now) and have it populate the form, or just populate straight to the table. This way we still have all of our number figures that we can run reports off of, but the system of making the estimate doesn't change. However, I do not believe that is possible. If anyone has made any sort of app like this, I would love to hear how you did it! I am open to anything.
  • Create New...