Hi fellow Coders,
I’m trying to create a self-referencing table, but I need to add a filter to display just a few options.
The problem is as follows:
1- I want to build a blog post and social media management system in a single table.
2- First, I choose the platform, which can be a social network or a blogging platform.
3- After writing a blog article, I want to post the link to that article on social media.
4- To do this, I select a social network in [platform] and then I want to have a list that presents only the lines that are “Articles”.
5-For this, I used the Concatenate command to create a searchable Content ID as a display column, joining [platform] with other relevant information.
6- I created a lookup using the [content id] column, but I only want to show options that contain the word “Article”. I couldn’t get this filter inside the lookup to work at all.