Is there an easy way to do this?

[Phil Rolf]

I am trying to determine an easy way to display data and have Soccer Officials update their availability online. Attached is a screen shot of the form that the assignor uses to enter their availability. It is an 10 week season 6 days a week. All of this info is stored in one field in a table based upon a referee number.
Date - date
Check Mark - checked available, not checked not available to officiate
A - Available AFTER this time
B - Available BEFORE this time

Without breaking this record apart per day and having a parent/child relationship, how can I easily display this data on the web per record?

The assignor needs to take the data from the web and import it into the Availability table on his computer. I have to leave the data (one record per official) on the assignors computer as there is a massive amount of code that would have to be changed if I break it out into a parent/child relationship.

If this does not make sense do not hesitate in asking questions.

Thanks

[Steve Wood]

RE: Is there an easy way to do this?

I have not done this yet, but play around with the Freeform Template option for the Grid. You'd build just one Grid, with no Details section. Add all of the fields to the Available Fields column, but make all but the first one Hide Row. Go to the first and only visable field, click Freeform Template and click HTML Editor. You can build a table structure and type in field placeholders like {myfield1} wherever you need to. You might be able to reproduce your design.

You would need to have a Search section to let the user find their particular record, especially since the initial screen would have a significant number of fields. Limit the Grid Properties to 1 Row, so the user has to search for their record.

Again, I have not used Freeform Templates, I could be all wrong.

[Phil Rolf]

RE: Is there an easy way to do this?

I played around with the column template and could not come up with a format that works. I cannot manipulate the data to the format I want.

I will keep trying...

[Pat Bremkamp]

RE: Is there an easy way to do this?

Philip,

If I understand correctly, you have a table with two fields:
RefereeNumber and Schedule. I'm guessing that Schedule is a character field, however, since character fields are limited to 255 characters, I don't know how you get all the data to fit. Perhaps you have one field per week with all fields in one record?

Anyway, sound like you need to create a lot of calculated fields parsed out of the schedule field(s). Then, you can use the freeform design to display them.

I've attached a screen shot of a table shown using freeform. Also, if you look at the sample screen shots from Jerry Brightbill's Scheduler, I think he uses this technique also.

Pat

[Phil Rolf]

RE: Is there an easy way to do this?

Pat, here is the structure for the table,

60 Date Fields (date for season)
60 Logical Fields (available per date T/F)
120 Character Fields (Time)(times available per date)
19 Misc Character and Logical (name, ability level etc)
Total number of fields per record 259.

All of this is in ONE record. That is why I am having such a problem displaying this info.

Thanks
Phil

[Pat Bremkamp]

RE: Is there an easy way to do this?

Philip,

I have good news for you! You have one of the few situations where the web version is actually superior to the desktop version of A5. Why? Because it is very easy to hide columns. So, you can build a grid that has 259 or so columns, but only display those that you want. For example, you could display only those that are available, or only those that are not available, or only those that are available within a certain time period.

Here is a snipit of code from one of my pages:
'================================
'Each component on a page must have a unique alias (componentName property).
with tmpl_Company_List ' "== look for this kind of statement
componentName = "Company_List"
for x=1 to 12
field_info[x+2].column.heading=session.CL[x]
if alltrim(session.CL[x])=""
field_info[x+2].column.hide=.t.
end if
next
end with
'================================

That's all it takes!
In this case, I created a character session variable array, Dim session.CL[12] as C

In your case, it might be
Dim session.gameday[60] as C

Then, read into the session variable the values from the record in the table that indicate whether you want it to display.

In my case, I loop through the array and if the column heading is blank, the column is hidden. In your case, you would use a different criteria.

Good luck,

Pat

[Phil Rolf]

RE: Is there an easy way to do this?

Pat, with your help you gave me the guidance to find a way to do it. Thanks

Is there anyway to add text above the grid that includes the following cdow(date) ?

[Pat Bremkamp]

RE: Is there an easy way to do this?

Philip,

Yes, if you can get the character dow into a session variable before you call the page. Then, on the page (not the component) above the grid you put A5 code to display it, such as
"%a5 ?session.dayoftheweek %"

There may be a way within the grid, but I don't know how.

Pat

[Phil Rolf]

RE: Is there an easy way to do this?

The date field is part of the table. I will give your idea a try. The location where I want to put it is in the Grid FreeForm "above the grid" option. Same location as in the V6 demos where Alpha places the number of records. No matter what I do relative to the formating of the CDOW expression, the output is always the text of the expression. Is it possible to the a5 format to get the CDOW to display?