Can I make this form in AppSheet?

[Eloy_Paredes_He]

Hello creators,

We have a legacy way of taking bets from different people on soccer games with the Google Form bellow:

I’ve been reading and looking for a way to do this in AppSheet but haven’t been able to.

The form should have a drop-down field to select the name of the person betting. The form would have to show different games for the date selected in another drop-down field. Then, after the name and the date have been selected the user should be able to choose one of three options from an Enum list for each game.

Thanks in advance for your help.

[OptimiX_XcrY]

What you said, is 100% poasible in Appsheet.

If you can post a Gsheet link , you will probbably get the closest guidance to your current files too

[Eloy_Paredes_He]

Great! This is the Form link. Y won’t be able to share Source Sheet due to privacy issues.

https://docs.google.com/forms/d/e/1FAIpQLSfNl__Z71fh8SsOq_58IlQnI5tVjJYEzH4pkytK84TAH4iSbQ/viewform

[OptimiX_XcrY]

Can you at least post or screenshot the headers of your tables?

[OptimiX_XcrY]

In general lines , I would do this :

1. Create one table with Names
2. Create one table with columns for gametitles , and Gamedates
3. Create a table for Bets, with columns for Name (ref from table 1) , date , and uniqueid
4. Create a table for betdetails with columns for Gametitle (dependent dropdown from table2.,based on date selected ay 3 ),uniqueid, resultbet . This table will be set as child table of table 3.

With this basic structure the app can be developed even more, with reports, history views, averages , etc

Maybe you can play with some existing samples, I think there are some with orders and orderdetails.

[Eloy_Paredes_He]

I have a very similar structure. Here the screenshots:

The Betters Table:

The Teams Table:

The Dates Table:

The Games Table:

The Bets Table:

These are the relationships between the tables:

I want to make it easy for Betters (Apostadores) to fill out the betting form in just one view. Just like the Google Form posted at the beginning of the thread.

[OptimiX_XcrY]

So you don’t want something like below, (classic child table) , where the user must press “NewGame” , but he cand add as many as he wants?

[Eloy_Paredes_He]

I´d rather not because they are used to the Google Form view shown.

[OptimiX_XcrY]

Then, my only idea so far is to put 20 more columns in Bets table, Game1,bet1,game2,bet 2,etc,
Game1-game10 having appsheet formula to populate them with the games based on date, and bet 1-10 being Enum (1 x 2).

This is assuming there are ni more then 10 games per day or per bet.

Game 1 to 10 can also be dependent dropdowns based on selected date , and each of them can be hidden until the previous is used

[Eloy_Paredes_He]

Yes. I thought of something similar but didn’t want to do leave empty columns.
Thanks for the help anyways!

[Eloy_Paredes_He]

Hey @OptimiX_XcrY,

I asked the bets admin and he said we could restrict the number of games per date to 11.

This solved the issue doing exactly what you told me.

Here’s how the form looks:

Great help again.

Thanks!!