humidor

Caspio tell me I have an invalid column name when the "priority" field in your example is a 'list-string'? Is this a limitation? UPDATE - looks like so: http://howto.caspio.com/tables-and-views/data-types/list/ " At this time, List fields cannot be used in Rules, Charts, Pivot Tables, Grouping, Aggregations, Parameters, Formula Field, and Calculated Field. Lists will be supported in more areas in future releases." That is kind of a deal-killer for me, wonder if there's a workaround?

OK great. There is no way though, on the initial form/data page to see the dates (read only) that are calculated though? so the user can decide if they want to enter a preferable date into the separate field?

If I have fields setup to calculate based on a formula, is there a way to allow the field value to be overridden by a user? For example I may have a field where a default date is calculated by formula based on a submitted date. But I would like to allow users to be able to change that date if needed.

Great - is there also a way to allow the user to override the calculated value from a formula using the submission form? Seems like when these fields are created they cannot be added to the submission form?

I would like to have a form where a user submits a start date and a priority for a given customer. Based on what the user selects for the priority I want the table to generate a schedule (for customer service followups) from the given start date. For example a customer MARY and HIGH priority might generate followups 1 day, 5 days and 30 days after the start date. Alternately a customer JOHN with LOW priority might only generate followups 30 days, 60 days and 90 days after the start date. How best to set this up? I can see how to use formulae to create the folowup dates but how to vary the intervals based on priority setting?