Jump to content

Search the Community

Showing results for tags 'Views'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Caspio Bridge
    • Caspio Apps for Ukraine
    • 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


Last Updated

  • Start


Filter by number of...


  • Start




Website URL






Found 13 results

  1. I am trying to produce a report that is 101 with a spreadsheet but can’t figure out how to do it with Caspio. Very simplified so I can explain my difficulty. I have two tables <Income> and <Cost>. Each table contain the following fields:- ID; Project#; and Amount. My desired report something like this Project# ~ Income_Amount ~ Cost_Amount 1 $200 1 $250 1 $150 1 $250 Total Project $450 $400 Profit $50 I tried to use a View to get the <Income> & <Cost> by project , However, I wound up hundreds of records - seemed to combine every <Income> with every<Cost>. And the report was meaningless. Simple task but how?
  2. Hey! Is there any way to automatically and instantly insert new view's records into a separated table?
  3. Hello! Is there any performance benefit to filtering results in the View vs. Data Page? Thanks
  4. Hi All, I have a table containing Marketing offers, each of which has a start and end date. Is it possible to create a database view which only lists the offers that are valid on the current date ? (I.e offers whos start date <= current date and end date >= current date) This is for use in a drop down list, where a paricular offer has to be selected. Thanks, Nas
  5. Hello, Any suggestions how could the following be done! I would like to use information from two tables First table (Orders) contains Customer_Email and Product_ID (Filled automatically using Zapier Integration) Second Table (Products) contains Product_ID and Product_URL When a new order is made, an email message should be sent to the customer’s email contains the related Product_URL Note: Zapier does not read Capsio Views also does not update a table
  6. Hello everybody, A simple question which is haunting me for a couple of days now. I have a table MEMBERS (where all my members are listed with different info. Most importantly there is one field: MemberUntil (Date Time Value) How is it possible for me to NOT allow a member to log in if the date is greater than the date under the field: MemberUntil? I have tried on VIEWS but the whole logic doesn't work. AND >> Members_MemberUntil >> Greater >> (then I have to manually input a date). I would like to be able to say: IF MemberUntil is greater than the date stated in the field MemberUntil, then this specific member will not be able to use his login details. Thank you so much for your time and consideration Cherif
  7. Hello, I am developing a report result based in two tables: the first one is holding the 'clients' with unique IDs, and the other one have the 'products' also with their IDs. Both lists have details, however the clients have special columns which indicates the products they have. For example, the 'client 1' has 3 more columns because he has the product 1, 24 and 33. The clients may have up to 9 products each. The report should be generated by searching for the name of the client, listing his products. The thing is that I don't know how to generate this report, it just shows the 'product id' on the results, which should be replaced for the 'product name' instead. I thinks the best way to do it is a many to many relationship, because the clients can have more than one product each. I've read something about making another table which would link all the information as a many to many relationship, but I am not sure how I can list the results from an "empty" new table. Is there any other way to do it?
  8. 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 inserting a new response in the response table. I am stuck. I have a kluge in place (basically tracking in an array which polls the user has responded to in his record in the user table). I'd love it if Caspio Bridge would let me do a "single-record update" or "details page update" which would, if it couldn't find the record, insert a new one. Something like that would make this app perfect and kluge-free. Or maybe I need to go about it another way entirely? Any feedback appreciated!
  9. Hi everyone, I'm using a detail datapage on which I would like to show some average numbers. I'm using a view for this datapage. Is it possible to use SQL statement on views? Here is my Statement: SELECT SUM(FIDELIS_INTERVIEW) FROM view_fidelis_emp WHERE ID_EMP= [@authfield:ID_EMP] Thanks
  10. Hello, My website (gradlook.org) uses Caspio to host a search engine for graduate schools as well as chat forums. I am now looking to create a compare functionality. This is essentially will just a combined table in which the user enters the names of two schools from the same table (preferably with an autocomplete feature). The results are a table with two columns (each school) and each school's fields/stats side by side. I have been working with views but haven't really been able to get anywhere. Can someone point me in the right direction? Thanks, Joe
  11. Hi all! How can I have multiple values pass as a single parameter in a detailed report datapage? Example: An asset has 3 serial numbers associated with it. I want any one of those serial numbers to pull up the assets profile when entered into a detailed report datapage. I hope this makes sense and I can get someone to shed some light on how to do this. I have looked at the tutorials for relationships, views, and one-to-many but still cannot get it to operate how I want it. Maybe I am just misunderstanding how it works. Thank you! Logan
  12. I am very new to Caspio and have found it to be excellent so far. I am following the real estate training video and am stuck with the following; In Views, I created new view and followed the instructions as per the tutorial. However the tick option and info for "Filter data by this field", "Comparison type" and "Value" tick box in "Field Options" are not there. How do I get them to appear in order to select them? I have attached a snapshot from the tutorial for reference. Please assist.
  13. Hello all. I am looking to create a view that pulls from two tables, however my caveat is that I am looking to pull random records from the second table. I would like to know if it is possible to create more robust views by directly manipulating the SQL behind it. Thanks, Mack
  • Create New...