this is a version of what you're after (written a long time ago and i have learned a lot since but it's working)
https://forum.game-guru.com/thread/207801?page=4#msg2497969
you would just need this part for the actual object to move forward and to keep the player on it
SetRotation(e,g_PlayerAngX,g_PlayerAngY,g_PlayerAngZ)
MoveForward(e,speed[e])
TransportToIfUsed(e)
note however that this would simply make the player travel forward and he can control it's direction by moving the mouse, if you dont want that then you would need to set the rotation once and only once -until you want to update it again - (either in a set direction or facing the same way as the player etc if you change the values)
and the trigger would be simply checking the objects health and then ending once you get closer to the object (or further etc) depending on what you want to happen when it's hit.
i have done a script for a grapple hook that you fire around to fast travel which is likely quite similar but it isn't available for all.
i can say it's certainly doable however if you intend there to be obstacles etc that will stop the camera/player (using default collision).... it wont work.
life\'s one big game
windows vista ultimate
i5 @3.3ghz, 4gb ram, geforce gtx460, directx 11