Jump to content


Caspio Evangelist
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Vitalikssssss

  1. Hi @kpcollier, Indeed there was a case which I did not think through. Here is a code which should resolve the issue: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { let v_fields = ["Labor1_Rate", "Labor1_Hours", "Labor2_Rate", "Labor2_Hours", "Labor3_Rate","Labor3_Hours", "Labor4_Rate", "Labor4_Hours", "Labor5_Rate", "Labor5_Hours", "Labor6_Rate", "Labor6_Hours", "Labor7_Rate", "Labor7_Hours", "Labor8_Rate", "Labor8_Hours", "Labor9_Rate", "Labor9_Hours", "Labor10_Rate", "Labor10_Hours", "Labor11_Rate", "Labor11_Hours", "Labor1
  2. Hi @rgiljohann, I think you can utilize a workaround from the following topic. Hope this helps. Regards, vitalikssssss
  3. Hi @rgiljohann, Try removing <noscript> tags which you have used to wrap Iframe. Also, I think you can set all Iframe attributes within <iframe> tags i.o. using a JS code. Hope this helps. Regards, vitalikssssss
  4. @kpcollier, I am glad that my suggestions helped. Regards, vitalikssssss
  5. Hi @kpcollier, Try this code: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { let v_fields = ["Labor1_Rate", "Labor1_Hours", "Labor2_Rate", "Labor2_Hours", "Labor3_Rate","Labor3_Hours", "Labor4_Rate", "Labor4_Hours", "Labor5_Rate", "Labor5_Hours", "Labor6_Rate", "Labor6_Hours", "Labor7_Rate", "Labor7_Hours", "Labor8_Rate", "Labor8_Hours", "Labor9_Rate", "Labor9_Hours", "Labor10_Rate", "Labor10_Hours", "Labor11_Rate", "Labor11_Hours", "Labor12_Rate", "Labor12_Hours", "Labor13_Rate", "Labor13_Hours", "Labor14_Rate", "Labor14_Hour
  6. Hi @dasigrist, REST/SOAP API is dedicated for people with extensive programming knowledge. I would recommend to contact these guys who can help you with REST/SOAP API. Regards, vitalikssssss
  7. Hi @kpcollier, You can use "start with" type of comparison in query selector like this: document.querySelector("input[id^='InsertRecordPrimary_Address']").value; The whole code would look like this: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { function f_address(){ if(document.getElementById('cbParamVirtual4').checked) { document.querySelector("input[id^='InsertRecordBilling_Address']").value = document.querySelector("input[id^='InsertRecordPrimary_Address']").value; document.querySelector("input[id^='InsertRecordB
  8. Hi @DesiLogi, It would be more challenging to get display values instead of ID`s. I have found a solution which might work for your case. Basically, you would need to add additional Calculated field to your Gallery report Datapage and modify the JS. 1. Calculated Field will use SQL in order to get string of all lookup values. You can use the following expression: STUFF((SELECT CAST(', ' + Name AS VARCHAR(MAX)) FROM a_1 FOR XML PATH ('')), 1, 2, '') Where: a_1 name of your Table which stores lookup values, "Name" - name of the fi
  9. Hi @Prophecy, First, you should use Caspio`s build-in event handlers (e.g. Datapage ready). Second, you should change the way how you trying to reference calculated field. You use Submission form along with Calculated Value form element as I have understood. If my assumption is correct than you can use the following code: <div id="Section_2" style="display:none;"> Some text Section 2 </div> <div id="Section_3" style="display:none;"> Some text Section 3 </div> <div id="Section_4" style="display:none;"> Some text Section 4 </di
  10. Hi @DesiLogi, You have made a small error in the field names reference in JS. You should have used Tags_Areas and Tags_Projects in the JS code. The code will work just fine as soon as you apply above changes. Regards, vitalikssssss
  11. Hi @NiceDuck, It will not be possible to capture who has deleted the record with Triggered action. I would recommend using another Datapage with auto-submit JS which would insert a record to the history log table. You configure your page to re-direct after record delete to the submission form and also pass parameters on exit to the submission form. However, this workflow would work only if you delete records from Details page. Hope this helps. Regards, vitalikssssss
  12. Hi @scottd, Here is a topic with a solution: Hope this helps Regards, vitalikssssss
  13. Hi @DesiLogi, Please send me an exported copy of the Datapage along with dependencies via private message, so I could have a close look. In the interim, you may import the Datapage which I`ve created while working on JS solution. It works fine on Mac. I can select multiple items by holding Command key. Regards, vitalikssssss CaspioData_2019-Oct-01_0958.zip
  14. Hi @kpcollier, This should be possible with Triggered Action. The Trigger should run on "insert event" and should checked #inserted value with lookup table values. You can create a new record in the lookup table if there are no records returned. Regards, vitalikssssss
  15. Hi @scottd, You can utilize Calculated value for the described scenario. https://www.youtube.com/watch?v=15zAruBT3LA Hope this helps. Regards, Vitalikssssss
  16. Hi @DesiLogi, Try using the following script in the Footer of the Datapage: <script type="text/javascript"> function f_listbox(v_state) { if ( v_state.indexOf(",") > 0 ) { for (let i=0 ; i < o_state.options.length; i++ ) { if(o_state[i].value == v_state) { o_state.remove(i); break ; } } let o_st = v_state.split(", ") ; for (let j=0 ; j < o_st.length; j++) { for (let i=0 ; i < o_state.options.length; i++ ) { if(o_st[j]== o_state.options[i].value){ o_state.options[i].selected = true ; break ; } } }
  17. Hi @Carioca, BTW there is a setting in Datapage wizard available for this. Regards, vitalikssssss
  18. Hi @DesiLogi, As I have understood you would like to have something similar to this: You would need a bit of JS to achieve this. Initially I have used this post as the inspiration for the following JS code which produce list of items. <!––Place this code into HTML block.--> <div id="demo[@field:Record_ID#]"></div> <!––[@field:Record_ID#] is a unique indentifier of the record--> <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { let list_string, arr, arrLen, text, i; list_string = "[@field:Text]
  19. Hi @Andrew, I am afraid that you will not be able to parse multi-select Listbox parameter in your second Datapage, however you should be able to achieve the desired logic of filtering if you use search form with multi-select Listbox on your second Datapage. You can create a Javascript code which would click on the "Search" button within 2nd Datapage after user clicks on "Search" on the 1st Datapage and also hide a Search form from the 2nd Datapage. Here is JS code which I have used: 1. Wrap a Search from from 2nd Datapage with the following: Header: <div id="search_f
  20. Hi @Roosta, I have managed to create the following Pivot Report based on the data you have shared. Let me know if you need any additional calculations in this Pivot report. Regards, vitalikssssss a1_Pivot_test_1_0_2019-Sep-26_1403.zip
  21. Hi @DesiLogi, I am not quite understood the logic of your Tabular/Gallery datapages. Do you have bulk edit option enabled where you would like to use ListBox with multiselect option? Regards, vitalikssssss
  22. Hi @Roosta, Can you share a datasource table, so I could try to build a relevant example using Pivot? Regards, vitalikssssss
  23. Hi @TaxGuy, I believe that the JS event you currently use causes the issue. Try to use Caspio built-in event handler BeforeFormSubmit explained in this article: https://howto.caspio.com/release-notes/caspio-bridge-13-0/13-0-impacted-areas/ Hope this helps. Regards, vitalikssssss
  24. Hi @NickO, I do not think it would be possible without back-end programming. I would suggest contacting Caspio Professional Services Team who can build this type of integration via back-end. Regards, vitalikssssss
  25. Hi @CHlux, I do not think you will be able to transfer file via Zapier. Perhaps you should check WebMerge REST API which should have a method to post a file into external database such as Caspio. Caspio REST API supports file transfer. You can check Swagger documentation in order to find the method for file transfer. I would recommend Professional service department of Caspio if you are not familiar with REST API. Hope this helps. Regards, vitalikssssss
  • Create New...