Jump to content

Mathilda

Caspio Rockstar
  • Content Count

    464
  • Joined

  • Last visited

  • Days Won

    49

Posts posted by Mathilda

  1. On 10/13/2017 at 10:20 PM, joscetre said:

    Is it possible for automated emails to be sent encrypted? 

    Although the site pages are encrypted, I am getting a warning on receipt of a Password Recovery email (via Gmail) that "Caspiomail.com did not encrypt this email".

    As far as I know, it's not possible. Caspio mailers send email on behalf of your email address, therefore you cannot use encryption in this case.

  2. On 9/28/2017 at 3:46 PM, johnvnwp said:

    Hi guys - after weeks of struggling with support to make my pages look like they were supposed to in WP, I almost gave up. We were adding custom code and and fast as we corrected one issue we broke another. As I said - I almost gave up. But then I discovered - http://html5blank.com/. This free template, called HTML5 Blank has virtually no formatting at all, with the result that all of my styles worked perfectly with no modifications. Hope this helps somebody out there.

    Hi,

    Thank you for sharing :)

  3. On 10/10/2017 at 5:20 AM, Accountability said:

    I am utilizing an HTML Block (Header) and would like to do the following:

    if ("menuchoice== option1")

       do this:
    &nbsp; &nbsp; &nbsp; &nbsp;<a href="https://www.xxxx-xxxx.net/webapps/shca/SA_Document_SUD_Employee_Search_Auto_Submit.html"><img alt="Search Again ?" src="https://xxxx-xxxx.net/webapps/common/Magnifing_Glass.png" style="width: 43.9773px; height: 38.9915px;" /></a>&nbsp;<br />
    &nbsp;&nbsp;<span style="color:#D3D3D3;"><strong><span style="font-size:14px;"><span style="font-family:arial,helvetica,sans-serif;">Search Again ?</span></span></strong></span>

    or if ("menuchoice== option2")

       do this:
    &nbsp; &nbsp; &nbsp; &nbsp;<a href="https://www.xxxx-xxxx.net/webapps/shca/SA_Employee_Search_Auto_Submit.html"><img alt="Search Again ?" src="https://xxxx-xxxx.net/webapps/common/Magnifing_Glass.png" style="width: 43.9773px; height: 38.9915px;" /></a>&nbsp;<br />
    &nbsp;&nbsp;<span style="color:#D3D3D3;"><strong><span style="font-size:14px;"><span style="font-family:arial,helvetica,sans-serif;">Search Again ?</span></span></strong></span

     

    Is this possible in Javascript ?  Thanks for you help.

     

    What type of the datapage do you use? You may have a look at this and this post

  4. On 10/8/2017 at 5:28 AM, GingerDan said:

    So I'm trying to get the value that is already in the current points field, do a calculation as depicted in the switch statement and then fill the field in again with the new number before submitting instantly.   This is all supposed to be done as a way of replacing an SQL update statement. For some reason my EditRecord or document.getElementById doesn't seem to be working at all.

     

    <script LANGUAGE="Javascript">
    function calculate(){
      var pos = [@pos];
      var points = [@field:CurrentPoints#];
       switch(pos)
       {
           case 1: points += 10; break;
           case 2: points += 8; break;
           case 3: points += 6; break;
           case 4: points += 4; break;
           case -2: points += -2; break;
           default: points += 2; 
       }
      document.getElementById("EditRecordCurrentPoints").innerHTML = points;
    }
       document.getElementById("mypage").onsubmit=calculate();

    </script>

     

    There is already a <div id="mypage"> in the header and a </div> in the footer.

    Am I just being very stupid?

    I suppose that you use update form. You  should use a little bit different syntax, have a look at this post

  5. On 10/7/2017 at 1:34 AM, ckunkleman said:

    I believe I answered my initial (silly) question but am wonder if sending an autonumber as a parameter when initializing a series of auto submits after a single record update form. Best practice? or is there a better way?

    What is the purpose of using series of autosubmit datapages? I assume that you need to submit values to different table, in this case you need to pass ID to those records. This will let you then join tables in views and give you more flexibility in retrieving data

    Hope it helps

  6. 12 hours ago, Accountability said:

    From the same table.  Thanks for responding.

    I would use SQL query in calculated field on details page. E.g.:

    sum(hours) from table_name where user_id=targer.[@field:userid]

    Calculated field generates a value on the fly on every page load (therefore it's always up-to-date), but if you need to save it in table you may use solution from this post

  7. I just wanted to share this solution

    if you wish to  add some text like "Select items" to your list string field, you may use this solution

    Insert HTML block above the field, disable html editor and insert code:

    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js">
    </script>
    <script>
    function placeholders() {
    document.querySelector("input[type=text][name=ComboBoxInsertRecordField_name]")
    .setAttribute("placeholder", "Select items");
    }
    $(document).ready(placeholders);
    </script>

     Replace Field_name with name of your field.

     

  8. On 9/29/2017 at 5:24 PM, NeoInJS said:

    Hello - I need your expertise on how to implement this workflow.

    Enter search data into datapage—pull up a list of companies in a string separated by the word OR and each company is in quotes.

    Example: Search criteria

    Result (in one row) = "Cyber games" OR "Initial Cyber" OR "Cybertron"

    I appreciate any feedback you can give.

    You may try passing parameters from the search to results page header or html block.

    Pass parameter on exit for a field on search page, then use parameter names in the header of the results page

    [@field1] OR [@field2] OR [@field3]

     

  9. 6 hours ago, Fibonacciphil said:

    I’m fairly new to this and am having difficulty adjusting my stylesheet to show results in a certain way.
    Not sure where i have to go to edit the relevant items.

    I’m trying to:
    Delete all borders around any cells or tables.

    Set Label text width to a fixed amount.
    Set the width of data fields to a certain width, and allow wrapping of text.

    Change the padding on data cells results.

    Screenshots of before and after attached.

    CaspioStyles2.JPG

    CaspioResultsRequired.JPG

    As far as I understand, borders appear when you embed a datapage to your webpage. If you don't pass parameters to/from the datapage, you may use iframe deployment method, this will let you keep the same look as you have on preview in Caspio. 

    Another option - edit CSS of your website and edit attributes which overwrite caspio style. One more possible option - ovewrite attributes in the header of the datapage, like:

    <style>
    #caspioform tr
    {
    border: none !important;
    }
    #caspioform td
    {
    border: none !important;
    }
    </style>

     

    You can user similar code for other form elements to override border:none. Use firebug or other F12 tools to inspect the form elements and find their respective style and customize them similar to the below code.

  10. On 9/27/2017 at 8:50 PM, NeoInJS said:

    Can anyone let me know if there is a mobile app builder which we can deploy Caspio DataPages to?

    You may try appypie, I tried deploying datapages there, works fine. I deployed datapage to "code page" type of page

  11. On 9/20/2017 at 3:14 PM, PDSRQ said:

    I am looking for a way to have employee data with a due date that is autopopulated, then it send an automatic notification 30 days before the due date.  There doesn't seem to be a away to have auto emails send without interaction/modification with the data.  I need it to run in the background without my assistance.

    As far as I know, this kind of triggers can be done on the server side only. You may reach out to this team, they implement this kind of requests

  12. 10 hours ago, danielg05 said:

    I would like to add a rule to a data page that prevents a user from selecting an erroneous date, ie anything after a certain like the current date or something after a age limit for the application.  When I try to choose greater than or equal to for the birthday calendar field, it does not allow me to add a condition that prevents the user from proceeding.  Is there a way to do this inside the data page?  Thank you.

    This kind of validation can be done using Java Script. Have a look at this post

  13. On 9/12/2017 at 7:55 PM, Heineperson said:

    Hello,

    I would like to create a calculated field in tabular report datapage that displays a column in related table as a concatenated string.

    For Example, many of my apps use the tblPlants as a data source. This is a table of plant species that has a one-to-many relationship with many other tables. I would like to present a field in the report that lists the the botanical gardens for each plant is found in from the tblBG as a string. 

    SELECT STRING_AGG(tblBG.Garden,",")

    FROM tblBG

    WHERE tblBG.PlantID = [@field:PlantID];

    I get an error that say there is a syntax error near "(", which I take to meant hat the STRING_AGG function does not exist. Is there another function I could use to accomplish this?

     

    Calculated field can return only one value. Perhaps, you may create a view, join tables and then use that view as a data source for report with grouping.

    Hope that helps.

  14. On 8/22/2017 at 10:48 PM, DaeBo said:

    On a claims list results table, I have inserted an HTML field next to a text datafield [@Claim_Status]. The [@Claim_Status] displays the status of the claim record; and the claim record has a unique identifier [@Claim_ID].

     

    I want the HTML field to display a hyperlinked text ("Complete Claim") if [@Claim_Status] equal "pending". If the status does not equal "pending", then show nothing at all. The link will open a new webpage to a datapage and receive a parameter [@Claim_ID] to pull up the claim so that the end user can complete the claim.

     

    What is the conditional script for this?

     

    Screenshot (364).png

    You may have a look at this post. The question is very similar, It has a script which you may try using 

  15. On 9/21/2017 at 11:33 PM, MHDslagelse said:

    Sure - But that is not best practice in a database

    I looking for something like

    
    For i = 1 To 3
      Set Name = Name+i and Phone = Phone+i
    Next 

     

    And I will have these 3 records

    
    ID	Name	 Phone
    1	Jack		  12345678
    2	James		11223344
    3	Susan		22334455

     

    As far as I know, mass insert is not allowed in caspio, therefore I would submit each record separately 

  16. On 9/8/2017 at 7:28 PM, Sindhuja said:

    Is there a way to give repeat section option in submission form? So that the user can fill a particular section in the form multiple times with different input.

    I found this option in other form building apps but not in Caspio. Please refer to the screenshot for better understanding.

    InkedCapture-1_LI.thumb.jpg.0b9fd1b16dbf9d1a56bfce4c1bb68487.jpg

     

     

    Thank you.

    How do you wish to store this information? I suppose it should be different records. If yes, you may specify "same form" in the destination page. This will let you open a clean form again after previous information is entered.

    If you wish to keep all the information in one records, you may have a look at this solution 

  17. On 9/15/2017 at 4:12 PM, ciwfootball said:

    So I have a Wix page already set up and the table DataPage works fine except it is stuck on the parameter value I originally set.

    The ideal solution here is that when a user logs in, Wix passes/creates a parameter [@email_address].  This is already set as a unique value in a Caspio table.  From there I can get [@player_id] which would then be used as authentication in the datapae,

    I just need a way to take the sign in from Wix and use that to define the authentication for the datapage. 

    If this isn't possible, then I will have to create a two tiered login for all users (1 for the site and a second for data entry).  All users are intended to enter data so it seems unnecessarily redundant.

    Hi, Wix deploys datapages in iframe and it's impossible to pass parameters from/to datapages or use scripts with redirection

    I would suggest selecting another CMS like weebly, wordpress.org, godaggy, etc.

  18. On 8/15/2017 at 7:44 AM, SongLian said:

    Hi Mathilda,

    Just found that there is still one problem with the script, the script works when 2 emails are selected, however, when I have 3 or more emails selected, the subsequent emails were not being sent as the divider between email was not replaced with semicolon

    Please refer to the example of emails that I've managed to captured below, as you can see, only the 1st and 2nd email was replaced with semicolon but not the subsequent emails. 

    tansonglian@gmail.com; tansonglian@yahoo.com,xxx@yahoo.com,song.lian.tan@recgroup.com

    Appreciate if you can help to amend the script. 

    Thanks in advance

    Capture.JPG

    Hi SongLian, I changed code for the footer, it should work now:

    <script>
    
    $('[name=cbParamVirtual2').change(function() {
    
    $('[name=cbParamVirtual3').val($('[name=cbParamVirtual2').val())
    
    
    });
    </script>
    <script>
    function replace(){
    
    var res=  document.getElementsByName('cbParamVirtual3')[0].value;
    var newchar = '; '
    res = res.split(',').join(newchar);
    
    document.getElementsByName('cbParamVirtual3')[0].value=res;
    
     
    }
    document.getElementById("caspioform").onsubmit=replace;
    </script>

     

  19. On 8/26/2017 at 3:40 AM, LuluSW said:

    Hi 

    I need to add a button that will redirect to a specific page on a HTML form

    This button must be visible or not visible based on a condition from an authentication field

    I created the html form and added this code:

    <script>
    if("[@authfield:User_Role]" == "Manager")

    {

         ---> Add a code here that will show a button that will redirect to a page

    }

    </script>

     

    Can someone send me an example code that I can place between the brackets?   I tried several options but nothing works.  

    Try using document.write, e.g.:


    document.write('<button onclick=document.location.href="https://www.google.com">take  me away</button>');
     

  20. On 8/25/2017 at 9:27 AM, johndavis50 said:

    My staff needs to create "estimates"

    Every estimate relates to a customer (obviously)

    Some customers are already in our database so the staff can select that customer from a drop down or similar.

    But most customers are new so before staff can  "create an estimate", first they need to "create" the customer. And it seems very inefficient to have staff first use one form to create the customer and then another form to create the estimate and finding the relevant new customer from a drop down in the estimate form.

     

    So what I want is: 

    One form

    That asks my staff to: "select existing customer" or "create new customer record"

    And then accordingly, if staff chooses to select existing customer then they do so from a drop down menu

    And if they choose to create new customer record, then a new form inside of the original form will open (or pop up) that lets them first add the new customer record, then when finished, they keep on adding the estimate record.

     

    I hope that makes sense.

    How can I achieve this with Caspio?

    You may have a look at this post.

    Another possible option is to enable inline insert option on tabular report which will let you insert a record from report

    Hope that helps :)

  21. On 8/25/2017 at 7:27 PM, lanphuonglien said:

    I have a search for students who have taken course a or course b. If they have taken both course a and course b I get to records for them on the results page. Is there any way to get only one...in other words, get unique records? or enable the grouping?

    Thanks!

    Hi,

    you may enable grouping in collapsible groups. You can find more info here

  22. 23 hours ago, MHDslagelse said:

    I would like a submission form with the possebilly to have one form with to or more files for each person going into x numbers of records

     

    Like this

    Form

    Name1 and Phone1

    Name2 and Phone2

    Name3 and Phone3

     

    I the database it will create 3 records. Not one record 

     

    How to do that please ;o)

    You could insert all those fields in table design in order to have all fields in one record.

  23. 19 hours ago, rickin21 said:

    Hi,

    I am trying to perform a calculation on one of the field "Amount" - the calculation is pretty much (regular hours x regular rate) + (overtime hours * overtime rate). I have the following javascript below but it does not seem to work. Please help me resolve this issue! 

    Fields: Amount, Regular_Hours, OT_Hours, Rates and Rate_OT

     

    <SCRIPT LANGUAGE="JavaScript">

     function calculate()
     {
       var v_hours = parseFloat(document.getElementById("InsertRecordRegular_Hours").value);

       var v_hoursot = parseFloat(document.getElementById("InsertRecordOT_Hours").value);
       
    var v_rates  = parseFloat(document.getElementById("InsertRecordRates").value);

    var v_ratesot  = parseFloat(document.getElementById("InsertRecordRate_OT").value);
       
    var v_amount  = ((v_hours * v_rates)+(v_hoursot * v_ratesot));
       
    document.getElementById("InsertRecordAmount").value = v_amount;
     }

     /* On submitting the webform, the function calculate is executed */
     document.getElementById("Regular_Hours").onchange=calculate;

     document.getElementById("OT_Hours").onchange=calculate;

    </SCRIPT>

    Hi,

    InsertRecord is missing before field names in the following lines:

     document.getElementById("Regular_Hours").onchange=calculate;

     document.getElementById("OT_Hours").onchange=calculate;

     

    You may use onblur event in order to run function onchange, also I would recommend adding one more conditions in order to check that all the values which are being used in calculation are fulfilled with data

    <SCRIPT LANGUAGE="JavaScript">
    
     function calculate()
     {
       var v_hours = parseFloat(document.getElementById("InsertRecordRegular_Hours").value);
    
       var v_hoursot = parseFloat(document.getElementById("InsertRecordOT_Hours").value);
       
    var v_rates  = parseFloat(document.getElementById("InsertRecordRates").value);
    
    var v_ratesot  = parseFloat(document.getElementById("InsertRecordRate_OT").value);
    
    if (isNaN(v_hours) || v_hours.length<1) {
     v_hours = 0;
    }else if (isNaN(v_hoursot) || v_hoursot.length<1) {
    v_hoursot = 0;
    }else if (isNaN(v_rates) || v_rates.length<1) {
    v_rates = 0;
    }else if (isNaN(v_ratesot ) || v_ratesot.length<1) {
    v_ratesot = 0;
    }
    
    var v_amount  = ((v_hours * v_rates)+(v_hoursot * v_ratesot));
    if ( isNaN(v_amount)){
    v_amount = "";
    }
    
    document.getElementById("InsertRecordAmount").value = v_amount;
     }
     document.getElementById("InsertRecordRegular_Hours").onblur=calculate;
     document.getElementById("InsertRecordOT_Hours").onblur=calculate;
    
    </SCRIPT>

    Cheers!

×
×
  • Create New...