# How to concatenate QR code scanning data and location data save into the database? **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** beginner\ **Created:** [April 11, 2022, 9:17am UTC](https://community.thunkable.com/t/how-to-concatenate-qr-code-scanning-data-and-location-data-save-into-the-database/1828325 "2022-04-11T09:17:38Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![vijayakumar.palanisa](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/vijayakumar.palanisa/32/130234_2.png) [@vijayakumar.palanisa](https://community.thunkable.com/u/vijayakumar.palanisa)\ **Post date:** [April 11, 2022, 9:17am UTC](https://community.thunkable.com/t/how-to-concatenate-qr-code-scanning-data-and-location-data-save-into-the-database/1828325/1 "2022-04-11T09:17:38Z")
![Screenshot 2022-04-11 144523](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/6/965c74fc75c941b4ea7104d158b50ad47e5a0dea.png) ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [April 11, 2022, 10:31am UTC](https://community.thunkable.com/t/how-to-concatenate-qr-code-scanning-data-and-location-data-save-into-the-database/1828325/2 "2022-04-11T10:31:52Z")
You’re not giving any information about your issue. Please explain what you expect the code to do and what it really did. ---
**Author:** ![vijayakumar.palanisa](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/vijayakumar.palanisa/32/130234_2.png) [@vijayakumar.palanisa](https://community.thunkable.com/u/vijayakumar.palanisa)\ **Post date:** [April 11, 2022, 10:38am UTC](https://community.thunkable.com/t/how-to-concatenate-qr-code-scanning-data-and-location-data-save-into-the-database/1828325/3 "2022-04-11T10:38:48Z")
I’m Creating the QR code scanned attendance report so we get embed QR code student details in email and student name, then we get location data and we save all the data for google sheet. now testing purpose I’m using stored email and user type, actually we replace the QR code scanned data in student name and email. our students training conduct for multiple venues so we want to location details, then current date and time. ![Student_Attendance](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/0/9088f926a2aa2508001ef2d6d7c0491953fc32a3.png) Like this ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [April 11, 2022, 11:27am UTC](https://community.thunkable.com/t/how-to-concatenate-qr-code-scanning-data-and-location-data-save-into-the-database/1828325/4 "2022-04-11T11:27:24Z")
> [@vijayakumar.palanisa](#): > > so we want to location details, then current date and time. Are you saying that the data is not being saved? You just explained your idea but has not said a word about what problem are you facing. ---
**Author:** ![vijayakumar.palanisa](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/vijayakumar.palanisa/32/130234_2.png) [@vijayakumar.palanisa](https://community.thunkable.com/u/vijayakumar.palanisa)\ **Post date:** [April 11, 2022, 11:28am UTC](https://community.thunkable.com/t/how-to-concatenate-qr-code-scanning-data-and-location-data-save-into-the-database/1828325/5 "2022-04-11T11:28:20Z")
Yeah @muneer data is not saving in our database ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [April 11, 2022, 11:31am UTC](https://community.thunkable.com/t/how-to-concatenate-qr-code-scanning-data-and-location-data-save-into-the-database/1828325/6 "2022-04-11T11:31:10Z")
Ok, At this stage, I would first remove the blocks you used for registering the `date` and `time` columns. and replace them by sample text such as ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/8/88343365e31b235ffcf2cea4e49f9e608a3d99b5.png) ---
**Author:** ![vijayakumar.palanisa](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/vijayakumar.palanisa/32/130234_2.png) [@vijayakumar.palanisa](https://community.thunkable.com/u/vijayakumar.palanisa)\ **Post date:** [April 11, 2022, 11:33am UTC](https://community.thunkable.com/t/how-to-concatenate-qr-code-scanning-data-and-location-data-save-into-the-database/1828325/7 "2022-04-11T11:33:04Z")
Ok i replace the blcok @muneer ---
**Author:** ![vijayakumar.palanisa](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/vijayakumar.palanisa/32/130234_2.png) [@vijayakumar.palanisa](https://community.thunkable.com/u/vijayakumar.palanisa)\ **Post date:** [April 11, 2022, 11:42am UTC](https://community.thunkable.com/t/how-to-concatenate-qr-code-scanning-data-and-location-data-save-into-the-database/1828325/8 "2022-04-11T11:42:43Z")
@muneer that’s not working ![Screenshot 2022-04-11 171110](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/1/c176c22dbb3efdb61e1aa6ca800ff32be75961a7.png) ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [April 11, 2022, 12:39pm UTC](https://community.thunkable.com/t/how-to-concatenate-qr-code-scanning-data-and-location-data-save-into-the-database/1828325/9 "2022-04-11T12:39:28Z")
You need to also fix these ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/e/ee2af75f6d82cc6c9d0cae9117fd3a31c8c58b7d.png) It should be like this ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/2/620b730afc25ad7f0fedfd817b94818155221e16.png) ---
**Author:** ![vijayakumar.palanisa](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/vijayakumar.palanisa/32/130234_2.png) [@vijayakumar.palanisa](https://community.thunkable.com/u/vijayakumar.palanisa)\ **Post date:** [April 11, 2022, 1:03pm UTC](https://community.thunkable.com/t/how-to-concatenate-qr-code-scanning-data-and-location-data-save-into-the-database/1828325/10 "2022-04-11T13:03:26Z")
@muneer No new result ![Screenshot 2022-04-11 182516](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/a/da3a2277a2c4a03b314bc984c55b7855ef83e09e.png) ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [April 11, 2022, 1:11pm UTC](https://community.thunkable.com/t/how-to-concatenate-qr-code-scanning-data-and-location-data-save-into-the-database/1828325/11 "2022-04-11T13:11:31Z")
I just made a quick project and tried this and it worked ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/5/1502817833f43046b09bf2e0ac939577dc8fc592.png) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/f/cff379e79ceb28fe6c2c8c6beb9d07e8cfeb419e.png) ---
**Author:** ![vijayakumar.palanisa](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/vijayakumar.palanisa/32/130234_2.png) [@vijayakumar.palanisa](https://community.thunkable.com/u/vijayakumar.palanisa)\ **Post date:** [April 11, 2022, 1:13pm UTC](https://community.thunkable.com/t/how-to-concatenate-qr-code-scanning-data-and-location-data-save-into-the-database/1828325/12 "2022-04-11T13:13:27Z")
@muneer Ok I will try this function ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [April 11, 2022, 1:14pm UTC](https://community.thunkable.com/t/how-to-concatenate-qr-code-scanning-data-and-location-data-save-into-the-database/1828325/13 "2022-04-11T13:14:46Z")
Remeber, **Location** green block does not actually have a name pf a place but rather other numbers. ---
**Author:** ![vijayakumar.palanisa](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/vijayakumar.palanisa/32/130234_2.png) [@vijayakumar.palanisa](https://community.thunkable.com/u/vijayakumar.palanisa)\ **Post date:** [April 11, 2022, 1:18pm UTC](https://community.thunkable.com/t/how-to-concatenate-qr-code-scanning-data-and-location-data-save-into-the-database/1828325/14 "2022-04-11T13:18:59Z")
@muneer ok but how we are getting the location name. we don’t want to the number. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [April 11, 2022, 1:31pm UTC](https://community.thunkable.com/t/how-to-concatenate-qr-code-scanning-data-and-location-data-save-into-the-database/1828325/15 "2022-04-11T13:31:34Z")
> [@vijayakumar.palanisa](#): > > how we are getting the location name Thunkable does not have a component for this so you need to use one of the API calls for reverse lookup or use this API to get the city name ```auto http://www.geoplugin.net/json.gp ``` If you want it through Google then use this example `https://maps.googleapis.com/maps/api/geocode/json?latlng=40.714224,-73.961452&key=YOUR_API_KEY` You will need to have an API Key first See [this link](https://developers.google.com/maps/documentation/geocoding/requests-reverse-geocoding) ---
**Author:** ![vijayakumar.palanisa](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/vijayakumar.palanisa/32/130234_2.png) [@vijayakumar.palanisa](https://community.thunkable.com/u/vijayakumar.palanisa)\ **Post date:** [April 12, 2022, 4:19am UTC](https://community.thunkable.com/t/how-to-concatenate-qr-code-scanning-data-and-location-data-save-into-the-database/1828325/16 "2022-04-12T04:19:11Z")
@muneer thank you, I will chase the result 🙂 [Reverse Geocoding App - Get Location from Latitude/Longitude](https://community.thunkable.com/t/reverse-geocoding-app-get-location-from-latitude-longitude/82343) ---
**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\ **Post date:** [July 11, 2022, 4:20am UTC](https://community.thunkable.com/t/how-to-concatenate-qr-code-scanning-data-and-location-data-save-into-the-database/1828325/17 "2022-07-11T04:20:02Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.