Hi I have a requirement I want to edit the prepopulated dropdown label name which will be coming from ref table and save that into other table. My first doubt is can we do that ?
Discussion posts and replies are publicly visible
Can you elaborate on your use case? Normally labels are not saved it database but the respective values are stored in fields in the table.
Yes as you said only Ids will be getting stored in the table. in my case also for a particular client some pre existing plans are coming from ref table which i will be showing in the drop down and User can select some plans from the dropdown and selected plan ids are getting stored into new client plan table. later using the query for I am displaying those plan in another task . this is easy normal flow. But now I want to edit the plan names which showing in the dropdown it should not affect the ref table value but to show in the other task it need to be edited.
Got it. In cases like this, generally below approach is followed :
In the reference table, include a value labelled 'Other'. If a user wants to input something that isn't available in the dropdown list, they can select 'Other' from the dropdown.
As a developer, when the user selects 'Other', you should display a text field near the dropdown. This allows the user to manually enter their custom value.
In the main data table where you store the selected dropdown value, you should save the ID corresponding to 'Other'. Additionally, you’ll need a separate column to store the custom value entered by the user in the text field.
Whenever 'Other' is selected, this custom value field becomes mandatory and must be filled in before the data can be saved.
In other tasks you can add an if condition checking if selected dropdown value relates to 'Other' then show the value from the related otherColumn in record else show the value from ref table.
Hope that clears things up!
Hi I think I failed to explain the requirements properly. ref table is not really like ref table its the main table also plan id plan name everything is there so for a particular client multiple plans lined for them is stored in there and it will used across multiple applications .If I add others then i need to add it for all the clients right. I want to edit the pre displaying plan name without affecting the original table .
In that case when you query the dropdown can you put a filter with particular client only 'Other' option is visible and not for others
iswarya2812 said:f I add others then i need to add it for all the clients right.