Jump to content
  • 0

Is there a CASPIO equivalent to an Access Update Query?


Question

I want to replace the blank values in a new field with the existing values in a different field

Example

Field OldJobCode is full for all employees but we are making modifications to how we do job codes to be pulled from a table instead of manually entered.  I would like to update the values in the field NewJobCode with what is presently in OldJobCode and one at a time is not viable.  

I've searched for this and not found a simple way to do this.

Thank you

Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0

@RossChevalierif you are simply trying to take the values from OldJobCode and put them in NewJobCode, you can utilize Tasks. Build a task just like a trigger. Use the UPDATE block and set it as 'On Demand'. Once you finish building it, click on Run Task and all of the records should be updated with New Job Code as the same as Old Job Code. 

UPDATE YourTable SET NewJobCode = OldJobCode WHERE NewJobCode is blank

 

Or you could export the table to Excel, copy over all of the values, and import them into the table. 

Link to post
Share on other sites
  • 0
5 hours ago, RossChevalier said:

I want to replace the blank values in a new field with the existing values in a different field

Example

Field OldJobCode is full for all employees but we are making modifications to how we do job codes to be pulled from a table instead of manually entered.  I would like to update the values in the field NewJobCode with what is presently in OldJobCode and one at a time is not viable.  

I've searched for this and not found a simple way to do this.

Thank you

This can only be done using Calculated Values as form elements wherein you use Select Statements to get the information of the desired field into the blank field. Also, Triggered actions may work. 

Calculated Values - Caspio Online Help

Triggered Actions - Caspio Online Help

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...