Jump to content

Vitalikssssss

Caspio Rockstar
  • Content Count

    497
  • Joined

  • Last visited

  • Days Won

    49

Reputation Activity

  1. Like
    Vitalikssssss got a reaction from subraasingapore in Validating a Field   
    Hello gbecker,
    I would suggest creating a separate table with promotion codes and use this table as a Lookup table in your Submission form.
    You should add a Virtual field to your Submission Form and use Cascading form element in order to retrieve a value from the Lookup table.
    You may use HTML blocks to hide the Virtual field from your users as described in this article. You can use my JS code example below as a reference:
    <SCRIPT LANGUAGE="JavaScript"> function myFunction(){ var v = document.getElementsByName("cbParamVirtual2")[0].value; if(v) { return true; } else { alert("Wrong code"); return false; } } document.getElementById("caspioform").onsubmit=myFunction; </SCRIPT>  
  2. Like
    Vitalikssssss got a reaction from subraasingapore in Dynamic filtering   
    Hi Gregstand,
    It looks to me that you need something similar to this.
    Hope this helps.
     
  3. Like
    Vitalikssssss got a reaction from subraasingapore in Automatic Email - Data Source Fields   
    Hi Craig,
    Note that then you select a parameter in the email set-up it uses "value" and not display value.
    I am afraid that you cannot reference "display value".
    You need to have Virtual field with form element "Cascading TextField" selected. This element will filter the records in Job_Table by job number and pickup the job name.
    Please use method like in this article if you do not want to display Virtual field on form.
    Hope this helps.
     
  4. Like
    Vitalikssssss got a reaction from subraasingapore in How to add records to three tables at once   
    Hi cigarprofiler,
     
    I would suggest passing brand ID parameter from "brand" upon submission of new brand to "line" submission form.
    "Line" submission form can have hidden field Brand_ID which will receive parameter on load.
     
    Here is some useful links on parameter passing:
    Passing-parameters
    Receiving-parameters
     
     
  5. Like
    Vitalikssssss got a reaction from nuimage in CASE in calculated field   
    Hi nuimage,
    I do not beliave that this is possible.
    Perhaps you may take a look at method described on Howto:
    http://howto.caspio.com/tech-tips-and-articles/advanced-customizations/how-to-limit-the-number-of-submissions/
    Hope this helps.
     
  6. Thanks
    Vitalikssssss got a reaction from hstange in CASE in calculated field   
    Hello nuimage,
    Please note that  @calcfield2 will have value after page load as per your described workflow, hence.
    I would suggest having two Datapages (Report&Single record update form) to replicate your workflow.
    On your Report Datapage you can place a link in HTML block to Single record update form and pass @calcfield2 value as a query string.
    Parameters-as-query-string-values
    Hope this helps.
  7. Like
    Vitalikssssss got a reaction from cigarprofiler in How to add records to three tables at once   
    Hi cigarprofiler,
     
    I would suggest passing brand ID parameter from "brand" upon submission of new brand to "line" submission form.
    "Line" submission form can have hidden field Brand_ID which will receive parameter on load.
     
    Here is some useful links on parameter passing:
    Passing-parameters
    Receiving-parameters
     
     
×
×
  • Create New...