cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

personal presets for "new formula column" right click menu

I often have to apply the same formula to correct input data.

Is there a way to define a list of personal formula presets that can be quickly used via the "new formula column" right click menu?

 

e.g. 

Num(Substitute( ..., ",","."))

to convert columns with comma decimal separator to numbers - just with a single click.

(Very convernient till there will be some settings to choose in the separator in the csv input dialog

 

4 Comments
Status changed to: Acknowledged

@hogi - Thank you for your suggestion! We have captured your request and will take it under consideration.

Status changed to: Investigating
 

Hi @hogi! I wanted to make sure you are aware that you can define a custom function and this allows you to add it to the new formula menu. You have to define the custom function in your startup.jsl or an addin (because the definition doesn’t persist). Would this fulfill your request? 

hogi
Level XI

Hi Sarah,

 

custom functions are fine.
I fond them after filing the request.

 

The request can be closed.