<p>Say I have a section called &quot;Stores&quot; that has an existing field called &quot;Store Hours&quot;. The client has populated the store hours for 1000 some stores. Now, however, it seems what the client really wants is the ability to quickly see which stores are open on Sunday. So now I need to add a new field called &quot;Open Sunday&quot; and correctly filly its value for each store based on its existing hours.</p>
<p>What I've tried:
I've added a new field, and then wrote SQL to update the contents table to fill out the value of &quot;Open Sunday&quot; based on the &quot;Store Hours&quot;, however, I need to manually re-save entries in order for my frontend queries to see the new &quot;Open Sunday&quot; value. Editing contents directly doesnt seem to let Craft know that the new field has a new value (possibly its saved in revisions or versions?).</p>
<p>*This example is just that, an example. I do not need twig snippets in how I can derive what stores are open on Sunday from a story hours field.</p>

CC BY-SA 4.0
2021-02-02T10:36:10.473Z
What field type is store hours? Can you add a screenshot of an example entry?
Oli
CC BY-SA 4.0
2021-02-02T21:12:44.430Z
The new field type is a radio button. The old field type was checkboxes
kenyabob
<craft3><database><field>
Need to populate new field based on existing data
# Need to populate new field based on existing data

(Asked by: username_0 on 2021-02-01)

Say I have a section called "Stores" that has an existing field called "Store Hours". The client has populated the store hours for 1000 some stores. Now, however, it seems what the client really wants is the ability to quickly see which stores are open on Sunday. So now I need to add a new field called "Open Sunday" and correctly filly its value for each store based on its existing hours.

What I've tried:
I've added a new field, and then wrote SQL to update the contents table to fill out the value of "Open Sunday" based on the "Store Hours", however, I need to manually re-save entries in order for my frontend queries to see the new "Open Sunday" value. Editing contents directly doesnt seem to let Craft know that the new field has a new value (possibly its saved in revisions or versions?).

\*This example is just that, an example. I do not need twig snippets in how I can derive what stores are open on Sunday from a story hours field.

**Tags:** craft3, database, field
> **Comments:**
> **username_1**: What field type is store hours? Can you add a screenshot of an example entry?  
> **username_0**: The new field type is a radio button. The old field type was checkboxes  

---

## 0 answers

