Catamorphism Fields
I wanted to show you a new demo I put together that "summarizes" text fields in child records to the parent record that uses the new 3Q&S technique. After I show you the demo I will generalize what th...
Forum Discussion
I'm attempting to use this technique to generate an html table (with child records, works great in QB) that I want to send with email. When I send the email, it sends the actual 3Q&S code and not the child records that it "catamorphized." Is there a way I can use that catamorphism data outside of QB?
- QuickBase Formulas are evaluated on the QuickBase server and their calculated values are saved (probably through some type of caching strategy) on the server. These 3Q&S fields are script that "evaluate" client-side (ie in the browser) and the "evaluation value" is not saved on the server. Rather the "evaluation value" that 3Q&S calculates is merely displayed on the page or used to modify the behavior or appearance of the page in some way. If you wanted to save the value a 3Q&S calculate you have to make a supplemental API_EditRecord call such as this:
let xml2 = await jqajax(
However, you appear to be calculating markup which includes a <table>. QuickBase will not allow you to store this type of content as it contains prohibited tags.
$(dbidTable, {
act: 'API_EditRecord',
rid: rid,
_fid_100: markup
})
);
If you want to send email, you can use the native method a=UserWin to send the email to a user by mimicking this native interface:
The received email will look like this:
The supplemental code to do this will look something like this:let html = await jqajax(
$('main', {
a: 'UserWin',
uids: '51084879.bdbt',
message: message,
send: 'Send'
})
); - Thanks Dan, with this first snippet - where would you place it in relation to the initial "Equity Focus Area" example?
let xml2 = await jqajax(
);
$(dbidTable, {
act: 'API_EditRecord',
rid: rid,
_fid_100: markup
})
