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 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.