As per my understanding of the GTFS specs, trip_id value in a row in frequencies table, must be a valid trip having an entry in trips table.
So, instead of typing in a trip_id value when creating a new entry in frequencies table, user should be given dropdown.
And the user will be wanting to put a frequency for a route. So two successive dropdowns needed : choose the route, then choose the trip.
Also a helping text will need to be there advising the user to go to trips page and create a trip first, in case they have provisioned a new route and they directly come here.
answerquest
commented
5 years ago
As per my understanding of the GTFS specs, trip_id value in a row in frequencies table, must be a valid trip having an entry in trips table.
So, instead of typing in a trip_id value when creating a new entry in frequencies table, user should be given dropdown. And the user will be wanting to put a frequency for a route. So two successive dropdowns needed : choose the route, then choose the trip.
Also a helping text will need to be there advising the user to go to trips page and create a trip first, in case they have provisioned a new route and they directly come here.