How do you reduce database size by deleting unused fields?
How do you reduce database size by deleting unused fields?
| Answer | Delete the fields before the doc is saved by adding code like this to the fields' translation formula:
@If (x=""; @DeleteField; x)
Make sure the x's are exactly the field name, or you will loose data.
Do not delete fields if they are used in other formulas. |
| Attachments | -none- |
| Applies to versions | 3.x; 4.x; 5.x; 6.x |
| FAQ Provided By | ken yee |
| Credit | Click here for information source |
 | |
|
|