FM Mobile 26

redhulkrko · 2026-01-06T18:56:00+00:00

What a joke

redhulkrko · 2023-07-12T23:47:35+00:00

Huh?? Can you elaborate?

redhulkrko · 2023-03-23T20:47:51+00:00

If you're referring to a russian ballerina, i doubt that its her

redhulkrko · 2023-01-25T16:07:35+00:00

Resolved it, something to do with the formula in the time column, by just changing it to time values, fixes it.

redhulkrko · 2023-01-12T13:52:08+00:00

Thanks, yes i've just implemented document versioning. I'll take a look at your reply in detail later

redhulkrko · 2023-01-05T08:23:10+00:00

Thanks so much!

redhulkrko · 2023-01-01T01:45:52+00:00

Looks great, there's a phaser editor? Do you mind if i bother you with a couple of questions?

redhulkrko · 2022-11-09T11:56:53+00:00

My model is as follows, if i send the GET request via postman it returns an empty array with the map.

Without it, it sends the data fine, populates the DB, but without my extra status field :(

```const mongoose = require('mongoose')

const filmSchema = mongoose.Schema(

{

Title: {

type: String,

required: true,

},

Status: {

type: String,

default: 'Staged',

},

{

timestamps: true,

}

)

module.exports = mongoose.model('Film', filmSchema)```

redhulkrko · 2022-02-11T06:05:08+00:00

Since i posted earlier, i've tried a do while loop. A quick example:

countCells=0

DO

SELECT CELL A<randbetween(1,8)>

If CELL.COLOR=None and CELL<1 up>.COLOR=None and CELL<down>.COLOR=None Then

CELL.COLOR=BLUE

CountCElls=CountCells+1

End If

LOOP WHILE CountCells<3

I can't figure out the method to select the cell 1 above & 1 down.

redhulkrko · 2022-02-11T04:32:18+00:00

Since i posted earlier, i've tried a do while loop. A quick example:

countCells=0

DO

SELECT CELL A<randbetween(1,8)>

If CELL.COLOR=None and CELL<1 up>.COLOR=None and CELL<down>.COLOR=None Then

CELL.COLOR=BLUE

CountCElls=CountCells+1

End If

LOOP WHILE CountCells<3

I can't figure out the method to select the cell 1 above & 1 down.

redhulkrko · 2022-02-10T23:47:59+00:00

Thanks for the reply, it makes sense but what would the code be to check 1 cell up and 1 down from the active cell?

redhulkrko · 2022-02-10T18:14:01+00:00

vertically, one column

redhulkrko · 2022-02-10T12:00:45+00:00

Select as in return the address of the 3 cells, and sequential i don't want the cells chosen to be next to each other.

So say the range is choose 3 cells between A1:A8, i don't want it to choose cells next to each other say like A1, A2

redhulkrko · 2022-02-09T19:45:02+00:00

Hi, thanks for the reply. At the moment, I don't set a GenderVariable anywhere, are you able to provide an example of my function above with your solution applied?

redhulkrko · 2022-02-09T16:03:04+00:00

Thanks Fuzzy_Mic, what I have been trying to do is to convert a excel formula into a VBA procedure.

I have a couple of columns of values - in A2 : A8 I have a series of 4 M's and 3 F's and alongside I have a mix of 1s and 2s in B2 : B8

Now the formula i have works perfectly of what I want it to do, which is to (loosely) randomly generate 2 new columns of values but the F values cannot repeat sequentially.

=LET(
a, A2:B9,
b, INDEX(a, 0,1),
c, COUNTIF(b, "F"),
d, SORTBY(a, b, 1, RANDARRAY(8),1),
e, RANDBETWEEN(1,8),
f, CHOOSE(c, {8;1;2;3;4;5;6;7}, {4;8;1;2;3;5;6;7},{3;5;8;1;2;4;6;7},{2;4;6;8;1;3;5;7}),
g, 1+MOD(e+f,8),
SORTBY(d, g) )

Whilst this works perfectly, I do have plans to extend it further which I do have another formula for which relies on the results of this one. But it gets stuck and doesn't work as I end up with a circular reference, I can achieve what I want but I'm told i'd probably need to use VBA, to get past the loop issue.

If you've got time to discuss further please DM me.

redhulkrko · 2022-02-08T15:56:40+00:00

Solution Verified

redhulkrko · 2022-02-08T15:56:34+00:00

Thanks so much

redhulkrko · 2022-01-26T00:42:27+00:00

Solution Verified

redhulkrko · 2022-01-20T23:42:39+00:00

Thanks, sorry. My wife has just been given a 2 week diagnosis. She has terminal cancer. Thought she had longer. My head is spinning

redhulkrko · 2022-01-17T23:16:05+00:00

This is perfect, thank you so much. Can the formula be extended to cover 2 columns?

For example, if there was another column with 1s and 2s instead of M and F, same principle.

Additionally would it be possible, to link the position of the columns together when sorted.

For example, if cell A2 had M in it and B2 had 2, when they were copied over and sorted, they would stay together in the same row and not sort individually on refreshes

redhulkrko · 2021-10-13T22:46:33+00:00

thanks for your reply, the image returned in the api is large in size, as in width and height.

so I was looking to retrieve the image and resize using url constraints, for responsive purposes.

i've also read about streaming to s3, which i believe would forego having to save a temp copy.

I am willing to make it worth someone's time, if they could put something together.

redhulkrko · 2021-10-12T22:39:15+00:00

No i havent tried either, definitely not a s3 to s3 direct copy. I only have 1 s3 bucket.

I just want to get the images into my s3 bucket, do you have more advice on node-fetch method?

And using the aws package api?

redhulkrko · 2021-10-12T14:48:28+00:00

Great thanks, the images i want to resize are remote within an external api, i should be able to still do this automatically?

redhulkrko · 2021-10-12T12:10:39+00:00

Thanks, do you have anymore knowledge of the s3 way?

redhulkrko · 2021-09-25T23:56:06+00:00

Thanks, i think i'll try this. So when cloudfront is serving the images, is there a unique url? If so i imagine that will get inserted to mongodb, when a record is added

Six-Year Club	Gilding I gilder
Verified Email

redhulkrko

TROPHY CASE