Search the Community

I have two complex data pages that are both submission data pages. Because they are submission data pages, I do not have the ability to use view data to help create the new records. Because of this, I am being forced to make MANY database calls in order to get the data I need to create the new records. Requirement: Log user Login activity, load external parameters, redirect user to appropriate landing page based on user type Scenario #1: 3 states (User exists and is Member, User exists and is Admin, User doesn't exist and is NEW) Based on User Status: If Exist, Get Profile information and load external parameters (currently 12 params) If Exists, Get Profile Preferences and load external parameters (currently 27 params) Redirect to appropriate location Problem: If I keep with a Submission DP (submitting ProfileLoginLog), then I need 39 individual calls to the database because I don't have a view I can rely on. What I am Thinking: If I change the data page to an Update DP, I can then use a view that will support the Profile and Profile Preferences. But then I end up with two problems: How do I handle the condition (a VALID condition) of when the user is NOT found? How do I insert a record into the ProfileLoginLog table? Any Ideas? If I can solve this for one situation, I can solve this for both situations. Your help would be much appreciated. Lynda

Hey! Is there any way to automatically and instantly insert new view's records into a separated table?

Hi, I have an application that I am building for an engineering company that would consist of the main departments, namely: Sales, Manufacturing, Installations, and Finance. A key function of this application is traceability between departments. What would be the best practice in linking these department documentation together? Scenario 1: By creating a centralized table that contains the quote #, manufacturing #, installation #, invoice #, and status. Each department table updates the centralized table to keep track throughout the process. Scenario 2: Having one single table for all the mentioned departments. I foresee some problems with this solution. Scenario 3: Each department has its table referring to the previous department inside their department table and deploying by using views to combine the necessary data. Do you have any suggestions or comments on the different scenarios? Perhaps even guides pertaining directly to the problem at hand.

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?

Hello! Is there any performance benefit to filtering results in the View vs. Data Page? Thanks

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

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

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

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?

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!

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

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

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

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.

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