Jump to content

DefinitelyNot31337

Caspio Guru
  • Content Count

    183
  • Joined

  • Last visited

  • Days Won

    18

DefinitelyNot31337 last won the day on December 19 2019

DefinitelyNot31337 had the most liked content!

2 Followers

About DefinitelyNot31337

  • Rank
    Advanced Member

Recent Profile Visitors

1,018 profile views
  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.
×
×
  • Create New...