Can we copy formulas when we create new tables?
We utilize TrackVia for research and the copy table function was very useful in Classic because we could choose to copy formulas and they'd all come over without data. Is there a work around. Is this in the mix for an improvement?
Justin Mauldin commented
Thank you for reaching out to us with your question.
Currently, in the new 2.0 system, we have the ability to copy tables. You just go into the "Edit Table" under the "Toggle View Options" button and click "Save As". This will copy your table for you.
However, we do not copy over any "Calculated", "Triggered" or any relationship fields that were created in the original table. You would then need to open the two tables side-by-side and copy and paste (most) formulas into a new field in the new copied table.
The ability to copy over formulas in Calculated and Triggered field types is not currently in the mix for an enhanced feature request, as we found that this can very easily corrupt your table.
Hope this helps!