Jump to content


Caspio Rockstar
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by kpcollier

  1. @NiceDuck Thank you, that's a helpful article and it answered most of my questions. May I ask, how many tasks do you have set up? Is there a limit to the number of tasks I can have? I don't need them to run at the same time, just on the same day, and I would probably need ~15 of them. I do understand the DataHub Requests per month limit - I am just wondering about actual connections for different files.
  2. I'm trying to figure out a way to get our estimating files on Caspio. I have been looking at Scheduled Imports, but I'm a little confused. Can you only do one file at a time on a scheduled import? If so, does that mean I would have to create multiple scheduled imports and make sure my files are named in the right order? That seems like it won't work for a long time solution. Is there a way to import multiple files a day from excel to Caspio, without being in the Bridge? Or, maybe, is there a way I could get the upload to happen as soon as my colleague saves it to our office server?
  3. Is there a caspio standard way to have an alert box pop up? I have a text field value that has 6 choices, represented by radio buttons. If the user clicks on '6', I am trying to get an alert to pop up. This will just be like a dialog/alert box where the user has to click okay to get back to the form. Can anyone help me out with this? I have tried with some JS, however I am not sure how to implement/call it. var reasonChoice = [@Reason]; if (reasonChoice = "6") { window.alert("Please see update below.") } Any help is appreciated.
  4. Hey @NickO, Did you ever figure out a solution to this?
  5. Your problem is that you are redirecting your users to a site (caspio.com) using the Authentication as well as expecting to redirect using your script. You need to set Login Redirection On Success to Same Page. With it like this, you aren't redirecting your users with the actual authentication, they are just staying on the same page, so the script will be able to run, which THEN will redirect users. Everything else looks like it is set up correctly. The Timeout option is a helpful security feature. If your user is idle on your page for whatever you set that timeout to, they get logg
  6. This is what I use. The sections are closed when you open the page. Do this for each section. If you want the first one to be opened when you first open the page, just get rid of the style="display:none" on the opening HTML block. HTML Block at beginning of section, enter this. <input type="button" onClick="Displayer(1)" value="Receiving Info"><br> <style> button styling </style> <table id="Section1" style="display:none;"><td> HTML Block at the end of section, enter this. </td></table> With this little script in the foo
  7. Are you just trying to get the value typed into 9.1 to be automatically copied to 9.2?
  8. Hey @shaferam, Have you tried the ready made apps? I believe they have a Document Review Management app that you may be able to customize to your needs. It should at least help get you started.
  9. @Altair Nice find. I couldn't get the webkit method to work from directly on the DP. The script updated above works, however. LC also said they are implementing a quick and easy setting for it in Styles, so we should be alright!
  10. Upon using the new Responsive DataPages feature from Caspio Release 21, I noticed all of my forms that had this enabled were aligned to the left. I couldn't get any of the solutions already in this forum to center my datapages. The new Responsive feature completely restructures the HTML of the DataPages. I have tried a lot of things. In DevTools, if you select the .caspioform element, you can add 'text-align: -webkit-center;" and it works. However, try adding this CSS rule to your DataPage, and nothing happens. Edit*: Live Chat has helped me find a fix. [action*="[@cbAppKey]
  11. First thought that came to mind is making that field Unique in the table level. If you do not want any duplicates for that field, checking the 'Unique' box on the table level for that field will prevent the submission automatically when trying to enter a dup. This could be a fairly easy solution. For the format and length, can you give us the requirements? Is this a text field? I believe with a combination of using the Unique feature and some simple JS, you can prevent form submission based on your requirements.
  12. The best current way to create a Document or Certificate-like datapage is with a list-type report page - to my knowledge. You'll need a lot of HTML and CSS to manipulate the page to look like a certificate. You need to add one field at least to get to the Results page - just pick a random one to get you to the Configure Results page. Once there, add in a Calculated Field and just write "NULL" in it. Now you can delete that random field you added in. Make sure to have Header and Footer enabled on the Configure Results page. After that, add an HTML block. Click on 'Next' to go t
  13. "We recognized this and starting middle of this year, we have been building out new infrastructure to make way for many exciting features in our product roadmap. Please stay tuned to our product update in early nextyear to have more information on the upcoming features." That is from an email straight from the Director of Product Management back in 2019. That's all they told me about a time. But, honestly, they are still even having trouble with the Safari Login Issue that they said would be fixed with the upcoming product release. Caspio 21.0 just came out yesterday, and unless I m
  14. All I can say is good luck. The best place to put your ideas is on the Ideabox, but, it's not used very much. There are a lot of voted for ideas that have no feedback from Caspio whatsoever. There are a bunch of subjects on there that say 'starting' that are a year old... I brought it up to them multiple times and they said that their infrastructure is old and they are working on a new one and that "all of my wanted ideas are already on the roadmap". Yeah, sure. I would still search the ideabox for a similar request or make a new one. But, on a real note, this forum post will prob
  15. Thanks, geoffdude. Your CSS worked. All I had to do was switch the width: 50% to 100% in the ChannelView rule. The date picker seems fine now!
  16. I am using iframes to display multiple datapages in a navigation bar style workflow. You can find it in this Caspio HowTo article. It works pretty good, except for the fact that the date picker when trying to edit a record is not in line with the field. This isn't the biggest problem until you get to records towards the bottom of the page, then the date picker is so far off align that it pops up out of the page, making it impossible to make a selection. Anyone have any idea? <head> <style> </style> </head> <style> .ui-resizable-helper { borde
  17. You will definitely want someone that is proficient in JavaScript. That is a BIG one with Caspio. There are a lot of things that Caspio is missing in their 'standard' features, and they all seem to be do-able in JS. HTML and CSS is pretty much a given. If they are good at JS, they'll know how to mess with these. Python might be a nice asset for APIs, but again, someone good can do it with JS. Knowledge of some SQL will definitely help with expressions and queries for Calculated Values and Formulas, etc. But that stuff is easier and Live Chat can help with this a lot more than
  18. You'll actually do this through the Styles tab on your Caspio Bridge. Go to the Style your page is using > Form/Details > Fields. Scroll down the list to find File. You'll see Border Options. I used a solid 1px with a light color and it works pretty well. You'll probably want to do it under Results Page > Fields > File as well.
  19. I believe the problem is that it cannot find any element with the ID of 'Section1', not that you have to 'unnull' anything. Are you using the correct ID from outside of preview mode? Not sure if it would change, but it could be the answer. One thing with Caspio elements, is that if you use any 'Special' elements, it appends a random string to the ID that changes with every load. I believe this is with cascading, autocomplete, calculated values, and whatnot. Once again, not sure if you are using any of these, but this could also be the answer. Did you create the Section1 element
  20. I tried to do this some time last year and couldn't figure it out. Obviously, it is not a standard feature (surprise) so it's gotta be something JS. When I was going through this, I initially was trying to just toggle hide/unhide the rest of the input fields with a button, but I couldn't figure out a good way to use a single button to loop through the rest of the input fields one by one. Another problem was removing the input fields if too many were summoned. (Maybe add another 'X' button by each field that when clicked, would hide the field?) I never finished this workflow and just went
  21. It is easier to see if you set a border around it. If you drag a file to anywhere inside the rectangle border it will accept the file. Have you tried to simply drag a file towards the 'Choose File' button?
  22. Usually when I am creating my dropdowns, I create a blank custom value so that users can bypass that filter. Such example would be like a '-Any-' or 'Match All' in the display and nothing in the value. I feel this is a pretty common workflow among the Caspio community. While creating a new report datapage, I couldn't help but notice an 'N/A' option at the bottom of each of my dropdowns. These N/A options were not created by me... And they only show for dropdowns that are populated by a lookup table or view. I have tried numerous different views and tables. I've created a dummy table just
  23. If you are using a Submission or Single Update form, you need to use 'InsertRecord______' where you would put the table name of the field in the blank space. If you are working on any report datapage, you need to make it 'EditRecord______' with the field name of the field in the blank. In example, if your field name was 'First_Name' and it was a sub form, you would use 'InsertRecordFirst_Name'. However, if the field you are using is a virtual parameter, you would use 'cbParamVirtual#' where you would put the Virtual Field number instead of the '#'. So, if your field was Virtual13, you wou
  24. I believe this is what you need: <script type="text/javascript"> document.addEventListener('BeforeFormSubmit', function(event) { location.reload(); }); </script>
  • Create New...