Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

Johan's Achievements

  1. Hi there I have a sequence of one "Submission Form" and 14 "Single Record Update"-datapages to capture data into one table called "Assessment". I have created triggered actions - on insert and on update - to create and update additional tables for reporting purposes. I presume the triggered actions on "update" will be executed for every datapage that updates the table - which in my case does not make sense and might create latency in the web-application. Question: Is there a way to make the triggered action work only on the LAST "Single Record Update"-datapage ? Thanks Johan
  2. NiceDuck Thanks for your post. I have redesigend the wrokflow, so I guess this is solved for now.
  3. Thanks for the reply ! 1 Datapage per Webpage works allright ! Caspio is cascading the webpages by itself. Great !
  4. Hi there I tried to deploy 2 charts on the same webpage in WebFlow based on the same "On load" external parameters. The webpage seems to be in an endless loop. Did anyone encounter this problem yet ? Thanks
  5. Hi there I have a Submission form and a chain of 12 Single Record Update forms. I am in the process of deploying this in a Webflow website. QUESTION: Should I use 1 webpage to manage all 13 DataPages or should I make a separate webpage for each Single Record Update form ? Is there some explanation how this works ? Thanks for any help with this.
  6. I found it, and indeed , this was the root cause. The solution is pretty obvious, though not clearly documented in the Caspio guidance (I am not a developer): I defined two triggered actions: one for inserting data into the table and on for updating the table. Both can be used at the same time. Caspio has a lot of secrets, and I try to find out step by step. Thanks for helping me taking this extra step Johan
  7. Thanks Barbie I was wonder if database related SQL functions can be used such as INSERT INTO or UPDATE ... ALso, where can those database functions be used in Caspio ? Johan
  8. Meekeee, I want to set up a SQL statement to update an external table with information from the current record such as INSERT INTO ... VALUES... Is this possible ? And how/where should I do this ?
  9. The triggered action in the Assessment file (ref. below PRTSCR 1) should update the 'ResultTable' with five records with data from the current record on #inserted. The first record to be inserted however is created but not filled with data. The four last records are correctly created with correct data. (ref below PRTSCR 2) The entry of records in the Assessment file is based on one Submission form and 12 subsequent Single Record Update forms. Records 2 to 5 in the new table are based on data in the Submission form. Record 1 in the new table is based on data from different Single Record Update forms. -> Is the use of data from Single Record Update forms the cause of the problem ? + I tried to change the action to 'insert and update' but this didn't help... Any help appreciated ... Triggered action: ResultTable output:
  10. Thanks Nuke354, it works now ! I also ommitted the IsNull function because the fileds are required fields. Kind regards Johan
  11. I tried to solve this with an SQL statement in a calculated field. However, I had another problem with my SQL statement (see other post on SQL statement)...
  12. I have encountered the following issue when using SQL statements in a Calculated Value in a DataPage: I want to calculate average scores in a database based on the values in specific fields in the same record. These fields function as filters. Example of record: Company_Name Company_Size_Employees Company_Revenues Score Context_AVG_Employees Context_AVG_Revenues ABC Inc. <100 < 50 M USD 9 AVG of SCORE for all records in AVG of Score for all records in the DB where employees <100 the DB where revenue < 50 M USD -> SQL statement -> SQL statement In the DataPage I have fields with SQL statements defined as Calculated Value to capture the results: Context_AVG_Employees: IsNull((SELECT AVG(Score) FROM Assessment WHERE Company_Size_Employees = [@field:Company_Size_Employees]),0) -> Result is 12 = CORRECT Context_AVG_Revenues: IsNull((SELECT AVG(Score) FROM Assessment WHERE Company_Revenues = [@field:Company_Revenues]),0) -> Result is 12 = NOT CORRECT, should be 6 It seems that the second field takes also the value of the first calculation. What could be the problem and what is the solution ? Thanks !
  13. Hi there I have a table with formula DataType. I want to transfer the result of the formula to another Table via a Triggered Action -> This is not working. So I was wondering if there is a sequence to be respected and if I should perform the formula calulation also in the triggered action ? Thanks for helping me out on this. Johan
  • Create New...