Jump to content


  • Content Count

  • Joined

  • Last visited

About innov2e

  • Rank
  • Birthday 02/18/1960
  1. I found this that clarify it to me: "Essentially the source table is the place where the data is coming from and the target table is the place where the data is going to or the table that an action is taking place on. They do not have to be in different schema's or have a different structure to each other and in fact they could actually be the same table."
  2. Excellent! It works, I adjusted the statement in this way to handle the first insertion: SELECT ISNULL(MAX(ere_num)+1,1) FROM scn_eredi a WHERE target.scn_id = '[@field:scn_id]' Noy I have to fill my skill gap goggoling anout target.....
  3. When I insert a record, I want use a fied (named ere_ I have a table representing heirs (named scn_eredi) with these fields: the scn_id referencing a records in the will table named (scn_successioni) the ere_id is a unique id used to build relation between heirs and will tables the ere_num should be a progressive number for each heir-person related to a will To fill the third field I used in webform datapage a calculated value with this formula: SELECT MAX(ere_num)+1 FROM scn_eredi a WHERE a.scn_id = "[@field:scn_id]" I tried the st
  4. Hello @TJJones, to pass users details from Wordpress to a data page accepting external parameters I use some javascript in Wordpress collecting user data and building the script used to display Caspio datapage. I use such Javascript to build, with the Worpress plugin Snippets an ad-hoc shortcode used into Wordpress pages. Here is how I work: 1. Assume that my datapage use as external parameter [@usremail] and the deploy code is <script type="text/javascript" src="https://c2xxx999.caspio.com/dp/vd9990009990009990009990099/emb"></script> 2. I create a new snipp
  5. Hi @CoopperBackpack the second data page is a tabular report with all three fields both in search, results and details definitions. From my tests in not necessary to have separate Results and Details datapages, because the Virtual1 Field defined into the details page and requiring parameter work as expected: when I preview the report page parameter is asked and is passed to every record i select where it is used. Now I wish to avoid users to change this value making the Virtual1 Field Display only, but: - If I set Virtual1 as Text it results as <input type="text" maxle
  6. sorry, once more: do you know if I can use it also in details forms from reports Datapages?
  7. I have a table with 3 fields: ID (Autonumber and unique), FieldAA (Text 255) and FieldBB (Text 255). My web form to update records shows Virtual1 getting its value as External Parameter [@Param1], then FieldAA as Text Field, FieldBB and ID as Display Only. I wish to set FieldAA with the value of Virtual1 when submit pressed. So looking into this post https://forums.caspio.com/topic/4983-passing-data-from-a-virtual-field-to-a-non-virtual-field/ I added at bottom an html block, disabled HTML editor and added this code <SCRIPT LANGUAGE="JavaScript"> function concatenate(
  • Create New...