I want to use a form to allow volunteers to register for upcoming events. Each volunteer can select multiple events. Volunteers may also return to fill out the form more than once, as many of them will return for future events. The volunteers will ju...
I have a base that stores plant information, including photos of each plant in an attachment field. I use a formula to put the attachment URL into a field. Here's what I do with that information to create a web map of my plants:1. Download a CSV of a...
My plant names table has these three fields: Taxon Name, Name Status, Accepted Name, and Synonyms. Here's the table: https://airtable.com/shrHB9evyZmBawj0CTaxon Name is for all possible plant names. Some of these are "accepted names", meaning they ar...
I asked this question in the past, but didn't get much of a response. I'm asking again in case anyone has new ideas. In this table I have a list of plant names (taxa) plus other information about the plant's habitat, etc. Plant names frequently chang...
I want to use this mathematical formula to calculate the "average" diameter at breast height (DBH) of a tree with multiple stems:DBHavg = SQRT({DBH1}^2 + {DBH2}^2 + {DBH3}^2 + {DBH4}^2)This is the formula I used:SQRT(POWER({DBH 1 (cm)}, 2) + POWER({D...
Thank you! That helped a lot. I also wanted to make sure the field stays blank if there are no DBH values entered. This field is in inches, so I also had to convert the final value. Here's the formula I went with: IF({DBH 1 (cm)} = BLANK(), BLANK(), ...
Thanks for your response. In my case the "Name" field (actually called "Taxon Name") is a formula field made up of several concatenated fields. That field should only contain accepted names, not synonyms. I don't want a "New Accepted Name" field beca...
