@Edgar_Butron Here’s why the formula shown in the screenshot will generate a blank value. The formula is as follows:
=concatenate([repair order], [operation])
When you add a new row into the table, both columns “Repair Order” and “Operation” are blank. As a result, when you combine their values together, you will end up with a blank value.
Also, I notice that you are using an app formula to compute the ID of the repair order. For IDs, it is highly recommended that you use Initial Value instead of App Formula to compute their values. This is because Initial Value is only evaluated once when the new row is first added to the table, which means that once the row has been added, the ID will not be recomputed and will remain the same. In contrast, app formulas are computed every time a row is added or edited. As a result, if an existing row is edited, and the values of columns “repair order” and “operation” are modified, the ID of the repair order will also be recomputed and modified accordingly. Since you probably don’t want the IDs of existing repair orders to change, you should use Initial Value instead of app formulas. You can read more about the difference between the 2 here:
help.appsheet.com - App Formulas and Initial Values App Formulas and Initial Values help.appsheet.com