Assign RFID Code to an employee #10348
-
Hello everyone, in advance I am not an extremely experienced Budibase user. I have an RFID scanner at the entrance of the production facility where employees can clock in and out at the beginning and end of their shifts for timekeeping purposes. The ID from the chip is directly written into a table with the date and time using the Budibase webhook trigger (Python Script - POST Request). However, I also want to automatically assign a name to the stamp number in the table. I have a database where the name is listed with the corresponding stamp number. Now, I want the name of the person who stamped their card to be automatically written into the table with the webhook. I think it is certainly simple to solve but I do not get on, thanks for the help in advance ! |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 2 replies
-
Hey @Den4ik1992, I'm assuming you are using the Budibase data source. As I can't see the automation you are running, I'll describe what needs to be done as best I can. First in your employees table can you make sure the Employee column has the toggle switched on for Click this and it should open a modal window, you can find the toggle Use as table display column here click it and then save. From here, I'd recomend deleting the employee column in your main table and re-adding it as a relationship field. I'd suggest a one to many relationship, where one employee can have many Time Entries (Not sure on what your main table is called). After the above, lets head back to your automation with the web-hook.
Test and save and this should do what you want! Optionally you don't have to create relationships between the tables. You could do a similar process without relationships and take the string name of the employees table and add this into the text field you currently have. Hopefully this makes sense and helps you! |
Beta Was this translation helpful? Give feedback.
Hey @Den4ik1992,
I'm assuming you are using the Budibase data source. As I can't see the automation you are running, I'll describe what needs to be done as best I can.
First in your employees table can you make sure the Employee column has the toggle switched on for
Use as table display column. This can be done by hovering over the column name within the table the pencil icon. (Screenshot below.)
Click this and it should open a modal window, you can find the toggle Use as table display column here click it and then save.
From here, I'd recomend deleting the employee column in your main table and re-adding it as a relationship field. I'd suggest a one to many relationship, where one empl…