There are many document editing tools on the market, but only a few are compatible with all file formats. Some tools are, on the contrary, versatile yet burdensome to use. DocHub provides the answer to these issues with its cloud-based editor. It offers rich functionalities that allow you to accomplish your document management tasks effectively. If you need to promptly Tweak formula in INFO, DocHub is the best option for you!
Our process is very easy: you import your INFO file to our editor → it automatically transforms it to an editable format → you make all required adjustments and professionally update it. You only need a few minutes to get your paperwork done.
When all adjustments are applied, you can turn your paperwork into a multi-usable 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
