There are many document editing solutions on the market, but only a few are suitable for all file formats. Some tools are, on the contrary, versatile yet burdensome to work with. DocHub provides the solution to these hassles with its cloud-based editor. It offers powerful capabilities that enable you to accomplish your document management tasks efficiently. If you need to quickly Tweak formula in 1ST, DocHub is the best choice for you!
Our process is incredibly straightforward: you import your 1ST file to our editor → it automatically transforms it to an editable format → you make all essential adjustments and professionally update it. You only need a few minutes to get your paperwork done.
Once all changes are applied, you can turn your paperwork into a reusable template. You only need to go to our editor’s left-side Menu and click on Actions → Convert to Template. You’ll find your paperwork stored in a separate folder in your Dashboard, saving you time the next time you need the same template. Try out DocHub today!
heres how you can alter the value of a column using inline formulas in macro so here we have a schema that represents people its got a primary key which is an ID first name and last name and gender if we take a look at the type of data this generates you can see that gender is either male or female the full word capitalized and what if we didnt what if we want a gender but we didnt want that particular format for example lets say we wanted to just have M or F instead of male and female so we can tweak the value of that field by clicking the formula button here and then what formulas allow us to do is basically do any kind of transformation of a field using Ruby syntax so we can get at the value of the current field through this and then if we wanted to lets say just take the first character of that field we can use Rubys string syntax just doing this at 0 so strings are like arrays in Ruby so if I apply this and then run our preview you can see we no longer have the full word ma