# Timestamp approval in the same row

**URL:** <https://community.glideapps.com/t/timestamp-approval-in-the-same-row/61993>\
**Category:** Ask for Help\
**Created:** [May 22, 2023, 3:03am UTC](https://community.glideapps.com/t/timestamp-approval-in-the-same-row/61993 "2023-05-22T03:03:12Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![CuriousGeorge](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/curiousgeorge/32/59363_2.png) [@CuriousGeorge](https://community.glideapps.com/u/CuriousGeorge)\
**Post date:** [May 22, 2023, 3:03am UTC](https://community.glideapps.com/t/timestamp-approval-in-the-same-row/61993/1 "2023-05-22T03:03:12Z")

</div>

Hello!

I want to make timestamp for my approval system that generate when the user editing the status in Glide. There are 3 roles with different level like level 1, level 2, and level 3. When the user with level 1 editing the request status to approve, it will generate a timestamp in the timestamp approval level 1 column. Also, the same process for the user level 2. Every approval from level 1 until level 3 will have their own timestamp approval column and this happen on the same data or same row,

I’ve already made the approval system, but the timestamp will always changing and following the new role that editing the status. So for now, I have 3 timestamp columns with the same value. Any good suggestion? Thank you!

---

<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 22, 2023, 3:11am UTC](https://community.glideapps.com/t/timestamp-approval-in-the-same-row/61993/2 "2023-05-22T03:11:06Z")

</div>

How are you currently setting the timestamps?  
Can you show a screen shot?

Based on your description, it sounds like you might need a custom action with conditional branches based on the signed in users role.

---

<div class="post-metadata">

**Author:** ![CuriousGeorge](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/curiousgeorge/32/59363_2.png) [@CuriousGeorge](https://community.glideapps.com/u/CuriousGeorge)\
**Post date:** [May 22, 2023, 3:13am UTC](https://community.glideapps.com/t/timestamp-approval-in-the-same-row/61993/3 "2023-05-22T03:13:20Z")

</div>

I’m just using special value for the timestamp in every roles view

---

<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 22, 2023, 3:17am UTC](https://community.glideapps.com/t/timestamp-approval-in-the-same-row/61993/4 "2023-05-22T03:17:06Z")

</div>

Is this with an edit form?

Probably what you need to do is change that and use an onSubmit custom action instead. The action setup would be something like:

- If User Profile → Role is Level 1  
– Set Column Values → Level 1 Approval Time → Current date/Time
- Else if User Profile → Role is Level 2  
– Set Column Values → Level 2 Approval Time → Current date/Time
- Else if User Profile → Role is Level 3  
– Set Column Values → Level 3 Approval Time → Current date/Time

---

<div class="post-metadata">

**Author:** ![CuriousGeorge](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/curiousgeorge/32/59363_2.png) [@CuriousGeorge](https://community.glideapps.com/u/CuriousGeorge)\
**Post date:** [May 22, 2023, 3:21am UTC](https://community.glideapps.com/t/timestamp-approval-in-the-same-row/61993/5 "2023-05-22T03:21:46Z")

</div>

It is an edit form because I want to edit the same row. Okay, I’ll try that first

---

<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 22, 2023, 3:26am UTC](https://community.glideapps.com/t/timestamp-approval-in-the-same-row/61993/6 "2023-05-22T03:26:24Z")

</div>

Just to be clear, I wasn’t suggesting that you get rid of your Edit Form.  
You can still use that, but instead of setting the timestamp in every column using the special value, do it as an onSubmit action and only set the appropriate column based on the signed in users role.

---

<div class="post-metadata">

**Author:** ![CuriousGeorge](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/curiousgeorge/32/59363_2.png) [@CuriousGeorge](https://community.glideapps.com/u/CuriousGeorge)\
**Post date:** [May 22, 2023, 4:49am UTC](https://community.glideapps.com/t/timestamp-approval-in-the-same-row/61993/7 "2023-05-22T04:49:05Z")

</div>

I just try your suggestion and it works. Thank you for your help @Darren_Murphy !

---

<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:** [May 23, 2023, 4:49am UTC](https://community.glideapps.com/t/timestamp-approval-in-the-same-row/61993/8 "2023-05-23T04:49:41Z")

</div>

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