Forum Discussion
- QuickBaseCoachDQrew CaptainWhen you look at the target field ID and click on the Usage tab it will show you the field ID#. Also on the field list of you click "options" towards the top right you can show the field ID# as well. Or right click on then field in the field list.
- MattMatt1Qrew TraineeOk so I located the field ID but I guess I am still confused on which field ID to use....How do I determine what field ID to use because I put in a few different options and none of them work....
- QuickBaseCoachDQrew CaptainPerhaps if you explain in words what you are trying to do, I can help with specifics, but in general the field ID is the one that you are trying to pre-populate on the Add Record form
- MattMatt1Qrew TraineeSomeone from the customer service team got back to me on the support case and helped me answer my question. For context and completion of this thread I wanted to share what they helped me figure out...Just in case anyone else is looking for this answer. What I needed to get to was the related field between the two tables. I was trying to create a button that converted an applicant to an employee. To reduce data entry I wanted it to carry through the information, such as first name, last name, primary contact phone number, etc. I wanted those fields to come through so that I could write dynamic form rules to populate those fields automatically. Additionally I only needed a form on the employee table that had necessary fields so I created a form that was abbreviated. So the challenge was creating a Formula URL button that carried the information from the existing table to the new table and utilized the specific form that I had created. I accomplished this by locating the reference proxy field id and added to the formula that I put in my original post. Thus my formula above turned into this:
URLRoot() & "db/bj68rdvfx?a=API_GenAddRecordForm&_fid_133=" & URLEncode ([Record ID#])&"&dfid=10" & "&z=" & Rurl()
I did learn that this does not work without the = sign at the end of the fid. Not sure why but it is needed or it will not work. Hope this helps someone else out as much as it helped me! - KellyBianchiQrew Assistant CaptainWhat if I just want to change the 'Add New Record' form above a table in a parent record to start a New Record with a populated date? No need to open the record.
- QuickBaseCoachDQrew CaptainTry this
URLRoot() & "db/" & [_DBID_the alias name of the table ] & "?a=API_GenAddRecordForm&_fid_xx="
& ToText([some date field]) - KellyBianchiQrew Assistant CaptainThe only field options are in the parent record. I'm not trying to pull the date from the parent record. I'm trying to create a new record with today's date in a field that's in the child record.
- MCFNeilQrew CaptainUse API_AddRecord, not GenAddRecordForm.
Then use the formula portion for the
&_fid_xx="&URLEncode(Today())&"
If you want the date AND time use,
&_fid_xx="&URLEncode(Now())& - KellyBianchiQrew Assistant CaptainI'm getting a Formula syntax error:
Expected a valid expression after the "& - MCFNeilQrew CaptainYou will still need the rest of the formula as well...
& URLEncode ([Record ID#])&"&dfid=10" & "&z=" & Rurl()