Jump to content
  • 0

General Questions On App Setup





Completely amateur user here. No coding experience, no database management experience. But I want to create a game to play with my friends.


Here is the thing; I want to setup a signup table. I did this, and I think it is OK to write to a USER database. 



Then I created another Table. With Column 1 being A through C. And A has an outcome of a or b. So does B and C. Same outcome. 


I want Caspio to spit out a datapage that goes to my table and Picks A (not a variable but a constant on the datapage) from my tables, and allows the user to pick a or b, AND assign a value to it. 


All this should be user specific. 


in other words, 


User #21 signs in, 

Sees a table

Table Lists A, with options a or b (preferably dropdown), and a field for value 

Table Lists B, with options a or b (preferably dropdown), and a field for value

Table Lists C, with options a or b (preferably dropdown), and a field for value


So the user selects a for A and enters 25

Then selects a or b for B and enters 30

Then selects a or a for C and enters 12


This comes back to me as a table:


User..... Variable... Selection.....Value

#21              A            a                 25

#21              B            b                 30

#21              C            a                 12


I don't even know if this is doable in Caspio. What do you think?


Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Hello sarpsekeroglu,


I think, you can create it easily.


You can create a Lookup table,

It will have fields id, List, answer, value.

Then enter,e.g.,

List A - a - 25

List A - b - 15

List A - c - 10

List B - a - 10

List B - b - 25

List B - c - 15



Another table will be store results, for example, it will have fields id, user_id, answerA, answerB etc.


A submission form will use the first table as a source for dropdowns and saves answers to the second table.


A Report form displays users and their answers.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...