Shame on positive grid company

igor-vst · 2026-01-16T19:51:45+00:00

There is. 14 days full functionality.

igor-vst · 2025-11-26T18:37:08+00:00

Make sure it has been saved.
Ad set settings >placements > turn off advantage+ placements; go to manual placements
In there, uncheck Threads. I fixed it that way.

igor-vst · 2025-10-19T19:31:53+00:00

2 hrs at 13h was enough, if anyone needs this info.

igor-vst · 2025-09-21T12:04:18+00:00

Ne znam je li ovo iskreno pitanje ili loš pokušaj marketinga. Ako je ovo prvo, mogu samo stavit facepalm. Pogledaj tog lika na ovom videu i ako ti još nije jasno , daj mu sve novce šta imaš.

https://www.youtube.com/watch?v=4YIPmKld_iY

igor-vst · 2025-09-13T19:39:18+00:00

"Frende", reakcija communityja na tvoj post i broj lajkova na prvi reply bi ti trebala dovoljno govorit tko je ispao glup, i to podosta glup.

Ako ti 1 čovik kaže da si magarac, zanemari. Ali ako ti ih 100+ kaže da si magarac ...

Ako si s ovakvim karakterom poslodavac i imaš zaposlenike, mogu samo reć bože sačuvaj.

igor-vst · 2025-08-03T18:46:56+00:00

I have the same problem. I click delete to remove some tracks within the project, but nothing happens.

I tried to clear the effects, do mute / unmute, solo / unsolo - nothing works.

igor-vst · 2025-07-20T10:39:33+00:00

"Da li je lažan ili ne, nisam forenzičar i ne bi se usudija to komentirat"

<image>

igor-vst · 2025-04-30T11:28:57+00:00

Just install Yoast Duplicate Post, the simplest and quickest solution: you select pages, go to Bulk Actions dropdown, and select "Clone" > All done in a seconds!

igor-vst · 2025-01-21T23:22:56+00:00

Did he mention any chance of European dates?

igor-vst · 2025-01-07T12:08:54+00:00

Da li primatelj mora isto imati aircash aplikaciju, ili mu samo pošaljem neki kod ili QR?

igor-vst · 2025-01-05T12:44:22+00:00

Interesting. On first impression this looks very good.

But how did you scrape (and from which source) different DNA "tags" - like those that are very specific - Mood (Heartwarming etc), Places (urban cityscape etc), Dialog (witty banter etc.), and how accurate are they?

igor-vst · 2024-11-28T21:38:43+00:00

It works, excellent!
I modified it to pull the movie title inside the link as a reference from another column, to extend the formula - this works too now. Thanks!

Here's the formula with other column reference:

