Jump to content

Search the Community

Showing results for tags 'formula field'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Caspio Bridge
    • Caspio Apps for Ukraine
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start




Website URL






Found 3 results

  1. 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?
  2. 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?
  3. 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
  • Create New...