How to easily pass data between 2 tables

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I have 2 tables one called Job Request and one called Job Folder.  The Job Request folder is open to the internet so people can request a job.  Most of the fields in the Job Request table are the same fields as the Job Folder.  When someone submits a request it goes to a manager who decides if they are adding it to the Job folder.  If they decide to add it how can they easily get the information into the Job Folder without having to copy the data?  It will be on a one by one basis.

Photo of Krista

Krista

  • 10 Points

Posted 4 years ago

  • 0
  • 1
What you want to do is to create your own custom Add Record button.

It will look like this

urlroot() & "db/" & "xxxxxxx"  // insert the characters you see in the URL when you do a normal add record button on that field.  It will be about 8 "random characters".

& "?act=API_GenAddRecordForm"

& "&_fid_6=" & URLEncode([name])

& "&_fid_7=" & URLEcode([phone])



etc

ie, you will need to populate the field ID# of the target table with the field value from the record you are on.  The URLEncode is to convert any characters which are illegal to have in a URL (such as spaces and slashes, equal signs) to an allowable format.








Photo of Krista

Krista

  • 10 Points
Thank you.  Are there any articles on creating a button.  I am a beginner and this seems advanced to me
Photo of Krista

Krista

  • 10 Points
I also don't know where to go to actually create the button - sorry still too new
To create  a new field, go to settings and add field.  Then choose file type formula URL.  

As for articles, I put an app in the Exchange called something like formula URL buttons for dummies. As a step by step guide.  Go to Create new application and then find the Exchange and Search on keyword dummies.
You can also contact me off line via the information in my profile for one on one assistance.