Using Formula in Primary Column

Avatar

By Anjali Daga

updated about 1 month ago

Formulas in Stackby can save you time by calculating data automatically by combining columns contents in a Table.

A Primary key is a column in a table which uniquely identifies each row in a table. Primary
 keys must contain unique values. 

If you want to create an ID in the primary column by combining two or more columns, you can use that using CONCAT () formula. 

Using CONCAT formula in Primary Column

Here CONCAT() is used to combine First Name and Last Name Column.

Example :-

 CONCAT({First Name} ,"  " , {Last Name})

One more example :-

 CONCAT({Product Name},{Product Code})


Did this answer your question?