Alison

Hi, Hi can I change the color of the column in chart for the blank values. For example, I want the color of the first column (blank) to be color red

Hi @JaredL, It is possible to implement using Caspio standard feature. You should go to the advanced settings of the authentication and change the time out and redirection option to the URL of your standalone login screen: Make sure that the DataPage should be authenticated as well. Also, you may look through the post with the same topic here:

Hi @BLEMAN9, You should get each date part separately and concatenate them in a needed order. Please see the screenshot below:

Hi @LIVINGSTONE, You should restrict access to records based on the current user’s profile data using Record Level Security feature. Please follow this article for mre details: https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/ Also this video can be useful: https://howto.caspio.com/getting-started/record-level-security-stamping-new-records/

Hello @taylorswiftlover, According to the documentaion, SysDateTime() function returns current system timestamp. More details can be found here: https://docs.microsoft.com/en-us/sql/t-sql/functions/sysdatetime-transact-sql?view=sql-server-ver15 Also, you can use the following function to get UTC date and time - SYSUTCDATETIME() To make it more relevant to another timezone you should use Dateadd() function. More details can be found here: https://docs.microsoft.com/en-us/sql/t-sql/functions/dateadd-transact-sql?view=sql-server-ver15 Hope it helps.

Hi @crionsynx and @ray, You should select the Lookup table as a Source and Filter cascade by the client_code. In that case in the field for display and for value you will see the scenario data. Please refer the screenshots below: Data source: Configure fields: Result: Please let me know if it works for you.

Hello @SteveP, Please refer the code in this post: https://forums.caspio.com/topic/7824-hide-columns-on-tabular-report-when-empty/?tab=comments#comment-23918

Hello @Jolly, When I use Shift+Enter for moving cursor to the next line, it correctly displays and sends the formatted value that was added to the Text Area field. Please see the screenshots below:

You should find element by the following class name cbSearchButtonContainer:

Hi @guardmetrics, That is correct - you should copy the cody for the button and put it in the HTML block. It is better to hide the button container. Make sure that you are reffereng to the different classes or ids to hide only the needed element.

Hi @emilyhanover, You should deploy your Caspio datapages on the different webpages to be able to get separated links to each of them and use these links for the redirections.

Hi @mbdiener, Make sure that the edited data is saved i the table - the green tick should appear on the left of the table: Also, you may try to create an authentication only with one unique field. It can be, for example, name:

Hi @Inovix, You may create a lookup table for the sub-category lists and use cascading dropdown form element to cascade by the product and show only corresponding data for the sub-categories from the lookup table. Please follow this article for more details: https://howto.caspio.com/tables-and-views/lookup-tables/ https://howto.caspio.com/datapages/datapage-components/cascading-elements/

Hi @Vitalikssssss, You should add two text fields to the Selected fields on the Submission form and one of them make a Dropdown form element. After that create a Header and Footer element and past the following code into the footer after disabling HTML edotir: <script> document.addEventListener("DataPageReady", function() { let dropdown = document.getElementById('InsertRecordname'); let textfield = document.getElementById('InsertRecordnumber'); let change = function() { textfield.value = this.options[this.selectedIndex].value; }; if (document.addEventListener !== undefined) { dropdown.addEventListener('change', change, true); } else if (document.attachEvent) { dropdown.attachEvent('onchange', change); } else { dropdown.onchange = change; } }); </script> InsertRecordname and InsertRecordnumber are the ids of the text fields elements where InsertRecordname is set to the Dropdown form element.

Hi @LelahPederson, You may change the height property with adding !important attribute for the .ListData or .SelectBox classes. For example: .ListData { height: 60 px !important; } You may add this style into the datapage's header or to the User-defined styles in Styles menu.