The check box turns to true and doesn’t apply link.
I have another short link automation that does the exact same thing - except I build those profiles on Glide tables - and that still works perfectly fine! So i’m thinking this is a Google Sheet / Boolean issue?
From your videos it seems that Make is writing to the boolean column instead of the shortlink one. Have you checked that the the Gsheets module in link is set to the appropriate column?
Please note that when you add new columns to the Sheet, you should always add it to the right end if you have already configured something with Make. If you still want it to be inbetween, make sure you change the settings in Make.
But on Make the Screen URL is AS. Did you move it back to AS? That’s where it was originally when i made the video.
I’m not sure how the columns got screwed up, I do everything in Glide and almost never look at my Sheets until there’s a problem (like this). When I make columns in Glide I often do this:
I refreshed the connection and it seems like the Screen URL link is now AR.
Next time, I would rather change it on the Make side. Changing it on the Sheet side might make other column configurations, if any, have a problem.
I believe any columns that are added from Glide will be added to the right end of your sheet, thus not affecting anything in Make. I just tested and it’s the case. The incorrect column mapping here suggests that there has been changes made to that sheet since the original configuration, though.
oh my gosh, so what you’re saying is…all i had to do was refresh the connection between Make and Google Sheets and it would have automatically updated the Make columns to match? And the short link column in Make would have adjusted from AS to AR? Because you’re right, I just tested and it’s fixed. Also noted, I won’t add any random columns in Google Sheets, only at the right end.
No, as far as I’m aware if you move columns around in your GSheets then you need to manually adjust your related Make scenarios. It’s one of those things I find a bit annoying about Make - that it’s not smart enough to deal with moving columns (like Glide is, for example).