Jump to content

BaySunshine

Caspio Ninja
  • Content Count

    46
  • Joined

  • Last visited

  • Days Won

    3

BaySunshine last won the day on February 2

BaySunshine had the most liked content!

About BaySunshine

  • Rank
    Advanced Member

Recent Profile Visitors

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

  1. Hi @DesiLogi, The error "Values cannot be submitted due to a data restriction" can be caused due to formula fields or triggers. Do you have those in your table? If you do, check those first. Disable trigger temporarily and try. If there is formula field, verify if the formula used is correct. Other way to confirm if JS is causing this error is by removing the code from the DataPage and test it. Before that make sure to save it on notepad or some place. If you still get the error, then it means that there is something else that is causing the error. Regards,
  2. Hi @NickO, Any time you have a many-to-many relation between two tables, always create a third table which has ids from both tables. That way you avoid having this kind of an issue. Example of a many-man-many relation: In this example, Orders and Products table are related many-to-many. So, a third table is added, Order_Products which will join these two tables individually by one-to-many relationship. I hope that helps. Regards,
  3. BaySunshine

    Tim

    Hi @TimJaggs, The only way to do an auto save in Caspio is by using Grid Edit functionality of a report. The Grid Edit works like an Excel sheet wherein you enter data in each cell and the system automatically saves the data. Here is the howto link for Grid Edit: https://howto.caspio.com/datapages/reports/data-editing-options-in-reports/ The other suggestion that Caspio usually gives for long forms is to create a multi-step form. In this the first step uses a submission page and the rest uses Details page with auto submission. You can refer to the steps from this article https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-create-a-multi-page-form/. Hope it helps.
  4. Hi @arnold, You cannot add fields dynamically to a table in Caspio. As a workaround for your use case, you can add some extra fields in the table and rules to show/hide them in the form. Refer to the howto article https://howto.caspio.com/datapages/forms/conditional-forms/ for help on creating rules in a submission form. Hope that helps.
  5. Hello @MrsWhitebread, To achieve this workflow, create a view for client-funder table based on the matching issue area. Then create a report DataPage using the view as the data source and filtered on predefined criteria. Pass search values for client, funder and issue area of match as parameters to the DataPage. It will then pull the matching results based on the specified criteria. I hope that helps.
  6. Hi @bbeshlian, The solution for this issue is to use a table which has ID field marked as unique field in the table. Use this field as the data source of your report DataPage. To show the rest of the fields in the report, use calculated fields with SQL queries to query the view based on the same ID value. Be sure to include a Where condition which will help only pull a certain record for the respective ID value. When using a view in the calculated field, add '_v_' to the name of the table like shown below: select field_name1 from _v_viewname where field_name2='..........' I hope that helps. Regards,
  7. Hi @Durand, Is your Description field set as a Cascading text field to show the description of a part number from another table? If so, I advise you to add a Virtual field and change the form element of this field to 'Calculated value'. Add a Case..When statement as below: ************* Case when [@field: Part_Number] is null Then 'Invalid Part Number' End ************* Add a Rule to the DataPage for both the Virtual field and the Description field. Rule 1: Part number field 'is blank', 'hide' Description field Rule 2: Part number field 'is not blank', 'hide ' Virtual field. I hope that helps. Regards,
  8. Hi @JanineB, Tasks can be set to run at specific intervals during the day, week or a month etc. However, if you are looking for updating the empty values as soon as they are inserted, you can use a trigger. For this, create a triggered action on the main table based on an insert action on the table. Then add a update trigger to update the inserted table field. Add a join to join the inserted table with the city table based on their ids. Hope that helps.
  9. Hi @kpcollier, You can use triggers to insert 3 lines in a new/existing table on an insert action in a table. For calculating total cost estimates, you can use a report. I hope that helps.
  10. Hi @FinTheHuman, Add left and top features to your code and you should be able to place it anywhere on the window. <a class="workorder" href="#" onclick="window.open("https://www.google.com/","mywindow", "menubar=1,resizable=1,width=750,height=950, top=150, left=500")">Google</a> I hope this helps.
  11. Hi @george43, Thanks for correction. I missed it. Yes, it should be document.getElementsByName("Value1_1")[0].value.
  12. The fields in the Search form can be referred to as Value1_1, Value2_1, Value3_1 etc in the order they are displayed. So, to access Value_1, you can enter: document.getElementsByName("Value1_1").value or document.getElementByID("Value1_1").value Hope that helps. Regards,
  13. Hi @JolliBeng, In Download Settings, select data to be printed from the Details page instead of the Results page. In the Details page, add all the fields that you intend to display in the PDF. I hope that helps. Regards,
  14. Hi @kpcollier, You can freeze first columns from Results Page Options settings. https://howto.caspio.com/datapages/reports/fixed-rows-and-columns/
  15. Hi @wvantongeren, Also make sure to add a group by clause if there are multiple records containing the same ID. Is OffertNR an ID field? If it is then try the following: SELECT sum(Teller) FROM K_Schadekenmerken_Data WHERE OfferteNR = target.[@field:OfferteNR] group by OfferteNR For examples, check out https://www.w3schools.com/sql/sql_groupby.asp.
×
×
  • Create New...