I’m Valentin and I’m a member of a french association.
We’re trying to reproduce a behavior we are able to achieve easily in Zoho Creator: prefilter a record selector by a status (a selected field) and another record selector (exclude what is already linked).
To explain that, here’s a bit of information:
- We have a module named “bundles” and another module named “hardwares”. We have also a module named “accessories” which have a matter of compatibility with the records in “hardwares”.
- an hardware can be added to a bundle only if its status is “available” and if it’s not already used by another bundle (unique)
- an accessory can be added to a bundle with the same condition and with another one : it has to be compatible with the hardware (have a field value in common)
I thought it could be achieved with ease but I’m stuck. Only the prefilter by status is working.
Thanks a lot for any help.