I added to the Airtable/commodities table all the commodities that are currently in F&F dropdown list. I also added prices for them and notes on where the prices were obtained (Note: this is a strange year where prices are currently far different from the RMA prices. But I want to have a referenceable price and most farmers know about RMA prices. Of course, this little factoid does not affect your programming. It is just that as I try to make this ready for prime time I have second thoughts about my default values.). I think this means that you can change the hardcoding to referencing this table.
Rick: The program will now build the Cash Crop list from the Commodities Airtable.
Questions that might arise as this is field tested (knowing them might help how you program):
[x] They are currently not alphabetical but in order of most likely to be chosen. I like the current order but field testers may argue for alphabetical order.
Rick: Unfortunately, the Airtable API sends data in a random order unless a sort key is provided. For this reason, I’ve added a new column named "order", simply to have a way to sort on the order that you’ve entered the crops.
[x] When anything besides corn or soybeans are chosen, the Yield tab disappears. Eventually, this will need to appear. It may mean that the text on this page needs to be commodity specific (if that is possible). The current logic will work for other commodities but we currently have no good information for “cover crop adjusted yield estimates.” Future modifications of this tab will have “cover crop adjusted yield estimates” that are not hardcoded but rather allow the user to enter in the percent change (and whether it is positive or negative).
Rick: The Yield tab appears for any Commodities that have one year, three year, and five year data (which is currently Corn and Soybeans only). We can certainly update the text on this page based on the commodity.
On the Yield tab:
[x] Minor edit: the spacing in the first line of the table (What is the expected yield for Soybeans in this field?) has spacing problems that need to be fixed.
[x] Major edit: The default value for what is the expected yield needs to be dependent on the crop chosen. My recommendation is that we add a column to Airtables/Commodities. If you can add the column, I’ll populate with defaults values.
Rick: I’ve added a new column to Commodities: expected yield. Whatever you enter here will automatically appear in the program.
[x] Minor edit: on the summary table where it currently says “Yield” can it say “yield impact?” This is the wording used on the Summary tab and I think it makes it clearer that it is not the total yield income.
(From Ray Massey)
I added to the Airtable/commodities table all the commodities that are currently in F&F dropdown list. I also added prices for them and notes on where the prices were obtained (Note: this is a strange year where prices are currently far different from the RMA prices. But I want to have a referenceable price and most farmers know about RMA prices. Of course, this little factoid does not affect your programming. It is just that as I try to make this ready for prime time I have second thoughts about my default values.). I think this means that you can change the hardcoding to referencing this table.
Rick: The program will now build the Cash Crop list from the Commodities Airtable.
Questions that might arise as this is field tested (knowing them might help how you program):
Rick: Unfortunately, the Airtable API sends data in a random order unless a sort key is provided. For this reason, I’ve added a new column named "order", simply to have a way to sort on the order that you’ve entered the crops.
Rick: The Yield tab appears for any Commodities that have one year, three year, and five year data (which is currently Corn and Soybeans only). We can certainly update the text on this page based on the commodity.
On the Yield tab:
[x] Minor edit: the spacing in the first line of the table (What is the expected yield for Soybeans in this field?) has spacing problems that need to be fixed.
[x] Major edit: The default value for what is the expected yield needs to be dependent on the crop chosen. My recommendation is that we add a column to Airtables/Commodities. If you can add the column, I’ll populate with defaults values. Rick: I’ve added a new column to Commodities: expected yield. Whatever you enter here will automatically appear in the program.
[x] Minor edit: on the summary table where it currently says “Yield” can it say “yield impact?” This is the wording used on the Summary tab and I think it makes it clearer that it is not the total yield income.