last tiger
Hey there,
I'm looking to design a system where a user submits data into the database, to then be approved by an admin. It isn't known what the user might enter exactly but it's highly likely they will enter a string that may contain a name that matches a table of names in the DB. Is there someway I can use Flows and possibly regex to match their entry to an item in the DB?
Here is what I have working in VS:
var artists = ["John", "Jane", "James", "Joe"]
var artistTitle = "John with Jane feat. James and Jill"
var filteredArtists = artists.filter(function(artist) {
return artistTitle.includes(artist);
});
console.log(filteredArtists);
The only issue I have with this is that the "artists" array will be around 2.5k items and Directus cannot load all of these in a Get Data operator and so filtering the array won't work. Perhaps there's a better way of handling this type of user input? It's worth mentioning that the user will most likely input the data through importing a csv file directly to a table in Directus.
pulsar spoke