Format Control Text Field

I’m using Text Field Controls to automate some formulas/models

I’m able to format the formula outputs (into Currency format) - but i cannot find a way for format the Control Text Field (so the entered data is in Currency format)

Am i missing something?

Hi @Martyn_Thomas

I am afraid that is not possible. The text field is purely text, so you cannot format it.
For now, you can place the currency symbol before the text control. It’s not the nicest solution, but I think it’s the only way to achieve something similar at the moment.
Still, it’s a good suggestion to have the option to format the text control like table columns (allowing number, currency, and other formats).

Cheers,
Arnhold

1 Like

Thanks for letting me know - good to know i couldn’t find a feature because it isn’t there :slight_smile:

You could use a single cel table. For a small ‘app’ the overhead is not an issue. On a team plan you can use locking (for a single page or your complete doc) to use it a a text enter field.

With some creative use you could use one table for multiple inputs: you can hide columns, prevent the enter key from adding rows, etc. You can get the the number(s) or other input in a similar way as you would get the input from a text field, like:
InputTable.amount
or you can use a display column to give descriptions and retrieve the values in a way like this:
@CarCosts.amount

You can have a formatted column (amount) for currency values, you can have a text column for text values, etc.

It is not complicated to setup and it is simple to use of you use a consistent naming convention.

image

2 Likes