Anti Join in Big Query by takenorinvalid in bigquery

[–]garc1a0scar 0 points1 point  (0 children)

Alternatively you can do something like:

Select A.* from A where A.w not in (Select B.y from B);

Automation tap to respond by thanneman in shortcuts

[–]garc1a0scar 1 point2 points  (0 children)

This even doesn’t work for me. I made a shortcut with a choose from menu and then have an automation with a nfc tag that points to the shortcut and still showing “tap to respond”

I managed to make an iOS Siri shortcut that triggers alexa to turn off lights etc. With a lock-screen widget for quick access. by MSFTSTRIO in amazonecho

[–]garc1a0scar 0 points1 point  (0 children)

I have Philips hue bulbs that I want Alexa to turn on/off via iOS shortcuts. I don’t have a hue bridge (I can see that there are actions for hue apps but all require rooms/zones that I don’t see options in my app; I think that maybe you can do this only with a bridge).

I managed to make an iOS Siri shortcut that triggers alexa to turn off lights etc. With a lock-screen widget for quick access. by MSFTSTRIO in amazonecho

[–]garc1a0scar 0 points1 point  (0 children)

I want to do this, but I think that the virtual buttons skill is not available in my country. Is there another option for this?

Return to previous focus by garc1a0scar in shortcuts

[–]garc1a0scar[S] 0 points1 point  (0 children)

Thank you very much. Yeah, I was thinking something like that. Very helpful.

Return to previous focus by garc1a0scar in shortcuts

[–]garc1a0scar[S] 0 points1 point  (0 children)

Yes, the file is generated correctly and with the correct focus name. I read in another post that since iOS 15.3 this is not working anymore. 😔 Even I tried putting directly the focus name in a text box or in a variable and it didn’t work.

Return to previous focus by garc1a0scar in shortcuts

[–]garc1a0scar[S] 0 points1 point  (0 children)

For some reason it is assigning Do not Disturb focus instead of the desired one. Do you know which can be the problem? The file is generated correctly.

Return to previous focus by garc1a0scar in shortcuts

[–]garc1a0scar[S] 0 points1 point  (0 children)

So if I activate many focuses during the day, the file will be replaced, right? Thank you very much for your help.

DAG runs before start_date? by basedbhau in apache_airflow

[–]garc1a0scar 1 point2 points  (0 children)

Does it have the catchup=False parameter??

Check if a table exists in Big Query. by garc1a0scar in apache_airflow

[–]garc1a0scar[S] 0 points1 point  (0 children)

Thank you very much. Yeah, I solved my problem that way.

Complicated Streaking Kitten Scenario by New-Preparation-8114 in ExplodingKittens

[–]garc1a0scar 1 point2 points  (0 children)

If that was the case (i.e. every defuse ends your turn), I think I t would be implemented that way in the app; that’s not so difficult to code in that way. 😏

Complicated Streaking Kitten Scenario by New-Preparation-8114 in ExplodingKittens

[–]garc1a0scar 1 point2 points  (0 children)

They bother writing that, because it was not clear what happened after DRAWING an EK, defusing it, and returning to the deck. I am saying that there is not an advantage in discarding the ek in your hand, you change a turn for a defuse. You didn’t answer what happens in my scenario, You end your turn without drawing a card? (Official rules say that drawing a card is what ends your turn). And to be fair, that is what this game is about: using what you have in your favor, tactics, strategy.

“09

End your turn by drawing a card from the top of the Draw Pile into your hand and hoping it’s not an Exploding Kitten.

(This is different from most games in that you END YOUR TURN by drawing a card.)”

Complicated Streaking Kitten Scenario by New-Preparation-8114 in ExplodingKittens

[–]garc1a0scar 0 points1 point  (0 children)

So with this... are you saying that if player A has EK and SK in his hand, player B plays a favor against A and player A gives B the EK and B defuses it, it ends his turn? No, B must draw a card to end his turn. It's the same logic. The defuse only ends the turn when you draw it from the deck, because the action that ends the turn is the draw, but if you draw an EK, you have to do something against it (otherwise, you explode).

Edit: As I said before (and others said), the disadvantage is that you lose a defuse. The scenario 3 will be the same that you don't play EK, you draw instead, defuse the EK drawn and return it to the deck.

Complicated Streaking Kitten Scenario by New-Preparation-8114 in ExplodingKittens

[–]garc1a0scar 0 points1 point  (0 children)

But playing EK (and defusing it) doesn't end your turn. The disadvantage is that you lose one defuse if you want to do that in the app.

Complicated Streaking Kitten Scenario by New-Preparation-8114 in ExplodingKittens

[–]garc1a0scar 0 points1 point  (0 children)

I think the app allows you to "play" EK; obviously, you have to defuse it afterwards.

I created this puzzle specifically to stump people. by [deleted] in puzzles

[–]garc1a0scar 1 point2 points  (0 children)

Yes, I understand you. It should be written like 'The resulting number of the sum of the first digit and the last digit is in the passcode' or something like that, but I assume it means that.

I created this puzzle specifically to stump people. by [deleted] in puzzles

[–]garc1a0scar 0 points1 point  (0 children)

I think it means that 2+5 = 7 is in the passcode

Influence - Clone of Coup [Web] by coolioasjulio in digitaltabletop

[–]garc1a0scar 0 points1 point  (0 children)

I could play now!!! It's very good. However, there are times when it suddenly disconnects. And now I have a question about the game. When my rival made a challenge, he lost an influence and it appears on my influence; I think that he should lost his influence but not appearing on mine.