All Activity

Please mark as best answer if this is what you are looking for. I defined this table: where there are 2 orders (OR-001 and OR-002) whit some items. Then I defined this task: After running the task the table is changed in this way: Note the totals in sum_of_dollar_value. Is this what you need?

Hi! Just wanted to show a little trick I use for my task/trigger email styling. I use an HTML Block or any element in a DataPage where I can make texts with styling. Then, I just hit "source" and copy the code

Another approach is to use a Calculated Field to determine if the record is already overdue, due this month, or due next month. Then the use the result of this Calculated field in the condition on the script. CASE WHEN [@field:Date] < Getdate() THEN 'overdue' WHEN (DatePart(month,[@field:Date]) > DatePart(month, Getdate())) AND (DatePart(year,[@field:Date]) = DatePart(year, Getdate())) THEN 'next month' WHEN (DatePart(month,[@field:Date]) = DatePart(month, Getdate())) AND (DatePart(year,[@field:Date]) = DatePart(year, Getdate())) THEN 'this month' END Then, you can apply the script provided here: https://howto.caspio.com/tech-tips-and-articles/how-to-dynamically-change-the-background-of-a-results-page/

Hi @khale, This forum post might help you with your desired result:

Hi @khale, Based on your workflow, it seems that a parent-child (one-to-many) table relationship is a better approach to having multiple dates on a calendar. I believe it will resolve the issue of the date being overwritten by a new date. The parent table could contain your clients' information, while the child table contains the dates of appointments. Here are also some article and video I found regarding the parent-child relationship: Creating a One to Many Relational DataPage Creating a One-to-Many Relationship — Child Forms and Child Reports in Caspio I hope this helps!

Hi everyone, Just want to share this HowTo article to have a dynamic redirection based on user input: Creating Dynamic Redirections After Form Submission Cheers!

Hi @MarkMayhrai, Caspio has an extension in their marketplace that is similar to your desired output. I believe you can add some information for customization before requesting it to your account. You may want to check it out: Bar Rating Extension Cheers!

Hi @MarkMayhrai, You may also want to create a Rule to hide the fields if there's no selection from the user. You can refer to the guides below: Conditional Forms Video - Creating Conditional Forms Using Caspio I hope this helps!

You can also check these HowTo articles: Shared Objects Sharing Data Between Apps

Hi @BrianI, Yes, it is possible to share the same tables with multiple apps. But please note that if they have an existing relationship with other table/s, it will also be shared to the shared app. For example, I have tables A, B, and C on my Sales App (tables A and B have a relationship with each other). I shared table A to my Marketing App, then table B will also be shared since they have a relationship. I hope that helps!

Hi @Gilmay, You may want to check the trigger from this forum thread: Cheers

Oh, I also saw this thread that tracks the insert, update, and delete actions from a table: I hope this helps!

Hi @kyle425, I believe this forum thread is similar to what you are trying to achieve:

HI All, We have a group of clients that all want their own form to fill in their own data. We want those forms to fill copy entries to two other tables. One will be a master table (Cleaned) and the other we are hoping to have a table that shows every input including deletion from the second table. So each partner will have their personal data. Then we will have a master table that combines all partners' data into one which is being cleaned for duplicate submissions by different partners. The 3rd will be a master that will keep everyone data without being cleaned of duplicates. Can anybody walk me through if this is possible.

Hi Hi, I don't want to add a running total to my datapage. Lots of examples on doing that. I actually want to add the running total to my table. I can use a task that I will run periodically to update my running sum. I have a table with 4 fields: Order Date, Order #, Dollar Value, Running Sum of Dollar Value. I want to sort by date and then calculate the running sum for each record. Thank you in advance.

This is what I try to accomplish. A triggered action on update of the 'members' table, checks the same table ('members') for records having : - the same e-mail address - the status 'active' If any record with the same e-mail address 'AND' status='active' is found, nothing has to be done. If no records are found having both conditions true, the status in a second table 'Accounts' needs to be set to false. In short: I want to disable the account when no more members with the same e-mail address are active. Thank you for any input.

Hello @BrianI, Thank you for your answers. 1) As a first step, you need to allow multiselection on the Advanced tab: 2) Then add JavaScript code to the Footer of the Search page. <script> document.addEventListener('DataPageReady', defaultOptionsHandler, { once: true }); function defaultOptionsHandler() { const taskListFieldOptions = Array.from(document.querySelector('#Value1_1').options); //Value1_1 is the 1st field taskListFieldOptions.forEach((option) => { if(option.value == 'In progress' || option.value == 'Not started'){ option.setAttribute('selected', 'selected'); } }) } </script> Please double-check the values that should be compared. In my example, they are 'In progress' and 'Not started'. Also, change the field ID if needed. On the Search page, the first field has ID = Value1_1, the 2nd field has ID = Value2_1, etc. If you have questions, feel free to update this thread.

Hello @BrianI, now I understand what you meant. The border is removed when its size is set to 0px along with color = none and type = none. You may check if setting the size to 0px fixes the issue.

I figured out how to solve this, but here is a note for everyone who might encounter a similar issue. Go to the Style, Source, and All. Find .cbSearchButtonContainer and .cbFormNestedTableContainer. When you find them, adjust their width until they reach the same width as the tabular report.

Hi I have multiple apps and some of them share the same tables. The shared tables are all in one app called central. Then there are other apps for example App1 and App2. Due to a design change some of the tables that are in App1 now need to be shared with App2 so I would like to move them to the central app. Is this possible while not breaking App1 and keeping all the relationships etc? Thanks

Hi @CoopperBackpack Thanks for the reply. I have a work around in my css. I was referring to the configuration in Caspio as shown in the below screen shot. These settings do not seem to work. I assume then that this is a bug and we need to override as I have done.

Hi, the values are not in a multi list string and I do not want to set it up that way as it has other limitations The values are held in a separate table with other metadata. @CoopperBackpack 1. yes it's a text255 field type 2. Search and results are on the same page 3. This should just be a default and the user should be able to change the search once loaded. Thanks

Hi! Just to add, here is the article for more information regarding Trigger Loops: https://howto.caspio.com/triggered-actions/triggered-action-elements/loops/

Hi @TriggerMan, Do While Loop in Trigger can help you to achieve your desired result. Here are the sample Triggers that you can refer to: https://howto.caspio.com/tech-tips-and-articles/render-date-range-in-calendar-datapage/ Hope this helps.

Hi @BrianI, If you use a List String DataType, in the Search form under the Advanced tab, you can set the Default Value to Not Started and In Progress. Hope this helps.