Hi, maybe someone could help me build this board, i have posted recently in general caster topic but i havent found a solution to get the desired result. So here it goes.-
In our company we have a large list of vehicle fleet, so we need Monday.com to:
- Our operators complete a pre-use check form reporting the vehicle kilometers.
- We need to automatically track the next maintenance service by kilometers.
- And we need to get alerts when some vehicle kilometers is near to target service kilometer.
Actually we have a board where every form goes in with the pre-use checklist and km value, like this:
I have previously tryin the Rollup Multiple Boards APP by @basdebruin to get in a resume board the next information:
VEHICLE ID - ACTUAL KILOMETERS (it will be the highets or MAX value recorded) -
But with this app i can recover only one parameter (ex. one vehicle), and it will be forcing me to build a board for every vehicle (so this will become multiple forms for every vehicle for every board)… and that is not viable.
I posted on the @Nir-Jetpack monday board for this case, Vlookup App but there is no workaround for this…
So, when subitems and general caster app appear i think my problems was solved but im far from this… for this try i build a new board where:
EVERY PULSE WILL BE A VEHICULE
EVERY SUBITEM WILL BE A CHECKLIST FOR EACH VEHICLE
IN A SUBITEM COLUMN THERE WILL BE A NUMBER COLUMN FOR KILOMETERS
IN THE PARENT ITEM WILL BE A RESUME COLUMN WITH THE MAX VALUE (actual KM).
IN THE PARENT ITEM I WILL HAVE A TARGET KILOMETERS FOR NEXT SERVICE.
AND WITH GENERAL CASTER I SHOULD MAKE A FORMULA FOR CHANGE A STATUS AND MAKE A NOTIFICACION WHEN THE DIFFERENCE BETWEEN ACTUAL KM AND TARGET KM WILL BE LESS OF 500 km.
So this was posted on general caster forum:
And for now looks like this app doesnt work with subitems or resume subitems on parent item. The formula column works OK and reads the max value from a subitem number column, and i can get a title like “SERVICE APPROACHING”, but then my options are:
- COLORING THE FORMULA RESULT
- FILTER OR MAKE A EXTERNAL SHARE-VIEW WITH FILTERS APPLIED.
But i cannot change a status, and make a notificacion to the vehicle responsable.