Jump to content

Xiang

Caspio Guru
  • Content Count

    75
  • Joined

  • Last visited

  • Days Won

    9

Xiang last won the day on May 28 2016

Xiang had the most liked content!

About Xiang

  • Rank
    Advanced Member

Recent Profile Visitors

1,072 profile views
  1. Hi Cameron, How are you? I think, you can use the following script: <SCRIPT LANGUAGE="JavaScript"> function setDate() { var firstDateFieldName = "first"; var secondDateFieldName = "second"; firstDateFieldName = "InsertRecord" + firstDateFieldName; secondDateFieldName = "InsertRecord" + secondDateFieldName; var f_Date = document.getElementById(firstDateFieldName ).value; var first_Date = new Date(Date.parse(f_Date)); var result_Date = new Date (first_Date.setMonth(first_Date.getMonth()+1)); var d_month = result_Date.getMonth() + 1;
  2. Hi Cameron, How are you doing? If you want only to allow multi select, I think, the following code should help (enter it in the Footer of your Bulk Update screen): <SCRIPT LANGUAGE="JavaScript"> /* "fieldName" is the variable name for the listbox type form element field. */ var fieldName = "ENTER NAME OF YOUR FIELD"; fieldName = "BulkEdit"+fieldName; var x=document.getElementsByName(fieldName); x[0].multiple=true; </SCRIPT> Have a great day!
  3. Hello Logan, I checked with numbers also. Please note, that you should add a Header&Footer element, select the Footer element, click the Source button (or disable HTML Editor) and enter the code. If you enter the code before the field, script cannot work. Please also note, that the name of the field must be the exact same as in Table design. Please verify, that it's a Submission form. If it's a Details or Single/Update form, you can use the following code: <script type="text/javascript"> function capitalize() { var fieldname = "YOUR_FIELD_NAME"; fieldname = "EditRecord"+f
  4. Hello! I have answered in another topic: http://forums.caspio.com/index.php/topic/5600-capitalizing-all-letters/ Have a good day!
  5. Hello Logan, How are you doing? I think, you can use the following script (don't forget to change "YOUR_FIELD_NAME" to the name of your field) <script type="text/javascript"> function capitalize() { var fieldname = "YOUR_FIELD_NAME"; fieldname = "InsertRecord"+fieldname; confirmname = fieldname+"@Confirm"; document.getElementById(fieldname).value = document.getElementById(fieldname).value.toUpperCase(); document.getElementById(confirmname).value = document.getElementById(confirmname).value.toUpperCase(); } document.getElementById('caspioform').onsubmit=capitalize; </script&
  6. Hi George, How are you doing? I think, the following code can help (you can add a Header&Footer element to your Bulk Update form, select the Footer element, click the Source button and enter the code): <SCRIPT LANGUAGE="JavaScript"> function concatenate() { var ResultFieldName = "Positions"; var position1 = document.getElementById("BulkEditPosition1").value; var position2 = document.getElementById("BulkEditPosition2").value; var allpositions = position1 + position2; var inputName = "BulkEdit"+ ResultFieldName; var checkboxName = "Enable"+ inputName + "Ckb"; document.getE
  7. Hi codell, How are you doing? I think, it's better to create an App Parameter (for example, name it "RedirectURL" and enter the URL of your DataPage as value). Then add a Header&Footer element to your DataPages, select the Header element, click the Source button and enter the code like following: <SCRIPT LANGUAGE="JavaScript"> var ValueParam='[@testParam]'; var redirectURL='[@app:RedirectURL]'; if(ValueParam.length==0) window.location.assign(redirectURL); </SCRIPT> Enter the name of your parameter instead of "testParam" and the name of your App Parameter instead of "
  8. Hi Isabel, How are you doing? I hope, two more links can help: Create a User Registration Process (video) - http://howto.caspio.com/getting-started/create-a-user-registration-process/ Setting Up User Permissions in Your App (article) - http://howto.caspio.com/authentications-and-connections/authentication/setting-up-user-permissions-in-your-app/ Have a nice week-end!
  9. Hi Flosie, How are you doing? I think, you can use the following steps: Add a Virtual field and select a Hidden FormElement for it, then add the Header&Footer element, select the Footer, click the Source button and enter the code: <SCRIPT LANGUAGE="JavaScript"> function emails() { var Regional_Manager = "Regional_Manager"; var Manager = "Manager"; var Submitter = "Submitter"; Regional_Manager = "InsertRecord" + Regional_Manager; Manager = "InsertRecord" + Manager; Submitter = "InsertRecord" + Submitter; var email_Regional_Manager = document.getElementsByName(Regional_Man
  10. Hi wvantongeren, How are you doing? I think, you can use the following script: <SCRIPT LANGUAGE="JavaScript"> function calculate() { var v_Werkuren = parseFloat(document.getElementById("InsertRecordWerkuren").value); var v_DWM_uren = parseFloat(document.getElementById("InsertRecorddwmuren").value); var v_55_uren = parseFloat(document.getElementById("InsertRecorduren55").value); var v_Ziekte_uren = parseFloat(document.getElementById("InsertRecordziekteuren").value); var v_Scholingsuren = parseFloat(document.getElementById("InsertRecordschooluren").value); var v_Onbetaalde_uren =
  11. Wow! Thank you! I start believing that CSS is a very powerful instrument!
  12. Hi mmorales, Thank you for sharing the solution! Does the query exclude only Sundays?
  13. Hello Flosie, I have an idea. I'll try explaining it, but if I'm unclear - ask more details Add a Virtual field (it's should be Virtual1) and select the "Hidden" FormElement. Then for every checkbox, you can add a Virtual field, select the CheckBox FormElement, and enter an email address in the "Value when checked" field. Now you have a Hidden field and all your checkboxes and addresses. Add Header&Footer element, select the Footer, click the Source button, and enter the following code. If only one checkbox is present, you can use this code: <SCRIPT LANGUAGE="JavaScript">
  14. Hello Chad, Thank you for sharing this! I like JavaScript code more, but this solution is simple and nice! Please, share more solutions, if you have them
  15. Hi AR, When a user submits a Form only one "onsubmit" event happens, so only first script works. You can combine both checks in one script: <script type="text/javascript"> function capitalize() { var fieldname = "name_last"; fieldname = "InsertRecord"+fieldname; var value = document.getElementById(fieldname).value; var newVal = ''; val = value.split(' '); for(var c=0; c < val.length; c++) { newVal += val[c].substring(0,1).toUpperCase() + val[c].substring(1,val[c].length).toLowerCase() + ' '; } document.getElementById(fieldname).value = newVal; var fieldname2 = "name
×
×
  • Create New...