Civi 5.15.1, WP 5.3.2
My organization provides low-cost farm plots to farmers. We use Civi purely back-end (no website exposure). Each farmer can have multiple plots, which we have implemented in Civi as multiple separate "Farm Plot" Memberships. Farmers usually keep the same plots year after year, so when we renew each Membership, the "Assigned Plot Number" field carries over, which is exactly what we need for that field.
However, we also need to record whether each farmer cleaned up each of their plots at year's end ("Plot Condition"), and we need to keep that information tied to that specific period/plot/farmer. When we renew the Membership, last year's value will carry over to the new year, which is NOT what we want for this field.
We considered switching how we handle Farm Plots from Memberships to Contributions (b/c they're already time-specific). But the plot assignments happen well before plot payments come in, which happens well before we assess Plot Condition. So we'd have to log the Contribution at the start of the year so the plot# is there (no more easy renewal carry-over from last year), set Contribution Status to Pending until we receive payment, and edit the record again at year's end to add Plot Condition. Yuck.
Could anyone suggest any alternatives (other than using Notes)? Many thanks!