Search Results for 'script'

[matt coxon]

Hi, I’m using the vlookup script by (Sam Moffatt) great script thank you Sam!!!

Is there a way to make a script field be a clickable URL / Hyperlink (as it would be if you had selected the “Web Site” field

This is the script,

Thanks Matt

form.runScriptNamed(‘vlookup’);

var trello_cards_id = ‘fld-a6346935a6af40d1833fad4f49958bca’;
var tsm_rfs_id = ‘fld-b0c9111f87064a23bde75c965374e97c’;
var short_url_id = ‘fld-7888517ad8204f5aa7a4bf926c92be15’;

var rfs = record.getFieldValue(‘fld-e13aa1493c6f4b919f30b27cd8bc8ae9’);

vlookup(rfs, trello_cards_id, tsm_rfs_id, short_url_id);

[matt coxon]

Hi, im playing around with scripts, (i’m new to them) is there a way to search a field for a partiular string and the output accordingly

Example would be

Field “Labels” has the following text (urgent,storage,emea,network,office moves,colo,new)

I’d like the script to search for the string “office moves” and return either a “yes” or whatever Id like

Is that possible
Thanks

[Brendan]

@John,

You could simulate that with a Calculation or Script field to concatenate the values.

[Sam Moffatt]

Ok, I’m going to attach a form template for this as well but the gist is naming a bunch of checkboxes the same way and then managing their state.

Two sets of checkboxes, one named “CBA” then a number and another set named “CBB” then a number. I created 15 of the CBA and 4 of the CBB. Too easy.

The biggest challenge in this is managing all of the checkbox ID’s because clicking all of those is a pain. Step 1: Form Script to generate Javascript for later (I called this “Generate Checkbox Script” but you could call it something else):

var fields  = form.getFields();

console.log(`var cbaList = [];`);
console.log(`var cbaValues = [];`);
console.log(`var cbbList = [];`);	

for (var index = 0; index < fields.length; index++)
{
	if (fields[index].name.match(/CBA/))
	{
		console.log(`cbaList.push('${fields[index].getID()}');`);
		console.log(`cbaValues.push(record.getFieldValue('${fields[index].getID()}'));`);
	}
	
	if (fields[index].name.match(/CBB/))
	{
		console.log(`cbbList.push('${fields[index].getID()}');`);
	}
}

This is an abuse of console.log but essentially I’m using it to write Javascript code. What we’re doing is asking the form for all of it’s fields (form.getFields()) and then looking to see which ones match CBA and which ones match CBB. The CBA ones we want to track their state, so we put the field ID into a list and then also grab their value at the same time. For CBB, we don’t necessarily care about it’s values until we know that all of CBA has been ticked, so we don’t bother with the extra lines. That for my template generates this:

var cbaList = [];
var cbaValues = [];
var cbbList = [];
cbaList.push('fld-955441d1635b4ce399a4d6008c7ee37d');
cbaValues.push(record.getFieldValue('fld-955441d1635b4ce399a4d6008c7ee37d'));
cbaList.push('fld-b22653c0a9904dcd976c31e8ba0388fe');
cbaValues.push(record.getFieldValue('fld-b22653c0a9904dcd976c31e8ba0388fe'));
cbaList.push('fld-49d779446f6b42a897a11d137e1c2817');
cbaValues.push(record.getFieldValue('fld-49d779446f6b42a897a11d137e1c2817'));
cbaList.push('fld-308e12249c64487fae2237f325fbc21d');
cbaValues.push(record.getFieldValue('fld-308e12249c64487fae2237f325fbc21d'));
cbaList.push('fld-99ade950b34c4d53bd98c218dce8d8ef');
cbaValues.push(record.getFieldValue('fld-99ade950b34c4d53bd98c218dce8d8ef'));
cbaList.push('fld-617fcf4b482e44cf92eac93d4719b2c9');
cbaValues.push(record.getFieldValue('fld-617fcf4b482e44cf92eac93d4719b2c9'));
cbaList.push('fld-3c97916b19f049bbb7edf6a2c68d0e3a');
cbaValues.push(record.getFieldValue('fld-3c97916b19f049bbb7edf6a2c68d0e3a'));
cbaList.push('fld-fc1d9f241ac745119901b4e1cabaab7b');
cbaValues.push(record.getFieldValue('fld-fc1d9f241ac745119901b4e1cabaab7b'));
cbaList.push('fld-2beae294572d40178c5f31b39d9d2f3e');
cbaValues.push(record.getFieldValue('fld-2beae294572d40178c5f31b39d9d2f3e'));
cbaList.push('fld-53b3172d013343eaa510169e71cc1a15');
cbaValues.push(record.getFieldValue('fld-53b3172d013343eaa510169e71cc1a15'));
cbaList.push('fld-880186ebe46e49cea5e2fa487e0112dc');
cbaValues.push(record.getFieldValue('fld-880186ebe46e49cea5e2fa487e0112dc'));
cbaList.push('fld-3c644b46b5b64f5e80575c601ef86938');
cbaValues.push(record.getFieldValue('fld-3c644b46b5b64f5e80575c601ef86938'));
cbaList.push('fld-1c85ce9ada1643ac89eb3304fffdb730');
cbaValues.push(record.getFieldValue('fld-1c85ce9ada1643ac89eb3304fffdb730'));
cbaList.push('fld-614d0018122d4a8eab464f96a3a4a623');
cbaValues.push(record.getFieldValue('fld-614d0018122d4a8eab464f96a3a4a623'));
cbaList.push('fld-16d97ccc160b4d26b572e38c89633908');
cbaValues.push(record.getFieldValue('fld-16d97ccc160b4d26b572e38c89633908'));
cbbList.push('fld-2437b06a3d3c4646a11c093e260fe860');
cbbList.push('fld-b465ee9958c44acdab05ceb042bc582e');
cbbList.push('fld-5fa2c5b939354661b706ba35a55fabc8');
cbbList.push('fld-1748eee5b1eb42f19fab7e74431a2710');

The three lists (cbaList, cbaValues and cbbList) end up forming the basis of the next piece. I pasted that into a new field script replacing it’s contents (I called mine “Checkbox Watcher” but really you can name it what you want).

I then wrote some stuff! Let’s take it apart, piece by piece:

var setFlag = 0;
var result = 1;

Setting up our variables: setFlag is used to know if I set a field and result is used to see if all of the checkboxes have been checked.

for (var cba = 0; cba < cbaValues.length; cba++)
{
	result = result & cbaValues[cba];
}

This is a simple loop over all of the CBA field values and it does a logical AND operation on each of them against result we created before. If any of them are zero/false, then result will be false and zero out for the rest of the runs. If they’re all set to one, then they’ll all come together. This means that the script will work on an arbitrary number of checkboxes without having to know precisely how many checkboxes there are.

if (result)
{
	for (var cbb = 0; cbb < cbbList.length; cbb++)
	{
		console.log(`${cbbList[cbb]}: ${record.getFieldValue(cbbList[cbb])}`);
		if (!record.getFieldValue(cbbList[cbb]))
		{
			setFlag = 1;
			record.setFieldValue(cbbList[cbb], 1);
			document.saveAllChanges();
			break;
		}
	}
}

First bit of fun, if we have all of the checkboxes checked, look for a checkbox from CBB that hasn’t been checked and check it. When it’s checked, setFlag is toggled for the next chunk. document.saveAllChanges() is sprinkled in to make sure to tell TapForms to persist our changes.

if (setFlag)
{
	for (var cba = 0; cba < cbaList.length; cba++)
	{
		record.setFieldValue(cbaList[cba], 0, false);
	}
	document.saveAllChanges();
}

If setFlag was set, then this loops through all of the CBA checkboxes and sets them to zero. There’s a third flag to setFieldValue here which is set to false. This is a special flag that tells TapForms to *not* trigger script changes which would call this script again and cause it to loop. More saving of changes too!

document.saveAllChanges();

console.log(new Date());

console.log(`All checked? ${result}`);

console.log(`Did we set overflow? ${setFlag}`);

`${result}/${setFlag} @ ${new Date()}`;

For good measure I have a final saveAllChanges that really is there from when I first started the script. I log out some debugging messages starting with a date, if all of the checkboxes were checked, if this invocation of the script set the overflow and then it sets the script field value to a slightly formatted form for easy reviewing.

Gotchas

I didn’t test this on iOS but it should work fine there as well.

When you import the template, open up the “field script” and save it. This should force Tap Forms to set up the watching behaviour properly. For me when I did a quick test import, that didn’t work properly however editing the field and saving it worked properly.

The last gotcha I found with this was that on the Mac, the UI didn’t seem to update properly after the last checkbox was checked. Since I’m uploading this template, hopefully the keymaster can have a look and see what’s up there. If I navigate away from the record to another one and then return, the checkbox state is correct. If I click on “recalculate formulas”, it refreshes the UI properly.

Why the form script and the field script?

A fine question is why I even write Javascript to write Javascript at all, couldn’t I just run the same Javascript directly? And the answer to that question is actually yes! I could have a field script that handled the same logic as the form script and it would mostly work. The only requirement would be to press the “recalculate formulas” to trigger the field script to run. For TapForms to trigger updates to a field script automatically, it needs to know which fields to ‘watch’. TapForms has some heuristics it runs to figure that out but the simplest is looking for getFieldValue('fld-id'). The point of the form script is to write the Javascript we need to get TapForms to watch the fields (in this case the 15 checkboxes) we care about. It’s also another reason why we don’t get the values of the CBB checkboxes that way: we don’t want to get updates for these fields, so we avoid triggering that behaviour.

This particular behaviour is on the edge of magic for me. I’ve made my peace with it because it mostly works and it is easy enough to work with or around once you understand it.

Attachments:

You must be logged in to view attached files.

[Bert Rietveld]

Thanks, Brendan. Waiting then (impatiently) for the next update ;)
I’ll continue my workaround for now: Copy the URL to the clipboard and running a fastscript or using keyboard maestro.

