This FAQ covers 3 common question groups about the T function, mainly around parameter format, returned results, and nested usage.
FAQ
Is it normal for the T function to return an empty string?
- Check whether the input value is text.
- If the input is a number, logical value, or other non-text content, an empty string is a normal result.
- If needed, review the original field content type and then adjust the formula.
What should I do if the T function returns an error?
- Check whether the function name, parentheses, and parameter format are complete.
- Confirm that the referenced field or content is available in the current table.
- Save the formula again and review the result.
Can the T function be used with other functions?
- Enter the T function in the formula field first.
- Use the result of T as a parameter or condition in another function.
- Save the formula and review whether the combined formula returns the expected result.
Glossary
| Term | Definition |
|---|---|
| T function | A function that checks whether an input value is text and returns the text or an empty string. |
| Formula field | A field type in a multi-dimensional table that generates results automatically through a formula. |
| Empty string | A text result with a length of zero, usually shown as blank in the interface. |