Anyone here that can build a database for pay?

[D J Leason]

As much as I loathe to admit it, I am over my head here. Is there an experienced person that has build a complex inventory database with Tap Forms, that would like to make some extra cash? If so please contact me.

[Sam Moffatt]

I’m not here to do it for pay, I am curious though of if you could explain a little more what you mean by complex inventory database? Roughly what you’re trying to track, how you think they’re related and what not.

I feel the biggest challenge is getting to understand database structures and figuring out how to map them to what you want to achieve within TapForms. Describing more precisely what you want to model will help someone who builds a new document for you.

[Brendan]

The Tap Forms part is actually fairly straight forward. Add a field, choose the field type and give it a name. The rest of the options are just about how things get displayed.

How are you managing inventory at the moment?

[D J Leason]

This is how I have been keeping track:

I might have to do this in a couple of submits.

Attachments:

You must be logged in to view attached files.

[D J Leason]

submit_2

Attachments:

You must be logged in to view attached files.

[D J Leason]

Submit 3, I can build them, although I may not be doing it right. You think I need more forms instead of crowing all that info into just a few? How do I make them play nice with each other, sharing information and all. As you can see how I was keeping the records, can I come close to that with TF?

Attachments:

You must be logged in to view attached files.

[Sam Moffatt]

“Right” is subjective to be honest, again I’d take an iterative approach. Import everything as is and then start to add functionality from there. Seems like you’re already well into that approach so that’s cool. One observation is possibly that “Others Herbs” and “Herbs” should probably be one form eventually and just have a checkbox for “Other Herbs” then filter out.

# How do I add 1 to ratio b and update the other calculation?

Calculations are fun but calculations are executed in order and grab the value of a field when they execute. Scripts used to run before calcs but now I think they run afterwards so what might work is to use a script field as it’s always at the end.

There is also a refresh button at the bottom that will trigger everything to refresh. Assuming your calcs are stable then hitting refresh will ensure everything is up to date.

A hack you can do with script fields is to reference the field but not use it. That causes the script field to run but they don’t inherently need to care about the field itself.

# How to handle log entry?

Immediate thought was to use a script to create a new child entry that copies the calculation field you have but part of me wonders if you’re thinking about this the wrong way in that this is already your daily log! Just add the records per day and you’ve got your log (duplicate if that makes sense).

# How many forms?

Conceptually what you’re aiming to do is not duplicate where possible. If you have a field value that exists in two places and is always the same, then it’s a candidate to be it’s own form that you link to from multiple places. That’s an ideal state, the path there from here is a little harder. You can start by using Link to Form with JOIN type to link stuff together and slowly add in the other types.

If all of the data is unique to that form and not repeated else where, make a mega form. The linking generally wants you to go 1:M or M:M so I’d think of it that way too: if there is only ever one value then leave it on the same form, if there are multiple potential values then create a new form and link to it or maybe use a table.

Fundamentally try out how it works for you and slowly move stuff around. And as always make backups.

[Sam Moffatt]

Some extra thoughts whilst I background process all of this.

One thought is to be able to think about how to filter records by fields. You’ve got a log sheet grouped by tab for herb type which in TapForms could be a set of saved searches for each Herb Type on top of a Link to Form from Herb -> Log Entry. Using saved searches could also help with other filtering based on more complex values as well.

Similarly your other cellar and cave spreadsheet could just be it’s own form and the only thing would be to set up a link from the herb form (Link to Form 1:M with show inverse relationship selected) to handle the herb field and then the rest is normal. If you have a saved search to hide completed entries then you have a record of what you used to have and it’s all tied together.

Another idea is that you can leverage custom layouts on the Mac to only display fields you care about. Similar to using the section headings to collapse out fields, layouts let you be a little differently thought out than the default single column layout.

There is a special “date modified” field that is updated each time the record updates. Might be useful but it will update regardless of how big, or how small, the change to the record is. I can see a few places where I think that might be relevant for you.

[Sam Moffatt]

One last thought before I go to sleep, each spreadsheet could be it’s own form to begin with and you could to get started just use TapForms with the MCLV spreadsheet like interface. If there are the same column headings between different sheets, that’s just one extra field in the form for a ‘name’ (e.g. herb name). Hopefully some of this makes sense.

