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.
QuickBaseCoachD's avatar
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.