Update multiple records
Just wondering how to do below with Data Assist and other extensions as i'm new Web Assist super suite extensions.
I have a table which holds all matches to be played over a season. This table is filled by a script that does automatic tossing and also stores the rounds to be played. This means that different divisions and teams play their rounds either on the same day or other days.
Anyway i now scripted everything by hand and it all works the way i want, but i would like to see if i can do the same task more easy with Data assist.
What i have now is that after the whole schedule has been created and inserted into the table i created a form in a repeat region so it shows me all the rounds available for that season, i grouped the sql statement by round number so i only see each round one time, then the admin can set the playdate per round in that form, Like round 1 = week 5, round 2 = week 7 etc. At this moment i use weeknumber selection with a select/menu element but later i wanna replace it with a datepicker (means the date picker will be inside the repeat region as well) When all rounds are setup the whole form will be inserted into a temp table so i can update the original table with the temp table in one sql statement. All matches will then be updated to the playdate selected for the round.
Can i do something similar with Data Assist and maybe even easier then how i scripted it now by hand?
I bought the whole suite to see if i can do everything more easy and more professional.
Basicly i'm trying to create a whole backend administration setup for a local Darts league competition.
Thanks for all comments.