[Sam Moffatt]

A straight forward implementation would likely be if/else but I’ve been thinking about the checkbox use case with some sort of array to do a for loop. I think it might be achievable with some introspection but it hasn’t quite come to me yet.

Everything will work on iOS except for the custom layouts. Running the scripts on iOS is a few more taps.

[Sam Moffatt]

I don’t think this is a scripting limitation, this is a MacOS App Store sandbox limitation. App Store apps can only access files in its sandbox or files that you have used the Apple file dialog to select.

Are you using the App Store version? I thought at one point there was a stand-alone version that might not have the same limitation (perhaps try the trial version?).

[Bert Rietveld]

Javascript support is a great addition to Tap Forms, but has some limitations (for good safety reasons): It cannot open local files. Unless I’m missing something, it cannot trigger an AppleScript (which could open local files). Putting a local file URL in a website field results in “Tap Forms Mac 5” does not have permission to open…”. Dropbox file URLs work but I cannot move everything over to Dropbox (>2TB). Some mechanism to script a button to get to local files would be very good. Does anybody know of a way how to do this?

[Karl M. Rowe]

Hi, Sam!

Thanks for working up and posting this script for me. I especially liked what you did here:

“The ‘Customers’ form has a bunch of stuff in it. I added a photo and title field for fun then we get into the more interesting business.”

Having a photo field would be great!

“Downside of this is that it only works on the Mac.“

So it’s possible that I may encounter one or more issues since I using the Tap Forms app on the iPad, but there is much here in the code you posted to study. Thanks for attaching the link to a zip file. As long as the files don’t require a Mac, I’ll probably be able to make use them.

I would really be interested in seeing some code that deals with checkboxes. Here’s that example I had in mind again:

Let’s say in a form you had the Checkboxes A!..A3 snd Checkboxes B1..B3, and when CBB1 and/or CBB2 and/or CBB3 is/are set to “1” (checked), then the CBA1, CBA2 and CBA3 checkboxes would be reset to “0” (unchecked), and only if CBB1 was set to “1” would the corresponding CBA1 would to set to “1” and CBB1 would be set to “0”; only if CBB2 was set to “1” would the corresponding CBA2 would to set to “1” and CBB2 would be set to “0”; and only if CBB3 was set to “1” would the corresponding CBA3 would to set to “1” and CBB3 would be set to “0.”

What would such code look like? Would you use a “IF/ELSE” or a “FOR” loop to do this or something else altogether?

Thanks again, Sam.

Peace

[Karl M. Rowe]

Hi, Brenden!

“Did you get any syntax errors when running your script in the Script Editor?

“Make sure you don’t use curly quotes or curly apostrophes. That can cause things to fail.”

Ok. Thanks; I will be careful to use straight quotes and check that within that which I may paste into one of my test scripts do not contain curly quotes.

Peace

[D J Leason]

@ Sam Moffatt
Ok so when I first started building the forms, I just did it in the sample form document so I could see the examples. Then I copied my stuff to a separate document. It looks like some of the forms are duplicates, that’s why. Some of that stuff in there like My Movie collection either came in the original TF template download or other templates I got off of the forum. You should be able to tell which forms have to do with herbs. This is not one of my forms:– First Name (fld-9d1bca52fb894f75a01b29fbd789d198)
– Last Name (fld-051eefffbb93476e9e9d65d149641169)
‘Contact’ contact (fld-62e52ae50ee5413abb2f5016d7227183)
‘Website’ web_site (fld-0ca041e8f0974c7ba736d0823010978f)
‘First Name’ text (fld-9d1bca52fb894f75a01b29fbd789d198)
‘Last Name’ text (fld-051eefffbb93476e9e9d65d149641169)
‘Phone Number’ phone (fld-c84e74d1fac64a57b0bdce5b79cc8e3d)
‘Email Address’ email (fld-c05386d884b941808a6822584ca1b642)
‘Street Address’ text (fld-3bbf50e5c9164a2986876229374c8b88)
‘City’ text (fld-fac7bf008a954d5e8bc5354fba68de5d)
‘Province’ text (fld-96389320949f4925a201e85a3452fe79)
‘Postal Code’ text (fld-b97c9408b6d34214bc3778f00c29e59f)
‘Country’ text (fld-5e691c9792bb488594b336ba1ae52c29)
‘Client Documents’ file (fld-3d142c97df914bbeb5671d7e0e1110cb)
‘Client Call Log’ form (fld-01144d1c706e4007a7ad1a7c98fe9147) toMany ‘Client Call Log’ (frm-581dd7a1772345f2af2724c80fa1155b)

This is not my form:Daily Journal: (frm-494dc8cef1934c0393dc932d13ccd94a)
‘Date’ date (fld-bf50f76f8fbe417faf8ae9e627972546)
‘Action’ text (fld-c0cae13ad58546b0a5023cd9d9984815)
‘Journal Entry’ note (fld-3849af82aa3e4304b3fb42441841b3ec)

This is not mine:=== ‘Movie Details’ section (fld-a0d18fb6afa040b59e01bc4ed8bbc811) ===
‘Genre’ text (fld-2a0d16d2aece4562b6f44170cf1736a6)
‘Summary’ note (fld-28cc8f7f082c43818f1169c96c96e5a9)
‘Rating’ rating (fld-3baff54c8e164de9b9ad3f0fbb040bc6)
‘Year Released’ text (fld-3a365169f48a4b69ad37e86e171f0e00)
‘I Watched This’ check_mark (fld-5fda15d66484465da69196949f1b9353)
‘Actor/Actress 2’ text (fld-4cacb0cf58364eb091437ac1834a4862)
‘Actor/Actress 3’ text (fld-2cdb0cf1ef1743b68fa5bda36f694a08)
‘Directed By’ text (fld-522a5de85bcc44e087e473bb2567a471)
‘IMDB Website’ web_site (fld-9bc90613e8db45fea77579f35eb53b9d)

Home Inventory: (frm-5de3dd00a2b44d4b802166979c21f91b)
‘Picture’ photo (fld-294fa505e27c4aa99438339d59c1b40d)
‘Purchased From’ text (fld-2d3154a342914146a6d7cbb8659527fa)
‘Insured Value’ number (fld-3e3c56a2b59d401fba379b508a54e3f2)
‘Number of Items’ number (fld-49afd76a3770426db95569493d17ff87)
‘Received as Gift’ check_mark (fld-57d6f4e4d3cf4e57a9b6f56b9f3bfd51)
‘Serial Number’ text (fld-58095db96d1d4f1c9ca0b1ede05e2802)
‘Purchase Date’ date (fld-5c45c558205e4989836e218b7e2863de)
‘Original Cost’ number (fld-6dbd8f48549a44529d58d9167d2ae142)
‘Location’ text (fld-880ae556bea942e1891b21ca46c582da)
‘Notes’ note (fld-92fa01ec5f5b4204b15695fb00df89c3)
‘Category’ text (fld-9ee801f49a884f9484235d3d4181694d)
‘Purchased Warranty’ check_mark (fld-a5061f32941641e2a89ca68ce172daf1)
‘Condition’ text (fld-b2dc1cf3e0554c1790a80fb1f3b16bce)
‘Item’ text (fld-bffefe6a2a6e4167a680479de15d62a3)
‘Description’ note (fld-da04516482fc48138a2b509394e08962)
‘Current Value’ number (fld-ef1ecf1eaff44d3bbbd0246fdbf8653f)

Or this:
Expenses: (frm-8bff4863a7594cbb8938e0b433ef5efb)
‘Description’ note (fld-e90e747b90dc49c1be7d2c02f07af3bc)
‘Expense Type’ text (fld-5a7a671218d84096847d1732cd214d88)
‘Amount’ number (fld-3da10ad6c3d7445a817fc132162f5937)
‘Date’ date (fld-edb6e5c684c74325a33892af25f42d8c)
‘Have Receipt’ check_mark (fld-b2f71831e8bb4c72913571a762d3baa2)
‘Reimbursed’ check_mark (fld-2310439013c74c598d0711d44ee8efab)
‘Person to Reimburse’ text (fld-de1917d9ba0a4a0d8366815534693890)
‘Paid By’ text (fld-759bcedc78564c649c2f3af957a7750c)
‘Project’ text (fld-c6b48015180948bf9c0e41a58ef1d162)
‘Receipt Photo’ photo (fld-f11218ec5d774ce48d6a293e8b3917e4)
Clients: (frm-0ad8c86d89d04d91873f8a31f4dae2d7)
‘Company’ text (fld-1dd431ab21cb43d28967d1ebb36c23fa)
‘Full Name’ calc (fld-f86ccf72fcf848669d17db555ca697f3)

Or this:
Referenced Fields:
– First Name (fld-9d1bca52fb894f75a01b29fbd789d198)
– Last Name (fld-051eefffbb93476e9e9d65d149641169)
‘Contact’ contact (fld-62e52ae50ee5413abb2f5016d7227183)
‘Website’ web_site (fld-0ca041e8f0974c7ba736d0823010978f)
‘First Name’ text (fld-9d1bca52fb894f75a01b29fbd789d198)
‘Last Name’ text (fld-051eefffbb93476e9e9d65d149641169)
‘Phone Number’ phone (fld-c84e74d1fac64a57b0bdce5b79cc8e3d)
‘Email Address’ email (fld-c05386d884b941808a6822584ca1b642)
‘Street Address’ text (fld-3bbf50e5c9164a2986876229374c8b88)
‘City’ text (fld-fac7bf008a954d5e8bc5354fba68de5d)
‘Province’ text (fld-96389320949f4925a201e85a3452fe79)
‘Postal Code’ text (fld-b97c9408b6d34214bc3778f00c29e59f)
‘Country’ text (fld-5e691c9792bb488594b336ba1ae52c29)
‘Client Documents’ file (fld-3d142c97df914bbeb5671d7e0e1110cb)
‘Client Call Log’ form (fld-01144d1c706e4007a7ad1a7c98fe9147) toMany ‘Client Call Log’ (frm-581dd7a1772345f2af2724c80fa1155b)

