Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

Everything posted by Johan

  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
  14. I have a data table with student grades (0-10) for math, for science, etc. When entering a new record for a student, I would like to compare the new score with the average of the entire student database, let's say for math, and then for science, ... Next I want to write the average score of each field into the current record for comparison. I thought that Triggered Actions would do, but don't know how to go forward with this. Any help ? Thanks!
  15. Thanks a lot for your replies kpcollier ! I'll check it out. Kind regards Johan
  16. Thanks for your comprehensive feedback ! Still some questions though: 1. In localisations> Paging : there are "previous" and "next" defined. Are these buttons or is this something else ? 2. In your answer you wrote: a. Step 1 page: The first step must be a submission form. In the DataPage Wizard on the last page (Destination and Messaging), set Destination After Submit to 'Go to a new page'. Put the URL of the next step's dd datapage here. -> I jut want to go to another datapage. Can't I just give the name of the datapage instead of a URL ? b. Make an HTML Block and put it at the very bottom of your page. Insert this code to create Previous and Next buttons (URL for Previous will be the URL for going back to Step 1, which we will cover next. Make sure to change UniqueField with your own unique field from your table) : -> here too, can't I use the pagename instead of a URL ? c. Styling -> Can't I put this in a custom style instead of the header of pages ? thanks !
  17. Hi there, I am trying to make a benchmark chart where the current record within a dataset is compared to the dataset average. THere is no problem getting the current datarecord fields, however, they cannot be included in the chart: the chart functionality does not allow to select current record data, only average, sum, min, max, etc. Anyone done this before ? Thanks
  18. Where should I put this script . I am no programmer ... In the styles, ... ?
  19. I agree with TDNGromac Strange to see that their demo charts are nicely spread, but in reality they are crowded. I have the same problem. This is something that should be solved. Having the problem solved with JS is in contradiction with Caspio's value proposition "Build Cloud Database Apps Without Coding! " ...
  20. Is there a way to put navigation buttons "previous" and "next" so I can navigate through multi-step forms, e.g. in the footer of a datapage ?
  21. Thanks for your help The following (see image) eventually helps with one major problem: it is the previous record that gets updated ... any idea what I should do ? Moreover, I cannot execute this for both "insert" and "update". Here too, any idea ? Thanks for your help.
  • Create New...