Formula Field on Table

[Joemac]

Hello.  I need help creating a formula on a formula field within a table.

So I need the final value to equal something like this --       *F6464*   

The astericks are letter F are static values.  The 6464 is a value from an Autonumber field.  I just dont know the syntax to do this.  

So something just need the syntax to write something like   *F[drop_id]*

[TellMeWhy]

 

12 minutes ago, Joemac said:

Hello.  I need help creating a formula on a formula field within a table.

So I need the final value to equal something like this --       *F6464*   

The astericks are letter F are static values.  The 6464 is a value from an Autonumber field.  I just dont know the syntax to do this.  

So something just need the syntax to write something like   *F[drop_id]*

 

 

'*F' + CONVERT(Varchar,[drop_id]) + '*'

 

[Joemac]

@TellMeWhy --- so helpful thank you!

[Tubby]

Hi @Joemac,

You may also want to check this HowTo Article about Function Reference for other helpful formulas: https://howto.caspio.com/function-reference/

I hope it helps.

~Tubsss

[Joemac]

@Tubby -- thanks again.  so the CASE function is basically an if/than statement right?

[Kurumi]

Hi @Joemac - Yes, that's correct 

See these articles for reference:

https://howto.caspio.com/tables-and-views/data-types/formula-fields/
https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/