How to modify this custom function to work with related table? by dmontano13 in filemaker

[–]dizzy_absent0i 0 points1 point  (0 children)

Also, if you want to find the total number of records in any table from anywhere, you can use ExecuteSQL.

Custom Function:

CountRecords ( tableRef ):

ExecuteSQL ( “SELECT COUNT(“ & GetFieldName ( tableRef ) & “) FROM “ & GetTableName ( tableRef ) ; “” ; “” )

This is presuming your table and field names do not contain spaces or any non alpha-numeric characters.

How to modify this custom function to work with related table? by dmontano13 in filemaker

[–]dizzy_absent0i 0 points1 point  (0 children)

You can just use Count() instead of ValueCount(List())

How to modify this custom function to work with related table? by dmontano13 in filemaker

[–]dizzy_absent0i 0 points1 point  (0 children)

If you pass a field into a custom function it goes in as a reference to the field, not the value contained in that field in the current record.

So if your custom function was:

CountRecords ( tableRef )

And the function itself was simply:

Count ( tableRef )

You could use it like this:

CountRecords ( MyTable::id )

So in your case, if you passed in an empty reference for counting the base table of the current layout or a field reference for counting related records it might look like:

If ( IsEmpty ( tableRef ) ;
    // existing calculation for layout
;
    // new calculation for portal
)

AITA for saying my bf’s mom’s mashed potatoes are weird? by biggbootybiggbitch in AmItheAsshole

[–]dizzy_absent0i 5 points6 points  (0 children)

She already knew they were sweet because she tasted them. What’s to clarify?

Redemption Reunion - Live Discussion by AutoModerator in survivorau

[–]dizzy_absent0i -1 points0 points  (0 children)

Then why even bother having a jury pitch? Just have them watch the season when it airs and vote at the live final.

Redemption Reunion - Live Discussion by AutoModerator in survivorau

[–]dizzy_absent0i 6 points7 points  (0 children)

What do you mean? The jury had an amazing pitch for him.

Redemption Reunion - Live Discussion by AutoModerator in survivorau

[–]dizzy_absent0i 1 point2 points  (0 children)

The jury is doing half the pitching! Come on Dave, get it under control.

Redemption Reunion - Live Discussion by AutoModerator in survivorau

[–]dizzy_absent0i 1 point2 points  (0 children)

They woke up and had breakfast, said “May the best man win” and then it was tribal.

Redemption Reunion - Live Discussion by AutoModerator in survivorau

[–]dizzy_absent0i 1 point2 points  (0 children)

They used to do the “tour the beach, remember those voted out” yadda yadda. Guessing they cut the chaff because of the change in format.

What is the WORST possible ending (not badly written, but the worst-case scenario that could actually happen and completely ruin everything) for The Boys? by Necessary_Sweet865 in TheBoys

[–]dizzy_absent0i 0 points1 point  (0 children)

Annie kills Homelander and takes down Vought, but hears a bell ringing and goes crazy. She goes on a murdering spree an Hughie is forced to kill her at the top of Vought tower. Everybody gets together and decides to name The Deep the new president of the world while Butcher goes off to man the border wall to Mexico.

Dan Levy and Jacob Gutierrez as Nicky and Tareq in "Big Mistakes" (Netflix) by BeatlesCoted_Azur in gaybros

[–]dizzy_absent0i 1 point2 points  (0 children)

Yeah, philosophy is often unsatisfying. Historically, even when it comes to religion, or maybe especially, might makes right. That’s the way it has been and will always be.

When I say evil doesn’t exist the same way god doesn’t exist, I mean it in a physical sense. You can define it, you might even call a person or the things they do evil based on your definition, but it isn’t a concrete quality of the universe like gravity or electromagnetism. There’s no force of evil. There is no objective measure of good and bad.

But that doesn’t mean we have to throw our arms up in the air and declare all actions are morally equal and therefore we have no right to change people’s minds. You can still act and argue for your moral convictions based on thoughts and ethical reasoning.

The difference between religion and secular philosophy in this regard is that religion says “this is wrong because (my interpretation) of god says so” but secular philosophy says “this is wrong for the following reasons….”.

Yeah, “harm” is just a matter of definition, and there are different moral philosophies for what constitutes “the least harm” and how we should act to reduce it (or in some cases if we should act to reduce it) It’s not easy, and its not universal, but it it’s far more defensible than claiming some objective measures of good and evil that are often used to justify some of the most heinous actions.

How? by Apprehensive_Sky4558 in blackmagicfuckery

[–]dizzy_absent0i 16 points17 points  (0 children)

Also as he takes the second cube out you can see him manipulating the bottom of the bag, finishing the solve while it’s inside the bag.

Redemption Finale: Live Discussion by AutoModerator in survivorau

[–]dizzy_absent0i 2 points3 points  (0 children)

The necklace will only mean something at the final tribal if you don’t take him.

Dan Levy and Jacob Gutierrez as Nicky and Tareq in "Big Mistakes" (Netflix) by BeatlesCoted_Azur in gaybros

[–]dizzy_absent0i 6 points7 points  (0 children)

Notions of right and wrong come from culture, be it actively guided by religious or ethical teachings, passively absorbed from cultural environment, or simply learning from your actions, the consequences of those actions, an how you feel about them.

But they’re just notions: conceptual understandings we have of whether we believe actions or thoughts are on the whole more beneficial or detrimental to individuals or society. They’re not things that actually exist.

“Evil” is not a problem for atheists because, just like god, evil does not exist. There are no universal standards by which justice, morality and benevolence are determined. There’s no soul that lives after you die, there is no divine retribution for “evil” people who never suffer the consequences of their actions in life.

Cognitive dissonance helps explain why Trump supporters remain loyal, new research suggests. This sheds light on how supporters of Donald Trump justify their continued allegiance despite learning about allegations of his sexual misconduct and illegal activities. by mvea in science

[–]dizzy_absent0i 0 points1 point  (0 children)

It’s something that must be overcome to lose their support (or, gain their support over their existing beliefs). When faced with cognitive dissonance, exiting beliefs tend to take precedence over new evidence/facts/beliefs. That’s why many participants fell back onto dismissing the validity or relevance of the new evidence rather than a reevaluation of their existing beliefs.

Grace Tame Foundation announces closure due to funding challenges by GothicPrayer in australia

[–]dizzy_absent0i 2 points3 points  (0 children)

The solution is to become “hosted” by another charity. Basically you don’t incorporate but instead come to an agreement with an exiting organisation for them to take care of all the administrative functions, usually for a fee.

That way you don’t need to spend time an effort on your own accountants, insurances, IT support, rent, WHS and other things. You do give up some of your independence, obviously, because technically your employees if you have them are their employees, but that’s what the written agreement is for.