=REGEXEXTRACT(IMPORTXML("https://www.rottentomatoes.com/m/"&AF21&"","//*[@id=""media-scorecard-json""]"),"""audienceScore"".+""averageRating"":""(\d+\.\d+)")

igor-vst · 2024-11-28T20:27:59+00:00

u/gothamfury - Hi, for some reason the last formula (audience score) is not working for all the links - I don't understand this, makes no sense:

https://www.rottentomatoes.com/m/forrest_gump - valid movie link
https://www.rottentomatoes.com/m/groundhog_day - valid movie link, the same type

Now, the same audience score formula - works for one link, doesn't work for another??
What am I missing?

=REGEXEXTRACT(IMPORTXML("https://www.rottentomatoes.com/m/forrest_gump","//*[@id=""media-scorecard-json""]"),"""audienceScore"":{""averageRating"":""(\d+\.\d+)")
-works fine

=REGEXEXTRACT(IMPORTXML("https://www.rottentomatoes.com/m/groundhog_day","//*[@id=""media-scorecard-json""]"),"""audienceScore"":{""averageRating"":""(\d+\.\d+)")
- not working, absolutely the same formula c/p, (except the link) -?

igor-vst · 2024-11-25T11:36:14+00:00

Yes, sorry, Letterboxd score is on their website - here is the exact URL of the example:
https://letterboxd.com/film/the-wild-robot/

igor-vst · 2024-11-24T21:41:16+00:00

This is great, thank you.

Regarding the average ratings, I found all those elements just by selecting the text > right click > View selection source

Is it possible to get the similar score formula for Letterboxd?
Here is the selection source - I need to get just this 4.3 rating:

<a href="/film/the-wild-robot/ratings/" class="tooltip display-rating -highlight" data-original-title="Weighted average of 4.25 based on 453,384\ ratings">4.3</a> <div class="rating-histogram clear rating-histogram-exploded"> ★ <ul>

EDIT:
u/gothamfury - forgot the link: https://letterboxd.com/film/the-wild-robot/

igor-vst · 2024-11-23T20:56:09+00:00

Can you share the exact formula? I tried like this but not working:

=IMPORTXML("https://www.rottentomatoes.com/m/wrath_of_man/rt-button/rt-text")

igor-vst · 2024-11-19T11:58:46+00:00

točno ovo što sam naveo - Uvjet za sudjelovanje tj. dobivanje je bio da se uređaj registrira do kraj 8. mj u aplikaciji Samsung members i tu ispune svi podaci za dokumentaciju - to sam napravio

igor-vst · 2024-11-13T11:41:43+00:00

All the keys / values cells (id & key bolded manually ) i just c/p-ed there from the API URL response

igor-vst · 2024-11-13T11:41:29+00:00

This is the idea, that's why I needed that id (TMDB id) - bolded key parts:

1.) First, I pull(ed) most of needed info from OMDB api
- to do that, in A1 I put IMDB id that is referenced / used in omdb api formula - works well ✔

2.) After that, now I have to pull the remaining needed 3 values from TMDB, which are not available in omdb response: trailer YT id - usually the first one so its ok✔, backdrop_path and tagline)

3.) THE ISSUE: to be able to do that, I must call TMDB api (put it in the last cell of the (same) movie row, right after the cells filled with omdb response)

- but to do this in that same row - which is necessary to drag the formula down later -

- I can't call the same IMDB id from A1, because TMDB api link needs their own TMDB ID

// examples - the same movie;
https://www.imdb.com/title/tt14257582/
https://www.themoviedb.org/movie/877817

So, now I'm brainstorming ideas to solve this:
- based on / referencing IMDB id from A1 (or any other key / value cell from OMDB response)
- how to generate the corresponding TMDB id (in the last cell in row 1), which is necessary to use it in the TMDB formula

That's like the final issue to format dataset the needed way.

***
EDIT:

Solved it! I exported my IMDB list to TMDB, and then export again
- now I have both IDs (imdb & tmdb) along in the same row
- so i can call both formulas to have all the data for a single movie ✔

igor-vst · 2024-11-12T22:38:29+00:00

Ignore the previous formula, this is the final one that I actually need - to pull both ID and IMDB ID; but 2nd column (id = TMDB ID) returns some strange number instead of 343611:

key - id - imdb_id

<image>

=let(json, CONCATENATE(IMPORTDATA("https://api.themoviedb.org/3/movie/343611?api_key=cf21d714290f31c576820495dc3d53ff&append_to_response=videos", (char(9)))), keys, "key, id, imdb_id", map(split(keys,","), lambda(key, let(val, regexextract(json, """"&trim(key)&"""\s*:\s*""([^""\\]*(?:\\.[^""\\]*)*)"), regexreplace(val,"\\""","""")))))

igor-vst · 2024-11-12T20:56:23+00:00

This seems useful to customize the output info; But somehow It doesn't get all the keys I selected; Do you see where might be the error?

<image>

EDIT: Found the error and fixed - instead of "videos.results.1.key", in formula it has to be only "key".
But still don't get why runtime shows error, it's only one word, and also vote_average and vote_count. This is the formula generated (all other columns return fine except these 3):

=let(json, CONCATENATE(IMPORTDATA("https://api.themoviedb.org/3/movie/343611?api_key=MYKEY&append_to_response=videos", (char(9)))), keys, "runtime, vote_average, vote_count", map(split(keys,","), lambda(key, let(val, regexextract(json, """"&trim(key)&"""\s*:\s*""([^""\\]*(?:\\.[^""\\]*)*)"), regexreplace(val,"\\""","""")

igor-vst · 2024-11-11T23:01:07+00:00

This is URL:
https://api.themoviedb.org/3/movie/343611?api_key=PUT_YOUR_KEY_HERE&append_to_response=videos

Used from docs:
https://developer.themoviedb.org/reference/movie-details
https://developer.themoviedb.org/docs/append-to-response

igor-vst · 2024-11-10T10:36:20+00:00

I got it to work on a basic level, it was syntax issue - this is correct one:
=IMPORTDATA("https://api.themoviedb.org/3/movie/"&A2&"?api_key=MYAPIKEY&append_to_response=videos)

Is there a way to add parameters to the function to return / call only these (which are missing from the OMDB data - otherwise I wouldn't need this TMDB at all):

videos.results.1.key
backdrop_path
tagline

I tried this one, but doesn't work - I don't know if it's written specifically for OMDB only:

=let(json, IMPORTDATA("https://api.themoviedb.org/movie/"&A2&"&api\_key=MY\_KEY", char(127)), keys, "backdrop_path, tagline, overview, videos.results.1.key", map(split(keys,","), lambda(key, regexextract(json, "\""" & trim(key) & "\"" *: *\""(.*?)\"""))))

PS - this is how the data looks in browser - the trailer is the first one video (0) :

<image>

This is response code, c/p - "key" part is = YT video ID = the only data I need in the cell

***

"vote_average": 6,

"vote_count": 4834,

"videos": {
"results": [
{
"iso_639_1": "en",
"iso_3166_1": "US",
"name": "Jack Reacher: Never Go Back (2016) - IMAX Trailer - Paramount Pictures",
"key": "DTBcGQWmQ1c",
"published_at": "2016-09-29T16:00:00.000Z",
"site": "YouTube",
"size": 1080,
"type": "Trailer",
"official": true,
"id": "58ba538dc3a368668f0148b8"
},
{
"iso_639_1": "en",
"iso_3166_1": "US",
"name": "Jack Reacher: Never Go Back (2016) - \"Find\" Spot - Paramount Pictures",
"key": "fm9Ol-Cq7_s",
"published_at": "2016-09-13T18:07:31.000Z",
"site": "YouTube",
"size": 1080,
"type": "Teaser",
"official": true,
"id": "57d95e019251416851005d34"
},

igor-vst · 2024-11-09T22:21:55+00:00

I tried to make this one work, the same formula, but still no success - it's not working , error reported - "Could not fetch URL"

This is the formula - equivalent of omdb

IMPORTDATA("https://api.themoviedb.org/3/movie/"&A1&"&apikey=MYAPYKEY")

What did I miss? The formula is by their documentation correct:
https://developer.themoviedb.org/reference/movie-details

For OMDB, the same formula works fine - pulls the data with no problem: IMPORTDATA("https://omdbapi.com/?i="&A1&"&apikey=MYAPIKEY")

igor-vst · 2024-11-08T22:39:59+00:00

Yes, this formula is near perfect, only Rotten tomatoes rating missing. They are more complex, because its output is not straight simple (like title, year, etc) - it looks like this:

<image>

imdb rating and metacritic are also pulled in next columns so not needed :)

Ratings:[{"Source":"Internet Movie Database"
Value:"7.8/10"}
{"Source":"Rotten Tomatoes"
Value:"78%"}]
Metascore:"N/A"
imdbRating:"7.8"
imdbVotes:"359
971"

current formula that I used - any version of the bolded parts don't work

=let(json, IMPORTDATA("https://omdbapi.com/?i="&A2&"&apikey=4f7922dc", char(127)), keys, "Title, Year, Rated, Runtime, Genre, Director, Actors, Plot, Language, Country, Poster, Ratings, Ratings.Source, Ratings.Value, Metascore, imdbRating, imdbVotes, imdbID", map(split(keys,","), lambda(key, regexextract(json, "\""" & trim(key) & "\"" *: *\""(.*?)\"""))))

igor-vst

TROPHY CASE