Jump to content


Caspio Guru
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by roattw

  1. Thanks for the offer. The localization decimal place setting didnt work either. Here is the formula I need to round to no decimals. (4*[@field:Burn_Amnt]*[@field:Weight])+(1500*[@field:BSA])
  2. ok thanks. just wanted to see directrix's solution as well. exact same?
  3. Yes! Teasing me without telling me the answer?
  4. Thanks for the reply. I think I got lucky. They all seemed to work since fairly basic. Although I cant get the Round() function to work without a syntax error.
  5. The rounding applied in location did not work. Still getting calculation with 4 places after decimal, want none. Tried to us Round() in the calculated field but always throws syntax error. For example, this calculation works: (4*[@field:Burn_Amnt]*[@field:Weight])+(1500*[@field:BSA]) But every which way I try to apply Round() to it it throw invalid formula error. As always, thank you!
  6. Need to convert an Excel based form with calculations to Caspio. Will straight Excel formulas work or will it need lots of tweaking of conversion to to JS or SQL? Thanks!
  7. Thanks for the reply! I checked those first. I did a text search for .ListDate and .item in all the CSS (both Caspio and Weebly applied). Didnt turn up anywhere. Thats what confused me. Chrome Dev Inspect showsit renders as that and it plainly and being called from Casio somehow at https://c3ebv137.caspio.com/scripts/Core/Dialog.css Wierd.
  8. Yes! But will have form B hidden. Usualy I make it way more complicated than it needs to be ;^)
  9. Good question. Static I guess. Not in a table anywhere,trying to create it programmatic.
  10. I know this has been done in several variations with list boxes and autocomplete. But I cant get it to fire in my scenario. Possibly because Im trying to accomplish this with same table/DP? Two fields A and B. Field A is Yes/No. B is hidden waiting to receive a value. If A=Yes, hidden field B should be completed with value "candidate". Simple, but alluding me. Triggered action, calculated field or passed parameter? Hoping not to have a separate table just for this option, only to put it back in there with a view.
  11. I have a site I need to increase space between listbox items, increase space between checkbox and label, and show full list box item width, and maybe loose scroll (show all). Chrome Dev clearly shows the the code, .ListData .Item and when I increase line-height: it increases space between listbox line choices. Some of the code comes from Weebly were hosted, and some from Caspio. But I cant find this resultant CSS in the Weebly style editor or the Caspio style editor. Chrome Dev seems to point it to code originating from Caspio though: https://c3ebv137.caspio.com/scripts/Core/Dialog.css and I dont know how to access that area. Thoughts? Need to 1. which margin or padding woud increase space btwn check box and label entry. 2. Expand box area to show full entries veritcally and horizontally, no scroll?
  12. Vitalikssss Thanks for the reply, sry for delayed response! The code did place the top scroll bar but it had nu functionality. Shows gray bar, scroll advance triangles, but no actual scrol fucntionality.
  13. All of a sudden people are reporting an increase in those Firefox and Chrome warnings for our sites like invalid certificate, Connection not secure, Connection not private messages. Firefox reports the certificate/connection not secure: Chromes seems to give the Connection not private: All embeded code and URLs reference https: Not sure how to avoid this, or why all of a sudden its started. Thoughts? Many thanks!
  14. Have a very wide report page and users request to have 250 records per page. Scrollbar appears on bottom but we would also like on on the top. Can two scroll bars be achieved? Thanks
  15. Me too. 6 users so far, documents. Seems very coincident to the last Caspio update maybe?
  16. Thanks for the careful reply. I had already figured it out but this will help others.
  17. I followed the instruction for Filter Results on a Single Web Page. It works but but I need the results page to only show results meeting one of the search form criteria. Search form has Name (drop down of names from table) and Type of Submission (drop down with two options - CME or Compliance) Search returns all the entries for chosen name, but I also need it to NOT show report fields that are empty that dont meet the Type of Submission Criteria, in this case Compliance. So below would like to see the 3 CME columns hidden. Alternately, if type was CME, to then hide the Compliance columns. Using the Filter Results on a Single Web Page instructions there is no option to apply a rule to the results page.
  18. Thanks for the response. If I am reading that correctly it is a great tool but might not work for this task. We can get the files to download currently, just have to click each one one at a time. We are just looking for a checkbox option for each file that can be downloaded, preferrably with a a shift-select to select multiple or even a select all option.
  19. Frustrating. Cant make it work ;^) Anyone need some freelance work?
  20. Data not getting passed correctly. Following the instructions I have: New Text Field (64000) to receive the email body: Does the Script go in Header? In header I have your script ending in: document.getElementById("cbParamVirtual5").value = email; } </script> New virtual and email field, hidden, receiving the Virtual5 script parameter: Im getting blank notification emails.
  21. Have reports with uploaded fiel hyperlinks. Is there anyway to get them to show full link in an exported Excel file? I only get a generic path (/Documents/fileneame). For $100/month they said I could get it thru FileStor. If the web hyperlink opens the file shouldnt it have a URL? Current web reports show a URL like this: https://xxxxxxxx.caspio.com/dp/3f2d4000070b68a1c9fe494a832b/files/2650879 which, when clicked, opens the file for download. But direct past in browser address bar gives a not found 404. Their work around was to create an HTMl page with link to each file
  • Create New...