IF({Gift Credit Count},
IF({Gift Credit Count}<{Soft Credit Count}, "Softs",
IF({Gift Credit Count}<{Appeal Credit Count}, "Appeals",
"Gifts"))))
3 fields I need to compare.
Gift, Soft, and Appeal.
I am trying to create a formula comparing
Gift to...
Months Active
is a formula that returns what appears to be a number.
IF({First Gift Date}, DATETIME_DIFF({Last Gift Date},{First Gift Date},‘month’),"")
Number of Gifts
is a count field
I’m trying to create a field that returns an frequency
{Months A...
2 Tables - Constituents and Constituent Types.
Constituents holds contact information.
First Name, Last Name, Email, Phone, etc.
Constituent Type holds the taxonomy (so it has a hierarchy) to organize the Constituent data
a. Individual
a. Organizatio...
I’m so confused using the Dedupe block. It doesn’t MERGE anything. It just keeps the primary record.
Let’s say I have a table with Name, Email, Phone, Address, and Transactions.
I select find dups records as Name and Email,
2 Records appear.
has the ...
And with that, I express my gratitude. Thanks so much! Hopefully soon javascripting will sink in for me.
let name = base.getTable('Constituents');
let parent = await input.recordAsync('The constituent', name);
if (parent) {
output.text(parent.get...
