Joemac Posted July 23, 2021 Report Share Posted July 23, 2021 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]* Quote Link to comment Share on other sites More sharing options...
1 TellMeWhy Posted July 23, 2021 Report Share Posted July 23, 2021 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]) + '*' Quote Link to comment Share on other sites More sharing options...
0 Joemac Posted July 23, 2021 Author Report Share Posted July 23, 2021 @TellMeWhy --- so helpful thank you! Quote Link to comment Share on other sites More sharing options...
0 Tubby Posted July 24, 2021 Report Share Posted July 24, 2021 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 1 Quote Link to comment Share on other sites More sharing options...
0 Joemac Posted July 26, 2021 Author Report Share Posted July 26, 2021 @Tubby -- thanks again. so the CASE function is basically an if/than statement right? Quote Link to comment Share on other sites More sharing options...
0 Meekeee Posted July 26, 2021 Report Share Posted July 26, 2021 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/ Quote Link to comment Share on other sites More sharing options...
Question
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]*
Link to comment
Share on other sites
5 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.