Jump to content

All Activity

This stream auto-updates

  1. Today
  2. I must admit it looks smaller for me and not as annoying as before.
  3. Yesterday
  4. I've since added an additional and additional upload "B", as well as "Upload" buttons for each upload. I'd like to have these button hidden upon a respective file being uploaded. Button A is coded like this, with Button B having a different id (upload_button_B): <input class="uploadButton" id="upload_button_A" name="Mod0EditRecord" type="submit" value="Upload" /> I've added the following commented lines in my Javascript in order to hide these upload buttons. However, the buttons remain visible even after file/s are uploaded. Below is my code. Any ideas what I might be doing wrong? <script> var UploadA='[@field:Credential_Upload_A]'; var UploadB='[@field:Credential_Upload_B]'; if (UploadA.length>0) { document.getElementById("EditRecordCredential_Upload_A").style.visibility = 'hidden'; document.getElementById("EditRecordCredential_Upload_ARemove").style.visibility = 'hidden'; document.querySelector('label[for="EditRecordCredential_Upload_ARemove"]').style.visibility = 'hidden'; document.getElementById("upload_button_A").style.visiblity = 'hidden'; //Hide upload button A } if (UploadB.length>0) { document.getElementById("EditRecordCredential_Upload_B").style.visibility = 'hidden'; document.getElementById("EditRecordCredential_Upload_BRemove").style.visibility = 'hidden'; document.querySelector('label[for="EditRecordCredential_Upload_BRemove"]').style.visibility = 'hidden'; document.getElementById("upload_button_B").style.visiblity = 'hidden'; //Hide upload button B } </script>
  5. Hi @StigOmenaas, are you talking about something like this? https://howto.caspio.com/tech-tips-and-articles/tech-parameters/how-to-create-a-one-to-many-relational-datapage/
  6. And if you want the Year field to be auto-populated with the current year(last 2 digits of the year), you may test this Trigger design:
  7. Hi. I have one datapage for entering records into a table. and another for displaying all records belonging to this ID. As i enter the records i would like to have another datapage show all the records i have in the child table below(on the same page). Does anyone know how to get the result page embedded at the bottom og the first page ?
  8. Hello @JenKri, I think this Forum post suits better for your workflow https://forums.caspio.com/topic/19337-multiple-customers-unique-ticket-number-starting-at-000/ You may check the steps I described in that Forum post. And if to modify the Trigger and Formula for your case: 1) For example, I have the table like this: 2) We are going to insert the Chapter_Number and Year. The Project_Number will be populated with the following Trigger: 3) Formula (the ProjectNumberFinal field) is the following: CASE WHEN [@field:Project_Number] < 10 THEN CAST([@field:Chapter_Number] as nvarchar) + '-' + [@field:Year] + '-' + '00' + CAST([@field:Project_Number] as nvarchar) WHEN [@field:Project_Number] >= 10 AND [@field:Project_Number] < 100 THEN CAST([@field:Chapter_Number] as nvarchar) + '-' + [@field:Year] + '-' + '0' + CAST([@field:Project_Number] as nvarchar) WHEN [@field:Project_Number] >= 100 AND [@field:Project_Number] < 999 THEN CAST([@field:Chapter_Number] as nvarchar) + '-' + [@field:Year] + '-' + CAST([@field:Project_Number] as nvarchar) END 4) The result:
  9. Hi @JenKri So, you are having a Submission Form, on which the user is selecting the Chapter number, and you want that to be used in making this autonumber which will essentially be unique record ID? As I see it, the best option is to use Triggered Action to do this, so something like on the following Post:
  10. Hello @sfraden, @kpcollier Thank you for providing valuable feedback. We apologize for the inconvenience caused due to the placement of the chat bubble. Our team is working on a solution to address the concern and we understand that chat function is very beneficial to users to conveniently reach out to Caspio Support team for assistance with inquiries. In Release 30, Caspio user interface has been refreshed to improve the navigation and usability. We value your feedback and are committed to continually improving our product.
  11. @kpcollier So the code involves, adding on the Results configuration page: 1) Header: <style> #doublescroll { overflow: auto; overflow-y: hidden; } #doublescroll p { margin: 0; padding: 1em; white-space: nowrap; } </style> <div id="doublescroll"> 2) Footer: </div> <script type="text/javascript"> function DoubleScroll(element) { var scrollbar = document.createElement('div'); scrollbar.appendChild(document.createElement('div')); scrollbar.style.overflow = 'auto'; scrollbar.style.overflowY = 'hidden'; scrollbar.firstChild.style.width = element.scrollWidth+'px'; scrollbar.firstChild.style.paddingTop = '1px'; scrollbar.firstChild.appendChild(document.createTextNode('\xA0')); scrollbar.onscroll = function() { element.scrollLeft = scrollbar.scrollLeft; }; element.onscroll = function() { scrollbar.scrollLeft = element.scrollLeft; }; element.parentNode.insertBefore(scrollbar, element);} document.addEventListener('DataPageReady', DoubleScroll(document.getElementById('doublescroll'))); </script> Now this works perfectly for the computer and tablet view. However, it's required that I turn off the Enable Responsive button, which means my program can't adjust for mobile phones anymore.
  12. Last week
  13. This is what I got when I tried it on my end Take note that the variable and the loops are important.
  14. HALO! You may want to try this trigger on tab_Profession_Paragraphs table.
  15. I am trying to create a project auto number with a twist. Currently our numbering is a manual 7 digit entry using a 2 digit start representing a chapter(ie. 88), followed by 2 digits representing the year (ie. 21) followed by 3 digits which is the project number. I would like the project number to be auto generated so there are no duplicates and the person entering doesn't need to look up the last number. My thoughts were to have the following columns in the projects table 1. Chapter Number record (select option) 2. Year record (default to current year if possible) 3. Project Number - This however is the part I am stuck on, I would like this as an auto number but I would like the auto number based on the chapter & Year ie: 88-21-001 then when it is asked to create a new project number it would set the project number to 002 so it would come up 88-21-002 (this would essentially be a combined field). But if it is going under another chapter their first project would come up 77-21-001 and then when they add another it would default the project number to 002. So essentially I want it to look at Chapter number, then Year Number then say the next project would be 1 greater. I hope that makes sense Thank you for your time
  16. It's smaller for me too (well, the image of the bubble. the clickable area is the same size as before). But, obviously, still in the way of the scrollbar and a bit of the last column on the right.
  17. I have noticed that the chat bubble became smaller than the previous bubble, or is it just me? Perhaps it is for the bubble not to overlap with the datasheet?
  18. Yeah, I feel like Caspio doesn't give much thought to the IdeaBox at all.
  19. Why would they (Caspio) spend all that time updating to 3.0 and completely refresh the web interface with a much cleaner look, but FAIL to actually move the damn chat bubble to the other side, out of the way? We have been asking for that for nearly two years now and it has been voted up several times in the IdeaBox, but for some reason is being ignored by Caspio.... Seems like when they were re-working the entire GUI web interface they could have spent the 5 minutes to move the chat bubble too.....
  20. Thanks for your suggestions @Meekeee and @NiceDuck. I will give them a try. It just seemed to me that this would be something that a lot of people would run into when importing from Access and that Caspio would have an easier method of accommodating it, but I guess not!
  21. I'm not too sure how to change the text in the 'Choose File' button. But, you can definitely change the way the element looks. <style> #InsertRecordFIELDNAME { height: 200px; border: 1px dashed; } </style>
  22. Can you share your code? It may make it easier for us. Read up on Media Queries, you can set a class for different sized viewports. This will let you use CSS to disable/hide the scrollbar on specific screen sizes.
  23. Hi guys, Is it possible to create code in our Datapages in Headers/Footers that only activates if the view is on a Computer vs. Tablet vs. Mobile? I'd like to add a scroll bar and I have the code for it, but I don't want it to activate in the Mobile view. Many thanks!
  24. @MeralomaFC, As an option, if you want to evaluate the Triggered Action feature, you may create a Trial account under your Profile (it is free , has 14-days duration, and has features that are included in the Grow paid plan). Then export your app from the Free account and import it to the Trial.
  25. Hello @peewee, You may check the list of supported functions in this article https://howto.caspio.com/function-reference/ Let me add more details about the FOR XML PATH clause for the future reference. For example, there is the table: 1) To display a comma-separated list of names: STUFF((SELECT ', ' + (EmployeeName) FROM EmployeeTable WHERE id > 1 ORDER BY EmployeeName FOR XML PATH ('')), 1, 1, '') The output: Ann, John, Tom 2) To display a list of names with line breaks: STUFF((SELECT CHAR(10) + (EmployeeName) FROM EmployeeTable WHERE id > 1 ORDER BY EmployeeName FOR XML PATH ('')), 1, 1, '') The output: Ann John Tom Note: WHERE clause, ORDER BY keyword are optional. Replace the field name and table name.
  26. Thanks, Vitalikssssss. This works like a charm. By the way, is there any document listing the SQL syntax allowed with CASPIO?
  27. wow you are so right! just tested. Very very cool. I wonder if I can play with the fileupload element to create a "box" for folks to drag and drop a file into instead of displaying the file picker. Thanks so much for your advice!
  28. @EvSamFwiw, you can already drag a file over to the standard file upload picker/element. Even though it has a button that says 'Choose File', you can still drag a file over to the box and it should work.
  1. Load more activity
  • Create New...