Skip to main content
Question

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

  • July 28, 2015
  • 0 replies
  • 297 views

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? 

This topic has been closed for replies.

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.
  • ArchiveUser
  • Author
  • Registered
  • July 29, 2015
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
  • Author
  • Registered
  • July 29, 2015
Actually I do have 1 question... Is it possible to open the form on the other table in EDIT mode versus VIEW mode?
Terms & ConditionsAccessibility statement