Leaderboard
Popular Content
Showing content with the highest reputation since 12/20/2020 in all areas
-
Just in case somebody prefers JS over rules, you can try the following code too. You need to add Header&Footer for your DataPage Elements and paste this to the Footer (with HTML Editor disabled on the Advanced tab). This code will also hide all of the 8 fields until something is selected from the dropdown. If you want them all to be initially shown, just remove the 2 lines that say "//hide all fields on page load''. <script type="text/javascript"> function hide(fields){ fields.forEach(el => el.style.cssText = "display: none;"); } document.addEventListener('DataPageRea1 point
-
Grouping text area field
WatashiwaJin reacted to ServiceBreez for a question
OK this worked as suggested, thank you! One thing to note for others that may go down this path, it cuts off at 255 characters. So grouping is possible (yay!), but unfortunately displaying the full text area is limited to 255. Thanks again @WatashiwaJin1 point -
Number of Fields Dependent On Value
SinJunYoung reacted to kpcollier for a topic
@SinJunYoung This is exactly what I am going for. Thank you for all of the help!1 point -
Number of Fields Dependent On Value
kpcollier reacted to SinJunYoung for a topic
I did this one last year https://c1abz415.caspio.com/dp/8c4b6000a85530fe3c4c4440a562 If this is what you wanted to achieve, then yes, this can be done by rules. You may have a lot of Rules Actions but the key is to do a reverse and instead do them from the criteria. Here's how I did it: 1. Pulled up the n number of fields. Make sure that there is a selector, in this case a virtual field that were divided from the rest of the fields via section. 2. From the Rules tab, create a rule. Remember that the number of rules will depend on the number of fields that will be1 point -
Number of Fields Dependent On Value
kpcollier reacted to CoopperBackpack for a topic
Hello @kpcollier, If I got your inquiry correctly then you need to have a dynamic dropdown based on another dropdown. This requires a rather bulky JS solution as I understand. Did you consider using a Cascading dropdown on the DataPage? You just need to have a well-structured lookup table (please refer to this example on the screenshot) So, the first field is dropdown and the second one is the Cascading dropdown (https://howto.caspio.com/datapages/datapage-components/cascading-elements/) Is this solution right for you?1 point -
All the Aggregate fileds in one row
CoopperBackpack reacted to sandy159 for a question
Hello @VincenzoCocciolo, If you would like to perform the same aggregate function on multiple field columns, you can add multiple fields to one aggregation, and the results will automatically appear in one row but in the appropriate column. Otherwise, if you need different calculations for each column, you must use multiple aggregate fields and it will appear in different rows. Please refer to the Totals and Aggregations article. Also, you may look into the Pivot instead of the Tabular Report DataPage. I found the forum post with a similar issue that may help you: Feel fre1 point -
Workaround for routine importing when you have "List - String" datatype columns
SinJunYoung reacted to ClayG for a question
This did mostly work. It was important that when exporting the DataPage, I do a 'Custom Export' and use "DataPage Only" as the export option so that the future import doesn't wipe out my table structure, etc.1 point -
Editing user entered numbers in a webform
David17 reacted to CoopperBackpack for a question
Hi @David17, I am glad that solution works for you now. If you need to add this code for several fields, please use this code <script> document.addEventListener('DataPageReady', checkInput); function checkInput(){ let numberFirst = document.getElementById('InsertRecordField_1_name'); //declare first variable let numberSecond = document.getElementById('InsertRecordField_2_name'); //declare second variable numberFirst.min = "0"; numberSecond.min = "0"; numberFirst.type = "number"; numberSecond.type = "number"; numberFirst.setAttribute("oninpu1 point -
Custom Autonumber, auto increment
kpcollier reacted to CoopperBackpack for a question
Hello @kpcollier I am afraid that this cannot be achieved with Formula field in the table, since Formula field operates only within 1 record. As a result, we cannot check/use the values that are stored in the other records in the Formula field. It looks like the best solution is to create a Triggered Action. I am not sure about your table design, so I assume that Est_Table is the child table that has the Bid_id field as well. For example, the table looks like this: This is the Trigger design: Here is the output: Ma1 point -
Different types of Caspio tables
TeamVilla reacted to CoopperBackpack for a question
Hello @TeamVilla, It looks like the Master/Detail tables are equal to Parent/Child tables. A Parent table is the table that stores the primary key (a field that uniquely identifies the table records). A Child table is the table that references the parent with a foreign key. Here is the article https://howto.caspio.com/tables-and-views/relationships/database-relationships/ I believe, that Domain table is equal to Lookup table (Countries_table, Months_of_the_Year_table, etc. ). It stores data you've pulled out of your table to make the table smaller. You may set the1 point -
Hi SinJunYoung, Many thanks for that tip- I did not catch that as an option for the Search/Filter date. It works really nicely except for one thing-I need the user to be able to change the week they want to Search/Filter by so the date needs a Begin/End criteria that's visible. I just need the current date to open by default so they don't have to enter it in themselves (bad design if they did). Here's some js I put together to get the Sunday before the current date and then add 6 days to it for the following Saturday, and then to put that into the Date Criteria for Begin and End d1 point
-
Get Exact Age
HeyItsDoug reacted to LittleMsGinger for a question
Hi @JanineB, You may try this formula as well. FLOOR(DATEDIFF(YEAR,[@field:Date_of_Birth],GetDate()) - (CASE WHEN DATEADD(YEAR,DATEDIFF(YEAR,[@field:Date_of_Birth],GetDate()), [@field:Date_of_Birth]) > GetDate() THEN 1 ELSE 0 END )) It worked in almost all scenarios, considering leap year, date as 29 Feb, etc. Hope this helps. -kristina1 point -
Pdf Or Print Button
jackclain reacted to DataCobalt for a question
Hello all, Please see the second to last post of this page. I have been using a slightly modified version of this deployed on my page instead of within the datapage to great success.1 point -
JavaScript Tips: Caspio Form Elements JavaScript is a client-side scripting language that is commonly used in HTML pages. JavaScript can be used in Caspio Bridge DataPages to extend capabilities outside the standard features. This page provides a guideline for referencing Caspio form elements using JavaScript. It is an advanced topic and you should have prior knowledge of JavaScript programming. Referencing Caspio Form Elements A common way to access a form element using JavaScript is by referencing the element's ID attribute using: - document.getElementById("id")1 point