Leaderboard

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('DataPageRea

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 @WatashiwaJin

@SinJunYoung This is exactly what I am going for. Thank you for all of the help!

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 be

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?

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 fre

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.

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("oninpu

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: Ma

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 the

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 d

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. -kristina

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.

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")