Search the Community

Hello all, Thanks in advance for looking at this. I'm looking for a clean way to refresh the data in a tabular search and report without reloading the whole page. I know that enabling AJAX in the Wizard allows the tabular report to use AJAX to filter and page through results without needing to reload the entire page each time. Reloading the whole page mandates that the user enter in all of the required search values prior to seeing the updated data. I am looking for a way around this. I currently have a system that works where I have added a calculated field as the final column in my results table. In that calculated field I have already placed "GetUTCDate()" . I named the calculated field "Last Updated: (click to refresh)". Essentially this shows up as a column and displays the date and time the table data was loaded. Filtering by this column refreshes the data and updates the "Last Updated:..." field as well. For me this solution currently does work, however I would be interested in a cleaner way of accomplishing this. Perhaps a method that does not require the use of its own dedicated column in the table is possible. On a side note, the data that I am most interested in refreshing is another calculated field (SQL). This is relevant because (at minimum) I do not actually need the entire table to refresh if only there is a way to refresh these calculated fields. Thanks again for bearing with me. I'm curious to see if others have had a similar problem or could use this solution that I currently have in place. COdell

We have data that has apostrophes in it (Men's, Women's, Kid's) and we are trying to use these data fields in formulas but the apostrophe is causing issues. How do we handle this. The example of the formula is: CASE WHEN [@field:Gender] = 'MEN'S' THEN 1 END

Dear All, Im newbie here, I just want to make social media database. However, I dont have any ideas or how can i expressed it via Datapages to show my member under me. In short I want to see who is members or followed me while im logging in. thanks for the help

Not sure how to best handle this. I have a couple of issues. First is my top row (Date) is always used. Sometimes I need up to 20 copies of the second row (Customer) to submit a batch of entries at once. What's the best way to spawn additional Customer rows on the fly? Second - Say I'm able to spawn 3 of the customer rows (all the same). But upon submitting I'd like to have each row submitted as a new record in the table using the Date row as if each record was submitted separately. Not sure if I'm making sense so let me know. I've attached my datapage and my table screenshots. Thanks!

Hi this is Liana, we are trying to create a dashboard using BigData. The Data are currently transacted in SQLServer and the front end is in MVC. As the data flow is extremely high to analyse using SQLServer itself it is decided to use BigData. I had chosen Cloudera Manager CDH, SQOOP to import data from SQLServer to HIVE and running the analytic using IMPALA. Decided to up the results with Microstrategy to provide the charts in mobile platform to the clients. Any Ideas or suggestion are welcome to improve the process?

Hi All, I am a newbie - so please forgive me if the answer to this is obvious and I've just missed it. I want a user to be able to append multiple records from an excel file into a table through a data page. And I want there to be some checks while they do it (like making sure that there are no blank or duplicated records). The user might want to upload anywhere from 1 to 1,000 records, so it would be very difficult to do this by hand. Once the data is loaded, I want to be able to generate charts and reports from it as if it were a regular data table. Is there a mechanism in Caspio to do this? Thank you!

I found that I can hide table elements based on HTML5 data attribute values. This solves a shortcoming of Caspio datapage configuration options: If you have a datapage that uses Inline Insert, you will find that you must choose between allowing a field to be editable on Insert, and allowing a field to be editable on Edit. In my case, I wanted to allow Inserts with a date, but once the record was there, I didn't want the date to ever change. When you enable Inline Insert, you don't have this ability, because if you disable editing the date, then one can't Insert new records with a date. However, a unique HTML5 data attribute=name, value=InlineEdityourFieldName is only applied to rows opened for editing, not on the Insert row, so we can use the attribute and value combo as a css selector to target Edits and not Inserts. Here I add the class "hideDateEdit" to matches for my selector, then inline a style to hide that class. Actually, I'm adding the class to the parentNode of my match, so that the contents of the whole cell are hidden, in this case, the date's text input, as well as the adjacent calendar img for the popup calendar function. <SCRIPT LANGUAGE="JavaScript"> var elems = document.querySelectorAll('input[name=InlineEditDates_Date]'); for (var i=0, m=elems.length; i<m; i++) { elems.parentNode.className = "hideDateEdit"; } </SCRIPT> <style type="text/css">.hideDateEdit { display: none; } </style>

Hi, Forgive me if I've missed it in the documentation. Looking for a way to lock a record when another user is editing it. To prevent simultaneous updates to the same record. Thanks

Dear all, Would like to pull data from the tables with Java. Then, after some calculation, put my results into another table in the database. Is it possible? If yes, how can I do?

Hello All; I am working through optimizing my app and step one is to ensure I'm using the proper field types. Is there an article that describes how much data is used per record per field type? Specifically: General Number Integer Number Currency Number Yes/No Text(255) Text(64000) I have a pretty good guess on how these rank, but more detailed information on exact data used will help greatly. Thanks CHAD

Hi. I need to collect data from several different drop-downs, then combine the results into a single array in my data table. How would I do that? Example: If I collect 5 as the value for dropdown_1, and 3 for the value of dropdown_2, and 4 for the value of dropdown_3, I would need to be able to use that to create an array in another field (dropdown_values) such as: 5, 3, 4 I'm guessing this is a javascript thing. Any idea how to do that? Thanks for any help.