Jump to content


Caspio Guru
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by DefinitelyNot31337

  1. Regarding the OP, I suggest to not reference from your DataSource fields ([@field:]) since you are using a SELECT statement. Secondly, try enclosing the count fieldname inside parentheses. The resulting query should look like something below: SELECT COUNT(Significnat_Other FROM tablename WHERE Significnat_Other = "Yes"
  2. Hello @Tr0Jan, I believe that Angular JS/2+ framework, similar to other popular JavaScript front-end frameworks/libraries (React, Vue), do not allow execution of external scripts (as widgets) and I haven't been able to disable this 'feature'. What I did to work this around was to deploy DataPages as iFrames. However, you would be needing JavaScript to resize and pass parameters onto your frames. In addition to this complexity, you wouldn't be able to utilize Caspio's AJAX functionality, and navigating your parent page requires JavaScript. If I assume correc
  3. It is possible that there is a JavaScript on the target webpage that causes the window to close. Either it is defined on an HTML Block, or set in "Destination after record submit" configuration. If this is the case, then, it is expected that the browser should have closed and is only not able to do so when opened on another window. I am assuming that the implementation was similar to this: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/add-an-option-to-a-public-facing-dropdown/ Anyway, if you have the browser open, you may open up your Dev Tools/Firebug >
  4. Hi. I was supposed to reply to this thread then reference it to the other one but instead I did it the other way around. Try checking this link:
  5. With the recent Caspio Release 20, the features Variables and Loops on Triggers and Tasks should make this possible. This workflow is pretty advanced, the following are pre-requisites: 1.) Auxiliary (aux) table 2.) An Autonumber field in the table you would be selecting against. (Timestamps would also do, if they can be unique. But let's stick with autonumber. It's much simpler.) Below is a Trigger demonstrating this implementation. On an aux table, create an OnInsert Trigger, that: 1.) Instatiates variables: a. init (min autonumber), b. len (
  6. Hi @Elderberg, It's true that this solution is experimental. Creating JS customizations for this feature (Inline Edit) is tricky, especially on Cascading Dropdowns. I see a lot of requests regarding that lately. I'm trying to work on it but it's harder than it looks. Anyway, for Dropdown form elements (NOTE: NOT working on Cascading Dropdowns!), I see that it's not working, but simply wrapping the script on a DataPageReady listener does the trick. Here's the code for 'ya. <script> document.addEventListener('DataPageReady', function() { // Replace [@
  7. h3110, With the recent Caspio Release 20 comes an improvement in Triggered Actions called "Variables" and "Do-While Loop". These allow you to achieve this workflow without having to specify a dummy table. Attached are the screenshot of the Trigger, and the Table Design Used. Hope this helps. Happy H4x1ng- -DefinitelyNot31337 Tables_2019-Dec-09_0543.zip
  8. While you may be using a 64-bit Operating System, it is possible that you may be using a 32-bit MS Office. This is because 32-bit apps are compatible with 64-bit OS'es, but not the other way around. 64-bit apps run faster since it can utilize more System RAM*, so it is really helpful to know if you have support to 64-bit versions of apps. Provided that you have 64-bit MS Office, it's best if you install 64-bit MS Plugin as well. Here's another article to determine which version of MS Office you are using: https://howto.salesflare.com/en/articles/1013253-how-do-i-know-if-my-outlook-progra
  9. On your DataPage, you have the option to overwrite an uploaded file so you don't keep the same file name at once. Reference: https://howto.caspio.com/files-and-images/uploading-files-and-images/ -DN31337
  10. Do you have a Separate List DataPage and (Single-Record Update, or Details DataPage)? I assume you have two DataPages since you can't have Inline Edit on List DataPage. In this case, you would need some interface to have the two connected to each other. Let me know if you have the deployed the SRU/Details DataPage as an iframe, or as embed on the same page as the List DataPage. Also, let me know if my assumption is correct.
  11. In addition to this, we may also specify this behavior to be default (on Styles level) so you don't have to specify the customization every time. To do so, locate your Styles first, but before modifying it I would suggest to duplicate the current style as backup. Once you are in the Styles configuration: 1.) Click on Source Tab 2.) Select All from DataPage Elements 3.) Look for cbTableDefaultCellspacing 4.) Add the rule: margin: auto; Below is how it should look like: Once this is saved, your DataPages with this localization will b
  12. Hi @JanineB, You may also upload external files to your Caspio Account then reference it on your DataPages. You may also do this on other files such as css, images, etc... Hope this helps
  13. First, I'm not sure why you had to do Full Name and Full Address on your Work Order table when you can structure it the same way as your Clients table (with First_Name, Last_Name, etc... on separate fields). === I haven't reviewed the table design and workflow as well. Haha. But I wanted to mention that formula field values can be referenced in the trigger (Read-only). This means that if you are able to separate the fields you need on a formula field, you may simply set First_Name_Text255 = #inserted.First_Name_Formula on your trigger. Hope this help
  14. Hi @NeoInJS, Having the date field default to first day of the month, and have the field be editable at the same time is currently not possible in Submission Forms without JavaScript customization. Too keep things simple in cases of "editable-default" value , I usually just setup a Virtual Field that is a placeholder of the custom user-input value, then have a Calculated Value for the actual field to be either the "user-input value", or the default value if it is blank. You may do so by following these instructions: 1.) Create a Virtual Field that will
  15. I agree that a feature like this is really a must-have for the platform. Meanwhile, for everyone's appreciation, we may also utilize Pivot Tables for the meantime. Add your distinct-to-be field in the Row, and your date for Values. Then set the summary to Max Do note, however, that Pivot Tables' performance becomes terrible as the DataSource grows. Less that 10,000 should work fine.
  16. Hi In addition to my response here, you may also check my latest solution which dynamically sets the height of the iframe based on its content. Hope this helps -DN31337!
  17. Hello @Didier, I was able to formulate a working solution by putting together workflows from external resources. On the Footer of the DataPage you want to deploy as iframe, paste the snippet below (Make sure HTML Editor is disabled from the Advanced Tab). //Script tested on Tabular Report <script> document.addEventListener('DataPageReady', function() { parent.postMessage(document.documentElement.scrollHeight, "*"); console.log(document.documentElement.scrollHeight); }) </script> On cases of Submission Form / Details Drilldown, you
  18. @Batchini, you may also consider this solution. 1.) Create a view. INNER JOIN on Table1.Project_ID = Table2.ProjectID. 2.) Create a Pivot Table using the View on item#1 as your DataSource 3.) For your rows, use Table1.ProjectName 3.) For your values, use Table2.Status; then set "Summarize values by:" to Min Hope this helps -DN31337!
  19. If you intend to filter your Parent records based on min(FieldName), Triggered Actions would be the way to go since Caspio does not have the capability to filter a report by a Calculated Field as of the moment. Also, it might be worth mentioning that Triggered Actions are not available on Explore plans x). --
  20. Hi @NickO, I agree that doing 15 Calculated Fields is better in performance the more complex Pivot Table. To my knowledge, I believe this is the most optimized solution we can implement. You just have a big amount of data. === You may want to consider "caching" your results by creating 15 integer fields (corresponding to each of your criteria) on your table, then populate it either by Tasks/Triggered Actions. Sorry for the late revert. Do feel free to tag/mention me with the "@" sign so I get notified when you respond.
  21. Hi @kristina, I believe you need to remove the space between thisDP and .querySelector. There are two instances of this in your code which results to a syntax error (^_^)v In addition, everyone else may also try this version of JS by putting this on an HTML Block in their search form: <script> var thisDP = document.querySelector(`[action*="[@cbAppKey]"]`); thisDP.addEventListener('change', function() { console.log('Changed!'); thisDP.querySelector('.cbSearchButton').click(); }); </script> This will automatically hit search everytime an input value has b
  22. Try checking Aggregation and Pivot Table Reports. https://howto.caspio.com/getting-started/advanced-reporting/advanced-reporting-1-of-2-grouping-and-aggregation/ https://howto.caspio.com/getting-started/advanced-reporting/advanced-reporting-2-of-2-calculated-fields/ https://howto.caspio.com/datapages/reports/pivot-table/ https://howto.caspio.com/getting-started/create-a-pivot-table-report/ You may need to create a separate DataPage for each reporting aggregation (i.e. Monthly, Yearly) As for per individual, departments, company overview, looks like you just n
  23. Hello Arnold. You might want to check my answer to this thread: The workflow above would be just one part of your solution since it only just allows you to duplicate a whole form, not a section. I'd suggest partnering that one with multi-step forms/one-to-many relationship so each section of your form is a different DataPage, and you can duplicate as needed. https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-create-a-multi-page-form/ https://youtu.be/J6dBPuipaNc https://www.youtube.com/watch?v=Hgflq6tUliU https://www.youtub
  24. I also think that is currently not possible. I was thinking of a Cascading Trigger workflow would do the trick, but unfortunately, it doesn't. Below is how I simulated it's runtime. === The children table, on record update, would append the value of the updated record to its corresponding parent in the parent table This Task should initially clear out the values in the parent table; After that, update each record in the child table so the trigger would be executed for each record. ==== However, it appears that the "Update chil
  25. The listener on the element should be "change". In addition, I'd recommend using a Query Selector wildcard since AJAX Loading generates a random suffix for the attribute. Finally, while arrow functions () => {} look more neat, this doesn't work on IE11 and lower browsers. Putting it all together and updating George43's code, try this and see if it will work: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { document.querySelector('[id*=InsertRecordSource_Shift]').addEventListener('change', function() { //yo
  • Create New...