Leaderboard
Popular Content
Showing content with the highest reputation since 03/17/2021 in all areas
-
Tables from Current Project Don't Show Up When I Try to Create an Authentication Object
Gabrielle and one other reacted to CoopperBackpack for a question
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.2 points -
How can I get numbers to align to the right?
Stepford reacted to PotatoMato for a question
Hello. Just to add, you may visit this How-to article regarding Styles: https://howto.caspio.com/styles/. -Potato1 point -
If you want to apply this to any data type, you may do the following in the Styles Page1 point
-
How can I get numbers to align to the right?
Stepford reacted to CoopperBackpack for a question
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.1 point -
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 ♥1 point
-
IF/THEN in Report
ParkLoey reacted to CoopperBackpack for a question
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.1 point -
New User
TellMeWhy reacted to Flowers4Algernon for a question
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/1 point -
Spacing on 3D Pie Chart
Eugene reacted to CoopperBackpack for a question
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. < scri1 point -
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!1 point
-
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/83ff8000344c2f4c1794467fb6e21 point
-
Passing from Datapage Report
CoopperBackpack reacted to jeffs88keys for a question
This worked perfectly. Thank you so much for your time to help me.1 point -
Free account
awolagain reacted to BaySunshine for a question
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 an1 point -
Free account
awolagain reacted to CoopperBackpack for a question
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 not1 point -
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.1 point
-
jquery on 'click' confirm not working
aaronfreed reacted to TellMeWhy for a topic
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.asp1 point -
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 r1 point
-
Free account
awolagain reacted to CoopperBackpack for a question
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.1 point -
Filtration Criteria
myName reacted to PotatoMato for a question
Hi @myName, you may use the 'Next X Days' or 'After Now' instead of using 'Not equal'. You may refer to the screenshot below. -Potato1 point -
Thank you very much I have contacted the support and they unblock the page.1 point
-
Dev > Test > Prod best practice
SinJunYoung reacted to Gillian for a question
Hi SinJunYoung That's excellent guidance! thank you. I see why you are a Caspio Rockstar.1 point -
Task to pull most recent entry for each device if last entry was 1+ month ago
CoopperBackpack reacted to FaeFaeFae for a question
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:1 point -
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!1 point
-
Task to pull most recent entry for each device if last entry was 1+ month ago
Fleshzombie reacted to NiceDuck for a question
You may want to try this setup: and the results1 point -
Left-align iFrame contents
Katey1234 reacted to RunForrestRun for a question
Hi, is there any way that I could move the contents of this iFrame to the left?1 point -
@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.1 point
-
How to remove duplicate characters from a string
sandy159 reacted to CoopperBackpack for a question
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):1 point -
authentication field parameter returning null value
aaronfreed reacted to NiceDuck for a question
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.1 point -
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 ♥1 point
-
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!1 point
-
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('cb1 point
-
Left-align iFrame contents
Katey1234 reacted to Flowers4Algernon for a question
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>1 point -
Display Time
SinJunYoung reacted to DesiLogi for a question
A couple years later--just want to say this is perfect and really helpful- thanks for posting it.1 point -
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 menti1 point
-
Search Records - Phone Number Formatting JS not working
Vvillie reacted to LittleMsGinger for a topic
Hi @Vvillie, You can still use the code here. You just need to change "#InsertRecordPhone1" to "#Value1_1" Hope this helps!1 point -
API Get with multiple parts
Valik reacted to CoopperBackpack for a question
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.1 point -
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 :-)1 point
-
Importing/Exporting spreadsheet with list-DataType
kpcollier reacted to WatashiwaJin for a question
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 t1 point -
Get Values From List - String Into Text Field
kpcollier reacted to Flowers4Algernon for a question
Hi, I think this might be helpful:0 points