Jump to content

Search the Community

Showing results for tags 'tables'.

  • 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


MSN


Website URL


ICQ


Yahoo


Skype


Location


Interests

Found 20 results

  1. Hi everybody, I have read everything about the 3 different types of Caspio tables; Master, Detail and Domain, but I still find it very hard to explain others the difference and when to use which. Does somebody have a simpel explanation when to use which tables type?
  2. In each of my application tables, I have added four fields for created timestamp, created by user ID, updated timestamp, updated by user ID. I am having trouble figuring out how to capture the "updated by user ID" field when I am editing a record from within a tabular datapage (both inline and details view editing). Any help at all would be appreciated!
  3. Hi friends, I am trying to implement a People table in which I would like to have a "son of" relationship. I need to know who is child of whom. I've found no way to implement a relationship on which parent and child tables are the same. Is this possible within Caspio? Thank you very much for your time. Ariel
  4. Deleted one whole application in my account but several tables were not deleted when I check all assets. Is there a glitch or am I missing something?
  5. I have two kinds of Budget items. table 1: Budget child table 1: Services child table 2: Check Requests When I report on Budget items, I want to see Services and Check Requests on separate rows in the same View, like this: budget# - service# - checkrequest# - amount 22 - 15 - NULL - $50 22 - NULL - 7 - $50 Budget1 Total=$100 Should I combine child tables 1 and 2? Or is there a way to join them to Budgets so that they can appear on separate rows, as in above?
  6. Hello, I am new to Caspio, I encounter a problem here. I have two Tables Table#1: Investment(Investment_ID, Client_ID, Latest Transaction date, BookValue, MarketValue) e.g. Invest001|Nov 1, 2018|500|1000 Invest001|July 1, 2018|800|2000 Table#2: Investment Transaction(Investment_ID, BookValue, MarketValue, Transaction_Date) e.g in Table #1 I have following records, Invest001|100|100|Oct 1, 2018 Invest002|800|2000|July 1, 2018 Invest001|100|200|Oct 10, 2018 Invest001|100|300|Oct 15, 2018 Invest001|200|500| Sep 1, 2018
  7. Hi guys, I'm trying to have a situation where a form is displayed to the user whereupon they enter particular information (Fields A - E), should this information be reviewed (user ticks "reviewed, Y/N" box), further fields (Fields F - P) are made visible to the user where they can enter in more descriptive information which was not asked in the first form. At the end, all the information pertaining to a specific incident must be combined so that reports can generated at a later stage. Ideally, in my mind, should the user tick the "yes tick box", further fields are displayed up
  8. I am trying to pass the value from specific column totals for use in html page(s) and/or virtual fields. Any help is appreciated. e.g. table with 3 columns and n rows I want to retrieve and pass the total value of column 1, column 2 and column 3 for use on a different webpage or for a custom html field Thanks in advance
  9. Does anyone know if its possible in JS to dynamically change the filters applying to a Table or View that's linked to a datapage? I have several checkboxes for Users to select from, and the selections can drastically alter the types of filters I want to apply. Essentially I'm looking for much greater control over the results table than the Caspio wizard screen filters can allow. Thanks
  10. Caspio minds I have a Tabular report and want to add a button that once the user clicks it will pass information from the tabular report and insert in another table. I saw an example where someone put an insert sql statement on a tabular report that would add values as parameters to another table. But I can't find this example. Any help will be appeciated
  11. I have a good app going with one main data table with lots of views and dependencies tied to it. I want to change some field types in the table - from Text to Integer, etc. But all the warning scare me about lost data if I proceed and "incompatible data will be lost." To preserve all the dependencies will this work? COPY that original table and data (call it Table 1) to "Table 1 Backup". Copy Table 1 again and all it Table New Change field types in Table New, save it. Delete original Table 1 and RENAME Table NEW to Table 1 (the original one referenced in a
  12. I'm normalising a large Table which can extend to 3-4 million rows. One of the fields is 'Year' (eg '2017'). There are up to 80 different years in the database and obviously many are repeated many times, Is it worth indexing this field? I can make a table with a primary key and the related year, such as y1 = 2000, y2 = 2001, y3 = 2002 and so on, then relate the primary key to year field in the main Table. I'm just wondering whether all this fuss for so little is worthwhile. Is it going to make a performance improvement? Or should I be doing this a completely different way.
  13. Hi guys, Please have a look at the picture it makes it more clear. hopefully someone can help with this simple question. So we have a "Customer" making an "order" this "order" has different "products". So 3 tables. When I connect Customer table to order table, no problem, one customer can have multiple order, when I connect orders to products, I want to be able to chose a customer and only see his orders in the products table. At the moment I can select the customer but I get to see all orders, I want to only see his orders. All this in the table. At the moment it seems that I
  14. Hello everyone, I started using Caspio only a couple of days ago. As a first test project I am trying to build an invoicing app. I am now facing a problem and I really hope that someone here can help me. Before generating a new invoice, I need to enter all data for it. Customers I pick from a drop down, invoice date from the date picker etc. That is all fine. Now I select the Service I am sending the invoice for. (Let’s assume it’s only one service in the invoice.) This is another dropdown and refers to a table with, let’s say, the following content ID SERVICE
  15. Thanks in advance for any assistance. I am trying to get results based off employer and location. Here is an example: Table 1 (Company): Employer_1, Employer_2, or Employer_3. Location is Business_Zip Table 2 (Customer): Employer_1, Employer_2, or Employer_3. Location is Customer_Zip When submitting a request form, the customer can request an answer from Employer_1, Employer_2, and/or Employer_3. The request will go to the Company with the matching zip (IE: Business_Zip = Customer_Zip) Here's where I'm stuck. I need to create a workflow that directs the ques
  16. I'm getting a system error when I delete Relationships. See Attached. The Relationship seems to be removed after refreshing the screen, but why i'm I getting the error? Error, System error <<OK>> with no other information.
  17. Hi, I'm designing a poll app. It's a simple one-question poll with an arbitrary number of answer options. I have a connection on it to authenticate users and require them to log in before answering polls. Everything is working so that my admins can make new polls/answers and users can log in and answer them. However, I can't figure out how to restrict users to one answer per poll. I have tables for users, polls, answer options for each poll, user responses. It's all working, but I need a (non-kluge) way to check whether a user has already responded to the specific poll before i
  18. Hi All, I'm trying to implement a data page report that pulls search results from 4 different tables (or categories). For example, on my search page I need to have four different columns of radio buttons that someone can choose from in succession. The results of the 4 choices will result in a report after hitting the submit button. So basically all 4 categories need to be combined behind the scenes to produce the results. Like narrowing down search results based on criteria (Car Make>Car Style>Car Color>Car Engine) results in only cars that match all four selections.
  19. First I would like to thank all community members who contribute to this forum. I have used Caspio for the past few months and any questions or problems I have had were answered by searching this forum. Unfortunately, I haven't found any that come close to solving this problem... I have several company's that use the same table to manage inventory at their location. This is a management problem and possible security risk. I can correct the issue by creating data pages for each company all with identical element fields and creating copies of the original data source for each company referenc
  20. I would like to set up a database where my authenticated users can upload their records (can be anywhere from 2-10k) in one go (who would fill in my form 10 thousand times a quarter?). The import feature worked great for me here, and if they had the ability to do something similar on their end - including the mapping ability the import wizard has it would be a life saver. Is this possible? I can't seem to find that option. Thank you kindly for your support! This is my first day and I do enjoy the ease of use here.
×
×
  • Create New...