Before I start trying and make a mess I wanted to ask.... Here is my situation: I have a tasks table and a weekly agenda table. Employees would like to be able to click a button on a task and move it to the Weekly Agenda table and maybe add more data once in the weekly agenda area. (They want it to Rather than having a relationship with reports links, etc... I would like employees to be able to click the button and have the relevant information auto-populate on the new form... I know this can be done within a table, but I dont know if it is possible to do ACROSS tables... Any suggestions?

Not tested, but try this and we can debug together if there are syntax errors. Urlroot() & "db/" & [_DBID_of the target table] & "?act=API_AddRecord"& "&_fid_10=" & URLEncode([Subject])& "&_fid_11=" & URLEncode([Topic Details])& "&disprec=1"So that will create a new record in the weekly agenda table and stuff the values of two fields on a task record into field IDs 10 and 11. Then it will display the Weekly Agenda record. The user would then edit the record manually to fill in the rest of the fields.

Wow! That was the most unexpectedly easy Quickbase task I have done yet!This just about worked!! No syntax errors.. The only thing I had to do was add an App Token. So my final formula looked like this: URLRoot() & "db/" &[_DBID_EMPLOYEE_TASKS] & "?act=API_AddRecord"& "&apptoken=c8usqfibak5cz4c2vx5fhdh7c9dv"& "&_fid_6=" & URLEncode([Subject])& "&_fid_10=" & URLEncode([Description])& "&disprec=1"THANK YOU!!!!!

Actually I do have 1 question... Is it possible to open the form on the other table in EDIT mode versus VIEW mode?

I am trying to something very similar but with a date field. I want Date of Incident from the Incident Submittals table to populate into the Date of Incident (fid=51) in the Cases table. I have the following formula in my URL formula field but keep getting an error.URLRoot() & "db/" &[_DBID_CASES] & "?act=API_AddRecord"& "&apptoken=My App Token"& "&_fid_51=" & URLEncode([Date of Incident])& "&disprec=1"Error Message:This XML file does not appear to have any style information associated with it. The document tree is shown below.<qdbapi><action>API_AddRecord</action><errcode>50</errcode><errtext>Missing required value</errtext><errdetail>Sorry, you did not supply a value for the required field named "Reported By Channel" with field id 13. Please provide a non-blank value for this field.</errdetail></qdbapi>If it opened the record in front of me I would enter the information in the required fields it's saying I need.

Stephanie,Are you trying to create a record or put up an Add Record form with some of the field pre-populated.

Is it possible to populate fields in one table with data from fields of another table?

17 Replies

QuickBaseCoachD
Qrew Captain
10 years ago
Not tested, but try this and we can debug together if there are syntax errors.

Urlroot() & "db/" & [_DBID_of the target table] & "?act=API_AddRecord"
& "&_fid_10=" & URLEncode([Subject])
& "&_fid_11=" & URLEncode([Topic Details])
& "&disprec=1"

So that will create a new record in the weekly agenda table and stuff the values of two fields on a task record into field IDs 10 and 11. Then it will display the Weekly Agenda record. The user would then edit the record manually to fill in the rest of the fields.
- StephanieHarris
  Qrew Assistant Captain
  8 years ago
  I am trying to something very similar but with a date field. I want Date of Incident from the Incident Submittals table to populate into the Date of Incident (fid=51) in the Cases table. I have the following formula in my URL formula field but keep getting an error.
  
  URLRoot() & "db/" &[_DBID_CASES] & "?act=API_AddRecord"
  & "&apptoken=My App Token"
  & "&_fid_51=" & URLEncode([Date of Incident])
  & "&disprec=1"
  
  Error Message:
  This XML file does not appear to have any style information associated with it. The document tree is shown below.
  
  <qdbapi>
  <action>API_AddRecord</action>
  <errcode>50</errcode>
  <errtext>Missing required value</errtext>
  <errdetail>
  Sorry, you did not supply a value for the required field named "Reported By Channel" with field id 13. Please provide a non-blank value for this field.
  </errdetail>
  
  </qdbapi>
  
  If it opened the record in front of me I would enter the information in the required fields it's saying I need.
- QuickBaseCoachD
  Qrew Captain
  8 years ago
  Stephanie,
  Are you trying to create a record or put up an Add Record form with some of the field pre-populated.
- StephanieHarris
  Qrew Assistant Captain
  8 years ago
  I would like to create a new record on the Cases table with some fields using data populated from the Incident Submittals table.
ArchiveUser
Qrew Captain
10 years ago
Wow! That was the most unexpectedly easy Quickbase task I have done yet!
This just about worked!! No syntax errors.. The only thing I had to do was add an App Token. So my final formula looked like this:

URLRoot() & "db/" &[_DBID_EMPLOYEE_TASKS] & "?act=API_AddRecord"
& "&apptoken=c8usqfibak5cz4c2vx5fhdh7c9dv"
& "&_fid_6=" & URLEncode([Subject])
& "&_fid_10=" & URLEncode([Description])
& "&disprec=1"

THANK YOU!!!!!
ArchiveUser
Qrew Captain
10 years ago
Actually I do have 1 question... Is it possible to open the form on the other table in EDIT mode versus VIEW mode?
- RyanStanford1
  Qrew Captain
  6 years ago
  I know this is an old post... but yes, you can have it open the form in edit mode, generally with adding a redirect at the end of the parameters

Forum Discussion

Is it possible to populate fields in one table with data from fields of another table?

17 Replies

Related Content

Moving Fields from One Table to Another

Copy Single Table from One App to Another

Nesting API Button Help (Add record and update another)

Auto populate prefilled records

Populating a Date field from another Record