Jump to content


Caspio Ninja
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by TWIRED

  1. Any help would be appreciated ! Thanks~ REQUIREMENT FOR Multi-Select Listbox in a Submission Form If a form has a listbox and other element fields, If the other fields are required and not filled in, On Submit The form should not submit (required fields not completed) BUT the listbox SHOULD RETAIN the values selected If the form is filled correctly (all required fields are complete) Then submit & store values selected in delimited string to table field. [SOLUTION} Below... Thanks!
  2. Thanks Mathilda Will look into it.
  3. These type of urls , used to work flawlessly https://c2eku181.caspio.com/dpImages.asp?AppKey=ff384000f093d12f0cad40eab055&file=/IMAGES_/TRIPATWORK/TESTIMAGES/spiderman.jpg Last night it stopped working. it gives "File or Directory Not Found" error We use this type of display of images a lot with our apps. any idea why??? Update It seems to be something to do with the fileID changing. If a field is set to : Upload New File / (Automatically create a unique name) 1) a user uploads a file abc.jpg the first time.2) when the user uploads a file :- again with the same name,The URL link to the original abc.jpg does not work - because the fileid changes.Im assuming this happens because at caspios backend , the fileid is referred to when the url is parsed.

    Links to Other Pages

    If its a result page, You could put the code below in the header(Source) authentication needs to be enabled. change the "http://.." to the appropriate URL. Hope this helps.. <div id="myDiv1"></div> <SCRIPT LANGUAGE="JavaScript"> var myDiv1 = document.getElementById("myDiv1"); var branchtype ='[@authfield:Staff_List_Branch_Type]'; //alert(branchtype); if (branchtype=='FS') { myDiv1.innerHTML = "<b><h3><a href=\"http://www.google.com\">Google</a></hr></b>"; } else if (branchtype =='SIS') { myDiv1.innerHTML = "<b><h3><a href=\"http://www.amazon.com\">Amazon</a></hr></b>"; } </script>

    Javascript onsubmit and Checkboxes

    Hey abelphathot, this might help.. In your original post, if its a checkbox <SCRIPT LANGUAGE="JavaScript"> function Updatestatus(){if (document.getElementById("approved").checked==true){document.getElementById("status")="approved";}else if (document.getElementById("approved").checked==false){document.getElementById("status")="pending";}document.getElementById("caspioform").onsubmit= Updatestatus; </SCRIPT> you need to change to function Updatestatus(){if (document.getElementById("approved").checked=true);{document.getElementById("InsertRecordstatus")="approved";}else if (document.getElementById("approved").checked=false);{document.getElementById("InsertRecordstatus")="pending";}document.getElementById("caspioform").onsubmit= Updatestatus; </SCRIPT> change from "==" to = and you were also missing some semicolons Best ~

    Friendly Link For Files

    Thanks for taking the time ! Will try the site account settings in the URL format. finally figured out what the problem is after many hours of messing around . Heres what I found out Exampleoriginalimage.jpg (path) is stored in table 1 (file field)lets say fileID is : 0000If the filefield is set to : Upload New File / (Automatically create a unique name) And,If a user uploads a file with the SAME NAME ,originalimage_1.jpg is created but the Original Image fileID NOW will change : originalimage.jpg : 0001 << increased by1 and changedoriginalimage_2.jpg : 0002 This was what was breaking the URL https://c2eku181.caspio.com/dpImages.aspx?AppKey=xxxxxxxxxx&file=/IMAGES_/TRIPATWORK/TESTIMAGES/spiderman.jpg so basically the URL becomes invalid , because it is tied to the fileID of the image.when the fileid changes, the url cannot find the image because it is still tied to the original file id Thanks for the zapier tip, will try it out and seems like a great way to store images with aws.. Best !!~

    Login Times

    Thanks Mathilda, ".. a separate table for history of logs and then create a submission form and receive user's ID and other datapa from authentication fields, then add auto-submit script. After that, you may specify in authentication to redirect user to that datapage and then after form is submitted, redirect user to the user's dashboard. " it worked
  8. Just some pointers:) ---------------------------- 1) One cannot copy a file or image to another table, just by code on the front end (lets say javascript) . Its because of security reasons its disallowed. There has to be user intervention (choose and submit) by the user to do that. 2) in caspio, images/files are not actually stored in the table, A file or image is actually stored in a folder (>> All Assets , Click on Files) >> ONLY a URL Link or path to the file is stored in the table field So basically , you dont need to "copy" the image over. *if you want to, you can copy the path to the image, in another tables field . The copied-to field must be a text field. After Submission of the saved image, whenever you want to reference the image , do so with a view (which has both tables) So if you create a relationship/Join between the 2 tables. ------------------------------------------------------------------------------------------- Table 1 Table 2 Table1ID (autonumber) Table2ID (autonumber) Table1FKID (Integer) << Foreign Key Join Table1 (Table1ID) >>One to Many >> Table2 (Table1FKID) Create a View ------------------------ Inner Join Table1 (Table1ID) >>One to Many >> Table2 (Table1FKID) Results or Report data Page (Referencing the saved image from Table 1 : in reports from other tables) --------------------------------------------- Use the View above as Data Source. Heres a working demo http://www.tripatwork.com/tagnt-test-2.html If you need any help, let me know...:) Thanks !
  9. HI Diversity, As Mathilda mentioned, you have to hit "Source" button (in footer) and then paste the code in. Also, Hold down Control key when selecting from the listbox.
  10. This might work.... Create a View with Both Tables - the table/field that will be updated , make editable Choose the view as datasource in the submission form Use the Resizer option in File Field Name , give it the field name you want to copy to. And, Instead of giving resized options, you could just give it the same width and height as the original. attached pic below.
  11. Hi Diversity, If yourlistbox field name is say, "LSTBOX", then you need to :- change it at both places in the script , in your submission form (in footer - configure fields section) to InsertRecordLSTBOX If its an update form then change to EditRecordLSTBOX Destination of Submission form : Same Form Heres a live working example: http://www.tripatwork.com/test-multilistbox-submit.html also attached is my settings for the listbox field element It definitely works, and it works well ! Hope this helps:) Thanks
  12. TWIRED

    Display Image

    This might help... Pure JS http://stackoverflow.com/questions/28545509/display-image-thumbnail-of-image-selected-from-filepicker http://stackoverflow.com/questions/23598175/thumbnail-image-that-pop-when-selected-javascript JQuery/Lightbox Method http://www.lokeshdhakar.com/projects/lightbox2/?u=9
  13. TWIRED

    Clearing Parameters From A Submission Form

    This seemed to work for me. After messing around with it a bit. The trick in the submit form , the destination , do not use "Same Form" opton Use "Go to New Page" and enter the URL of the results datapage Also.. In the Submit form ---------------------- add < ahref="url?cbResetParam=1 > New Search</a> in Header destination : url of results page ( do not use "same Form" option !!) in dropdowns , make sure the onload external parameters is checked and entered. This will keep the drop downs in place after every submission. results page do not add search form links in results and details wizard options, leave it blank
  14. Just wanted to share this. Hope it helps somebody. solution to change the value of a label of a particular element in a form (Javascript): ------------------------------------------------------------------------------------------------------------ var labels = document.getElementsByTagName('label'); // 'label' is passed as the argument. To get this argument, First inspect the form element TYPE name in Chrome. for (var i = 0; i < labels.length; i++) { if (labels.htmlFor != '') { var elem = document.getElementById(labels.htmlFor); if (elem) elem.label = labels; } } document.getElementById('EditRecordDummyCount').label.innerHTML = 'Label text is changed';
  15. What I was looking to do was : change the value of a label (of a particular element) in a form. figured it out. Thanks ! Qtn : Using Javascript, is it possible to change the value of a >> Virtual Field ? If so, How ???? solution to change the value of a label of a particular element in a form: ------------------------------------------------------------------------------------------------------------ var labels = document.getElementsByTagName('label'); // 'label' is passed as the argument. To get this argument, First inspect the form element TYPE name in Chrome. for (var i = 0; i < labels.length; i++) { if (labels.htmlFor != '') { var elem = document.getElementById(labels.htmlFor); if (elem) elem.label = labels; } } document.getElementById('EditRecordDummyCount').label.innerHTML = 'Label text is changed';
  16. HI I have a field in a submission form called "Website URL" It is validated with some javascript in the footer. If it has an error message I need to either a) modify the default "required" error message underneath the field or b ) have the error message show up on the top of the page in a label. ANy help would be pretty , pretty , pretty cool
  17. TWIRED

    Cross-app App Parameters

    Just my 2 cents, maybe a shared table , with the parameter values? can then be used witha view or as a lookup table? Thanks
  18. TWIRED

    Hi Jan,

    Could use your help


    Im trying to change the text of a label.

    script below doesnt work.

    I can get the id , but unable to replace the text.


    What am I doing wrong?


    Ive also loaded it onLoad , so that the html loads before the script,

    but it doesnt work

    Thanks !!



    var label=document.getElementsByTagName('input')[0].id;
    alert("label value=" +label);
    document.getElementById('label').innerText = 'Change The Label Text';

    1. TWIRED



      I have managed to change

      -the label of a virtual field

      -label of an  input field

      -value of an input field


      All I need now is help updating the value of a virtual field text box.


      Thanks !

  19. TWIRED

    SIngle Update Form Issues-No records found displayed

    That would be most probably because the authentication and the Update Page Authentication has not been set up correctly. Mess around with >>> Web Form Wizard - Record Identification on the Update Page . I had the same issue and switched it to "find record through Record Level Security" , then I chose Identity field in Authentication: : AUTHID Matching field in current data source : AUTHID and it worked. If you choose : Find record through unique ID and have a unique email in the table , then you can match the emails vs the authid( autonumber). If you are using unique email for Authentication, then go to the AUthentication Data Page choose the email, go to Advanced and ON Exit , Check it. Note the email field and use the SAME field in >> Find record through unique ID The Other reason could be if in the Update Page Search and Report Wizard - Select Filtering Fields You have more than 1 filtering field that does not match up. Hope this helps.
  20. TWIRED

    Limit the number of search by user?

    Heres a working model that works..(Just 2 datapages) http://www.tripatwork.com/test-searchsubmit-page.html user: guest@guest.com pass: guest
  21. AuthFields do get impacted. This baffled me for a while, I would rename or re-create fields in the table, and they would not be available or re-named in my javascript code (auth fields) The Trick is to go into your VIEW , and make sure the field is selected as well as re-name it IN THE VIEW. it then should be double checked in your javascript . Hope this helps someone~
  22. TWIRED

    Limit the number of search by user?

    <script type="text/javascript"> var maxsearchesallowed=5; var counter=0; var counter="[@field:DummyCount#]"; var paiduser="[@field:DummyPaidUser^]"; var searchpermitted=document.getElementById("EditRecordDummySearchPermitted").value; //alert("searchpermitted= "+searchpermitted); //alert("counter="+counter); //----------------------today date format--- var today = new Date(); //alert(today); var dd = today.getDate(); //alert("todays date= " + dd); var mm = today.getMonth()+1; //January is 0! //alert("todays month= " + mm); var yyyy = today.getFullYear(); if(dd<10){ dd='0'+dd; } if(mm<10){ mm='0'+mm; } var today = mm+'/'+dd+'/'+yyyy; //today=new Date(today); var searchdate=document.getElementById("EditRecordDummyUserSearchDate").value; //test //today=searchdate; function myFunction() { //alert("today= "+today); //alert("searchdate= " + searchdate); //alert("paiduser= "+paiduser); if((today => searchdate) && (paiduser=="No" && Number(counter) < Number(maxsearchesallowed) ) ) { alert("allow to search"); document.getElementById("EditRecordDummyUserSearchDate").value=today; document.getElementById("EditRecordDummyCount").value=Number(counter)+1; document.getElementById("EditRecordDummySearchPermitted").checked=true; //alert("counter="+counter); } else { alert("sorry, you have exceeded your quota!"); document.getElementById("EditRecordDummySearchPermitted").checked=false; document.getElementById("cbParamVirtual2")[0].value="http://www.tripatwork.com/test-searchsubmit-page.html"; return false; } } document.getElementById("caspioform").onsubmit=myFunction; </script>
  23. TWIRED

    Limit the number of search by user?

    Add A Header & Footer to Your DataPage. Javascript is generally put in the footer of the DataPage
  24. submission will cancel the redirect or vice versa. Dont put code on the submit button but do it in the onsubmit, secondly return false to stop the submission function redirect() { window.location.replace("login.php"); return false; } using <form name="form1" id="form1" method="post" onsubmit="return redirect()"> <input type="submit" class="button4" name="order" id="order" value="Place Order" > </form> Or unobtrusively: window.onload=function() { document.getElementById("form1").onsubmit=function() { window.location.replace("login.php"); return false; } } using <form id="form1" method="post"> <input type="submit" class="button4" value="Place Order" > </form> use window.location.replace("login.php"); or simply window.location("login.php"); It is better than using window.location.href =, because replace() does not put the originating page in the session history, meaning the user won't get stuck in a never-ending back-button fiasco. If you want to simulate someone clicking on a link, use location.href. If you want to simulate an HTTP redirect, use location.replace.
  25. TWIRED

    Separate numbers

    Use calculated field functions 1) Use Cast to convert the number to a string, 2) select the string character using Left(string, number) 3) Use Cast to convert the string to a number. http://howto.caspio.com/function-reference/ hope it helps.