# Possible bug : pulling in incorrect data

**URL:** <https://community.glideapps.com/t/possible-bug-pulling-in-incorrect-data/65292>\
**Category:** Ask for Help\
**Created:** [August 23, 2023, 1:00am UTC](https://community.glideapps.com/t/possible-bug-pulling-in-incorrect-data/65292 "2023-08-23T01:00:57Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\
**Post date:** [August 23, 2023, 1:00am UTC](https://community.glideapps.com/t/possible-bug-pulling-in-incorrect-data/65292/1 "2023-08-23T01:00:57Z")

</div>

I am having this crazy issue, so not sure if it is an issue with my understanding.

In the builder I am trying to diagnose an issue, but this data at the bottom does not reflect the data I am inserting/generating in the above screen. It seems like it is pulling in the first record from table (22nd March).

The issue I am having is that I am trying to generate a jobID, shown as 1043440  
The job ID is a concat (template) of employID(104) and a nextNum (3440), however the issue I am having is that the current employee logged in is DAN (101) and not adesh(104) who is being pulled in from the first record in the table.

It doesn’t matter which user I select the prefix 104 doesn’t change, and this is the same issue when testing from a mobile app.

Any thoughts ?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/d/4dcf994b22105fc0dbedc72af2d80d5b03ca3bb9.jpeg)

After the record is inserted, then it gives me the correct employee ID (101), but by then its too late because the JOBID has already been generated and inserted with the (104) prefix. Resulting in all jobs with a 104 prefix.

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [August 23, 2023, 1:09am UTC](https://community.glideapps.com/t/possible-bug-pulling-in-incorrect-data/65292/2 "2023-08-23T01:09:52Z")

</div>

Can you show the configuration of the template? Are you sure it’s referring to properties of the current user and not the current 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:** [August 23, 2023, 1:28am UTC](https://community.glideapps.com/t/possible-bug-pulling-in-incorrect-data/65292/3 "2023-08-23T01:28:44Z")

</div>

~~What you are trying to do won’t work, because the data isn’t available for the template until _after_ the form is submitted, by which time it is too late.~~

 

~~To do what you want to do, you will need to use a Custom Form. Then the values that are entered/selected will be held in User Specific columns, and your template will be able to use them.~~

Edit: the above is incorrect in this case. See below 👇

---

<div class="post-metadata">

**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\
**Post date:** [August 23, 2023, 1:34am UTC](https://community.glideapps.com/t/possible-bug-pulling-in-incorrect-data/65292/4 "2023-08-23T01:34:37Z")

</div>

🤯

I think what David directed me to worked. I was pulling the data from the row, but now I changed it to pull the employeeID from the profile-\>empID I am now getting the correct information. I will do some stress testing and see if it is stable. (never stop learning).

@Darren_Alderman, I also think you are correct, that is what I think I was seeing, but now that I am looking that the profile-empID, the correct employeeID is being pulled for the prefix. As I change my user in the builder, it is changing the ID.

Let me know if you need more context.

---

<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:** [August 23, 2023, 1:39am UTC](https://community.glideapps.com/t/possible-bug-pulling-in-incorrect-data/65292/5 "2023-08-23T01:39:09Z")

</div>

> [@Dan\_San](#):
>
> I was pulling the data from the row, but now I changed it to pull the employeeID from the profile-\>empID I am now getting the correct information.

ah yes, that will work 👍

I didn’t read what David wrote (or process what you wrote) properly. As long as you’re not trying to use anything from the form screen for the template, then you should be okay.

---

<div class="post-metadata">

**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\
**Post date:** [August 23, 2023, 1:44am UTC](https://community.glideapps.com/t/possible-bug-pulling-in-incorrect-data/65292/6 "2023-08-23T01:44:17Z")

</div>

yep… i confused myself a few times writing it so kudos to David.

Also my PHPdevs AND the client can not believe that I managed to get such rapid support at 9pm at night from a community forum, what is blowing their mind is that I got support from the CEO 🙂

Thanks David/Darren

---

<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:** [August 30, 2023, 1:44am UTC](https://community.glideapps.com/t/possible-bug-pulling-in-incorrect-data/65292/7 "2023-08-30T01:44:36Z")

</div>

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