Jump to content

Search the Community

Showing results for tags 'data'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Caspio Bridge
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Found 10 results

  1. Lianamelissa

    Big Data Analysis

    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?
  2. oscargoldman

    Apostrophe in Data

    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
  3. 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!
  4. 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
  5. codell

    Ajax Table Refresh

    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
  6. 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>
  7. humbabba

    Lock Record When In Use

    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
  8. 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?
  9. ezIQchad

    Field Type Size Comparisons

    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
  10. 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.
×