I have created a database field called "Smartlist" and want to fill that database field with a value that indicates what Smartlist the database record was selected by.
I have also set the "After playback expression: setfield(smartlist,)
My first attempt at setting the "Smartlist" field in the database record was to add an "Expression Column". The Expression Column contains the following command: "SetField(Smartlist,DI 2020)" for a Smarlist that selects database records based upon the date the record was Imported.
I went on to duplicate that approach in other Smartlists using the command: "SetField(Smartlist,LP 2020) for database records based upon the date the record was Last Played, and using the command: "SetField(Smartlist,NP 2020) for database records based upon the Number of Plays. Example attached. And finally, I duplicated this approach for a Smartlist that selected database records at Random using the command: SetField(Smartlist,RA 2020) and it too appeared to work as intended. Example attached.
Next, I created a Combo Smartlist that included the four Smartlist playlists. The ones with; Setfield(Smartlist,DI 2020), Setfield(Smartlist,LP 2020), Setfield(Smartlist,NP 2020), and Setfield(Smartlist,RA 2020). Example attached. When the Combo Smartlist executes, the database Smartlist field shows records with the values "DI 2020" Date Imported, "LP 2020" Last Played and "NP 2020" Number of Plays, however the records selected by the Random Smartlist show up with blank values. For some reason when the Combo Smartlist processes the Random Smartlist the Expression column does not get processed, or the Expression column gets processed after records were returned to the Combo Smartlist, or the Combo Smartlist returns a different random set of records.
Help please, is this a bug or am I doing something wrong? I think it would be awesomel if there was an "Add Modifier" option in Smartlists that would allow you to execute commands like "Setfield". Is that possible?