[D J Leason]

@Sam MoffattAcquire it: (frm-74f4e0d6356947c490f896281d556587)
‘Herbs’ from_form (fld-21c3aa9d48e6477689ab4466b3c2a364) toOne ‘Herbs’ (frm-a732173d17814494941539b0749bf652)
‘Grow it’ form (fld-03c726089ffb4e27af266ad0e17f338f) toMany ‘Grow it’ (frm-2124581c9aa6486a87f49b58040f34fd)
‘Acquired What?’ text (fld-4e44896b0d414045b4d61b0d978028a6)
‘Choose a type’ text (fld-4d55ae3e92b74869af7c8c90f6753320)

=== ‘If Herbs is chosen then:’ section (fld-79345b6bb9e04cea8071750aa4bed5f4) ===
‘Where’d You Get It?’ text (fld-1568a59cf3d7432780eafba8c32a2ccc)

=== ‘If Harvest, THEN:’ section (fld-0006f142ec25416894c725792b40f933) ===
‘Herb Part Harvested’ text (fld-f4d0fb45a49144fdb7306b441d6ede10)
‘In Herb List?’ check_mark (fld-b43f94c17ab943f595370374d3235b85)
‘How Many?’ number (fld-b43586f25e434bae88c07ac359ab7fbd)
‘Fresh Weight in oz’ number (fld-8c9bc38fe4aa4a9e90fdf7a71fe1401c)
‘Harvest Date’ date_time (fld-63c3c676f11c441781b927c479ab13eb)
‘Harvest Status’ text (fld-d8208602bb324cbdb29e69a6af86c4fd)
‘Harvest Pourpose? ‘ text (fld-26c4f72c511045c6b25e63f31ba2364b)
‘Harvest Action ?’ text (fld-7ab7a0a9e76f4fb0b185dec840eaf933)
‘Note. IF choice:’ note (fld-a26681afaa1b44a18361894065326f9b)

=== ‘If Trade or Gift, THEN:’ section (fld-4809863ec0a449729b43558b5616eeca) ===
‘Acquired Pourpose? ‘ text (fld-44530f3ee1ca48fc8d90b64a61a6ea50)
‘New Herb?’ check_mark (fld-156ab50c1ca04ae59b7d74df24e74882)
‘Date Acquired’ date (fld-e5ae25b9aac249a5ac6d4cbb27fa0b11)
‘Gifted From Who?’ text (fld-531a7086e497455d8617a6bc8917bca0)
‘Traded with Who’ text (fld-c9a8017cba604c84ac0894b272dfe942)
‘Traded for What?’ text (fld-0e04fb7c457a46dda238524386d4eed9)

=== ‘If Herb Purchase, THEN’ section (fld-7ad936be960f41168cdfbfc7c721e547) ===
‘Herb Type’ text (fld-8d0f3b75093643669604bfa5fc3dd245)
‘Purchase Pourpose?’ text (fld-f822dcbad7ce490ca10f3bcf77d9e392)
‘New Herb? 1’ check_mark (fld-e7dd4c4bf83049849a5d8dc03eacd9d8)
‘Plant Part’ text (fld-59120148982f44a299d47da97f40ca02)
‘Country of Origin’ text (fld-e97c186dc9a74ff48da166a5ed1f22de)

=== ‘Purchase Details for any Purchase’ section (fld-627b569bc43141d4815d2445ea4aa29d) ===
‘Item/s’ text (fld-cbb0db3cff7c4ab384873f45e637618c)
‘POS’ date (fld-1acacae813c84e22bf6e74d0a0307504)
‘Order Date’ date (fld-ff868a7f9e234ab98b62517615a38ee5)
‘Expected Delivery Date’ date (fld-3a86190217734411932b7734bc142dc6)
‘Actual Delivery Date’ date (fld-7022767b6de4444c83a03ce31cb8ff0f)
‘Merchant’ text (fld-5f8b78a384504f0e90be6201a1361870)
‘Invoice #’ text (fld-ec8d0e28897b43f687b69f0560623515)
‘Invoice Date’ date (fld-af757ad1d6b3412a9abc85f324266d50)
‘Lot #’ text (fld-2c51062fed814ba18d6358cb8cd71963)
‘Sold BY Unit’ text (fld-7961e767b93f421da64800efcf04e577)
‘# Units Bought’ number (fld-635258ad69f34ab691b779f4a0885021)
‘Price Per Unit’ number (fld-2e1f1423559446c785ca67dd913ff19a)
‘Sales Tax’ number (fld-b06c6ef737d641118c7d54286dfbebed)
‘Shipping Cost’ number (fld-877afc4987584702aaf4956b10977d4f)
‘Invoice Total’ calc (fld-4cb76fa914334e3488c08055bd327653)
Referenced Fields:
– # Units Bought (fld-635258ad69f34ab691b779f4a0885021)
– Price Per Unit (fld-2e1f1423559446c785ca67dd913ff19a)
– Sales Tax (fld-b06c6ef737d641118c7d54286dfbebed)
– Shipping Cost (fld-877afc4987584702aaf4956b10977d4f)
‘Shipping Method’ text (fld-82412dee0a134a509ba197ec0425a2fe)
‘Payment Method’ text (fld-3b002a22312149e0825591c2c51fc506)
‘Payment Date’ date (fld-cf4c746ad4c14d968d42eb1fdf371e88)

Grow it: (frm-2124581c9aa6486a87f49b58040f34fd)
‘Self-Propagting?’ from_form (fld-59fc2857379d434bb6b007741e84d568) toOne ‘Herbs’ (frm-a732173d17814494941539b0749bf652)
‘Acquire it’ from_form (fld-f97f87b172064071abc17a144dc2b938) toOne ‘Acquire it’ (frm-74f4e0d6356947c490f896281d556587)
‘Herb Garden Tips’ web_site (fld-13299b6f18f2416e8dfd0db7407fa5ab)
‘Rare Seeds’ web_site (fld-6e3b2186e4e24ffca042f6dfa999632c)
‘Heirloom Organics_Growing’ web_site (fld-335046c13e94431d998e84fd223ededa)
‘Grow Purpose’ text (fld-ebed041c44e84b5c9059c5aba274b1f0)
‘Growth Habit’ text (fld-ecde08c779434176a84f4ad83e68d5eb)
‘Hardiness Zone’ text (fld-8235fad8b2c443a78782858e76605a94)
‘Herb Type’ text (fld-877285aaf9a4441ba85cb5ee3c08cf81)
‘Flowering_Months’ text (fld-e516265621154b12a10d2b725e8bc344)
‘Seeeds Ripen_months’ text (fld-85e4da2d80a94cd1b89a7b97643b3d48)
‘Self-Propagating?’ text (fld-f77767bc3b864123be2c1703e1530e8a)
‘Germination Needs’ text (fld-31316315e223422a9709c3588d6fbf8d)
‘Stratify length ‘ text (fld-78f2196b418d4d4090be16ee6452ff98)
‘Germination Length_Days’ text (fld-95fa1ebf0a2047f0930b204ce95cacde)
‘Spacing Betweeen Plants’ text (fld-b939da3c5d9044299c1054feab38ea6e)
‘Height’ text (fld-90875e2623ef4c00a4bd1858ebf1b801)
‘Direct Seed?’ text (fld-6ebd797b300c4037a02777fbf4af9361)
‘Frost Tender?’ text (fld-de42c468725a4bccbd96fa3d273c03cd)
‘Growth Rate’ text (fld-1342d8214b3e4b88933bc4fb632590dc)
‘Planting Season’ text (fld-c012d553317443119eacb69650d518d5)
‘Moisture Requirements’ text (fld-ecb61afa77754d379cf03f9d41e172db)
‘Soil Type’ text (fld-e3dd78bb8e8c4f6aa3d915de0eef92f5)
‘Soil PH’ text (fld-704801d77bec45ebb314a6e06bb87962)
‘Shade?’ text (fld-7384758b8f9c449e94d7d5793430abe2)
‘Time Until Harvest ‘ text (fld-cacd1e5741534faa96f875dbcc317908)
‘Harvest – How Many?’ text (fld-2ce2a9ab1cb34a05b38f554c9cec360e)
‘Growing Months’ text (fld-ae28e544b88f46ce94b43d778d83c070)

=== ‘Get Specific about Seeds’ section (fld-f961b7f274184f9cb39ff79bfee8ceb8) ===
‘Date Started’ date (fld-419646ea04874808b18459325eaef491)
‘Date Germinated’ date (fld-e9099285c4a34b87896e872124d3b9d0)
‘% Germinated’ number (fld-157e9011115141c48a9d9e4cfb83a282)
‘Date of First True Leaves’ date (fld-009f42bafd84452ab828475347301c3d)
‘Date Transplnted Outside’ date (fld-760542d650a949a8b0d2d2685e16cd8f)
‘Bed Location’ note (fld-dfdbdabaf5b84dc193cee4f5db8dac63)
‘Expected Harvest Date’ date (fld-c5699d03cc9645cc937e9fb19a3d7703)
‘% Survival’ number (fld-5d640491184049f28ac2acee79d27086)

=== ‘Get Specific about Roots’ section (fld-cf317109c12440818e6db748e27272fe) ===
‘Date Planted’ date (fld-9ed5ad73d2ce4be9b9167462bd0fab81)
‘Container Size’ text (fld-a5aeffb9e30a4f8593a8384adbae7dc5)
‘Container Type’ text (fld-93bbe04c54a54e00a29158bc1a39b8d3)
‘Date Sprouted’ date (fld-11bc4ab0b42d4a1e9c5e6fcba24fa477)
‘Date First Leaves’ date (fld-a891ffd8f40845f2a94867c248b85599)
‘Date Transplanted’ date (fld-a65351b2123f4316b507ce6d203db328)
‘Bed Location’ note (fld-b0c7f98bf6d541bf953535e5e4d860a6)
‘Expected Harvest Date’ date (fld-5c0299ffcd21444d9a9eb6b2ffe111c8)
‘% Survival’ number (fld-13410b660bd4407ab3c387c83c258914)

