So far, I’ve managed to achieve this by exporting two separate tables: one containing the race results, and the other with the flight colors for each race and competitor. I then combined this data using a code editor.
However, I would prefer to accomplish this directly within Sailwave, ideally using the Effects panel. Is there a way to extract the flight color data for each race and competitor within Sailwave, so that I can apply a script to display a color circle next to the points for each race?
To provide additional context, the flight colors change after each day of racing (typically after every three races), so I can’t rely on the static data in the “Flight” column, as it constantly updates.
Any advice or suggestions on how to achieve this would be greatly appreciated!
Very well done. Like Jon and I suspect others it would be great to know the exact workflow you did to achieve this.
As you probably know Sailwave has effects to highlight the first three boats in each race, Most effects work together, it would be a shame if what you have come up with has a clash of colours.
A tip if in case you were not aware, The names used for flights should all start with a different letter; for example:
Yellow
Blue
Green
Red
Purple/Fuschia
White
In Spanish Yellow (Amarillo) and Blue (Azul) both start with the same letter. This made it more difficult a few years ago trying to resolve a problem for a Brazilian Sailwave user when looking at results in finishes view.
First of all, I’d like to thank Jon and Huw for their help with this topic—the information you shared was very useful and helped me achieve my goal. Apologies for the late reply; I’ve been filled with tasks lately.
As Jon mentioned earlier, selecting the “separate starts in separate columns” option provided enough information in a single HTML document, making it possible to apply a script and manipulate the data to display what I had in mind. Using JavaScript, we managed to gather the color assigned to each competitor for each regatta and created an additional div to display a colored circle or diamond showing the color for each race. This same script can be applied as an effect within Sailwave data and used every time you publish!
