Hi ,
I want to add a text box in a dashboard panel and the manual input value of that textbox should be added to a new column in an already existing table.
I understand that this can be done by lookup to save the values but i am not sure how to go ahead with it.
This is the data format of the table i have with sample data(the original data i have is confidential).
NAME | IP | ID(new column) | |
nish123@gmail.com | Nishanth | 10.10.10.0 | |
abc098@gmail.com | ABC | 224.0.0.0 | |
amit187@gmail.com | Amit Sharma | 63.125.0.0 |
I want to add a text box to this panel whose values should be inputted into ID column based on the unique value of EMAIL.
and i want to save this table with the new values of ID.
How can this be done?? Any help would be appreciated.thanks