Description: The article is about wix login. This is a brief introduction about Wix. The author mainly shows us how to use Wix Developer tools to create a simple database and then use that database content to populate a table. It is very helpful.
I use Wix developer tools also known as Wix code to create a table populated by a linked database,I hope you find it useful for your website,if you have questions please feel free to leave me a message,I’m going to show you how to create a table connected to a database,it will be filled dynamically.
First I’ve added a table by going to the plus sign,I have to turn on my developer tools by checking tools,once that happens,you will see this user input and you can go down and drag a table over which is what we’ve done here. This particular table is going to be for upcoming races,you can see the name of the race the date of the race and when the registration date is.
We need to create a database that connects to it,we are going back to the plus sign find the database and create a new collection,we’re going to start creating and we’re going to call it racers.
What’s this database for? When we look at site content,anyone can view data from this collection which is what we’re going to do,we’re going to create collection,we’re going to click on the plus sign and going to call it base name,it’s a text field,they have all these different fields,this will be dates and we’re going to put in a date and time field.
I’m also going to add a date as text field depending on how we want the information to be displayed,I am going to add another one for registration and this will be a link to the race site,we’re going to make it an URL,for example we’re going to call the first race my mother race and then we’re going to set that the date for next month on the 30th of April,we’re going to say that it’s begins at 8 a.m. and then here we’re going to put it in the date as a text field.
I’m going to put in the link to my website for now so you can get the idea. We have one entry there,we need to go back to our page where we have our table,we have to connect this to our database and that can be done by adding a data set,we’re going to add a data set,this will be invisible.
Once we launch our page,we’re going to click on manage data set,we are going to connect a database and connect our races database,we want it to be read-only,we don’t want anyone to be able to change the information,we only want them to be able to view it,it’s going to be read-only.
We can choose how many things we want to display,I’m going to increase this to maybe 40 in case we have as many as 40 races and not in a time period,but you could do a filter or do a sort,this is going to sort the data by newest to oldest,you can add a sort if you want to choose a particular field.
We will do it by date and do it the newest to the oldest,there are going to connect each of these items to the database within this data set. We’re going to choose the races data set ,our race name is going to connect,we’ve got our date,we have date text and registration URL,it’s preview,we have our registration,we have our URL,we have our date text and we have the date displayed.
As she’s displaying it,we might switch that around,we have a title field which a database adds in automatically,it’s pulled in this title,we’re going to get rid of that because we don’t need it in our table,we can go to manage table,you’ll see that it’s pulled the various references from my database,we’re going to delete that.
We will end up with the race name,the date and the date in text format,I don’t think we’re going to need that so I’m going to delete that from the table,I’m not deleting it from the database,it’s still in the database,we get that,we will end up with our registration.
Under settings,we’re going to choose month day and then year,that is on the settings and on the date format. When we preview it,it’s going to bring in the race,the date and the registration,if you don’t like the the look,you can create the design by customizing that,you can have a look at the text and the link color,we’ll need them,let’s color the background. We also might want to alter the setting and then you can also alter the width of your table,since we have three things we will make them 250.