Repitition of Imported Data

I'm not understanding your question. Are you asking how to clear those fields after each test?

Each time I import and update existing records in my app, there are certain fields which tend to repeat the data.  I have attached examples of these two fields. They happen to be text fields and have the date logging on in their setting as a common trait. I would also like to clear these fields once I have clarity on how to avoid repetition.

I don't see an obvious way to avoid repetition when importing to a field with logging enabled, other than not importing into that field.  But then new records would be missing that field.

A suggestion is to import into that field, causing repetition, but then hide that field from most reports and forms, and instead use a formula text field to extract out the most current data. Then provide an alternate form for users to use (accessed by a URL formula button) to display those raw fields with the logging. So users would only use that alternate form if they needed to see the update history in that field.

Thanks. But the date being recorded is the same as you might have noticed.  Also how do I clear this field to have one final upload?

To clear the field , change the field type to a formula text field and then back to a text field.

What does that red button do next to the Save button?

It is a little button with some coding that allows to create a table of content on the side of the page where you can click and navigate to a real long form easily.  This is to get around the lack of native capability of QB to not to offer tabs in the forms.

Oh cool!  You can also add tabs to your form if you can add this button.

Really, how?

Here's a link that might help.  http://www.w3schools.com/howto/howto_js_tabs.asp
You can set up something similar to this in Quickbase.  My recommendation is to move out of the formula-text fields for your code as quickly as possible and use db pages instead for your html, css, and javascript.  That will substantially improve the readability of the code.

Now here's the awesome part, each form section comes with it's own id.  You can use that id in place of the id in the example of the link I provided.

If you want I can write you a formula-text field that do this for any form where the field is included.