What is your goal?
I would like my Scheduled scenario run through Facebook each to choose a different picture to go with the post. Right now it will only choose one every single week it never changes.
What is the problem & what have you tried?
I need to know from the screenshots maybe I selected the wrong set for the google sheet you know when I ask if you want Which fuel type what sort order type all that stuff II iāve tried things I just canāt seem to figure out what Iāve done wrong here because it does run but itās taking the first picture only out of the 5 I have on my google sheet.
Error messages or input/output bundles
There are no error messages because it works but itās still only choosing one of the pictures thatās 1st picture.
Screenshots (scenario flow, module settings, errors)
I can add more screenshots if needed but Iām just trying to figure out what the choices I should have made in the settings drop down on how to get it to pull a different picture each week I want it to rotate a different picture along with the weekly post that I have it scheduled.. So far three weeks in a row itās just been picking the first picture off the top and thatās not what I want thatās too redundant..thx
Yeah thatās essentially what you have set in the search module - to give you the first picture in descending order.
Maybe add a new row where you specify which picture to use today and search by the values in that row. By days of the week for example.
Or have the scenario tag that this was already used and then have the search module only return pictures that have not been used yet.
My question though, Should I put it as attending order I was told that the setup that each week it should rotate from picture to picture what should I put in the settings exactly,
so it will pull a different picture each time scheduled run each week and then starts back over at top.
I mean I thought thatās what this AI is smart enough to do it must be A setting and Iām looking for some easy settings..
He was told that what my setup to do but I had made an error in some of the fields and Iām asking if somebody truly knows what change they need to make scenarios that will do just that I was told itās possible without doing anything crazy..
Your Google Sheets limit is set to 1 which means youāre only going to get one photo when you run the search. When you combine that with a fixed sort order that means you will only get a single row each time.
To fix this you can add a row number column to your GSheet and use a counter or a data store in Make to keep track of which row was used previously. You can then increment it for each run. That way you can use that value in your Get a Row step to get the next specific row that is needed each week until you get down to the end of the list. I might also add a column to determine if the photo has been used already which would be added at the end of the workflow just to prevent any duplicate issues from occurring.
Iām not an expert but if I set that limit in the Google sheet if youāre talking about on the settings if I put two 3 or 4 whatever number I put in there itās gonna send four posts all at the same time if I put the number 4 in thereā¦ So yes thereāll be 4 pictures and 4 post there one right after the other. At least thatās what I found in the past but Iāve got to research this further.thx
Correct, raising the limit would send out multiple posts so it might not be the best solution.
So the best thing is to add a āSet Variableā module under āToolsā to generate a random row number with something like āceil(random() * 5)ā or however many photos you have, then use that output into the āGet a Rowā module instead of Search Rows that way you will only retrieve one row and have just one photo.
