# Two columns cause updates in other columns

**URL:** <https://community.glideapps.com/t/two-columns-cause-updates-in-other-columns/42557>\
**Category:** Ask for Help\
**Created:** [May 30, 2022, 10:54pm UTC](https://community.glideapps.com/t/two-columns-cause-updates-in-other-columns/42557 "2022-05-30T22:54:00Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![rleinen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rleinen/32/43270_2.png) [@rleinen](https://community.glideapps.com/u/rleinen)\
**Post date:** [May 30, 2022, 10:54pm UTC](https://community.glideapps.com/t/two-columns-cause-updates-in-other-columns/42557/1 "2022-05-30T22:54:00Z")

</div>

I’m wondering if it is possible to do the following when new record is submitted:

If one column (Assigned To) has a value then put current date in Assigned Date

and ALSO in the same record

if a second column (Completed By) has a value then put the current date in Completed Date.

So I have two conditions that need to be looked at and responded to.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [May 31, 2022, 12:51am UTC](https://community.glideapps.com/t/two-columns-cause-updates-in-other-columns/42557/2 "2022-05-31T00:51:31Z")

</div>

It’s possible, but it’s a bit tedious. If the newly submitted record is from a form, then create an “On Submit” custom action\>

If Assigned to is not empty AND Completed by is empty \> set column Assigned Date \> current date and time

else if Assigned to is not empty AND Completed by is not empty \> set column Assigned Date \> current date and time & set column Completed Date \> current date and time

else if Assigned to is empty AND Completed by is not empty \> set column Completed Date \> current date and time

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [May 31, 2022, 1:32am UTC](https://community.glideapps.com/t/two-columns-cause-updates-in-other-columns/42557/3 "2022-05-31T01:32:00Z")

</div>

This is a use case where a Custom Form would make it a bit easier. You could prepare the date values prior to the form being submitted and then add the lot in one go. Although, there is extra work involved in creating a custom form, so maybe that offsets the effort saved with the action logic 🤪

---

<div class="post-metadata">

**Author:** ![rleinen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rleinen/32/43270_2.png) [@rleinen](https://community.glideapps.com/u/rleinen)\
**Post date:** [May 31, 2022, 5:14pm UTC](https://community.glideapps.com/t/two-columns-cause-updates-in-other-columns/42557/4 "2022-05-31T17:14:36Z")

</div>

Thank you, Robert! You’re right, not pretty, but brilliant, that will work.

---

<div class="post-metadata">

**Author:** ![rleinen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rleinen/32/43270_2.png) [@rleinen](https://community.glideapps.com/u/rleinen)\
**Post date:** [May 31, 2022, 5:16pm UTC](https://community.glideapps.com/t/two-columns-cause-updates-in-other-columns/42557/5 "2022-05-31T17:16:55Z")

</div>

Darren, thanks for the reply. I’m not quite sure how that works. I am a newbie so not real clear on the custom forms. I just did the “Show Form Screen” to add a new row.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [May 31, 2022, 6:00pm UTC](https://community.glideapps.com/t/two-columns-cause-updates-in-other-columns/42557/6 "2022-05-31T18:00:15Z")

</div>

I wouldn’t worry about it, my response was slightly tongue in cheek 😉

The option that Bob gave you is perfectly fine 👍

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [June 1, 2022, 6:00pm UTC](https://community.glideapps.com/t/two-columns-cause-updates-in-other-columns/42557/7 "2022-06-01T18:00:55Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.