=== ‘Get Specific about Cuttings’ section (fld-efdc510f3caf47e2b7c3a069cf9127dc) ===
‘Date Cutting Taken’ date (fld-651e5aefe0ff47deb6c50b606938c778)
‘Rooting Method’ text (fld-d3897ff18c094be6836a7f2deee3d7ea)
‘Dates Roots Appeared’ date (fld-d639f3a598314bfd8e023876a5f69fe3)
‘Date Transplanted’ date (fld-b8654bba9a594febbd67d4cf5274f5c6)
‘Bed Location’ note (fld-e7fac249c47a429aa07e612baac3e64c)
‘Expected Harvest Date ‘ date (fld-7afa385d60a8498899d30e971bfa5893)
‘Expected Harvest Date 1’ date (fld-40536b57dd7f414d8eb752f5e12c400d)
‘% Survival’ number (fld-d262894a8abe45f583f322706f9b7513)

=== ‘Get Specific about Live Plants’ section (fld-bc081a1b6db4482fa22320dfe180f43f) ===

Clients: (frm-0ad8c86d89d04d91873f8a31f4dae2d7)
‘Company’ text (fld-1dd431ab21cb43d28967d1ebb36c23fa)
‘Full Name’ calc (fld-f86ccf72fcf848669d17db555ca697f3)
Referenced Fields:
– First Name (fld-9d1bca52fb894f75a01b29fbd789d198)
– Last Name (fld-051eefffbb93476e9e9d65d149641169)
‘Contact’ contact (fld-62e52ae50ee5413abb2f5016d7227183)
‘Website’ web_site (fld-0ca041e8f0974c7ba736d0823010978f)
‘First Name’ text (fld-9d1bca52fb894f75a01b29fbd789d198)
‘Last Name’ text (fld-051eefffbb93476e9e9d65d149641169)
‘Phone Number’ phone (fld-c84e74d1fac64a57b0bdce5b79cc8e3d)
‘Email Address’ email (fld-c05386d884b941808a6822584ca1b642)
‘Street Address’ text (fld-3bbf50e5c9164a2986876229374c8b88)
‘City’ text (fld-fac7bf008a954d5e8bc5354fba68de5d)
‘Province’ text (fld-96389320949f4925a201e85a3452fe79)
‘Postal Code’ text (fld-b97c9408b6d34214bc3778f00c29e59f)
‘Country’ text (fld-5e691c9792bb488594b336ba1ae52c29)
‘Client Documents’ file (fld-3d142c97df914bbeb5671d7e0e1110cb)
‘Client Call Log’ form (fld-01144d1c706e4007a7ad1a7c98fe9147) toMany ‘Client Call Log’ (frm-581dd7a1772345f2af2724c80fa1155b)

Other Herbs : (frm-204eb6e7774c46f19f13f2d9c40bd6e3)
‘Common’ text (fld-0197693a413541988c89d8e988a23909)
‘Latin’ text (fld-145bd1991baf4dada3a28d77168a088c)
‘Uses’ text (fld-2b8a6aa735434ee78cd658e15dcc7232)
‘Action’ text (fld-d93c7345e240492c95ad9d53e789d914)
‘Edibility Rating’ rating (fld-aaf7cf203e45460f9bd4235477ea0e85)
‘Medicinal Rating’ rating (fld-2315b089a09647bcaaabf326422325c4)
‘wild here’ check_mark (fld-9288e346366b4176a4d444d5b2ec0573)
‘will grow’ check_mark (fld-02d35c19770145678ff02fc8e79c087f)
‘cultivated’ check_mark (fld-bffa287a52d84100ade1b6f56c5e6ac5)
‘have seeds’ check_mark (fld-283f009909ed4ca9bcc3b87685856fc6)
‘I buy’ check_mark (fld-f65d72fbbf5c4350a7398896d6b11938)

Tincture Inventory: (frm-b10c959a72384709a862db66783e93b9)
‘Herb’ text (fld-c0b9c321d5da4ca6a1d92f31b91dbe04)
‘Batch’ text (fld-25cfe883f65e4694a4100a6e7292c9bf)
‘Untitled 1’ text (fld-558dc6187b7445e7a3170dfe3e060517)
‘Special’ text (fld-197d61f326d9476cbfa6bf3474e630b2)
‘Date’ date (fld-bb62e2fbbc6c47f59fc767a102eb3b2c)
‘Action’ text (fld-ef78f5b36c9344dca3d60c73f8f54ff8)
‘OZ R & D’ number (fld-98bfe8b85eed4367809260134bdef194)
‘per use’ number (fld-a8e58f5001d24698af33088bc548c0f1)
‘samples’ number (fld-d35297627ad84690a47bbf8543200153)
‘spilled’ number (fld-cd66d9c5c13b4281b2793fee9db2af35)
‘Spoiled’ number (fld-d4a256fc5c304fe79fdce782634ee15e)
‘oz Pantry Btm shlf’ number (fld-5f435fcf37ca482f9bf707c40e77e96d)
‘Pantry BTM shlf date’ text (fld-27285e0ce8ec43508db2e0d273134316)
‘Pantry Btm shlf Bottle size’ text (fld-0820a286a6e0457593b249cd65744b91)
‘Pantry mid-shlf Bottle Date’ text (fld-660b476a9a65479996ecc982693c19ac)
‘Pantry oz mid-shelf’ number (fld-1b2bd2f6425244089c55460bb3b1ff92)
‘Pantry mid shlf Bottle size’ text (fld-1e025eec767c451095962ac4e5c981c0)
‘Pantry MT bottle size’ text (fld-7e82f6314b76473ba3969f4238b57bac)
‘Pantry oz in BB’ number (fld-de386a5795614dd29d9d2b868f8510b7)
‘Pantry Date of BB’ text (fld-30b21fb0915b4ebaa244a8cba631b71a)
‘Cave Box #’ text (fld-75632d4714a9458dbfa7a48f021fd734)
‘Cave bottle date’ text (fld-72a8fb11c6d64762af84c17e05a094ea)
‘oz in Cave’ number (fld-6a6d440c5a5941778bbfbbc571d266b1)
‘Cave Bottle size’ text (fld-d382cdbdbf4c4269b10f36d5e75061ef)
‘Cellar Section’ number (fld-a945355dd3434ca68d7c316ed59816df)
‘Untitled 2’ text (fld-02512eddd1c54dcea35f658a1e6d92f4)
‘Cellar Row’ text (fld-9fa3db38b6994bd1aa71159156103bc8)
‘Cellar bottle date’ text (fld-b8cfe79333474ad89595b3b1d9ee84f2)
‘oz in Cellar’ number (fld-5d4ba2d214a945eb961c96cb776271d5)
‘Cellar bottle size’ text (fld-ad890ebbe6d345169e5a024972727a07)
‘probable ounces Macerating’ number (fld-23fe60d6d7e748c3970a70aee3fb6c94)
‘Mac. end Date’ text (fld-3428161186164226a40abcf3c0a6b9e1)
‘Mac jar size’ text (fld-4098d46c3d2646a38383fcee4e76a8ae)
‘Yield in oz’ number (fld-c699d1c12cab4bfeac21c4b2e48f8727)
‘TTL oz on hand’ number (fld-4dc34eaa13964f21a243c1330a81019f)
‘Used’ number (fld-9e64e35cad20437a8236c38e143e6d35)
‘Notes’ text (fld-05058ab63b2b430091bade2f66196bdc)

Alerts: (frm-5b3c76e1e2d74bc193a918f42fc38271)
‘New Field’ text (fld-0360c28e51fd451fadadb9fb5eff47a7)

Herbs: (frm-a732173d17814494941539b0749bf652)
‘Common Name’ text (fld-53033594246f46e79a979e4f1efc4ea3)
‘Latin Name’ text (fld-805634cd53944bb3926a88ec4e710e55)
‘Other Names’ text (fld-fa598b8b78614af09c4f885066d35d2a)
‘Materia Medica’ text (fld-0dbd80b770264ef586dd41be4ba2feb7)
‘Plant Family’ text (fld-dafddd4d49b14d888caf2bd5b2fecfaf)
‘Part Used’ text (fld-6433904c764c4e5a85a425defd66de41)
‘Habitat’ text (fld-67b4db01bc1d47e0991caacee10b18ac)
‘Photo’ photo (fld-8c88231c0f09414aa13c3c73d9d72c53)
‘Edible’ check_mark (fld-5fd4b7d226134c8698fd1fa17016dcd7)
‘Edible Rating’ rating (fld-f3cb5066047e461bb64fbb4bff4aae42)

=== ‘Medicinal Attributes’ section (fld-cc21c093ac9a427b92660d6dae843d20) ===
‘ Safety Rating’ rating (fld-b40bbdcf4e95419192ee95e2882a8061)
‘Medicinal’ check_mark (fld-466e9b2edf654cc39a3d280640786548)
‘Medicinal Rating’ rating (fld-260a5fd2885b4cfdb6e18778c24b7964)
‘Taste’ text (fld-fdb6a611ecf3485d8402e307186bcb53)
‘Energeticcs’ text (fld-d50f5f57b3f94a92b8122a17d02816c4)
‘Herb Actions’ text (fld-bdd995c6157b42b1bde62c07e8bb49d4)
‘Conditions’ text (fld-9806e2c467244f12a8fc41e38e9d0d36)
‘System’ text (fld-328f130f4cc442e790540b9e09a90a8f)
‘Body Parts’ text (fld-e4f85e78fd72489e868c23dd0e40246c)
‘Main Constituents’ text (fld-49f43952a40b47be82d7b23ab5b2f644)
‘Warnings’ text (fld-467b9bac8b2044a4bce1c7c109c9a911)
‘Monograph’ web_site (fld-642bf84f91014e929b755410d79b2a1a)
‘PFAF’ web_site (fld-03b42c19e7a045d88bce4c5236b956ad)
‘European Union Monograph’ web_site (fld-3db75b9bce5d43b7a69ea5b1886f7563)
‘Good Info Website’ web_site (fld-3993082f85c544fca3e9b04d5759ef4a)
‘Matthew Wood’ web_site (fld-3ff110cc01724f98a4162040c900ad99)

