MayMusic

Caspio Evangelist
  • Content count

    1,075
  • Joined

  • Last visited

  • Days Won

    44

MayMusic last won the day on August 12

MayMusic had the most liked content!

4 Followers

About MayMusic

  • Rank
    Advanced Member
  • Birthday May 19

Profile Information

  • Gender
    Female
  1. I cannot replicate this issue I used the code just instead of nth-of-type(2) I have nth-of-type(1) and it is hiding the aggregation as well. What is the URL to your page?
  2. You can add a formula field to your table and use the formula below: CASE WHEN CHARINDEX('CG:', [@field:FieldName]) != 0 4 THEN CASE WHEN CHARINDEX(',', SUBSTRING([@field:FieldName], CHARINDEX('CG:', [@field:FieldName]), LEN([@field:FieldName]))) != 0 THEN SUBSTRING(SUBSTRING([@field:FieldName], CHARINDEX('CG:', [@field:FieldName]), LEN([@field:FieldName])), 4, CHARINDEX(',', SUBSTRING([@field:FieldName], CHARINDEX('CG:', [@field:FieldName]), LEN([@field:FieldName])))-4 ) ELSE SUBSTRING([@field:FieldName], CHARINDEX('CG:', [@field:FieldName])+3, LEN([@field:FieldName])+3) END END [@field:FieldName] needs to be replaced with the field that has the values in.
  3. Add the code below to the header of the page: <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script> <script> window.onload = function multiselect() { var a = document.getElementsByTagName('select'); var index; for (index = 0; index < a.length; ++index) { if (a[index].size!==0) { a[index].multiple=true; } } } </script> And this code to the Footer <script> $('[name=InsertRecordServices]').change(function() { $('[name=InsertRecordDescription]').val($('[name=InsertRecordServices]').val()) }); </script>
  4. If there is no specific formatting for the email, you can add a virtual field, make it hidden and use the code below to assign non-blank values to a virtual field and then use it as your email body <script> document.getElementById('caspioform').onsubmit = function (){ var mylist = new Array("EditRecordFirst_Name", "EditRecordLast_Name", "EditRecordDOB", "EditRecordAge", "EditRecordDescription"); var email= ''; for (var i=0; i< mylist.length;i++){ if (document.getElementById(mylist[i]).value){ email = email + ', ' +mylist[i].substring(10) + ": "+ document.getElementById(mylist[i]).value; } } document.getElementById('cbParamVirtual1').value = email; } </script> This is for update/details page for submission page you need to change EditRecord to InsertRecord var mylist = new Array("InsertRecordFirst_Name", "InsertRecordLast_Name", "InsertRecordbutton", "InsertRecordAge", "InsertRecordDescription"); And change all the field names with your field names. Also you need to change this line to: email = email + ', ' +mylist[i].substring(11) + ": "+ document.getElementById(mylist[i]).value; Since InsertRecord is 11 characters and we want to only get the word after that for the label
  5. I tried this in my header and added HTML Block to create my images and it worked like a charm. <style> img { border-radius: 50%; } </style> The style rule above is the shorthand for: image{ border-top-left-radius: 50% 50%; border-top-right-radius: 50% 50%; border-bottom-right-radius: 50% 50%; border-bottom-left-radius: 50% 50%; }
  6. You need to create an authentication so user can login and you can get access to user color choice, add a calculated field to your page and use this code (CASE WHEN '[@authfield:Color1]' = '[@field:Color1]' THEN 1 ELSE 0 END) + (CASE WHEN '[@authfield:Color1]' = '[@field:Color2]' THEN 1 ELSE 0 END) + (CASE WHEN '[@authfield:Color1]' = '[@field:Color3]' THEN 1 ELSE 0 END) + (CASE WHEN '[@authfield:Color1]' = '[@field:Color4]' THEN 1 ELSE 0 END) + (CASE WHEN '[@authfield:Color2]' = '[@field:Color1]' THEN 1 ELSE 0 END) + (CASE WHEN '[@authfield:Color2]' = '[@field:Color2]' THEN 1 ELSE 0 END) + (CASE WHEN '[@authfield:Color2]' = '[@field:Color3]' THEN 1 ELSE 0 END) + (CASE WHEN '[@authfield:Color2]' = '[@field:Color4]' THEN 1 ELSE 0 END) + (CASE WHEN '[@authfield:Color3]' = '[@field:Color1]' THEN 1 ELSE 0 END) + (CASE WHEN '[@authfield:Color3]' = '[@field:Color2]' THEN 1 ELSE 0 END) + (CASE WHEN '[@authfield:Color3]' = '[@field:Color3]' THEN 1 ELSE 0 END) + (CASE WHEN '[@authfield:Color3]' = '[@field:Color4]' THEN 1 ELSE 0 END) + (CASE WHEN '[@authfield:Color4]' = '[@field:Color1]' THEN 1 ELSE 0 END) + (CASE WHEN '[@authfield:Color4]' = '[@field:Color2]' THEN 1 ELSE 0 END) + (CASE WHEN '[@authfield:Color4]' = '[@field:Color3]' THEN 1 ELSE 0 END) + (CASE WHEN '[@authfield:Color4]' = '[@field:Color4]' THEN 1 ELSE 0 END) You would then see: If you do not want to see the user it self in filtering you can add name not equal and receive from authentication
  7. Can you elaborate what is the calculation and table setting. To have all aggregations show up in one row, you can create a details page and add calculated field with SQL to get the SUM value.
  8. Restrict date range of calendar popup?

    That is a good question, how can we gray out some dates and only show a specific range?
  9. Add image in email notification

    Thanks for sharing
  10. Changing ID to display text in Report DataPages

    This tutorial explains how to enable this option http://howto.caspio.com/tables-and-views/relationships/relationship-settings/
  11. Distance Search Virtual Form

    Elaborate more on how you want to receive this parameter. You should be able to receive the value in filtering page, or search page from previous page.
  12. Then somehow the employee is selected so you can use this field as parent and for the list of names, you can select cascading as form element, http://howto.caspio.com/datapages/datapage-components/cascading-elements/
  13. I do not think this is customizable. Try to change the date format in the localization you use for this page and see if that helps
  14. Maybe you need to have Caspio change your download file type from CSV to Excel file!
  15. Simple View Setup Question

    Create a relationship and in your relation ship choose to see the name instead of ID, this will resolve the issue. Refer to http://howto.caspio.com/tables-and-views/relationships/relationship-settings/