I am trying to create a table for my microgreen growing log. I would like to have a function that when I create a new record and fill in the crop name of that record, the corresponding harvest days will be autofilled in another field. But I don't want to use formula as the field type of harvest days as I might have to adjust the harvest days in some situation.
Solved
How to autofill a value with corresponding value in another field?
Best answer by TheTimeSavingCo
microlocalfarm wrote:
The first photo is the planting record table where I will mark down the info for every tray of microgreen that I sowed, e.g. sowing date, type of crop. The second photo is the microgreen data table and the field "sow to harvest day" is the number of days that I have to harvest that crop aftering sowing. So now I need to have a way that whenever I create a new record on the planting record table, the harvest date will be calculated by adding the "sow to harvest day" from the microgreen data table to the sowing date of that new record, but I don't want to use formula field type for the "harvest date" field as I might have to change the date if the microgreen is not growing well as expected.
Ah I see now. I think if I were you I'd create a formula field for the harvest date called "Calculated harvest date" to get the correct date, and then have an automation that triggers when "Calculated harvest date" is not empty and "Harvest Date" is empty, and its action would be to paste the value of "Calculated harvest date" into "Harvest Date", does that make sense?
+18Where are each crop's corresponding harvest days stored? Could you share some screenshots of your tables and the relevant fields please?
TheTimeSavingCo wrote:
Where are each crop's corresponding harvest days stored? Could you share some screenshots of your tables and the relevant fields please?
The first photo is the planting record table where I will mark down the info for every tray of microgreen that I sowed, e.g. sowing date, type of crop. The second photo is the microgreen data table and the field "sow to harvest day" is the number of days that I have to harvest that crop aftering sowing. So now I need to have a way that whenever I create a new record on the planting record table, the harvest date will be calculated by adding the "sow to harvest day" from the microgreen data table to the sowing date of that new record, but I don't want to use formula field type for the "harvest date" field as I might have to change the date if the microgreen is not growing well as expected.
+18microlocalfarm wrote:
The first photo is the planting record table where I will mark down the info for every tray of microgreen that I sowed, e.g. sowing date, type of crop. The second photo is the microgreen data table and the field "sow to harvest day" is the number of days that I have to harvest that crop aftering sowing. So now I need to have a way that whenever I create a new record on the planting record table, the harvest date will be calculated by adding the "sow to harvest day" from the microgreen data table to the sowing date of that new record, but I don't want to use formula field type for the "harvest date" field as I might have to change the date if the microgreen is not growing well as expected.
Ah I see now. I think if I were you I'd create a formula field for the harvest date called "Calculated harvest date" to get the correct date, and then have an automation that triggers when "Calculated harvest date" is not empty and "Harvest Date" is empty, and its action would be to paste the value of "Calculated harvest date" into "Harvest Date", does that make sense?
TheTimeSavingCo wrote:
Ah I see now. I think if I were you I'd create a formula field for the harvest date called "Calculated harvest date" to get the correct date, and then have an automation that triggers when "Calculated harvest date" is not empty and "Harvest Date" is empty, and its action would be to paste the value of "Calculated harvest date" into "Harvest Date", does that make sense?
That's indeed a good way to implement my idea. Thanks!! 🙂
1 person likes this
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.