[D J Leason]

@ Sam Moffat
# How to handle log entry?
Immediate thought was to use a script to create a new child entry that copies the calculation field you have but part of me wonders if you’re thinking about this the wrong way in that this is already your daily log! Just add the records per day and you’ve got your log (duplicate if that makes sense).

That log entry is for the weight to volume method only, which I don’t use daily. I can see the entry in the Form where created in the MCLV so that does give me a chronological list of tinctures made using the W2V method. I can see the entry in [Herb] Form / [WIP_W2VC Link to Form table], which gives me a list of each time I started that particular herbal tincture using that particular method but it does not show in the MCVL there because it’s just a [Link to Form] field and for the same reason, I can’t drag it into a new layout. So to get a chronologically ordered list for the year, although admittedly less expedient, I can physically copy and paste each entry to the [Daily Herb Log Form], (I haven’t advanced to Scripts or child entries quite yet), which helps me plan my calendar for next year. I could have a [Herb Log Entry] calculation for each Form with activities, copying and pasting each until I learn how to write scripts. Is that what you mean by duplicate? I really do appreciate all your help!

[Sam Moffatt]

I’m not sure I completely follow so if this doesn’t make sense then it’s probably me being confused.

If you have a daily log entry record already and you have one off W2VC entries for when you do those measurements, what you could do is setup a Link to Form 1:M going from the W2VC to the Daily Log. This is slightly counterintuitive but what it enables is for you to use a calculation field in the daily log form to pull out values from the W2VC form because it’s actually a 1:1 relationship and you can create a new records from the 1:M side. This is similar to the suggestion I made on another thread.

I should have been clearer by what I meant by duplicate. The intention is that you shouldn’t have the same piece of information stored in more than one place. The reason being that if you have to update it, then you have to change it in multiple places. Ultimately the aim is to reduce duplication and automate it where it makes sense.

In your data model, I think something like this makes sense:

– Herb 1:M -> Daily Log <- 1:M W2VC

You have the Herb form at the root, you have daily log entries per herb and then when you do changes you link to that daily log the W2VC data. You can use calculation fields to bring up the data from the W2VC when it’s there to include.

I think it might be helpful at this point to have a dump of your database structure, let me think about some instructions to help you do that in an effective way. I have some tooling to do it but it’s not completely user friendly.

[D J Leason]

@ Sam Moffatt

Attachments:

You must be logged in to view attached files.

[Sam Moffatt]

Some questions:

– Is the daily herb log entry for a single herb or for a single treatment of a herb? Is it possible you’re doing two different instances of the same herb? (WIP?)
– You should be able to do a calc on Link from Form fields that are on the single side of the equation.

Let me see if I can steal some time to build a POC of what I’m talking about that you can use. This week has been crazy due to work related travel.

[D J Leason]

If, on the same day, I dug elecampane roots, that would be one log entry in ‘Acquired it’. If I took half of those roots and made a tincture using the weight to volume method, that would be one log entry in W2VC. If I took the other half of the roots and made a tincture using the Folk Method, that would be one log entry in the WIP form. That is unless, I figure a way to combined the WIP and the W2VC forms and re-write one log entry on the WIP form. POC = piece of cake? LOL

[D J Leason]

@ Sam Moffatt
BTW, share your considerable skills at your leisure. You are in no way obligated to help me but know that your help is much appreciated. Normally, I just type in all herb related activity for a given day in the Daily Herb Log under that date and then copy and paste the information for various herbs into the Individual Herb Logs. I don’t see a way automate the process in Tap Forms, but then I don ‘t have your skills.

Thanks Sam

