for some reason my input field isnt allowing me to enter anything and i cant work out why.
firstly I create the input field (Congestion_Threshold). i then reload that table providing the field with the input field property. later on i drop the field from table 1 to avoid sync tables.
can anyone see where i've gone wrong?
60 as Congestion_Threshold,
//autonumber(systemcodenumber & lastupdated) as %Scoot_id, //use this one when live
autonumber(systemcodenumber & Date & Time) as %Scoot_id
//autonumber(systemcodenumber) as %scn
min(linktraveltime) as Min_TravelTime