Jump to content


Caspio Guru
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by Hastur

  1. Hello @Sherif To implement such a formula you may use modulo division. The formula should look something like this: CAST( ((FULL_AMOUNT_OF_MINUTES - FULL_AMOUNT_OF_MINUTES % 60) / 60) AS NVARCHAR) + '.' + CAST( ((FULL_AMOUNT_OF_MINUTES % 60) * 100 / 60) AS NVARCHAR)
  2. Hello @Sherif The formula should look something like this: DATEDIFF( hh, (SELECT TOP 1 (Name_Of_Your_Date_Field) FROM Your_Table_Name WHERE Name_Of_ID_Field = target.[@field:Name_Of_ID_Field] AND Name_Of_Your_Date_Field < target.[@field:Name_Of_Your_Date_Field] ORDER BY Name_Of_Your_Date_Field desc), target.[@field:Name_Of_Your_Date_Field] ) This formula selects the last one entry with the same ID you have entered and return the difference in hours between submitted date and selected date.
  3. @DesiLogi It is not possible to save the file itself in this way. You can use direct link as the source to display images in your application. This link needs to be saved into Text Field and then you can use it as "src" attribute of <img> HTML tag, as the example.
  4. @Fernanda Hello! I think that I have a similar solution for you. Please check this DataPage - https://c1abc032.caspio.com/dp/9a2360006d21e3b1b5b14b03942f Try to put cursor under the grey rectangle and wait for a while. You will see the report with the result set related to the hovered element ID. Is that the solution you are looking for?
  5. @Neole Hello! I think that you have found the best approach. As Caspio tabular reports do not have unique identifiers for each element, we need to deal with arrays of nodes. You need to care about the position of needed element manually by changing the number of the element in your code.
  6. @vanderLeest Hello! Unfortunately, it is not possible to set up dynamic file name for download. I have even try to change the "download" property of the link using JS and it does not change the name of downloaded file. It seems like the name of the file is coming from server side. You can suggest such a feature in Caspio Idea box - http://ideabox.caspio.com/forums/164206-caspio-bridge
  7. @kpcollier Hello! As I know, there is no any workaround on this case. However, you can use additional table to create many to many relationship and use the values from this additional table as the set to be copied by trigger. Example: Each table from example contains 2 fields. You have some users: 1 - Andy 2- Mark You have some categories: a - cat_1 b - cat_2 c - cat_3 Connection table with id's from previous tables should look like: 1 -a 1- b 1- c 2 - a 2 - b 2 - c You can create the trigger to copy entire categories set and insert in in the connection table with id of newly inserted user.
  8. Hello @Alwayslost Can you elaborate on your workflow with more details, please? I know how to implement pop-up windows using Caspio, but I need more information related to content you want to display in this pop-up.
  9. Hello @kpcollier To implement such a workflow you need to adjust the trigger to be able to check whether the needed field was changed. Check the print screens with examples here - https://dropmefiles.com/Qt9eW
  10. Hello @kpcollier Am i right that you insert the data into the Tech_Schedule_Table on Update action in Work_Order_Table? Also, as I understood, you want to insert the particular set of dates only once to avoid duplicates. Looking forward to your reply.
  11. You can use cascading with list-box. To implement the multi-select use this code in the header of the datapage: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { document.querySelector('select[name="name_of_your_select_field"]').setAttribute('multiple', 'multiple'); }); </script> You can check the name of select using the DevTools of a browser you use.
  12. Hello @kpcollier You can implement a similar workflow if you create datapages "on the fly". It can be done if your datapages use AJAX. All datapages are AJAX by default. First of all, you should create a wrapper div where you will load a new step datapage. On each step of submission, you need to define the custom event to clear wrapper and load new datapage. This event should be fired on click of next/prev buttons. Example of the function: function createPage() { var dataPage = document.createElement('script'); dataPage.src = 'https://your_domen.caspio.com/dp/your_app_key/emb?param1=' + val1 + '&param2=' + val2; document.getElementById('wrapper').appendChild(dataPage); }
  13. Hello @kpcollier I think that the better idea will be to use Cascading to restrict the amount of values you get in multi-select list box. You can check this article to get familiar with this feature - https://howto.caspio.com/datapages/datapage-components/cascading-elements/ You can use virtual field to define to category. Then you may use this field as the parent field to get appropriate set of options in multi-select list box.
  14. @rgiljohann You may use the iframe deployment to make sure that you choose appropriate chart. Use this code with the Iframe deployment: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { console.log(event.detail.appKey); var chart = Highcharts.charts[0]; console.log(chart); chart.update( { plotOptions: { series: { pointWidth: 20, cursor: 'pointer', point: { events: { click: function () { window.parent.location.href = 'https://hhaclaims.weebly.com/inpatient-referral-sources.html?HHAIPName=' + this.name; } } } } }, } ); }); </script>
  15. Also, you can check this article - https://howto.caspio.com/release-notes/caspio-bridge-13-0/13-0-impacted-areas/ It has some interesting info related to the dispatching of events when some particular datapage is ready. Here is the example from the article. <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { if (event.detail.appKey == 'MY_DATAPAGE_APPKEY') { //do something } else if (event.detail.appKey == 'MY_WEB_FORM_APPKEY') { //do something } }); </script> Maybe it will be helpful in future.
  16. @rgiljohann The issue is not related to the "id" You need to choose the appropriate chart from the "Charts" variable. Try to use this code: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { var chart = Highcharts.charts[6]; chart.update( { plotOptions: { series: { pointWidth: 50, cursor: 'pointer', point: { events: { click: function () { location.href = 'https://hhaclaims.weebly.com/inpatient-referral-sources.html?HHAIPName=' + this.name; } } } } }, } ); }); </script>
  17. Hello @rgiljohann Can you specify which chart do you want to use with the code? Looking forward to your reply.
  18. Hi @Perzival Unfortunately, it is not possible to use bootstrap classes because Caspio classes has more weight. However, you can use native Caspio styles to get needed layout. Check the Style section and try to create and adjust new one. You can find all the options related to colors of result set in the Results Page -> Table Layout Here you can find all the information related to Caspio Styles - https://howto.caspio.com/styles/
  19. @kpcollier I mean that you may have the same set of fields in both "Work Order Form" and "Client Table" tables. In this case, you can use Trigger to copy values in appropriate fields.
  20. Hello @rgiljohann Here is the example of the code you may use with Column chart to implement redirection: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { var chart = Highcharts.charts[0]; console.log(chart); chart.update( { plotOptions: { series: { pointWidth: 20, cursor: 'pointer', point: { events: { click: function () { location.href = 'https://en.wikipedia.org/wiki/' + this.name; } } } } }, } ); }); </script> Insert this code into the Header of your chart datapage. Do not forget to disable the HTML editor.
  21. Hello @kpcollier It is not possible to implement such a workflow on the trigger level because triggers have no tools to define the exact part you need to save in separate field. I can suggest you to split the Work Order submission form. In this case, it will be possible to implement such a trigger without any difficulties.
  22. Hello @Perzival Can you specify the type of a DataPage you try to use with Bootstrap styles?
  23. Hastur

    Pass Parameter

    Hi there! I need help with the following case. I have two chart Datapages deployed on a single web-page. Chart + Report Datapage with Search form above the report; Chart Datapage; In my first Datapage I have a Listbox type of form element with multi-select option enabled. I pass a parameter (on exit) for this field. Finally, I want to receive this parameter on the second Datapage to filter the data based on multiple parameters within single search field. My second Datapage does not show any data as soon as I try to select more than one criteria in the Listbox from 1st Datapage. Any help would be appreciated.
  24. @roattw Actually, I do not get your point. Can you elaborate a bit more on what you mean?
  25. @danieldonadel Hello! You can use Record Level Security to restrict the access to data based on the User Role (type of store in your case) Check these articles to get familiar with this concept : https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/ https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/create-a-workflow-using-record-level-security-and-filtered-dropdown/ https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/restrict-access-to-data-by-user-or-role/ https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/filter-lookup-dropdown-or-listbox-based-on-user-or-role/
  • Create New...