BBQ Competition App - Help

jheasley — Mon, 06 Mar 2017 00:28:27 GMT

Good Evening,

I am part of a competitive BBQ team, and recently started trying to build an app to analyze our previous seasons, as well as prepare for capturing new data for competitions. I think I may have over-wrought the dataset, and I need some help with the loader and linking. We have several tables to link and analyze:

Competition Data (key is Comp ID) - this is the basic time/date/location info

Equipment Table (Equip ID) - just assigns equipment Name to Meat Entries and Equipment temperature reading Entries

Events (event ID) - assigns an event name to scores and meat entries

Turn in Times (Comp ID and Equip ID) - assigns comp/event specific turn-in time

Meat Data (Entry ID) - captures weight of entry, meat type, and where it is cooked

Meat Milestones - (Entry ID) - captures the specific milestone times for each entry

Meat Temp (Entry ID) - captures periodic temperature readings with timestamp

Cooker Temp (Comp ID/Equip ID) - captures periodic cooker temperature readings

Weather Data (comp ID) - captures weather data with timestamps

Comp Results (Comp ID) - captures scores from all teams

I am having trouble with the date aspect of the app. when I used the auto loader, the dates worked as autodates, but I had a few mods to add in the loader (a canonical date of 'Timeline'). once I modded the loader, the autodates stopped working and broke my visuals. any help with dates would be appreciated. I have attached the app for review. Feel free to ridicule and offer correction on my loader scripting, I am terrible at that part. Also feel free to reach out for questions on the data. Thanks!!

topic BBQ Competition App - Help in App Development

BBQ Competition App - Help