=== ‘Plant Characteristics’ section (fld-ef2fc1fe10a343ef8c22e3545bcd5a8d) ===
‘Description’ note (fld-d5fdd0c220da4fcfae94b01ef4803496)

=== ‘OK, So…’ section (fld-35cd3a8d220345dca563d286f049c3ab) ===
‘Do What ?’ text (fld-ff89d9be36aa4d7fa295dd3dd9ecba51)

=== ‘Linked Forms’ section (fld-9f82b5512358444c8867145f00c68775) ===
‘Work In Progress’ form (fld-82e3a915254749d9b42f0d9de43abb9b) toMany ‘Work In Progress’ (frm-5a9d3b56f074403f886a27910f146493)
‘WIP_Weight To Volume Calculator’ form (fld-9e3a4c8a824844f19283b5fff7dff77e) toMany ‘WIP_Weight To Volume Calculator’ (frm-84324ea377e54fec97bbd8d89835113d)
‘Acquire it’ form (fld-de91a0cc3851495180b36a2de6974fd5) toMany ‘Acquire it’ (frm-74f4e0d6356947c490f896281d556587)
‘Grow it’ form (fld-9bc16bb74942483faa779eddbe84e6f3) toMany ‘Grow it’ (frm-2124581c9aa6486a87f49b58040f34fd)
‘Consume it’ form (fld-30f5c6a99e1b40a9a64df0986d7f8c46) toMany ‘Consume it’ (frm-c427d441f64543a6940c1beb72d9995f)

=== ‘Wish Granted! Carry on Grasshopper.’ section (fld-816271282b1143fc8e0c2cca222fd081) ===

WIP_Weight To Volume Calculator: (frm-84324ea377e54fec97bbd8d89835113d)
‘Herbs’ from_form (fld-30a462ca83394202bc09fe54ac2a01b6) toOne ‘Herbs’ (frm-a732173d17814494941539b0749bf652)
‘Work In Progress’ from_form (fld-92a2891f30d8478ebf33dc55956192f8) toOne ‘Work In Progress’ (frm-5a9d3b56f074403f886a27910f146493)
‘Daily Herb Log’ form (fld-8bca54a06eb94d529c470ead2d49bfe6) join ‘Daily Herb Log’ (frm-d8963fdc083a44b99e9813294cd14dfd)
ON WIP_Weight To Volume Calculator.Herb Log Entry == Daily Herb Log.Log Entry
‘Input oz of Marc’ number (fld-4509fc9cff754ce2b93cdedd1183e577)
‘Input Materia Medica Ratio A’ number (fld-a8b446e68801418096c95fc200f212c4)
‘Input Materia Medica Ratio B’ number (fld-fbfe7004cde9425ca36c1726ca4fb70c)
‘Input Materia Medica %A’ number (fld-f2dbb3a6833d4f33a2a8aac84750601f)

=== ‘RESULTS_BEST CHOICE’ section (fld-92950bd22d984065bffc70d26f865091) ===
‘Menstruum Volume’ calc (fld-4f06f3f545ae47e888fe763f8dc931c7)
Referenced Fields:
– Input oz of Marc (fld-4509fc9cff754ce2b93cdedd1183e577)
– Input Materia Medica Ratio B (fld-fbfe7004cde9425ca36c1726ca4fb70c)
‘oz of Alcohol’ calc (fld-81c4d5e65e31495288b6efefa3961829)
Referenced Fields:
– Menstruum Volume (fld-4f06f3f545ae47e888fe763f8dc931c7)
– Input Materia Medica %A (fld-f2dbb3a6833d4f33a2a8aac84750601f)
‘oz of Water’ calc (fld-4f37604c8a8e42799102b35e005e7ea5)
Referenced Fields:
– Menstruum Volume (fld-4f06f3f545ae47e888fe763f8dc931c7)
– oz of Alcohol (fld-81c4d5e65e31495288b6efefa3961829)
‘Combined Marc & Menstruum’ calc (fld-46c3b77fa67544028678aadd09a27a78)
Referenced Fields:
– Input oz of Marc (fld-4509fc9cff754ce2b93cdedd1183e577)
– Menstruum Volume (fld-4f06f3f545ae47e888fe763f8dc931c7)
‘Cups’ calc (fld-b5457cbb3ce0451cbb62694b5b0a4352)
Referenced Fields:
– Combined Marc & Menstruum (fld-46c3b77fa67544028678aadd09a27a78)
‘Jar Size Needed’ calc (fld-9436396b3e274e8f9770f7e635478340)
Referenced Fields:
– Cups (fld-b5457cbb3ce0451cbb62694b5b0a4352)

=== ‘HIGHER RATIO ONLY IF MARC NOT COVERED BY MENSTRUUM’ section (fld-dfb93cffebc3426e81bb1d09e47654c0) ===
‘MARC NOT COVERED?’ check_mark (fld-e63ddf151f9b42f2a045b046b8eefcc6)
‘Edited_ Input Materia Medica Ratio B ‘ calc (fld-7929ec5788ae4c8a864d543763592e2a)
Referenced Fields:
– Input Materia Medica Ratio B (fld-fbfe7004cde9425ca36c1726ca4fb70c)
‘Menstruum Volume_New value’ calc (fld-484e455473704c38b7dd0d4c47cf70f1)
Referenced Fields:
– Input oz of Marc (fld-4509fc9cff754ce2b93cdedd1183e577)
– Edited_ Input Materia Medica Ratio B (fld-7929ec5788ae4c8a864d543763592e2a)
‘oz of Alcohol _New Value’ calc (fld-ec7cb70685cd42948fe6cee017eacc16)
Referenced Fields:
– Menstruum Volume_New value (fld-484e455473704c38b7dd0d4c47cf70f1)
– Input Materia Medica %A (fld-f2dbb3a6833d4f33a2a8aac84750601f)
‘oz Water _New Value’ calc (fld-a8f5551569f2401391603607d4639aa3)
Referenced Fields:
– Menstruum Volume_New value (fld-484e455473704c38b7dd0d4c47cf70f1)
– oz of Alcohol _New Value (fld-ec7cb70685cd42948fe6cee017eacc16)
‘Combined Marc & Menstruum _New Value’ calc (fld-8c10941125a04b4fb05cd264c910b931)
Referenced Fields:
– Input oz of Marc (fld-4509fc9cff754ce2b93cdedd1183e577)
– Menstruum Volume_New value (fld-484e455473704c38b7dd0d4c47cf70f1)
‘Higher Ratio_oz Alcohol To Add’ calc (fld-f9dc5f3b14a64e55b53acb559651e43b)
Referenced Fields:
– MARC NOT COVERED? (fld-e63ddf151f9b42f2a045b046b8eefcc6)
– oz of Alcohol _New Value (fld-ec7cb70685cd42948fe6cee017eacc16)
– oz of Alcohol (fld-81c4d5e65e31495288b6efefa3961829)
‘Higher Ratio_oz Water To Add ‘ calc (fld-b56c00b9ef4342b6ae213b0f276fd2ed)
Referenced Fields:
– MARC NOT COVERED? (fld-e63ddf151f9b42f2a045b046b8eefcc6)
– oz Water _New Value (fld-a8f5551569f2401391603607d4639aa3)
– oz of Water (fld-4f37604c8a8e42799102b35e005e7ea5)
‘Cups _New Value’ calc (fld-fb0295bb887b4d1f8f5cb3956bfc187d)
Referenced Fields:
– Combined Marc & Menstruum _New Value (fld-8c10941125a04b4fb05cd264c910b931)
‘New Jar Size Needed ‘ calc (fld-7624875a59844ebaa9827877140a4678)
Referenced Fields:
– Cups _New Value (fld-fb0295bb887b4d1f8f5cb3956bfc187d)
‘Jar Check’ calc (fld-f86447954aa8415cb98666d1945ec083)
Referenced Fields:
– MARC NOT COVERED? (fld-e63ddf151f9b42f2a045b046b8eefcc6)
– Jar Size Needed (fld-9436396b3e274e8f9770f7e635478340)
– New Jar Size Needed (fld-7624875a59844ebaa9827877140a4678)

