OK, I’m NOT a pro at this, but I think I can help you, in writing, how to refer your fields…
Let’s say you want to have a table that contains years, brands and models, and you want to refer brand and model to seperate databases.
-
1 - You create your 1st database : Year
-
2 - You create your 2nd database : Brand
-
3 - You create your 3rd database Model
-
4 - In your Year database, you can change the name of your 1st column, from Title, to Year. That’s where you’ll be entering the different years (or whatever you chose as the main column.)
-
5 - Now click on the “+” at the end of that line
-
6 - The “Add column” window will pop up
-
7 - In the “Column name” blank, let’s call it Brand
-
7.A - You can personalize the field name if you wish. It should appear by default as “brand”
-
8 - Now click on the little arrow pointing downwards. It’s located at the end of “Text” under “Data Type”. The 1st choice in the list is “Reference”. Click it.
-
8.A - A new option called “referenced Collection” has appeared below. You might need to scroll down to see it.
-
9 - Click at the arrow pointing downwards, located at the end of “Chose a Collection”.
-
10 - You should see your Brand database. Select it.
-
11 - Now click Add
-
11.A - Click on the 3 vertical dots at the end of the name of column “brand”, If I explained this correctly (Should be correct) and that you followed the steps as mentionned, you should see now that your Brand column is “referred”
-
12 - DO NOT enter brands in the YEAR database. You will add them in your first column in the Brand database.
-
13 - Repeat the above steps to create the referred to column “model”
==========
Personal note that might clear a few questions you might have :
So as an example, To associate your teams that will be playing in the 2018 tournament, you will need to create a page where you can add drop menus, each containing the pertinent infos that you need, and save that in a new database that you could call 2018 tournament, or whatever else you wish.
Once the page is created, you’ll need tp make the database and dataset that you’ll save your tournament infos in, and the datasets of the contents of your drop menus.
For the database that will contain your final tournament listings, I need help myself with this, But creating the dataset itself is done the same way as for the ones containing your drop menus’ contents. :
- In your new tournament page, click on the “+” in the vertical sidebar, click on Database, then click on the 2nd option. Mine is in French, so I suppose it should be called “Set”.
- An icon will apear on your page, double click on it.
- In “Connect a collection”, select your YEAR database. You can personalize the “Dataset name” if you wish.
- In the Mode, select “Read only”
- “Number of items to display” and “Filter” options" are to your discretion.
- For the “Sort” option, I would suggest you chose to sort “Year” column from Z-A, to have the most recent years appear first.
Example :
YEAR DROP MENU :
- Add a drop menu
- in Settings, select “Reserved space”
- In the “Reserved Space” blanck, you can enter “Select Year”
- I suppose absolutely want the year to be filled in, so check the box at the bottom.
- To see the years appear in the drop menu, you need to go in the “Connect to data” button
- BELOW “Connect a list”, click the 1st button to make it move to the right to show more options.
- In “Connect a dataset”, You’ll select the “yearDataset” that you’ve just created.
- In the “List values” option, you’ll select the name of the colomn that has your years.
Repeat steps above for other drop menus.
NOTE :
Since you might have already referred you other databases to your main one, you can just refer your other YEAR DATASET columns or you can individually create datasets for each database and do as you just did for the years. Personally I’d go for the first option.
P.S. TO ALL :
You are welcome to add, correct, or suggest anything I may have missed or not explained right.
If it’s possible to have a “STEP BY STEP” guide as the one I just did here, for but my similar problem, it would be GREATLY APPRECIATED.
I have a members’ page where the members can add inventory to my site.
- Most of the members inputs are through drop menus, and a few input boxes.
- How can I make the form show the drop menu content as they type what they want to add, AND offer to add it to the database id it’s NOT FOUND?
I’m pretty certain that n.stark67 would LOVE to be able to use this feature, for example, if he wants to add teams that are not already in his TEAMS database.
Thanks in advance
merlinregis