Hello all,
there are two collections, each of which has a new entry stored in it. Each Entry has not a Title collected. Now I want to combine both collections into a single collection and filter the entries of both collections.
CombinedCollection looks like this:
| MachineTitle (String) | ComponentA | ComponentB |
| 123451 | xy | xy |
| | | xy |
| | xy | |
I combine two collection:
ClearCollect(colCombined;ComponentA;ComponentB);;
Now I just want to only display empty MachineTitle values in the gallery so the user can add photos to the attachments of the new items.
Gallery.Items:
Filter(colCombined;'{HasAttachments}' = false && IsBlank(ID))
The code isn't working, but
when I change it to !IsBlank(ID), like this:
Filter(colCombined;'{HasAttachments}' = false && !IsBlank(ID))
The filter here works with only stored ID, but not with empty ID. How?
I have tried LookUp().
Any help is appreciated!
