How To Update A Single Record With A Datapage Redirect

[svearvaldyr]

Hi - this appears to be a solution to many issues, so I need to figure out how to direct a form submission to a different datapage so that it updates one or more fields automatically.  There are two main instances where i want to do this: 

1. I have a new user form which creates a user_ID autonumber and passes it as an external paramater, I have fields for First_name and Last_name (both passing as external parameters on exit) and want to then create a full name by sticking them together.  The way I presumed to do this was to direct to a 'Name creation' datapage which is a single record update that received First_name and Last_name as external parameters (hidden fields) and has a third hidden field that sets a Default value of [@First_name] [@Last_name].  I then redirect back to the original page.  Not working though - any idea what I'm doing wrong?
2. I'm building a project management tool and need to compare timelines on form exit.  So I need it to see if the projected finish date is different to the actual finish date and - if it is - adjust some other dates accordingly.  I also need to update some other fields, like 'Current_step' or 'Current owner'.  

Any ideas at all would be most welcome!  

 

Cheers.   

Tim  

[Jan]

Hello Tim,

 

It seems, the article Concatenate/Combine two fields into one field can help you with first question.

 

If I understand correctly your second question, I think Conditional forms may be useful to you.

You can compare values of two fields and  make a field required or hide/show a field.

[svearvaldyr]

Thanks for this, Jan - got the first one working, though it only works with one datapage on the webpage (I need two) ... and for some reason today it's randomly stopped working entirely! Ah well - using a workaround for now.  

 

The second one is a tricky one - I have a Start_date, an Estimated_completion and a bunch of milestones in between the two.  When I reach a milestone I need to compare the length of time that's passed since Start_date with the length of time that was expected to have passerd - and if it's different, AUTOMATICALLY update all of the remaining milestones and the Estimated_completion.  I don't want the user to have to input anything for the update.  

 

Very tricky