=== ‘WRAP IT UP’ section (fld-7236e1c9fb5e4ea49f019764080e55e1) ===
‘Mac Start Date’ date (fld-c5149916ab6746dc8476f4207f12b34e)
‘Mac End Date’ date (fld-054a9038b5804bafaf34baacf6d1074f)
‘Herb Log Entry’ calc (fld-20d3af56ce944530bccb0639b0a05424)
Referenced Fields:
– Mac Start Date (fld-c5149916ab6746dc8476f4207f12b34e)
– Work In Progress::WIP_Action (frm-5a9d3b56f074403f886a27910f146493::fld-aac2cbe4036844dabdfd11382d5cce26 via fld-92a2891f30d8478ebf33dc55956192f8)
– Jar Size Needed (fld-9436396b3e274e8f9770f7e635478340)
– Herbs::Common Name (frm-a732173d17814494941539b0749bf652::fld-53033594246f46e79a979e4f1efc4ea3 via fld-30a462ca83394202bc09fe54ac2a01b6)
– Work In Progress::WIP_Preparation (frm-5a9d3b56f074403f886a27910f146493::fld-4037302dfd544f538ebd9ae4a05ef72d via fld-92a2891f30d8478ebf33dc55956192f8)
– Work In Progress::Choose a stripe (frm-5a9d3b56f074403f886a27910f146493::fld-604c0e1eb74e4be481a4c79d201d2700 via fld-92a2891f30d8478ebf33dc55956192f8)
– Work In Progress::Choose a Status (frm-5a9d3b56f074403f886a27910f146493::fld-16627063a01a44b7a1502aed4cfc1736 via fld-92a2891f30d8478ebf33dc55956192f8)
– Work In Progress::Cauldron Contents (frm-5a9d3b56f074403f886a27910f146493::fld-c9cbf78998354713a5f3c1fa9b13f728 via fld-92a2891f30d8478ebf33dc55956192f8)
– Input oz of Marc (fld-4509fc9cff754ce2b93cdedd1183e577)
– Work In Progress::Choose A Method (frm-5a9d3b56f074403f886a27910f146493::fld-7a6a11b04dae48e0b8687c3798a828c7 via fld-92a2891f30d8478ebf33dc55956192f8)
– Work In Progress::Choose a Menstruum (frm-5a9d3b56f074403f886a27910f146493::fld-b0ea1804c0ee47d98212f7050d9ca9b7 via fld-92a2891f30d8478ebf33dc55956192f8)
– Input Materia Medica Ratio A (fld-a8b446e68801418096c95fc200f212c4)
– Input Materia Medica Ratio B (fld-fbfe7004cde9425ca36c1726ca4fb70c)
– Input Materia Medica %A (fld-f2dbb3a6833d4f33a2a8aac84750601f)
– oz of Alcohol (fld-81c4d5e65e31495288b6efefa3961829)
– oz of Water (fld-4f37604c8a8e42799102b35e005e7ea5)
– Mac End Date (fld-054a9038b5804bafaf34baacf6d1074f)
‘Script’ script (fld-663bc82b609142a381bb36923ed0ef7b)
‘Script’ script (fld-5eb6fd48e6f44b4286bf43bea2d8a0d6)

Research it: (frm-f5f73c5cef734d3ea46217d97461a3ea)
‘Kelly_Momographs’ web_site (fld-f01178eda4b74592964af97f78103271)
‘PFAF’ web_site (fld-84cccfa4408740f09013de939ca6372c)
‘Herbpathy’ web_site (fld-94f36f15f5204965809c0c35be24ab7d)
‘Rosalee’ web_site (fld-5c8fc469d0744bf2bfaac5bc0d4d70c0)
‘Jim Mcdonald’ web_site (fld-903b22cf4d744f56bc573ce39720fa35)
‘Matthew Wood’ web_site (fld-6003c3ad071d4ec5a9e4a8b854bad080)
‘Herb/Action’ web_site (fld-946cddd05abf4746b5e13544dee320ed)
‘Annie’s Remedy’ web_site (fld-07912019fb384521b844eda5ecc84dbb)

Client Call Log: (frm-581dd7a1772345f2af2724c80fa1155b)
‘Topic’ text (fld-e67b43da03a24c66a018ae657c9d6b1f)
‘Call Date & Time’ date_time (fld-cc5830eb7be2455e9ab79fde89d6df84)
‘Notes’ note (fld-0a123c2403c74438931765932524f2e7)
‘Clients’ from_form (fld-99caf798c8af40e189f71833a41943d4) toOne ‘Clients’ (frm-0ad8c86d89d04d91873f8a31f4dae2d7)

Work In Progress: (frm-5a9d3b56f074403f886a27910f146493)
‘Herbs’ from_form (fld-aef0c8324dcb488da427251577d2b717) toOne ‘Herbs’ (frm-a732173d17814494941539b0749bf652)
‘WIP_Weight To Volume Calculator’ form (fld-0b7244331649440bad48e7a79750d3d4) toMany ‘WIP_Weight To Volume Calculator’ (frm-84324ea377e54fec97bbd8d89835113d)
ON Work In Progress.Herb Log Entry == WIP_Weight To Volume Calculator.Herb Log Entry
‘Date ?’ date (fld-64e7d72953ed43f4ad4d8101b1cf9ca8)

=== ‘Preparation Stage’ section (fld-d19700c1da0f43008c7c4e4fa3a00b19) ===
‘WIP_Action’ text (fld-aac2cbe4036844dabdfd11382d5cce26)
‘WIP_Preparation’ text (fld-4037302dfd544f538ebd9ae4a05ef72d)
‘Choose a stripe’ text (fld-604c0e1eb74e4be481a4c79d201d2700)
‘Choose a Status’ text (fld-16627063a01a44b7a1502aed4cfc1736)
‘Cauldron Contents’ text (fld-c9cbf78998354713a5f3c1fa9b13f728)
‘Choose A Method’ text (fld-7a6a11b04dae48e0b8687c3798a828c7)
‘Choose a Menstruum’ text (fld-b0ea1804c0ee47d98212f7050d9ca9b7)
‘Choose a Jar Size’ text (fld-b18cc67d98db4ed8a52ab15ea97ffbfe)
‘Choose a Phase’ text (fld-4ccdbe9d0e13423a9f9e3b157f003380)
‘Choose a Mac Time’ text (fld-b4caab4504b64b7f944d1cb2c366c9bb)
‘Mac Start Date’ date (fld-ef219eac291c4195a0db8f3e9316bca6)
‘Mac End Date’ date (fld-12c78ef39b2e4004b8e19c301b2d0fb8)
‘Herb Log Entry’ calc (fld-33bbc3ec82e64d1aaa15541cca5da6b5)
‘Start Pic’ photo (fld-5c607dda5b57470bba69da969624ded9)
‘Strain Date’ date (fld-b68b6237676e498191b42a0023bd148f)
‘Batch #’ number (fld-8bd2403259d24bc1a3b420b711acd322)
‘Strain Pic’ photo (fld-16b830b450724eb1a04248447570789f)
‘Yield in oz’ number (fld-361296f7124e46038038c184aa2b71c4)
‘White Board’ photo (fld-6ab46c23ba7e43449617e9342d1d7d16)
‘Date Bottled’ date (fld-65df83e284cb44498807962900c9bd1d)
‘Bottle Size’ text (fld-e624bad905b44dce94027310b37b1425)
‘Calculation’ calc (fld-8b8888d83efe47b0ba7374a12fd31a53)
Referenced Fields:
– Choose A Method (fld-7a6a11b04dae48e0b8687c3798a828c7)
– Herb Log Entry (fld-33bbc3ec82e64d1aaa15541cca5da6b5)
– WIP_Weight To Volume Calculator::Herb Log Entry (frm-84324ea377e54fec97bbd8d89835113d::fld-20d3af56ce944530bccb0639b0a05424 via fld-0b7244331649440bad48e7a79750d3d4)
‘Bottle ID’ text (fld-a7c381d036bd48778cbd948771b8edd0)
‘bottled Pic’ photo (fld-2a52530c20a146b4b20a11c12c4a0831)

=== ‘Wrap It Up’ section (fld-fa211617c5174873a13d681d9360b1ac) ===

Log Book: (frm-0a04294de19d4c5caaa0f68d60926263)
‘Date of Activity’ date (fld-285f02cf6fdd4a399bcf775ca964fc02)
‘Herb’ text (fld-0ee388c052724add952ba2cfa0c6ebeb)
‘Activity Name’ text (fld-17afeb9904e94f348ba4e565a40e3330)
‘Notes’ note (fld-abf557592bcf4bda8f68a93fddb0bc52)

Consume it: (frm-c427d441f64543a6940c1beb72d9995f)
‘Herbs’ from_form (fld-770689fdf00541378d92c3fc240a4bc1) toOne ‘Herbs’ (frm-a732173d17814494941539b0749bf652)
‘Vitamins’ text (fld-49f2ded1026d46cda1f1789ee3d7f69a)
‘Drinkable Parts ‘ text (fld-8bd6866c87f1477a877e38883c57c331)
‘Drinkable Preparations’ text (fld-55bbcddbc70f49d48b2dab6e223fa040)
‘Edible Parts’ text (fld-ab0c6e8854ad4999b056681527b4de4a)
‘Edible Preparations’ note (fld-103596f6278949b984e17f711ee14f7d)
‘Recipe 1’ note (fld-1bfa1a0686944c92bcf74a0f7ef0b0a8)
‘Recipe 2’ note (fld-ea1982370ef449138b4dce233178958d)
‘Recipe 3’ note (fld-a1a16af2821145fabaf6b52411b0ae2a)
‘Recipe 4’ note (fld-f89cb2fbde9e48488560a58ba89e7e71)
‘Recipe 5’ note (fld-79da02e83aef446f8ce539a62e61a61b)
‘Infusion Recipe’ note (fld-2c750714e6cc4bc38a4894e6ffe3918a)

Important Dates: (frm-0c90999bee5043eaaa6e65009bb70596)
‘Event Name’ text (fld-d263980c4ef84dc5b46a8eaa4806bcda)
‘Date’ date (fld-48ba15e9f7b74dc6838eda5213454737)
‘Details’ note (fld-18c34691b0fb4738b3b68afd95f23463)
‘Photo’ photo (fld-5b336351e7184449a961de3e90b2c608)

Individual Herb Logs: (frm-7243b873a8384d81842704766448e43c)
‘New Field’ text (fld-2091a836a73c4f1194a99b840fec2fa1)

Herbal Actions Glossary: (frm-4fa0b95ad9624e9ea5826a8a6064d479)
‘Action’ text (fld-98e162b373cc40d5a5c847fd8b533bd6)
‘Herb Examples’ text (fld-584ba2a1c5c845ff8c20f4b7e8bd8ef8)
‘Works How’ text (fld-7aa6fa0392ff4816999253f450bde118)
‘Source’ text (fld-2165d5e70ab74e3faa1f87676e1db791)
‘Uses’ text (fld-85b8a13df3b246438933c7069b2ce381)

