Leaderboard

Hello @Gabrielle, Please note that this dropdown shows the tables that have a unique field. The Authentication can be created using the table with the unique field since it`s required to define the specific user. For example, in this table the email field is set to unique: Feel free to update this thread in case of additional questions.

Hello. Just to add, you may visit this How-to article regarding Styles: https://howto.caspio.com/styles/. -Potato

If you want to apply this to any data type, you may do the following in the Styles Page

Hello @Stepford, You may select one of the two approaches: 1) Change the alignment in the Styles section. In this case, the changes will be applied to all DataPages that use this Style. Please open the Source tab -> All -> find the cbResultSetTableCellNumberDate CSS class using Ctrl-F (or Command-F for Mac) -> change the text-align to right. 2) You may apply the changes to the particular DataPage without changing the Style. To do this you may add Header/Footer elements on the Configure Results Page Fields page and paste the code to the Header.

Hi guys! Just wanted to add these links about setting up authentications. It's very informative and helped me a lot when I was just starting out with Caspio https://howto.caspio.com/authentications-and-connections/authentication/ - Jihyo ♥

Hello @jeffs88keys, It looks like the solution depends on the exact DataPage type. Could you let me know if this is a Tabular Report DataPage or Details DataPage? Do you need to display the statement in each record if this is a Tabular Report DataPage like this? If so, please double-check the condition, since I am afraid it your question it is "when [field1] is blank or if [field2] is blank" for both cases. Also, specify the the data type for [field1], for [field2] it is File data type as I understand.

Hi, Faldo! Watching tutorial videos helped me when I first started using Caspio. This might help you as well: https://howto.caspio.com/getting-started-videos/

Hello @Eugene, Since Caspio uses the Highcharts library to render Chart DataPages, I have checked the Highcharts documentation https://api.highcharts.com/highcharts/ I was able to find the solution that allows to add spaces between slices for the usual Pie Chart (not 3D Pie Chart). You may paste this code to the Footer section on the "Chart Wizard - Configure Chart Options" screen of your DataPage. Do not forget to disable the HTML editor on the Advanced tab before pasting the code. I put the borderWidth as 3, please use the value that you need. < scri

Sure! Btw, I found a way <script> document.querySelector("input[id^='InsertRecordList']").addEventListener('change', function() { document.getElementById('cbParamVirtual1').value = document.querySelector("input[id^='ComboBoxInsertRecordList']").value; }); </script> The input with id starting with InsertRecord**FieldName** stores the checked values, so you can just use that as a reference to listen for a change You can try it out again https://c2aby549.caspio.com/dp/83ff8000344c2f4c1794467fb6e2 Cheers!

I'm confused what are you using? MultiSelect Dropdown or Listbox, afaik, Listbox doesn't display the concatenation of choices, right? Is this what you're trying to do? https://c2aby549.caspio.com/dp/83ff8000344c2f4c1794467fb6e2

This worked perfectly. Thank you so much for your time to help me.

Hello @awolagain, You can request any app from Free App Templates for Your Online Database | Caspio to be uploaded to your account but keep in mind that the number of deployed DataPages allowed for free accounts are only 5. So, if you wish to deploy the app on a host and use it for your business, you will be able to do deploy only 5 of them at a time. However, if you want to just see and learn how the tables are designed and DataPages are built etc, you can do so without any issues. You can also preview any number of DataPages separately without having to deploy them. To request an

Hello again @awolagain, 1) If you are referring to the demo application in your account as shown on the screenshot below, this demo is attached by default to showcase the application in Caspio account, etc. You may even delete it. This is up to you. 2) If you are asking about Trial and Free accounts, these are two different plans. As far as I know the Trial account is valid for 14 days and has features that are similar to the paid Grow plan. So each user of the Trial account can review most of the available features. Free account is limited in features, but not

There use to be a checkbox next to where you name the download in Download Options that would append the current date to the name. But, for some reason, they deleted that and changed it out without telling anyone. I was also looking for this today. Now, you need to click on the 'field picker' next to the name box in Download Options and select the timestamp option.

This is not working because Caspio does not have the jQuery library, you will have to include it in your header. You may find the CDN here https://www.w3schools.com/jquery/jquery_get_started.asp

Hi @myName, If I understood you correctly, you want to filter the records where Work_Date is blank or Work_Date is not today's date. Here is a workaround that I found. You may add a Difference field in the Table and populate it with the Application Task. Then use this field to Filter the needed records in View. Table (Difference - Number data type): The Task can be set up to run every day and update the Difference field. Basically, it checks the difference in days. If it is today- then difference will be equal to 0. In the View you may filter all the r

Hello @awolagain, You may refer to this article https://howto.caspio.com/tech-tips-and-articles/common-customizations/create-user-specific-redirect-after-login/ This solution is relevant in case you need to redirect users to deferent web-pages depending on their roles. If all users have the same role, you may skip this step and not create the HTML page with JavaScript code for redirection the users. Hope this helps.

Hi @myName, you may use the 'Next X Days' or 'After Now' instead of using 'Not equal'. You may refer to the screenshot below. -Potato

Thank you very much I have contacted the support and they unblock the page.

Hi SinJunYoung That's excellent guidance! thank you. I see why you are a Caspio Rockstar.

Hey, @Fleshzombie! I wanted to add to the above solution. Below is a bit more effective way to sort the data by using HAVING instead of outer SELECT block. The solution above is good and it will work when inserting into a table, however when using a table variable with the query, you may encounter "Operand type clash" error. Try this:

Terrific, thanks so much, this tip has solved all manner of issues for me.

Hi there, In our app there will be a text displayed which has to be read thoroughly. In order to do this, users can safe and return. To make it even easier for them, I would like to add a function that MEMORISES up to which point the user has been reading , when he saves to return later. The application should REMEMBER up to which line in the text he has been reading. WHICH Caspio tool can provide this service? Is there a way to integrate this? Thanks everybody!

You may want to try this setup: and the results

Hi, is there any way that I could move the contents of this iFrame to the left?

@kpcollier I see, that's quite the workflow. Basically, what you want is the onchange function in the virtual field that receives C, and then select that option in the dropdown. It should easily be able to select the same value with the script, like : document.addEventListener('change', function (event) { document.getElementById("InsertRecordTitle").value = document.getElementById("cbParamVirtual1").value; }); I'm only changing Virtual 1.

Just sharing the solution in the Question&Answer way. Maybe it is helpful for some forum members. This formula helped to remove extra commas from the string: REPLACE(LTRIM(RTRIM(REPLACE(REPLACE(REPLACE(REPLACE(([@field:field_1] + ',' + [@field:field_2] + ',' + [@field:field_3] + ',' + [@field:field_4] + ',' + [@field:field_5]), ',', '><'), '<>', ''), '><', ','), ',', ' '))), ' ', ',') The output is the following (Formula_1 field):

If you need some live values from authentication table, try using select statements from calculated fields then call that calculated fields to your header. Not doable on HTML datapages though.

Hey guys! I also found this thread and it says that your DataPage must have been recognized as abused: You can reach out to support if @ParkLoey's comment doesn't apply to you - Jihyo ♥

Hi there @myName after checking Caspio's list of error messages, it seems that error code 62504 is caused by this: 62504 Failed security check. DataPage cannot be rendered from this account type. This error occurs when you store users’ passwords in a Text (255) field in a user table. Due to data security restriction, passwords must be stored in a Password data type field. https://howto.caspio.com/troubleshooting/errors-and-messages/ You may want to check your table.. I hope this helps!

If you're hiding it, you don't need to, you just want to pass the dropdown value if it's changed. Just do script for both, if a dropdown is hidden, they will not be changed anyway, so, the script should not fire. For example I have a dropdown with id cbParamVirtual1 document.getElementById('cbParamVirtual1').addEventListener('change', function() { document.getElementById('InsertRecordTitle').value = document.getElementById('cbParamVirtual1').value; }) for your 2nd dropdown, if it's cbParamVirtual2, just do the same, and rename the Virtual1 document.getElementById('cb

Hi, You may try pasting this on the Header DataPage element of your wizard: <style> @media only screen and (min-width: 577px) and (max-width: 1024px) { section[class^="cbFormSection"], section.cbCalendarReport, nav.cbCalendarNavBarPanel, .cbAuthSimpleOuterTable, .cbAuthSidebarOuterTable { margin-left: 0% !important; } </style>

A couple years later--just want to say this is perfect and really helpful- thanks for posting it.

Hey there @RossChevalier List data types are designed to accept multiple values. A user Can select just one option, but they Can also choose more than one. Not sure if any script will work for enforcing the field to just accept one choice. You can learn more about that data type here. Depending on your workflow and why you needed to use a list data type, an alternative I can suggest is to use a text 255 data type for these fields instead. It's kinda ideal since if you use it in a submission form, set the form element to a dropdown, it will only accept one value. Plus, since you menti

Hi @Vvillie, You can still use the code here. You just need to change "#InsertRecordPhone1" to "#Value1_1" Hope this helps!

Hello @Pingzinggolf, In case you want to get all fields that meet the criteria Lead_Source='a" and Email = 'b' (just example), please use AND logic operator. Please see a screenshot: If the Lead_Source and Email fields have Text(255) data type, use single quotes to wrap the values as shown on the screenshot. Hope this helps.

I have resolved the issue. Instead of trying to update the entire record i just update the specific field in question - and i have added the where-clause. $postdata = "TestTable2_SMS_sendt":true} and '/views/' . $name . "/records?q.where=" . $columnname . "=" . $columnvalue; 'Hope this can help others :-)

Hello @IamGroot, Just wanted to inform you, I found a way to export/import a table/database with List-DataType value inside it. 1. Change the DataType to "Text(255) field" and Export it. 2. And in your Excel file, make sure that the value for the List-String field is comma separated like this: (Item1,Item2,Item3,Item4, etc.) 3. Proceed with the import as usual. After successfully importing your file. Go to your Table and to the Table Design. 4. Change the "Text(255) Field" (The one we changed in step 1) back to List-String DataType. 5. Then it will just return t

Hi, I think this might be helpful: