kme Posted April 11, 2014 Report Share Posted April 11, 2014 Is there a way to create a search filter for a calculated field? Quote Link to comment Share on other sites More sharing options...
0 MayMusic Posted April 11, 2014 Report Share Posted April 11, 2014 Do you want to have calculated field on search? If yes, then it is not a standard feature yet. Post this request to http://ideabox.caspio.com Quote Link to comment Share on other sites More sharing options...
0 kme Posted April 11, 2014 Author Report Share Posted April 11, 2014 So there is no way to do it, whether with Javascript or..? Quote Link to comment Share on other sites More sharing options...
0 MayMusic Posted April 11, 2014 Report Share Posted April 11, 2014 It should be possible by programming for sure contact professional services team http://www.caspio.com/support/professional-services.aspx Quote Link to comment Share on other sites More sharing options...
0 kme Posted April 17, 2014 Author Report Share Posted April 17, 2014 Does anyone know of a workaround for this, without having to pay the support team for customization? Quote Link to comment Share on other sites More sharing options...
0 Jan Posted April 18, 2014 Report Share Posted April 18, 2014 Hello kme, I think, you can store the value of a Calculated field to the table and then work with it. It is not the best solution, but it is a solution. Quote Link to comment Share on other sites More sharing options...
0 kme Posted April 21, 2014 Author Report Share Posted April 21, 2014 How do you store the Calculated Field values into a table? I'd like it done automatically as the value is being calculated. Quote Link to comment Share on other sites More sharing options...
0 Jan Posted April 23, 2014 Report Share Posted April 23, 2014 I think, you can use a Java-script code, like this for example: Perform a calculation on values entered in a WebForm DataPage Quote Link to comment Share on other sites More sharing options...
0 Kurumi Posted April 29, 2019 Report Share Posted April 29, 2019 You could try using the Calculated Value in the Submission Form. Use the Submission as a Search Form then pass the parameter to the Reports DataPage. You can check the same workflow here: https://howto.caspio.com/tech-tips-and-articles/tech-parameters/how-to-separate-search-page-and-results-page-into-two-different-webpages/ I hope it helps! Quote Link to comment Share on other sites More sharing options...
0 DefinitelyNot31337 Posted July 7, 2019 Report Share Posted July 7, 2019 On 4/21/2014 at 10:58 AM, kme said: How do you store the Calculated Field values into a table? I'd like it done automatically as the value is being calculated. Hello. You must be looking for Formula Fields or Triggered Actions. https://howto.caspio.com/tables-and-views/data-types/formula-fields/ https://howto.caspio.com/tables-and-views/triggered-actions/ If the Calculated Field is processed using the other fields on the same record, you may use Formula Field. Otherwise, if you are referencing to data outside the row/record, you'd need to use a Triggered Action. Glitch 1 Quote Link to comment Share on other sites More sharing options...
Question
kme
Is there a way to create a search filter for a calculated field?
Link to comment
Share on other sites
9 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.