Forum Discussion
Ok, so I have to use an intermediate Formula Text Field and write a formula to replace the text inside square brackets along with the brackets with a comma. How can I achieve that?
Let's say you have a field into which you import the additional text. Let's call it for now, [Additional Text]. << this is to be a normal, multi-line text field.
Let's create a formula text field, [Text field plus additional text]. << This is a 'formula text' field.
Inside the code for the formula text field, [Text field plus additional text], you will say,
[my current text field] & " any separator characters " & [Additional Text]
[My current text field] is whatever your current text field is whose "content" is to be appended to within your formula text field.
Your import spreadsheet would import only into [Additional Text]. Not any of the other two text fields.
You would create or modify existing reports using the formula text field, [Text field plus additional text]. In other words, your reports will use [Text field plus additional text].
Your current already in use text field would be for normal single record form input.
Does this make sense?