Jump to content


Caspio Rockstar
  • Content Count

  • Joined

  • Last visited

  • Days Won


Posts posted by Mathilda

  1. On 1/14/2017 at 7:26 PM, Frank625 said:

    I am using excel 2016. I installed the caspio 64 bit office plug in for 2010 (more recent versions not available). In excel when I click get data, there is no response. When I click refresh data, I get error message as below. Is there anyway to use the plug in with excel 2016?





    ************** Exception Text **************
    System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.Office.Interop.Access.Dao, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
    File name: 'Microsoft.Office.Interop.Access.Dao, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c'
       at Caspio.RemoteSyncAgent.frmTables.frmTables_Load(Object eventSender, EventArgs eventArgs)
       at System.Windows.Forms.Form.OnLoad(EventArgs e)
       at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
       at System.Windows.Forms.Control.CreateControl()
       at System.Windows.Forms.Control.WmShowWindow(Message& m)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

    WRN: Assembly binding logging is turned OFF.
    To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
    Note: There is some performance penalty associated with assembly bind failure logging.
    To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

    ************** Loaded Assemblies **************
        Assembly Version:
        Win32 Version: 2.0.50727.8745 (WinRel.050727-8700)
        CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
        Assembly Version: 3.3.4927.21593
        Win32 Version: 3.3.4927.21593
        CodeBase: file:///C:/Program%20Files/Caspio%20Bridge%20Remote%20Sync%20Agent/RemoteSyncAgent.dll
        Assembly Version: 7.0.3300.0
        Win32 Version: 7.00.9466
        CodeBase: file:///C:/WINDOWS/assembly/GAC/Extensibility/7.0.3300.0__b03f5f7f11d50a3a/Extensibility.dll
        Assembly Version:
        Win32 Version: 15.0.4613.1000
        CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/office/
        Assembly Version:
        Win32 Version: 2.0.50727.8745 (WinRel.050727-8700)
        CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/
        Assembly Version:
        Win32 Version: 2.0.50727.8750 (QFE.050727-8700)
        CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/
        Assembly Version:
        Win32 Version: 2.0.50727.8745 (WinRel.050727-8700)
        CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/
        Assembly Version:
        Win32 Version: 15.0.4569.1507
        CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.Office.Interop.Access/
        Assembly Version:
        Win32 Version: 15.0.4569.1506
        CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.Office.Interop.Excel/
        Assembly Version:
        Win32 Version: 8.0.50727.8745 (WinRel.050727-8700)
        CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualBasic/
        Assembly Version:
        Win32 Version: 2.0.50727.8745 (WinRel.050727-8700)
        CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/
        Assembly Version:
        Win32 Version: 2.0.50727.8745 (WinRel.050727-8700)
        CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Web.Services/

    ************** JIT Debugging **************
    To enable just-in-time (JIT) debugging, the .config file for this
    application or computer (machine.config) must have the
    jitDebugging value set in the system.windows.forms section.
    The application must also be compiled with debugging

    For example:

        <system.windows.forms jitDebugging="true" />

    When JIT debugging is enabled, any unhandled exception
    will be sent to the JIT debugger registered on the computer
    rather than be handled by this dialog box.



    I use 32 bit plugin for 64 bit office 2013. Works fine.

    You may try using 32 bit plugin, hope it will help

  2. On 1/12/2017 at 10:36 AM, TexterVaid said:

    I need to  Insert a Received   Parameter (Password)  in a form

    and Insert the value into an Encrypted Password Field in a Table.


    I dont see the Receive parameter for the Encrypted Password Field / Element


    How do I Do this ?


    I need to do this

    Form 1 - gathers company info > gathers employee login info ( Virtual Fields) >> and submits parameters to Form 2

    Form 2 - Receives parameters from Form 1 , applies the received password to an encrypted password field in the Source Table ,


    Thanks !

    Hi Texter,

    Data in password fields are encrypted and can't be passed as a parameter. You  may try using text field as a password and pass value to a field in form#2. You can show values in the field on the form #2 like ***, this setting can be found in the field options settings. (Show as password ***)

    Hope that help

  3. 16 hours ago, lmooring said:

    Hi Caspio World,


    I feel like this is an easy one, but I am not able to figure out the java scripting. I have two fields on a submission form; Cost and Retail.

    I am looking for a simple data check script to make sure that cost is always less than the retail amount. If Cost is greater, an alert pops up, "cost must be less."


    Thank you for any assistance.


    try using my code in the footer of the datapage:

    <SCRIPT LANGUAGE="JavaScript">
     function check()
       var v_cost = parseFloat(document.getElementById("InsertRecordFirst_field").value);
     var v_retail = parseFloat(document.getElementById("InsertRecordSecond_field").value);
    if(v_cost>v_retail) {
         window.alert("Cost must be less");
     return false;

    Replace First_field with field name where you store cost, and Second_field with field name where you store retail amount.

    Hope it helps! :)

  4. 2 hours ago, neilcovert said:

    Is it possible to do a FV (future value) calculation inside of either a Calculated or the new Formula Field?

    This function returns the future value of an investment based on a series of regular periodic cash flows (payments of a constant amount and all cash flows at constant intervals) and at a fixed interest rate.

    The formula is: FV(periodic-rate, num-periods, payment, present-value, when-due).




    Hi Neil,

    I calculated future value using this formula. I have all the data in one table, so I used formula field with the following formula:


    It's possible to calculate the same in calculated field on report, if you need to take values from different tables.

  5. 17 hours ago, vishal said:

    I have a datapage of type Report -> details.  The page receives a parameter for the record ID.  All the fields that I display to the user are configured as "Display only".  How do I disable/hide the "Update" button at the bottom of the screen since I want this to be "view only" with no other buttons on the page?  

    I looked at the help section at http://howto.caspio.com/datapages/reports/creating-a-report-datapage/  

    According to the instructions at the bottom of this page, " The next screen depends on the whether any field is editable. If at least one field is editable, destination options become available and they dictate where the user is directed to when they click the Update button on the details page. "

    However, as I said above, all the fields on my  "Search and Report Wizard - Configure Details Page Fields are marked as "display only". yet I get the Update button. 



    The update button appears only if you have at least one editable field on the datapage. Perhaps you hide that field using rules or javascript.

    Anyway you can hide update button using java script. Just add header/footer and paste the following code in the footer:

    window.onload = function hide(){
    document.getElementById("Mod0EditRecord").style.visibility = 'hidden';
  6. On 1/2/2017 at 4:15 PM, kytan5 said:



    I notice whenever I use javascript within caspio datapage and do a preview, it seems to work. However when I save my datapage and have it deployed to my web environment, the script does not work at all.

    Anyone know why and how I can fix this?

    Thanks in advance.


    You may try checking the direct URL of the datapage (URL type of deployment). If it works on direct URL and doesn't work on your site, you need to check  your webpage. Hit F12 and check console, do you see errors there?

    Also what that script should do? I know that redirection doesn't work if you use iframe type of deployment. If the datapage is not authenticated you can send me an URL in private message, I'll check.

  7. 17 hours ago, DoDoTwin said:


    I tried your code in a HTML Block:


    <div id="mydiv[@field:Agent_ID#]"> </div>

    <SCRIPT LANGUAGE="JavaScript">

    if ("[@field:Agent_Name]" == "Jason"){ document.getElementById("mydiv[@field:Agent_ID#]").innerHTML ="<span style='color:blue;'> [@field:Agent_Name] </span>"; }

    else{ document.getElementById("mydiv[@field:Agent_ID#]").innerHTML ="[@field:Agent_Name]";


    When I do a preview, I can see the code above with IDs. But not the name in blue.

    Please find attached a screenshot of the preview page.








    Hi Dorian, you didn't hit "Source" button before inserting code. You can find more information here

    Cut code->hit Source-> paste the code back

  8. 17 hours ago, DoDoTwin said:

    Hello Mathilda,


    I have the same issue on my website (http://k2t.twinsummits.com)

    I have some ugly lines around the elements. I have "Grow Pro" theme.

    I also haven't .entry-content table and it seems that it's not just on the tables.







    Hello Dorian,

    Since the datapage is authenticated I can only check the login page. To remove borders, insert the following code in the header of the datapages and authentication:

    #caspioform tr { border: none !important; }
    #caspioform td { border: none !important; }
    table { border: none !important; }


    Also I would recommend editing theme in wordpress and deleting "margin" attribute for "table" element. 25px value adds space between elements.

    You may also use dev tool in your browser (F12) to find other attributes which you need to edit. This article might be helpful 

  9. 2 hours ago, DoDoTwin said:



    I changed the parameters (font, style, size and so on) of 1 default style (Caspian). But I would like to RESET my modifications as it doesn't seem good.

    It has been saved. Is it possible to RESET my modifications and to come back to the original settings?

    There is a RESET button/ink but it's for the current session.





    Hi Dorian,
    Create a new style. Do to Styles tab and click on the new style button in the top of the screen. As far as I know you will create a new default style this way.

    Hope it helps :)


  10. 19 hours ago, Pulford said:

    Is there a way to make a chart/graph that would give a visual representation of the progress toward a goal? 


    For example, I have a numerical field that gets an entry every time a table entry is made. 


    There is a goal number associated with that entry table as well. That number remains consistent. 


    So I want a graph to show we have 10 out of 50 complete. Then it may change to 11/50 with the next entry and so on. 



    Hi, I would recommend using column  type of chart. Define the following settings on the Configure chart settings screen of the  wizard:

    - Chart settings: define value for the width setting, because chart will be too wide for 1 column. Try using 400px.

    - Data source settings: select  "Use a separate field for each series"

     category X axis: leave blank

    - category Y axis: set "fixed" for Axis value range and in the "to" field define your goal, so you need to put 50 there. Also select "none" in the formatting setting (it's set to % by default)

    - value1: select a numerical field and select "count" in aggregation. After that save changes.


    Hope it helps :)

  11. On 1/2/2017 at 0:58 AM, luizamorim said:



    I am developing a report result based in two tables: the first one is holding the 'clients' with unique IDs, and the other one have the 'products' also with their IDs.

    Both lists have details, however the clients have special columns which indicates the products they have. For example, the 'client 1' has 3 more columns because he has the product 1, 24 and 33. The clients may have up to 9 products each.

    The report should be generated by searching for the name of the client, listing his products.

    The thing is that I don't know how to generate this report, it just shows the 'product id' on the results, which should be replaced for the 'product name' instead.

    I thinks the best way to do it is a many to many relationship, because the clients can have more than one product each. I've read something about making another table which would link all the information as a many to many relationship, but I am not sure how I can list the results from an "empty" new table.

    Is there any other way to do it?


    As far as I understand one product can have many clients and each client can have many products.

    You need to create one more table to build a many to many relationship. Build a one to many relationship between client table and the 3rd table based on client ID and one more one to many relationship between product table and 3rd table based on product ID.  So you will get a many to many relationship in the 3rd table. Then you may create a view using 3 tables and display needed information on report.

    Please feel free to ask if you have questions.

  12. On 12/27/2016 at 10:54 AM, thanhvanchi said:

    Hello all member!
    I have almost completed a project but I am facing problems while sending bulk emails based on some filters. I can pull those emails in list box but not sure how to select all emails from listbox make a string separated by ';' and send emails to all the recipient. I badly need support.

    Thank you in advance.

    Where do you store those emails? do you have one email per record and you need to send emails to all the emails if the field?

    It would be great if you could describe a scenario. 

    Also please note, there is a limitation in a number of characters in "to" field. You can enter up to 200 characters. You may find more info here

  13. On 12/27/2016 at 11:12 AM, thanhvanchi said:

    One of the first fields on my form needs to be unique (FieldA), and the form itself is rather long. If a user enters a value into FieldA that is not unique, they get an error message, but not until they try to submit the form.

    How can I have the the error message ("Value already present") appear as soon as the user clicks out of that field - using onblur in javascript, for example -  rather than waiting until the user hits the submit button? I sought out information on the internet but have not found a suitable solution to this problem. I am trying to prevent users wasting time filling out the entire form so that they are alerted of the error immediately upon entering the non-unique value.

    Thanks so much for the help.

    Hi, as far as I know it's not possible to check if value is unique on the fly, you need to hit "Submit" anyway. I would recommend separating your form into 2 steps, like in this solution. First, user fills-out unique fields in submission form, then you may redirect user to update form where he can complete registration.

  14. On 12/27/2016 at 11:04 AM, thanhvanchi said:

    Hello everyone!

    A field used to search is from dropdown list which contains something like "- Select -" when nothing is selected. Is it possible to ignore it in the search criteria? 

    In the Configure Search Fields page, you can configure to ignore the field in search criteria if it is left blank. Can the same thing be done for a special word?


    Hello, Happy Holidays! :)

    Sure, it's possible, just remove "Select" from the Value field the when you configure the drop-down field.

    Please find more information here

  15. On 12/2/2016 at 9:06 PM, Psquare1 said:

    I'm finally breaking down and asking if someone can assist me in getting a new page to refresh from an html login. I have a login page, we will call page.com/login, that contains the embed html login page. When I login, instead of taking me to a new page, page.com/client-home, it places the redirect page inside the login frame.

    Attached is the before login and after login views. 

    Login 1.png

    Login After.png

    Hi, Wix deploys datapages in iframe, that is why redirection doesn't work.

    Wix this is not the best site builder if you need to pass parameters or use scripts with redirection.

    I would recommend changing the site builder.

  16. 39 minutes ago, neilcovert said:

    I've created an HTML block to be used on a Data Page describing particular entries below that block.  How do I specify the Google Font Raleway in the HTML code?




    Hi Neil,

    First select needed font at: https://fonts.google.com/

    You will get a link to the css file and css attributes. For example, for Indie flower font family you will get the following code:

    1. font-family: 'Indie Flower', cursive;

    <link href="https://fonts.googleapis.com/css?family=Indie+Flower" rel="stylesheet">

    Then you need to paste that link to the css file in the header of the datapage. After that use provided css attributes to define inline style for text in html block.

    <p style="font-family: 'Indie Flower', cursive;">Your text</p>

    Hope it helps :)

  17. 13 hours ago, prashanth said:


    The Search and Report datapage has only one choice now to add a new variable for the results and that one is HTML Block. Any reason I am not seeing calculated field, Virtual field etc. Other datapages seem to be fine. See screenshot below. I appreciate any help.






    Hi, as far as I know, virtual fields are not available on results page. Also Calculated fields are not available for free accounts, so if you have free account, calculated fields will not appear on report datapages. Conciser using formula field if it works for you.

  18. On 12/23/2016 at 5:10 AM, aewilcox10 said:

    Hello all!

    I have a table in which I need to list the citizenship requirements for particular jobs/grants. I wanted to do a drop down list in which someone could select US Citizen and all opportunities available to US Citizens would be available. The issue, however, is that some grants are open to US Citizens, Nationals, and Permanent Residents. As all this information is listed in the table under "Citizenship," it lists the following in the drop box:

    US Citizen

    US Citizen Permanent Resident 

    US Citizen Permanent Resident Foreign National

    No Requirements


    How can I fix this? I thought about giving each its own column, but that didn't seem to work, as I'd then have to have multiple drop downs.

    Hi, I would recommend you using cascading elements

    Hope this helps

  19. On 12/26/2016 at 9:26 AM, bookish said:

    Happy holidays again!  Is it possible to disable inline edits if field status is WAITLISTED? The inline edit for that particular field is a dropdown. Thanks!

    Hi, Happy Holidays!

    As far as I know, it's not possible, however there are several workarounds:

    - you may filter records to exclude records with WAITLISTED status. This will let you show and edit only records with other statuses.

    - allow editing records on details page. Add a virtual field, make it hidden and onload receive data source field "Status". After that create a rule:

    Criteria: When value in virtual field equal to "WAITLISTED" 

    Action: Make status field "Display only"

    You can find more information regarding conditional forms here

    Hope that helps :)

  20. On 12/13/2016 at 7:52 AM, TexterVaid said:

    Hi I have a multi-page forms

    form1 - 

    after completion

    I need to send a hidden parameter to a field called "Registration1_Complete".

    The field is a Yes/No field.


    In the form i have a hidden field which hen submission completes needs to "Check" the field in the database


    I have tried various parameters in the On Exit to get teh database filed checked .

    like [@YES] , [@TRUE]


    Nothing seemd to work.

    Whats the parameter to get the field in the database checked.


    Hi Texter, Happy Holidays! Hope you still need help on this

    I suppose that there is no need to pass parameter to the second form, just make this field hidden and onload receive "yes".

  • Create New...