All Activity

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.

Hi @Flowers4Algernon, In the Chart Configuration, you can just change the value under Maximum data points on chart. Also, make sure that the Chart sort order is set to descending. Hope this helps!

Hello @IVAN88, The general approach is to join the updated table and the #inserted table on a unique field. This is needed to identify the record that is updated. The next step is to compare the value that was in the field before the update and the new value. For example, I want to track the changes in the 'Phone' field: What data do you need to insert into the second table? Is it taken from the first table?

Hello, I hope somebody has experience with this and can help me. I am working on app deployment on the website. I want to change the width of the white space where my search filters are placed so it is the same width as the table. I have inserted a screenshot of what it does look like now. Is there any way to achieve this? Best regards, Aleksandra

Hello @bookish, it is good to know that it works. I think I didn`t get all the details to understand the workflow. The main thing is to understand how to identify the updated record (join the tables on a unique field) and to compare the old and the new values. So, it is important to understand which values should be compared.

Hi @MarkMayhrai, I believe the error is related to the formula syntax, particularly the Virtual field. Please enclose the [@cbParamVirtual1] into the single quotes to see if this helps to get rid of the error message. As ParkLoey replied, then you may use the IsNull() function: IsNull( (your select statement),0 )

Hello @BrianI, Please provide more details: 1) Is the 'Task list' field a Text(255) file (not a List_String)? So, the result should be: 2) Do you have Search and Results on one or separate pages? 3) Do you need to apply these default values once when the DataPage is loaded? Because the user can change the search criteria while using the report.

I usually use this formula to calculate the exact age and it works correctly too. DATEDIFF(year, [@field:Date_of_Birth], SysDateTime()) - CASE WHEN DATEADD(year, DATEDIFF(year, [@field:Date_of_Birth], SysDateTime()), [@field:Date_of_Birth]) > SysDateTime() THEN 1 ELSE 0 END This formula is also provided in this article https://howto.caspio.com/datapages/reports/advanced-reporting/calculated-fields-and-datediff-function/ Since age calculating requires using functions to get the today`s day and these functions are not supported in the Formula field in the Table, the workaround to store the age in the Table (if needed) is to use a Task:

Hello @BrianI, Yes, you refer to the correct elements. By default the styles for those elements are added like this: As you can see, the class name is not just .cbFormTextField but there is an additional class before it is added automatically. So, for example, when you refer to the element as .cbFormTextField, the CSS rule with 2 classes overrides the CSS rule with 1 class There are 2 options to fix this: 1) to use more specific selectors; 2) to use the !important property. In this example, the !important property is the simpler option. Please test: <style> .cbFormTextField, .cbFormSelect, .cbFormTextArea{ border: none !important; } </style>

Hi @cianelectric, I don't think there are alternatives for cases like this. I remember I tried using a single-record update form and planned to just make my user remember this very unique ID so they can use it to look up their account, then change the password in the form but it requires the current password so they can create a new one. Looks like the password recovery form is the only way. You can try checking if the email and domain you use for sending the verification is verified to lessen the chance of your users not receiving the email: https://howto.caspio.com/notifications/email-notifications/verifying-email-and-domain/ Hope this helps you. I'll also follow this thread in case someone has other ideas

it seems that image cannot be seen....

@Barry's suggestion is on point! Just make sure to indicate that the check box when checked will return records with "NO FILES" so they don't get confused when using your report form. https://howto.caspio.com/datapages/reports/search-and-filter-comparison-types/

Hi @MarkMayhrai! You try adding an IsNull function to your calculations. If there are no values returned, you replace them with a pre-defined value. IsNull(value, replace_value) https://howto.caspio.com/function-reference/#:~:text=Number-,IsNull,-(value%2C replace_value) I hope this helps!

Hi there Support Community, I'm currently working on an edit page where I have implemented a calculated cascading dropdown displaying a selection of pricing options. However, I'm encountering some issues with three fields that have been set as calculated values. Specifically, I want these fields to display their related lookup values from the pricing table upon selection from the cascading dropdown. However, when no selection is made, a calculation error is displayed. I would like to have these fields display a value of 0 instead. Could someone please provide guidance or assistance on how to achieve this functionality? Thanks in advance!