Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
10 years ago

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

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 ...
Forms
reports and charts
Tables and fields
QuickBaseCoachD's avatar
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's avatar
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.