Thank you very much for your detailed feature request @Philippson
We have already discussed it with the team today and we will deliver a proper solution as soon as possible. We discovered that the request can already be fulfilled with Workflow Automations and other existing features on closer examination.
First, two views need to be created in the app where the records are selected. One for “already selected records” and one for “not yet selected records”. The two record types can then be mapped to the views using a filter, such as a single select field. This single select field can then be set by an automation when a relation is created or removed. As a final step, the view “not yet selected records” should be selected in the relation field settings. With this configuration, only records that are not yet selected can be selected.
Due to the importance of this use case and the complexity of the current solution, we would like to add filters to the calculation field for you. I will let you know when I have an accurate estimate of the development time so that the use case can be implemented more easily and without automation.
We can also set up a video call so that I can explain the current solution proposal to you. Since there are repeating entries in the app, we could use the “On schedule” trigger there to generate them automatically. Would love to help you out with this!
Thank you again for the great call this afternoon, @Philippson . I’m happy that the feature rollout of new filters on calculation fields was able to solve your problem directly. If you have any further questions or problems, please feel free to contact me anytime.
