I want to define two fields in a table e.g 'name' and 'type' such that there in only unique record with certain value of name and certain value of type ; i.e. the name field value can repeat with different value in type but not with having the same type. How can I achieve this in Retool ?
i figured i can do this easily using sql editor ,not using the gui