Jump to content

Vitalikssssss

Caspio Rockstar
  • Content Count

    383
  • Joined

  • Last visited

  • Days Won

    37

Everything posted by Vitalikssssss

  1. Hi @Corpcatalog, You can build such Chart in Caspio but you would need to modify your table first. You table should look like the following: You can build the following Chart once you transform your table: You may import attached Datapage to your account in order to see the settings for the Chart Datapage. Hope this helps. Regards, vitalikssssss CaspioData_2019-Sep-10_1309.zip
  2. Hi @mgredmond, It looks like a Bug to me. I would recommend reporting this issue to Customer Support via a ticket. Hope they will be able to address it quickly. regards, vitalikssssss
  3. Hi @kpcollier, You should consider using Triggered action for this type of ID generation. Your Trigger should be based on Order table and should update the #inserted. Also, you need to have on field to store a sequence number of the Order. You can import attached examples to find more about the Trigger. Hope this helps. Regards, vitalikssssss Dynamic_ID_number_1_0_2019-Sep-05_1359.zip
  4. List-String is a special Datatype and I am afraid you cannot use is in SQL functions.
  5. @roattw, By Dropbox, did you mean List-String with 4 choices?
  6. @JJMcM123, You should use Product table as a Datasource in order to create a report with a unique Product without duplicates. You can use SQL in Calculated fields in order to retrieve values from Price table. Relationships between table will not help to avoid the duplicates. Hope this helps. Regards, vitalikssssss
  7. Hi @kpcollier, I think you should consider using Triggered action in order to validate if customer exist or not. You can create a new record if the customer does not exist with Triggered action. Hope this helps. Regards, vitalikssssss
  8. Hi @splinteredangel, I assume that you using Auto-submit JS from the following post: https://forums.caspio.com/topic/4314-js-auto-submit-a-datapage/ If so, you can change timeout time in order to slow down the submit of the Datapage. By default, the code set to auto-submit the form with 1 sec (1000 ms). Hope this helps. Regards, vitalikssssss
  9. Hi @JJMcM123, Please send us a screenshot of table relationship between concerned tables. Thanks, vitalikssssss
  10. Hi @JJMcM123, Try using the following expression in your Calculated field: SELECT TOP 1 Price FROM Price WHERE PlanID = target.[@field:PlanID] ORDER BY Date DESC Make sure that you using table "Plans" as a Datasource for your Report Datapage. Hope this helps. Regards, vitalikssssss
  11. Hi @kpcollier, I was able to replicate the issue only in FF browser, however the behavior was not consistent. I would recommend adding min-width property with an "!important" tag to all List-String elements. You can check this screenshot for more information. Hope this helps. Regards, vitalikssssss
  12. Hi everyone, I would like to implement XIRR function from Excel in Caspio. Can somebody give me a direction on how to achieve this? Thanks, vitalikssssss
  13. Hi @Colnocode, Perhaps you can utilize a Triggered Action feature in order to create a back-up log of quotes. More or less similar case explained in the following tutorial video: https://www.youtube.com/watch?v=wA7KR9dygh4 Let us know if you need any further help. Regards, vitalikssssss
  14. Hi @roattw, I do not think there is a way to add a prefix First_Last_Name to the uploaded file. I have found a similar request on Caspio IdeaBox: 164206, so you can vote for implementing such a feature in one of the upcoming releases. If you allow your users to upload files with authenticated DP (Submission/Report) then you can capture user ID in a hidden field. Hope this helps. Regards, vitalikssssss
  15. @kpcollier, I see. Perhaps you can place a package on a Dropbox or G drive and provide me with a share link via private message. Regards, vitalikssssss
  16. Hi @kpcollier, My suggestion is to check field width property for concerned List-String. Try using a fixed width in pixels: Please provide me with an exported copy of Datapage along with dependencies (without data) if the issue still persist. Regards, vitalikssssss
  17. Hi @kpcollier, I have seen similar behavior on Caspio Ready Made App called Resource scheduling. http://apps.caspio.com/demo9/rs/login.html Login in as a member, perform a simple search and you will see a Tabular Report with "Reserve this Item" button which performs similar logic. I believe you need the following items in order to create similarly flow within your app: 1. Single record update form with default elements hidden by CSS. 2. Embed this DP in the HTML block of the report by using the Iframe deployment method. I need to mention that DP performance might decrease if you have a lot of records on Result set (e.g. 250 per page). Hope this helps. Regards, Vitalikssssss
  18. Hi @mgredmond, Do you use View as a Datasource for the Datapage? Perhaps you trying to write a parameter into the table which is not editable. Hope this helps. Regards, vitaliksssss
  19. Hi @roattw, It is not necessary to use SQL to count a number of times a checkbox was checked. It is hard to imagine how your table design looks like, so I can provide you with general tips. You can check the Total & Aggregation field available in Tabular report to create desired output: https://howto.caspio.com/datapages/reports/advanced-reporting/totals-and-aggregations/ You may also consider using Pivot table in order to get an aggregated count: https://howto.caspio.com/datapages/reports/pivot-table/ One of the reasons why I chosen Caspio over the Knack is the ability to store an unlimited number of records in the table, and easier customization of styles. You can post on Caspio Idea Box if you have some ideas on how to make Caspio better from a user perspective. Hope this helps. P.S. share an example of your table if you need more detailed guideline with aggregate expression. Regards, vitalikssss
  20. Hi @kpcollier, What DP type do you use?
  21. I have tweaked the formula provided by @MayMusic further since some time I need zero in front of single-digit hour e.g. 7:00. So, for the total&aggeration field it looks like this: (CASE WHEN LEN(CAST ((SUM(DATEDIFF(SECOND, [@field:Start_time], [@field:End_time]))/3600) AS VARCHAR(6))) < 2 THEN '0'+ CAST ((SUM(DATEDIFF(SECOND, [@field:Start_time], [@field:Hora_fin]))/3600) AS VARCHAR(6)) ELSE CAST ((SUM(DATEDIFF(SECOND, [@field:Start_time], [@field:Hora_fin]))/3600) AS VARCHAR(6)) END) + ':' + (CASE WHEN LEN(CAST ((SUM(DATEDIFF(SECOND, [@field:Start_time], [@field:Hora_fin]))%3600/60) AS VARCHAR(6))) < 2 THEN '0'+ CAST ((SUM(DATEDIFF(SECOND, [@field:Start_time], [@field:Hora_fin]))%3600/60) AS VARCHAR(6)) ELSE CAST ((SUM(DATEDIFF(SECOND, [@field:Start_time], [@field:Hora_fin]))%3600/60) AS VARCHAR(6)) END) Hope it would help someone. Regards, vitalikssssss
  22. Hi @MayMusic, I have noticed that this expression does not return a correct result if accumulated hours exceeds 24 hours. Can you help me to tweak the formula? Thanks, vitalikssssss
  23. Hi @eetimm, Please note that below syntax in SQL query is incorrect because it is treated as a single string value: How do you store data in the field "search_alpha"? It would help if you could provide us with more insights on how this field is generated and what is the desired output of the Trigger. Regards, Vitalikssssss
  24. Hi there, How can I create a chart using just values from table fields but not the count/sum functions? My result set is 1 row and I want to show values on a chart. If value is blank - I don't want to show it on the chart. Any help will be appreciated. Regards, vitalikssssss
  25. @Casey, it looks like a bug to me too. It is better to notify Support Team, so they could address it in one of the upcoming releases. regards, vitalikssssss
×
×
  • Create New...