Search the Community
Showing results for tags 'formula field'.
-
I have a formula field which calculates a number value perfectly but I'd like to add a letter to the front of the number so I assume that means I need to cast my result to a string. Here is my formula right now: SELECT MAX(Clean_Job) FROM tbl_ggl_job WHERE Job_Letter = 'CC') + 1 Which gets the max job number that is currently in use and adds 1 to that. So if the max job is CC100 this would return 101. I'd like to concatenate this with the Job Letter CC so that the result would look like CC101. How can I do this?
-
We just recently moved from Google to Caspio. I'm trying to find a way to recreate the same reporting we used in google and the report was created by an outside source. Right now, we are using a bar chart. I would like to do something similar to our previous reports.
-
Hello! I'm trying to set my formula field (concatenating two strings) as a lookup values for my list-string field, however, it seems that the formula field is missing in the dropdown options. Is that possible?
-
Hello - I have and Start_Date field with Data type Date/Time. I added another field that is call Renewal_date with Formula field data type. May I please ask for the formula to use in my Renewal_date field. For example: Start_Date - 07/15/2017 Expected Renewal Date should be = 07/15/2018