Used in a table, the mask column allows you to apply an input mask on the linked data.
Example of application
I have a set of heater models.
The references vary from one model to another, I need to retrieve 4 characters of the reference of the model in question to consolidate them in the same format.
To work, this feature requires at least 2 tables :
- A selection table carrying your Mask.
- A table applying the Mask.
1. Selection table that carries the mask
a. Start by listing your models.
b. Create the column of type Mask.
c. Fill in your input mask rules in front of each template.
I want to consolidate my references in 4 characters, no matter which model is selected.
- The references of model 1 are composed of 8 characters. I want to recover the last 4.
- The references of model 2 are composed of 10 characters. I want to retrieve the first 4.
- The references of model 3 are composed of 6 characters. I want to exclude the first and last character.
- The references of model 4 are composed of 6 characters. I want to retrieve the 2nd, the 4th and the 5th.
2. Input table that applies the mask
a. Create a Select (list from another table) pointing to your previously mentioned select table. Base your Selects on the column with your templates (here "Type").
b. Create a Text column. The template reference will be entered manually in this field.
c. Create a column of type Formula and select APPLY_MASK.
Configure your formula as follows :
In our case :
The formula will retrieve and apply the input mask depending on the model selected from the selection table. Your data is consolidated and reliable 🦾
Please sign in to leave a comment.