How do I create a database to populate a field if a specific text or value is in another?

You can use the "Update a Form Field Value" condition in order to do this. Please refer to this guide: https://www.jotform.com/help/286-How-to-Populate-Field-with-a-Value-from-another-Field

Let us know if you need any help. Thank you.