# Seting column value when login **URL:** \ **Category:** Ask for Help\ **Created:** [November 17, 2024, 7:01am UTC](https://community.glideapps.com/t/seting-column-value-when-login/77965 "2024-11-17T07:01:54Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Emmanuel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emmanuel/32/82002_2.png) [@Emmanuel](https://community.glideapps.com/u/Emmanuel)\ **Post date:** [November 17, 2024, 7:01am UTC](https://community.glideapps.com/t/seting-column-value-when-login/77965/1 "2024-11-17T07:01:54Z")
Hello Gliders ! I’m using a user specific reference date and I would like it to be reseted to today at every new user login or first table view (dashboard)… Would you know how to do that by any chance ? 🙏 ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [November 17, 2024, 7:15am UTC](https://community.glideapps.com/t/seting-column-value-when-login/77965/2 "2024-11-17T07:15:58Z")
You can configure all tabs visibility to off if start date( in the user’s row) is empty and just visible single wellcome tab with button which set start date ---
**Author:** ![Emmanuel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emmanuel/32/82002_2.png) [@Emmanuel](https://community.glideapps.com/u/Emmanuel)\ **Post date:** [November 17, 2024, 7:42am UTC](https://community.glideapps.com/t/seting-column-value-when-login/77965/3 "2024-11-17T07:42:09Z")
Thanks ! that’s a good idea ! I take it and will think of doing something like that if I don’t find better Glide solution, because then users get welcome message and must do one useless click every single time they log in . ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [November 17, 2024, 8:09am UTC](https://community.glideapps.com/t/seting-column-value-when-login/77965/4 "2024-11-17T08:09:02Z")
Unfortunately no native solution for now. Another approach you can add this set column to each custom action(details screen and so on) with condition. Another one: if you use Google sheet as data source, you can see user login table and you can create Google script which can set date as you need ---
**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:** [November 17, 2024, 8:53am UTC](https://community.glideapps.com/t/seting-column-value-when-login/77965/5 "2024-11-17T08:53:47Z")
What is this date value actually used for? A filter? There is no way to trigger an action on login, so that option is basically out of the question. A simple option might be to add a “Reset” button that the user can click on that would reset the value to the current date. ---
**Author:** ![Emmanuel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emmanuel/32/82002_2.png) [@Emmanuel](https://community.glideapps.com/u/Emmanuel)\ **Post date:** [November 18, 2024, 6:42am UTC](https://community.glideapps.com/t/seting-column-value-when-login/77965/6 "2024-11-18T06:42:44Z")
Yes this date is registered in Glide table to be used in different filters in the app during user’s session ; it would be very usefull to be able to triger action before first Table appears or after login, so that we can reset previous session temporary datas or other context things… Any way for now I use a botton action Thank you guys ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/1/41fd958066d3fd7e6bf72ee62625365ea7882917.jpeg) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 19, 2024, 12:06am UTC](https://community.glideapps.com/t/seting-column-value-when-login/77965/7 "2024-11-19T00:06:50Z")
Would it always be today? Is it the “en date du” field you’re showing on the screen? ---
**Author:** ![Emmanuel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emmanuel/32/82002_2.png) [@Emmanuel](https://community.glideapps.com/u/Emmanuel)\ **Post date:** [November 19, 2024, 12:34am UTC](https://community.glideapps.com/t/seting-column-value-when-login/77965/8 "2024-11-19T00:34:17Z")
yes, to be reset to today for every starting session. So, for now, I add a ‘change to Today’ button when value is not today (from previous session and other app page) … But this makes my Dashboard too heavy ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 19, 2024, 1:54am UTC](https://community.glideapps.com/t/seting-column-value-when-login/77965/9 "2024-11-19T01:54:22Z")
I’m thinking something very hacky that might require workflows. - A column for “Logged in Today?” as a boolean. - Your normal “En Date Du” field. - Create an AI Component that looks at those two columns above, if “Logged in Today?” is not checked, then set the current date to “En Date Du”, else keep “En Date Du” as is. - Add a workflow that clears the “Logged in Today?” boolean every day at midnight. ---
**Author:** ![Emmanuel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emmanuel/32/82002_2.png) [@Emmanuel](https://community.glideapps.com/u/Emmanuel)\ **Post date:** [November 19, 2024, 5:02am UTC](https://community.glideapps.com/t/seting-column-value-when-login/77965/10 "2024-11-19T05:02:30Z")
woaw, I did not know we can triggered workflow automatically on a schedule, that is already a good solution to just reset my date column every night ! I don’t know much about what we can do with AI component yet, I’m still duscovering Glide possibilities… thanks ---
**Author:** ![Emmanuel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emmanuel/32/82002_2.png) [@Emmanuel](https://community.glideapps.com/u/Emmanuel)\ **Post date:** [November 19, 2024, 5:19am UTC](https://community.glideapps.com/t/seting-column-value-when-login/77965/11 "2024-11-19T05:19:25Z")
I have to work on it ; I’m not able to set ‘dateref’ column to today for all rows (using a filter) and at a scheduled time. Your welcome if you have more advises… ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/a/3a4f432b43592499e42e162c92fa1039253a11d5.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 19, 2024, 8:11am UTC](https://community.glideapps.com/t/seting-column-value-when-login/77965/12 "2024-11-19T08:11:51Z")
What plan are you on? At the moment the time-based workflows are in Closed Beta. ---
**Author:** ![Emmanuel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emmanuel/32/82002_2.png) [@Emmanuel](https://community.glideapps.com/u/Emmanuel)\ **Post date:** [November 20, 2024, 8:35pm UTC](https://community.glideapps.com/t/seting-column-value-when-login/77965/13 "2024-11-20T20:35:39Z")
free (implementing and testing) hopefully soon maker… ---
**Author:** ![Atom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/atom/32/82126_2.png) [@Atom](https://community.glideapps.com/u/Atom)\ **Post date:** [November 20, 2024, 11:55pm UTC](https://community.glideapps.com/t/seting-column-value-when-login/77965/14 "2024-11-20T23:55:26Z")
I saw this post in the Slack channel but can’t seem to find it in the Resource tab: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/f/bf3ac5cf79cc805100a3f1195191d23c37ef74f4.png) ---
**Author:** ![Atom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/atom/32/82126_2.png) [@Atom](https://community.glideapps.com/u/Atom)\ **Post date:** [November 20, 2024, 11:57pm UTC](https://community.glideapps.com/t/seting-column-value-when-login/77965/15 "2024-11-20T23:57:56Z")
I’m dumb. I just now realized it’s the prompt you need to use in a Custom AI component and it will trigger the action. Let me know if you guys have any luck with it! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 20, 2024, 11:59pm UTC](https://community.glideapps.com/t/seting-column-value-when-login/77965/16 "2024-11-20T23:59:08Z")
That’s a pretty neat idea from @MaximeBaker . I guess there’s another layer of difficulty in here, that Emmanuel only needs it to trigger on the first run of the day. - Add a column for First Login Today as a timestamp. - Add an if-then-else column called “Logged In Today?”, if First Login Today is within today then true, else false. - Only trigger setting the current day to the “En Date Du” field when “Logged In Today?” is not checked, and then also set the current timestamp to “First Login Today”. Else don’t do anything. ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [November 21, 2024, 12:16am UTC](https://community.glideapps.com/t/seting-column-value-when-login/77965/17 "2024-11-21T00:16:07Z")
Here it is @Atom > [@Auto Action trigger](https://community.glideapps.com/t/auto-action-trigger/77525): > > I made a prompt that allow an action to be triggered on page load. I attempted to create a prompt that allows the AI component to perform an action on load after a delay of 100 ms. While I couldn’t get it to work with the provided delay value, it still enables us to make the AI execute a custom action upon page load. Here is the prompt : 1. In the \*\*DATA\*\* section, define only the `Delay` property with a milliseconds value. 2. On component load, automatically retrieve the `Delay` property. If… I don’t see it in the Expert Hub either. ---
**Author:** ![slscustom.ru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/slscustom.ru/32/77336_2.png) [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)\ **Post date:** [November 21, 2024, 10:40am UTC](https://community.glideapps.com/t/seting-column-value-when-login/77965/18 "2024-11-21T10:40:57Z")
> [@Auto Action trigger](https://community.glideapps.com/t/auto-action-trigger/77525/1): > > I made a prompt that allow an action to be triggered on page load. Excelent idea, but for now we need keep in mind: custom Ai component still in beta and some time works as expected, but some times looks like black rectangle ---
**Author:** ![Emmanuel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emmanuel/32/82002_2.png) [@Emmanuel](https://community.glideapps.com/u/Emmanuel)\ **Post date:** [November 24, 2024, 7:48am UTC](https://community.glideapps.com/t/seting-column-value-when-login/77965/19 "2024-11-24T07:48:53Z")
> [@Auto Action trigger](https://community.glideapps.com/t/auto-action-trigger/77525/1): > > ```auto > 1. In the **DATA** section, define only the `Delay` property with a milliseconds value. > 2. On component load, automatically retrieve the `Delay` property. If the property is not set, use a default value of 100 milliseconds. > 3. Use the retrieved `Delay` property to start a `setTimeout` function. > 4. After the specified delay: > a. Dispatch the **Show Notification** action from the **action** section. > 5. The **Show Notification** action must be defined in the **action** section. > 6. There will be no visual elements, start, or stop button; the action will trigger automatically without any manual intervention. > 7. Ensure that all code runs within the component's secure context to avoid violations of Content Security Policy (CSP) and prevent loading external scripts. > > ``` Hello ! this is just what I needed ! I could succeed in initializing filter date value automaticaly and only after first login with this AI component prompt 🙏 1. In the **DATA** section, define only the `Delay` property with a milliseconds value. 2. On component load, automatically retrieve the `Delay` property. If the property is not set, use a default value of 100 milliseconds. 3. Use the retrieved `Delay` property to start a `setTimeout` function. 4. After the specified delay: execute all actions. 5. There will be no visual elements, start, or stop button; all actions will trigger automatically without any manual intervention. 6. Ensure that all code runs within the component’s secure context to avoid violations of Content Security Policy (CSP) and prevent loading external scripts. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/5/f5a2d845c1cef406a45812c3b9851c9d0454cc57.png) many thanks for having shared you knowledge and thinking ! ---
**Author:** ![Emmanuel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emmanuel/32/82002_2.png) [@Emmanuel](https://community.glideapps.com/u/Emmanuel)\ **Post date:** [November 25, 2024, 3:20am UTC](https://community.glideapps.com/t/seting-column-value-when-login/77965/20 "2024-11-25T03:20:19Z")
it just came out Glide scheduled workflows ; I guess this topic was convincing ! 🙂 > **[Introduction to Workflows | Glide Docs](https://www.glideapps.com/docs/automation/workflows)** > > Create complex automations with a variety of triggers. [Next page](https://community.glideapps.com/t/seting-column-value-when-login/77965.md?page=2)