Jump to content

Setting a field value before import


This topic is 6566 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Is there a way to pre-set a value for one field before importing records, such that this new value would populate that field for each new record.

I have a list of standard tasks in one table. I would like to be able to change the name of a particular WORKER on the fly, then import a list of tasks with his name entered into the WORKER field.

The list of tasks would be imported as a list of constants, but the name field would be variable, before the import.

I hope I explained this right.

Any ideas?

Jarvis

Link to comment
Share on other sites

One way to do this is to create a global field in the Tasks table for the worker. Set or choose the worker, then import the global along with the regular task fields. It will be the same value for all imported records.

Link to comment
Share on other sites

Thanks Fenton!

I hadn't considered changing the imported data with a global field. For some reason I was thinking this would come under an auto enter type function. I might also have been suffering coffee deficit at the time.

I will look into what you suggest.

Jarvis

Link to comment
Share on other sites

This topic is 6566 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.