Assigned
 
 
 
 
Tomato Seed Special Giving Form
Advancement Website → Online Giving
Due Open Deliverables
 1 / 1
Project Lead Project Team
not assigned D Chris Barnett
Sponsor Information
Institute of Food and Agricultural SciencesCaylin HiltonDirector of Development & External Relations
Project Description
Dr. Klee wants to give tomato donors the opportunity to participate in a citizen science type project when they contribute, however they need to check yes on a material transfer agreement to protect the test seed ability to later be commercialized. Is this something we could potentially facilitate through a special campaign page?
Deliverables
NO DELIVERABLES - Please add at least one deliverable
Comments & Notes

Add your comment or additional information by clicking the Edit button in the upper-right corner and completing the form.

The update will be added to the project and a notification will be sent to the project team.
[OCT-13-20 Jason Phenicie] >> On Jan 10, 2020, at 4:13 PM, Chris Barnett <cbarnett@uff.ufl.edu> wrote:
>>
>> Hi Caylin, I'm circling back on this.  I think you just want a description & checkbox, but I can't tell.   Let me know when you're free for a call and we'll go over what you need.  I think we can probably build you a special form for this and provide you with data on it, but we need to make sure we understand what you need first.
>>
>> Thanks,
>>
>> Chris


> Sounds good to me - if I can add the agreement language in a drop down or stagnant text box on gift form and then the check box yes/no acceptance data can be added as export column to the gift report Kelly gets to share with lab, that will work perfectly.
>
> Caylin Hilton


> What report does Kelly get?
>
> I don't know that this would make its way onto any standard gift reports from Advance/AP, but we can ask.  We can certainly supply a report directly from GGE that can include that data.
>
> Chris


Circling back on this - would like to get this deployed as soon as possible. I let Giving Day push this down in spring and then haven't followed back up. Attached is the language we need folks to agree to in order to receive seeds from new cultivars as a thank you. Anyone who doesn't accept this will still receive seed but will be from older varieties. This can be a drop down with text that they click a box to accept/agree.

If a custom report can be pushed out/accessed as referenced below that indicates the gift details and that they checked the box that would be perfect - the lab is on board to be promoting a higher gift amount as well. YAY

If you can let me know any time frame for getting it activated, I can let lab know what to expect. Thanks!

Caylin L. Hilton
Created on Oct. 13, 2020 at  8:35 AM (EDT). Last updated by Jason Phenicie on Oct. 13, 2020 at  8:38 AM (EDT). Owned by Phenicie, Jason.
Jason Phenicie
Jason Phenicie
Show fields from Show fields from Show fields from a related table
Report Name *
Description
Reports and Charts Panel
Each table has a panel listing its reports and charts, organized in groups.
Please wait while your new report is saved...
Field label
Column heading override
Justification
What does auto mean?
Fields in:

Fields to Extract:
Name for the new table:
Items in the new table are called:

When you bring additional fields into a conversion, Quickbase often finds inconsistencies. For example, say you're converting your Companies column into its own table. One company, Acme Corporation, has offices in New York, Dallas and Portland. So, when you add the City column to the conversion, Quickbase finds three different locations for Acme. A single value in the column you're converting can only match one value in any additional field. Quickbase needs you to clean up the extra cities before it can create your new table. To do so, you have one of two choices:

  • If you want to create three separate Acme records (Acme-New York, Acme-Dallas and Acme-Portland) click the Conform link at the top of the column.
  • If the dissimilar entries are mistakes (say Acme only has one office in New York and the other locations are data-entry errors) go back into your table and correct the inconsistencies—in this case, changing all locations to New York. Then try the conversion again.

Read more about converting a column into a table.

We're glad you're interested in doing more with Quickbase!

Now we need to make you official before you share apps or manage your account.

Verifying your email lets you share Quickbase with others in your company.

Your work email
Your company