Expenses: (frm-8bff4863a7594cbb8938e0b433ef5efb)
‘Description’ note (fld-e90e747b90dc49c1be7d2c02f07af3bc)
‘Expense Type’ text (fld-5a7a671218d84096847d1732cd214d88)
‘Amount’ number (fld-3da10ad6c3d7445a817fc132162f5937)
‘Date’ date (fld-edb6e5c684c74325a33892af25f42d8c)
‘Have Receipt’ check_mark (fld-b2f71831e8bb4c72913571a762d3baa2)
‘Reimbursed’ check_mark (fld-2310439013c74c598d0711d44ee8efab)
‘Person to Reimburse’ text (fld-de1917d9ba0a4a0d8366815534693890)
‘Paid By’ text (fld-759bcedc78564c649c2f3af957a7750c)
‘Project’ text (fld-c6b48015180948bf9c0e41a58ef1d162)
‘Receipt Photo’ photo (fld-f11218ec5d774ce48d6a293e8b3917e4)

My Movie Library: (frm-f49181f7a0944a8f963d6e56ea9833e7)
‘Case Cover’ photo (fld-e2cf02f376864a7cb9f090e4a597f3e4)
‘Movie Title’ text (fld-987c9aac738a4f0fa1d18395902b3fb1)
‘Actor/Actress 1’ text (fld-c8ad6ad088bb4b57a09917de6793919b)

=== ‘Movie Details’ section (fld-a0d18fb6afa040b59e01bc4ed8bbc811) ===
‘Genre’ text (fld-2a0d16d2aece4562b6f44170cf1736a6)
‘Summary’ note (fld-28cc8f7f082c43818f1169c96c96e5a9)
‘Rating’ rating (fld-3baff54c8e164de9b9ad3f0fbb040bc6)
‘Year Released’ text (fld-3a365169f48a4b69ad37e86e171f0e00)
‘I Watched This’ check_mark (fld-5fda15d66484465da69196949f1b9353)
‘Actor/Actress 2’ text (fld-4cacb0cf58364eb091437ac1834a4862)
‘Actor/Actress 3’ text (fld-2cdb0cf1ef1743b68fa5bda36f694a08)
‘Directed By’ text (fld-522a5de85bcc44e087e473bb2567a471)
‘IMDB Website’ web_site (fld-9bc90613e8db45fea77579f35eb53b9d)

Home Inventory: (frm-5de3dd00a2b44d4b802166979c21f91b)
‘Picture’ photo (fld-294fa505e27c4aa99438339d59c1b40d)
‘Purchased From’ text (fld-2d3154a342914146a6d7cbb8659527fa)
‘Insured Value’ number (fld-3e3c56a2b59d401fba379b508a54e3f2)
‘Number of Items’ number (fld-49afd76a3770426db95569493d17ff87)
‘Received as Gift’ check_mark (fld-57d6f4e4d3cf4e57a9b6f56b9f3bfd51)
‘Serial Number’ text (fld-58095db96d1d4f1c9ca0b1ede05e2802)
‘Purchase Date’ date (fld-5c45c558205e4989836e218b7e2863de)
‘Original Cost’ number (fld-6dbd8f48549a44529d58d9167d2ae142)
‘Location’ text (fld-880ae556bea942e1891b21ca46c582da)
‘Notes’ note (fld-92fa01ec5f5b4204b15695fb00df89c3)
‘Category’ text (fld-9ee801f49a884f9484235d3d4181694d)
‘Purchased Warranty’ check_mark (fld-a5061f32941641e2a89ca68ce172daf1)
‘Condition’ text (fld-b2dc1cf3e0554c1790a80fb1f3b16bce)
‘Item’ text (fld-bffefe6a2a6e4167a680479de15d62a3)
‘Description’ note (fld-da04516482fc48138a2b509394e08962)
‘Current Value’ number (fld-ef1ecf1eaff44d3bbbd0246fdbf8653f)

Store it: (frm-5914a244ee7a478d836605e1ceaca953)
‘Dried Herb Container’ text (fld-574f012a9265474ca68e3c59b1b943f8)
‘Inventory Action’ text (fld-83f511fd2091454e8ef8eeb5aadc262f)
‘Storage Locations’ text (fld-e64b8d6a0e494b3b8287305191667e00)
‘Cellar Section #’ text (fld-90f2d815788f4f76854080d1c494337a)
‘Cellar Shelf ‘ text (fld-ec4c73b99f514318b3e7ea20f1b2720b)
‘Notes’ note (fld-2e34014633244ec7b22f3cc377150003)

Inventory_Fresh Herbs: (frm-633224c604b743029fab93e0cf9f2dec)
‘Harvest Date’ date (fld-91f73c36391d4ec5bbfa842bea1cd903)
‘Herb’ text (fld-e2f93b8b16c74327aa67d13b2b9f84fe)
‘How Many?’ number (fld-a500d28abdb44412aa6fec74272f2982)
‘Weight in oz’ number (fld-341af6b69de7468cb66d15476f87d01a)
‘Status’ text (fld-7c0d28cb2c7d4a4facace3004129f5d3)

Daily Journal: (frm-494dc8cef1934c0393dc932d13ccd94a)
‘Date’ date (fld-bf50f76f8fbe417faf8ae9e627972546)
‘Action’ text (fld-c0cae13ad58546b0a5023cd9d9984815)
‘Journal Entry’ note (fld-3849af82aa3e4304b3fb42441841b3ec)

Body Systems: (frm-5689d126c1f44e98843d54531ced1573)
‘System Name’ text (fld-a66eec23cee047a8a184018cc2d44ebe)
‘Components’ text (fld-9ed000b2c5554cb6ab83d927886f4071)
‘Role’ text (fld-3c8009f517584efa8b04d0bfc7cfad1a)
‘www’ text (fld-5577937cc591496e8979cffe2f74a292)

Process it: (frm-19c79fbfc71e4cd29a7cc4e83b96794a)
‘Herb Drying’ text (fld-a0c7bc6ac71346f193f2420b2f86c96f)
‘Harvest Date’ date (fld-b269a193e4ec44c9a5a96997a403bf00)
‘Drying Method’ text (fld-d64183db6f8e42369d337a7b9b958d88)
‘Tray, Rack or Wire NO.’ text (fld-c956585a946844418ff5ab248fb741e7)
‘Date Drying Complete’ date (fld-74bdd877ca4c40579b660cbe52d79a94)
‘Dried Herb Container’ text (fld-3ef91aef638e486085ff213fc3bbaaed)
‘Dry Weight in oz’ number (fld-65cdaa10ea234ff296a49ca5cda9a66a)
‘Dry Storage Location’ text (fld-4e2227e58eee487aa87ba5337f1ca662)

Daily Herb Log: (frm-d8963fdc083a44b99e9813294cd14dfd)
‘Date’ date (fld-459c4747e4a54cbfbba7f1dc858d3ec4)
‘Log Entry’ text (fld-7b48a204950a4f9a86f3771e8a51711e)

[Sam Moffatt]

Interesting! You hit a bug, I’ll have to figure out what happened there and ship a fix.

Do you mind attaching a copy of the following files in your /tmp directory (from the terminal you can use open /tmp to have Finder open up the path for you):

– Any files prefixed with tf_servers
– Any files prefixed with tf-dns_sd_resolve

They should have a random suffix of a period followed by seven characters. These are plain text files that contain the debugging data for the script.

This location is cleaned up when you restart, so if you restarted you’ll have to redo the steps from the start again. If you haven’t restarted, they should be there. My guess is that I am not handling some whitespace properly in my script. The address details will also change a little each time you close and reopen the document in TapForms again but hopefully I can just fix the script for you.

Thanks for testing!

[Sam Moffatt]

POC is proof of concept and I’m still trying to figure out a good way to map your model. This can be automated but getting the right structure is the key to that part.

We can pull something together in TapForms, might need to pull in a few scripts but it’s surely doable. In another thread I’ve started a nascent point of sale system, I’m sure once we can nail this together we’ll be able to get this to shine.

How comfortable are you with the MacOS “Terminal” application? I want you to run some stuff for me to help me get a better understanding of your structure. Assuming you’re sort of comfortable or at least willing to give it a go, here are some instructions that should work. You can see a video of what it looked like on my machine here: https://asciinema.org/a/cCqqZdK1TzaYbk6KFxi003mr2

Before we start, in TapForms open up “Preferences” and go to the “Sync” tab. On the left hand side below the options there is a database ID like “db-c4bb7e8222bb4befb0a6d9ddf8b00d69”. Keep a copy of that somewhere, you’ll need it later. Make sure your TapForms document is open whilst everything is going on.

Use Spotlight to open “Terminal” or use Finder to go to “Applications” then “Utilities” and then launch “Terminal” from there. It’ll open up a new window and we’re going to type some stuff in (you can copy and paste each line one at a time across):

cd /tmp
curl -LO https://github.com/pasamio/tftools/archive/master.zip
unzip master.zip
cd tftools-master/
bin/tf-finder.sh
cat /tmp/tf-hosts 

At this point all going well you should have a list of TapForms instances on your screen. It looked like this for me:

https://deported.local.:65007/db-c1da6869786341efbd8dbe2021a8df72
https://deported.local.:65017/db-5af742cf299940b1b9ad32e7fae7ec41
https://deported.local.:55778/db-c4bb7e8222bb4befb0a6d9ddf8b00d69

Now I want the last one because the ‘db-c4bb7e’ matches the one from my TapForms preferences earlier. I’m going to type in one more command: ./build-tree.php https://deported.local.:55778/db-c4bb7e8222bb4befb0a6d9ddf8b00d69 to print out the structure. It’s a little hard to see on the recording but it looks like this:

$ ./build-tree.php https://deported.local.:55778/db-c4bb7e8222bb4befb0a6d9ddf8b00d69
Processing https://deported.local.:55778/db-c4bb7e8222bb4befb0a6d9ddf8b00d69
================

