Jump to content
  • 0

How To Update A Single Record With A Datapage Redirect



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!  



Tim   :mellow:

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

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

Link to comment
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.

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.

  • Create New...