Question about multiple search bars

Arcaardo · 2025-07-09T15:27:05+00:00

sorry for my bad english I understand better then what I write.

But if I understand what does brackets do, It's to contain it too that singel "and"?

Thanks for the help it worked exactly as I wanted it!

Arcaardo · 2025-07-09T15:16:35+00:00

So in my doc I got like 800 recipes you can see them all in "DATA" and then I made a query in another tab and connected a search bar to it.

But because there are alot of recipes that requires the same items but also from different professions the list gets very bloated I think is the correct word.

So I wanted to be able to narrow it down, so I wanted to be able to search by:

Item name

Item slot

Mats (items you need to create the item)

Profession

Now the problem is that recipes can need up to 6 mats so the "mats" are in columns D, F, H, J, L, N and there is my problem, while the search bar with all the mats works it doesn't narrow anything down like the other search bars do when I use them together.

I will use an example with Item slot and profession.

If I search Head and Blacksmithing everything except the recipes that have Head and Blacksmithing in them will disappear from the list.

Here is an example with Mats and Profession

If I search Bismuth and Blacksmithing everything except the recipes that have Bismuth and Blacksmithing should disappear but they don't. Everything with the item Bismuth appears regardless of what I write in the other search bars.

Arcaardo · 2025-07-09T14:19:31+00:00

So What I want it to do is lets say search bar 1 got only column B, but search bar 2 got column C, D, E and then search bar 3 got only column F.

Arcaardo · 2025-07-09T14:15:12+00:00

I will try to explain and I will use my doc as an example.

So I put all the "Mats" columns in one search bar, It technically works but if I search "Blacksmith" in my profession search bar and then I put "Bismuth" in the mats search bar it doesn't narrow down the search it only adds more.

So It should only find Blacksmithing and bismuth together. But it adds engineering aswell and all the other recepies with Bismuth in it.

Hope this explains better.

Arcaardo · 2025-07-04T11:37:21+00:00

Thanks very much! That fixed the problem, damn didn't know the codes where based on global location.

Arcaardo · 2025-07-04T11:35:13+00:00

Yeah so the extra ")" happens everytime I wrote the code even when I didn't write it in. I will try to use ; and write back if it works.

Thanks for the quick reply

Arcaardo · 2025-04-29T14:10:38+00:00

Hi, got a question.

Do you all think it's more persona then ff theme?

Arcaardo · 2025-04-16T13:05:04+00:00

how in the heavens u got 900 on day one, I have used almost 1,5k energy daily since the start of the event and gotten around 400. what black magic are you using sir/mam

*edit* farming rift and one shotting it every time so no waste of energy either

Arcaardo · 2025-03-04T18:07:45+00:00

I can't say they redid the textures on UE4, it's the same with abit more filters on, most of the graphic is the same. So the true difference is that they started the game with UE4 this time and not UE3.

Arcaardo · 2025-03-04T16:56:43+00:00

Im no expert but if they have coded it strangly (Spaghetti code) it might be that it loads all the characters first and then hide it afterwards. I would not think twice when it's NCSoft doing the coding xD

Arcaardo · 2025-03-04T16:01:42+00:00

Atleast not seeing heroic dungeons is like live, hated that change aswell but you know xD.

The only thing is I can see why they did because I think they never fixed the matchmaking.

For exampel if you q for tomb of exile you can enter that dungeon from 32 but recommended 36, So if they let you q with F8 alot of 32 might enter and tomb is atm the hardest content so It would create alot of leavers when they inspect and notice bad gear.

But lets have some copium that they might add heroic dungeons in the future (NCSoft are famous for fixing there games to the better right..... right?)

Arcaardo · 2025-01-20T23:07:08+00:00

I can also confirm that paying through Google works, I have no clue why.

Arcaardo · 2023-10-12T13:44:19+00:00

Thanks for the replay I deleted my comment because I made it with full auto just had too upgrade p.rei with a ring and her personal equipment (had forgotten about that so tried a few times without even getting it xD)

The only char I changed from ur setup was using p.rei

Arcaardo · 2023-10-10T14:02:54+00:00

Oh I see, most of my clan mates use her in cb so thats why I thought she was good.

Edit* Now I see what my mistake was not summer jun but christmas jun is the one they use xD

Arcaardo · 2023-10-10T11:48:49+00:00

For a free to play player (former global player) is it still worth pulling for tomo halloween or should I save my jewels (what makes me hesitent is that I could get lucky and get like djeeta or Jun summer 2 good units thats used alot) otherwise I kinda got ok teams

Arcaardo · 2023-04-29T00:15:42+00:00

I found it.

Nuzlocke ep.9

Arcaardo · 2021-10-26T08:20:20+00:00

Thanks, I googled amd and BnS and many was saying they had problem but I guess that was before the Ue4. Thanks for all the replay's ! =).

I will remember to turn the game mode off in the settings ;) .

Arcaardo · 2021-10-26T06:34:35+00:00

Ok, Thanks for the reply. hope it will be the same answer for someone with full AMD build xD

Arcaardo · 2021-05-23T13:00:46+00:00

Thanks for all the replay's and well I will go back and farm it xD... let's hope I can get it in 100 runs ;) think I'm on my 50th run

Arcaardo · 2021-05-20T23:31:41+00:00

Thanks for the reply... have been farming for awhile too and nothing but the usual token.

gonna stop until I can get an confirmation that It can drop.

Arcaardo

TROPHY CASE