[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.

[D J Leason]

@Sam Moffatt
I tried the first part but it didn’t work. I tried it with spaces between the copied lines and without spaces. This is what happens:

Attachments:

You must be logged in to view attached files.

[D J Leason]

Here is another try that returned No Such File exist. Tap Forms was open.

Attachments:

You must be logged in to view attached files.

[D J Leason]

OK, got it. Have to hit Enter between each line.So it did respond but the build tree processing came up short.

Attachments:

You must be logged in to view attached files.

[D J Leason]

Not sure what part of the HTTP to change. Should it look like this:Danas-iMac:~ danaleason$ ./build-tree.php htpp://deportedlocalDanas-iMac.localdb-e83c5f983f764b57bb14494c210f2c20

[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!

[D J Leason]

This is what I found:

[D J Leason]

The Resolve files have zero bytes If any of those are what you need let me know and I will try to send them.

Attachments:

You must be logged in to view attached files.

[D J Leason]

Here is one with tf_server

[Sam Moffatt]

I don’t think the forum will let you attach it, just rename it to have “.txt” at the end to upload. The dns-sd files being empty explains some of the quirk (not able to resolve anything), I think I know what the other part is (space in the host name).

[Sam Moffatt]

Ok, I think I fixed it and pushed an update. You will need to delete the master.zip file and the tftools-master in /tmp to re-run the instructions (or just rename them) but then it should work properly. Needed some restructuring to handle the single quote and space in your hostname, but I set up my Mac like that and it seemed to work. This is all throw away code, you can delete everything and start again safely.

[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)

[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]

There are some Forms that I have yet to develop like these:
Count it: (frm-9191dd1cdd3440058263fe83ab50b057) Spreadsheet of Herbs to do physical inventory
‘New Field’ text (fld-5a04fb3372d3461ebbc16309ee128c71)
Tasks: (frm-9f8f6052762a4bef89c7140e22e9b7ef) A To-Do List
‘New Field’ text (fld-7379fd7ab0b847878036d80ab2514d01)
History: (frm-769acbef8e754ec4bc620b74ec85efe7) where I will store past Daily Herb Logs
‘New Field’ text (fld-8e276469f5ec4519843505aeaf6674c9
Find it: (frm-d687800053d44cf9920e39115dc475d4)
‘Action’ text (fld-fd3f7905861945b3a7482c2aeeb4b4c8) Will be saved searches
‘Date’ text (fld-b8ded14d41dd4334bc87907b7b14b61f)

ID CheckList: (frm-b86ac47117174bcd9d87249cd547afd2) A check list of plant parts to check off in the field for positive herb ID.
‘New Field’ text (fld-cae7d32322b6498e99aeb6de2eaea350)

[Sam Moffatt]

One minor ask, can you edit your posts to wrap the pasted text in back ticks (the code button also inserts it), they enable a preformatted text mode.

Here’s an example:

And this is what it looks like:

Example
Text
In
Backticks

These links should work for you:

Reply To: Anyone here that can build a database for pay?

Reply To: Anyone here that can build a database for pay?

Reply To: Anyone here that can build a database for pay?

Attachments:

You must be logged in to view attached files.

[D J Leason]

@ Sam Moffatt

Attachments:

You must be logged in to view attached files.

[Sam Moffatt]

The aim is at the beginning and at the end to preserve the indenting. The indenting has special meaning to me because it flags referenced calc fields or joins in a way that isn’t immediately apparent when the white space is removed. Basically I use the white space to see how everything is connected even if it looks like a bit of a mess, it makes sense to me.

That said I think I reconstructed the layout and I’m having a look through.

[D J Leason]

Ok. Good to know. Sorry I messed that up for you. I will remember that for future post. So where exactly do I place the Backticks? At the beginning of each sentence?

Thank you!

[Sam Moffatt]

Just at the start of where the code/preformatted section until the end of it. You can also highlight it and hit “code” as well and it’ll wrap it for you.

In this case, all of the highlighted text then it’d look like this (subset copied):

Acquire 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)

[D J Leason]

@ Sam Moffatt

Not Sure how or if it will affect your data model planning but some day in the future, if I find time to learn to code, I want it to look something like this.

Attachments:

You must be logged in to view attached files.

[Sam Moffatt]

I’m still trying to wrap my head around the relationships you have currently, I started down a road of trying to model it more traditionally in a data model tool to visually map it a little more.

In the Grow It form, you link to Herbs and Acquire It which feels a little redundant because Acquire It also links to Herbs. Similarly the WIP forms are linked into Herbs which I don’t think they need to be. There’s also a join on the Daily Herb Log which I think should be a 1:M instead.

Herb I feel should link to Acquire It, that makes sense. Linking to consume it makes sense too. Grow It I’m not sure if it should just be linked to Acquire It or if it should be linked to Herb. I feel like Grow It can be split in two because it has entries like “Rare Seeds” and “Garden Tips” in it that feel like facts that maybe they should live with the Herb record then later you have specific dates which indicates to me a transactional entry.

Herb I’m not sure should link to the WIP forms, it feels like these should link through Grow it. You have a *herb* that you’ve *acquired it* and now you’re trying *grow it* and from there you have a *wip* which has *daily log* which uses *calculator* entries.

Instead of manually linking “Herb” in at each of these layers, you can use a calculation field to propagate the herb name into the child forms. That will have the advantage of being able to use that field to search/filter on in your views.

For the other item that feels like a new form with a table of a couple of the rows. I’d leverage the prompter functionality to turn this into a wizard to prompt each of the steps.

[D J Leason]

@ Sam Moffatt

That might just be because you know what you are doing and the most efficient way to do it where as I don’t know what I am doing and am struggling to figure it out. But I can say that If I Acquire an herb it can be in more than one way, buy it, harvest it from the wild, harvest from cultivated ( I grew it), Get it through a trade or get it via a gift. I acquire it for more than one reason: To Consume it, (tea blends or other herbal recipes) or to macerate it (make tinctures, vinegars and oils which are medicinal) or to grow it myself. If I buy Dried herbs, it is because I was unable to harvest enough from wild or cultivated means, unless I am buying a package of seeds or a potted plant or a bare root in which case the aim is to grow it. I also buy dried herbs which are too much physical pain to harvest or grow such as Milkthistle, for tincture ( massive thorns ), or Stinging Nettle leaf which I make health delicious tea from but breakout in a rash when trying to harvest. Perhaps it would be helpful to you if I posted the Form templates so you can see the pick lists with all the choices that are made on each form. Rare seeds and Garden Tips are just websites that I visit to get tips and buy seeds. Let me know if you wan me to post the form templates.
Thanks!

[D J Leason]

This may or may not be helpful:

Attachments:

You must be logged in to view attached files.

[Sam Moffatt]

Just a heads up that I’m going to be in China for the next two weeks, hopefully I’ll get some time to work on this some more. I’m beginning to wonder if I need to work off a backup to do some example restructuring but I won’t ask for that until I’m back to a part of the world that’s a little more internet friendly.

[D J Leason]

@ Sam Moffatt

Dosage is different for Folk vs W2V they have to be kept separate. Don’t need the W2V calculator for Folk Method. On the Daily Herb log. I need to see it in a Daily/yearly way and be able to filter by herb. That log needs to contain everything about each herb – Acquiring,Growing,Storage,Harvesting, Preparations created in WIP/W2V. I forgot to put @ Sam Moffatt o the previous submit but you should see it in the forum 8/23/19 aat 9:39 PM

[D J Leason]

@ Sam Moffatt
Ok Sam. Thanks for the heads-up. Have fun in China! Yeah you might need a backup when you get back because I am still building and (revising forms when I find duplicate fields and typos). I will try to get a backup on iCloud. By the time you get back, I may be away from the iMac for a time as well. Thanks for all you do. Maybe I could contribute to your favorite charity?

[D J Leason]

@ Sam Moffatt

Acquire it Form relationships

Attachments:

You must be logged in to view attached files.

[D J Leason]

@ Sam Moffatt

Here is something else that might help with the model.

Attachments:

You must be logged in to view attached files.

[Sam Moffatt]

Can you duplicate your database within Tap Forms to give it a new ID, rename it so that it’s got something that won’t have you confuse it with your real database and shoot me an email with the DB ID from the sync settings page of the newly created duplicate database? (my username is my email)

[D J Leason]

@Sam Moffatt
Hi,
Glad to see you made it back safely. Here is the dupe DB ID: db-f5337e1de7b14e92a9ae3b22fab96e47

[Sam Moffatt]

Thanks! Please send me an email so that I can send you login details for a CouchDB instance.

[D J Leason]

@ Sam Moffatt
I am unclear on your email address. You can email me at djleason@icloud.com and I will return one.

[Sam Moffatt]

Oh, it’s pasamio at gmail.com (my username is missing the @ and has a – instead of the .). I’ll shoot you an email with the details shortly.

[Author]

Posts