Jump to content


Caspio Ninja
  • Content Count

  • Joined

  • Last visited

  • Days Won


Glitch last won the day on March 27

Glitch had the most liked content!

About Glitch

  • Rank
    Advanced Member

Recent Profile Visitors

174 profile views
  1. Caspio Bridge can import data files in the following formats: Microsoft Access files (.mdb and .accdb, all tables data types and relationships) Microsoft Excel files (every worksheet) CSV (Comma Separated Values) Tab Delimited text Fixed Width text Caspio Bridge XML (every setting) Custom XML Please check out this article, you might be missing something important. https://howto.caspio.com/tables-and-views/importing-data/
  2. You can refer to this link whenever you want to CAST or CONVERT fields to other DataTypes: https://howto.caspio.com/function-reference/ Check under MISCELLANEOUS FUNCTIONS AND EXPRESSIONS.
  3. Let me just update the Video tutorials mentioned in the first comment. Here's the new link: https://howto.caspio.com/pre-recorded-live-training/
  4. Glitch


    Hi, Have you checked this article yet? Activities performed inside Caspio Bridge that incur data transfer include: 1. Running Scheduled Tasks : interactive/on-demand 2. Enabling CDN FileStor (count one time to move to CDN) 3. Some activities associated with Preview of DataPages. 4. Preview Submission Form and you submit data and files. 5. Preview Search and Report DataPage and you Search. When you get results with many rows and images, sorting and paging, and click to details and go back to results. Activities performed inside Caspio Bridge that don't incur data transfer include: 1. Creating and accessing objects 2. Import of apps/tables/DataPages 3. Export of objects 4. Upload and Download of files 5. Preview of Submission form without lookup dropdowns 6. Preview of Report DataPage, direct to results (or details) that does not display images nor paging activities Activities outside of the Caspio Bridge that incur data transfer. These activities include: 1. Plugin 2. Zapier 3. API 4. All end-user activities of deployed DataPages including direct URLs. Hope this answers your question, @telly telly tabies.
  5. Yes, to achieve this, you only need to enable Referential Integtrity and Cascade Update/Delete. CASCADE UPDATE AND DELETE For relationships in which referential integrity is enforced, you can enable cascade-update and cascade-delete options. When enabled, deleting a parent record or changing its ID value causes related child records to also get deleted or updated respectively in order to preserve referential integrity. You can check this link.
  6. Hi @matstein, You can consider automatic emails as well, but this will not indicate what field was changed, and what it was changed to. You are correct that this workflow should use a triggered action. I have set up an easy Triggered action on how to achieve this. FIRST, the trigger should run on UPDATE. NEXT is to join the INSERTED table with the OWN Table. This way, we can retrieve both updated value and the previous value. Here's a screen shot of how the Trigger should be set up. (My screen shot looks funny) I hope this helps. I also have attached the table, in case you want to test it for yourself SendEmail_2019-May-02_1717.zip To use SELECT along with the Send Email, just click the Gear button on its right. Regards. Glitchhhhh
  7. Hi @PlaceWorks, Have you tried the comparison type, "NOT IN"? This will allow you to check if that ID is existing in the other table. As I understand, This trigger should insert a Data in the other tables upon update, which explains the behavior that it inserts a new data upon update. I have a similar workflow on my app, that ifever an ID is not existing, it will insert a new record. If it is existing, update the record. Tables_2019-May-01_2304.zip Hope this helps.
  8. This can help =) You just need to use the [@authfield] parameter that comes from the login
  9. You should add the sum to the inserted Value. Reading the trigger, You are only summing up the CommentHRS. Meaning to say, the inserted one is still excluded, since you are still on the process of inserting the Data. I hope this helps.
  10. You can easily compare plans here: https://www.caspio.com/pricing/basic-plans/
  11. I think you'll be needing Javascipt for this function. Something like this one:
  12. If you already put the responsive codes inside your DataPage, like what's mentioned here. Have you perhaps included this on your website? <meta name="viewport" content="width=device-width, initial-scale=1"> Also, you may need to add some codes inside the media query string to make other containers responsive. I have tried something like this as well, and some of the HTML blocks and other containers does not respond with the responsive codes. But with a little help of selectors and some CSS, I got it to work. (Why is the text blue). Oh well. I hope this helps. Glitch.
  13. While it is true that you can use SELECT Statements for this. I think it is also doable using Pivot tables, wherein you can easily select Value then use summarize values by Count. You can refer to this link.
  14. Hi @Becca37, Caspio only allows a limit of 2 cascading triggers. That being said, it seems that you already exceeded this limit. As you mentioned, these are the events occuring on your cascading triggers "(1) Insert into Clients triggers insert into audit and Admissions (2) Insert into Admission triggers insert into audit and AdmissionChecklistItems (3) Insert into AdmissionChecklistItems triggers insert into audit" Due to the system limit, you may want to rethink the structure of the trigger. My first question is, the trigger that you are trying to implement, can it be compressed or joined to the prior triggers? For example, if trigger one inserts to table 2. and table 2 has trigger that inserts the inserted record to table 3. Would it be possible if we joined these triggers on trigger 1 itself? I do not have an overview with your triggers, but it could be helpful if you would explain how it works. I hope this helps.
  • Create New...