Purchases: (frm-1ef8c6949a634690b1a8c0ba04d4acda)
	'Customer' from_form (fld-8d14f6b4d1f548969179465843edeaa0) toOne 'Customers' (frm-74813cf4d5e9466786d94835bb631e89)
	'Date & Time' date_time (fld-04cf1e8e78c44bbbbdbb73de551c9ff7)
	'Purchase ID' calc (fld-b9e4ce6cc4924a8abf4303a520c9c1eb)
	'Coupon' from_form (fld-9747e0950c184972a24ec957365ef4de) toOne 'Coupons' (frm-75b20fd711814723aeec5d0b82654885)

Customers: (frm-74813cf4d5e9466786d94835bb631e89)
	'Photo' photo (fld-a713d3becf424a03a9874e4ef58f1cac)
	'Name' text (fld-09c06e6fb4ac45f396d34f37f1eb5134)
	'Unclaimed Coupons Count' script (fld-5df1a4a31f26465eb92300f2e5dbef20)
	'Unclaimed Coupons' form (fld-ceed38ab41c3491e87701c9ed8afd9e1) join 'Coupons' (frm-75b20fd711814723aeec5d0b82654885)
			 ON Customers.Coupon Key == Coupons.Coupon Key
	'Purchases' form (fld-473360977fa94a32a5ff7ac7bc936abc) toMany 'Purchases' (frm-1ef8c6949a634690b1a8c0ba04d4acda)
	'Coupons' form (fld-acaa893ee387440ea894a42f6aaf93db) toMany 'Coupons' (frm-75b20fd711814723aeec5d0b82654885)
	'Coupon Key' calc (fld-8a0b920043ef457b840bc7359331dcb6)
		Referenced Fields: 
		 - Customer ID (fld-d22a0cd4e0e848b7a0215b8c358b9c4b)
	'Customer ID' calc (fld-d22a0cd4e0e848b7a0215b8c358b9c4b)

Coupons: (frm-75b20fd711814723aeec5d0b82654885)
	'Customer' from_form (fld-d8ae855a86c04fc9a5fcea5e9271fb45) toOne 'Customers' (frm-74813cf4d5e9466786d94835bb631e89)
	'Coupon ID' calc (fld-6f8298c572b34b9a970b08f5144e8052)
	'Purchases Counter' script (fld-53d2deb246c44b53b88445777c89a4d4)
	'Purchase Count' calc (fld-933cd52286e3446ea2c88d0845c60852) - calculation field missing formula!
	'Claimed' check_mark (fld-1b9172f2b462431fa75e17a38199f017)
	'Coupon Key' calc (fld-926d6814fc3a428e878acaf0305dbaf9)
		Referenced Fields: 
		 - Customers::Customer ID (frm-74813cf4d5e9466786d94835bb631e89::fld-d22a0cd4e0e848b7a0215b8c358b9c4b via fld-d8ae855a86c04fc9a5fcea5e9271fb45)
		 - Purchase Count (fld-933cd52286e3446ea2c88d0845c60852)
		 - Claimed (fld-1b9172f2b462431fa75e17a38199f017)
	'Purchases' form (fld-328c4efe13d8420198034eccca4e4841) toMany 'Purchases' (frm-1ef8c6949a634690b1a8c0ba04d4acda)

All done

As you can see it’s a dump of the structure of the TapForms document which is in a format that doesn’t expose too many details beyond field names. You’ll have to change the https bit to match your document and hostname. You can use the mouse to highlight the text to copy and then paste into the forum to share.

[Sam Moffatt]

Ok so I decided to do a quick POC for this that turned out to be not so quick. I’m going to share this quickly since it’s 2am and I need to sleep but I think it is a step in the right direction. It doesn’t deal with checkboxes because that logic is a little hard for me to follow.

The attached document has three forms: Purchases and Coupons and Customers. I’m going to do this a little backwards so bear with me.

The “Purchases” form just records the individual purchases that were made, think of these like your checkboxes but with one record per purchase. This has advantages when it comes to sync as you are less likely to have sync conflicts with two people changing the same record. It’s a pretty useless record in general tracking a created date & time as well as a unique ID. It has links back to Customer and Coupon.

The “Coupons” form has a link to the Customer, a Coupon ID, a couple of counters, a flag for if this coupon has been claimed, a JOIN key field and then a Link to Form for the “Purchases”. The “Coupon Key” calculation takes the unique ID of the Customer, adds the purchase counter field and adds the claimed flag. This is done so that the Customer form can JOIN to get unclaimed coupons.

The “Customers” form has a bunch of stuff in it. I added a photo and title field for fun then we get into the more interesting business. Probably easiest to just list each of the fields out:

– Unclaimed Coupon Count: A script to count the JOIN field for unclaimed coupons.
– Unclaimed Coupons: A Link to Form JOIN field for unclaimed coupons; uses the Coupon Key to find coupons belonging to this customer that have 15 purchases and aren’t claimed.
– Purchases: A Link to Form 1:M field for all of the purchases the customer has made.
– Coupons: A Link to Form 1:m field for all of the coupons the customer has.
– Coupon Key: This is a calc field with the customer ID, the number 15 (number of purchases) and the number 0 (the coupon claimed flag)
– Customer ID: This is a single time generated unique identifier.

For “Customers”, there’s a “Customer View” layout that is your front end view for your data entry folk. It’s ugly right now but has two buttons that do something interesting: add purchase and claim coupon. Add purchase prompts to add a number of purchases and “claim coupon” prompts for a coupon code to redeem.

There are two other form scripts: “Claim Coupon (Any)” and “Create Coupons”. The first is a variant of “claim coupon” that finds any valid coupons and claims them. If you’re handing out things to customers to return, that’s not so useful but if you are letting customers claim when they have credits then you can use this instead. The second looks through the database to process all of the customers, all of their purchases and creates “coupon” records for them. This “Create Coupons” script would be your daily admin task. In theory it could be included with the “Add Product” flow to be done automatically.

Some quirks I found when playing with this is that not everything is being recalculated properly. After running some of the scripts, you might need to go to each form and click the “refresh records list” button. If something doesn’t look right, go through each of the three forms and click on this button. That should clear out any weird caching behaviour and cause the calculation fields to update properly. Something about adding records via scripting doesn’t trigger the updates properly for calculation and script fields which then means the JOIN fields are broken.

This could be simplified further by hiding the fields in places but I think this captures some of the simplicity you’re after in a model that I think maps better to how TapForms internally operates. This is also much safer when handling multiple data entry points and potential conflicts that having a single form with a lot of checkboxes wouldn’t. Downside of this is that it only works on the Mac.

Purchases: (frm-1ef8c6949a634690b1a8c0ba04d4acda)
	'Customer' from_form (fld-8d14f6b4d1f548969179465843edeaa0) toOne 'Customers' (frm-74813cf4d5e9466786d94835bb631e89)
	'Date & Time' date_time (fld-04cf1e8e78c44bbbbdbb73de551c9ff7)
	'Purchase ID' calc (fld-b9e4ce6cc4924a8abf4303a520c9c1eb)
	'Coupon' from_form (fld-9747e0950c184972a24ec957365ef4de) toOne 'Coupons' (frm-75b20fd711814723aeec5d0b82654885)

Customers: (frm-74813cf4d5e9466786d94835bb631e89)
	'Photo' photo (fld-a713d3becf424a03a9874e4ef58f1cac)
	'Name' text (fld-09c06e6fb4ac45f396d34f37f1eb5134)
	'Unclaimed Coupons Count' script (fld-5df1a4a31f26465eb92300f2e5dbef20)
	'Unclaimed Coupons' form (fld-ceed38ab41c3491e87701c9ed8afd9e1) join 'Coupons' (frm-75b20fd711814723aeec5d0b82654885)
			 ON Customers.Coupon Key == Coupons.Coupon Key
	'Purchases' form (fld-473360977fa94a32a5ff7ac7bc936abc) toMany 'Purchases' (frm-1ef8c6949a634690b1a8c0ba04d4acda)
	'Coupons' form (fld-acaa893ee387440ea894a42f6aaf93db) toMany 'Coupons' (frm-75b20fd711814723aeec5d0b82654885)
	'Coupon Key' calc (fld-8a0b920043ef457b840bc7359331dcb6)
		Referenced Fields: 
		 - Customer ID (fld-d22a0cd4e0e848b7a0215b8c358b9c4b)
	'Customer ID' calc (fld-d22a0cd4e0e848b7a0215b8c358b9c4b)

Coupons: (frm-75b20fd711814723aeec5d0b82654885)
	'Customer' from_form (fld-d8ae855a86c04fc9a5fcea5e9271fb45) toOne 'Customers' (frm-74813cf4d5e9466786d94835bb631e89)
	'Coupon ID' calc (fld-6f8298c572b34b9a970b08f5144e8052)
	'Purchases Counter' script (fld-53d2deb246c44b53b88445777c89a4d4)
	'Purchase Count' calc (fld-933cd52286e3446ea2c88d0845c60852) - calculation field missing formula!
	'Claimed' check_mark (fld-1b9172f2b462431fa75e17a38199f017)
	'Coupon Key' calc (fld-926d6814fc3a428e878acaf0305dbaf9)
		Referenced Fields: 
		 - Customers::Customer ID (frm-74813cf4d5e9466786d94835bb631e89::fld-d22a0cd4e0e848b7a0215b8c358b9c4b via fld-d8ae855a86c04fc9a5fcea5e9271fb45)
		 - Purchase Count (fld-933cd52286e3446ea2c88d0845c60852)
		 - Claimed (fld-1b9172f2b462431fa75e17a38199f017)
	'Purchases' form (fld-328c4efe13d8420198034eccca4e4841) toMany 'Purchases' (frm-1ef8c6949a634690b1a8c0ba04d4acda)

Attachments:

You must be logged in to view attached files.