Forum Discussion
QuickBaseCoachD
6 years agoQrew Captain
Crystal, I would have given the same answer as Gil, but now you have added the twist that this is on a report and not on a form.
So Plan B.
A report link field type just runs a report but with an extra filter as defined on the report link setup. (for example where [Record ID#] on the Parent matches the value in the field [Related Parent] on the child record. So let's just find another way to run a report as a Report link field cannot be a "formula Report link field type as that does not exist.)
You can make an <ask the user> report on the child table which is waiting for the answer to the [Related Parent].
Once you create that report and run it and and observe the URL, then you know what we need to mimic in our URL formula.
So the URL formula would be something like,
IF([# of child records]>0,
URLRoot() & "db/" & [_DBID_table name from advanced properties goes here]
& "?a=q&qid=xx&nv=1&v0=" & ToText([Record ID#]))
where xx is the report number of the <ask the user> report.
So Plan B.
A report link field type just runs a report but with an extra filter as defined on the report link setup. (for example where [Record ID#] on the Parent matches the value in the field [Related Parent] on the child record. So let's just find another way to run a report as a Report link field cannot be a "formula Report link field type as that does not exist.)
You can make an <ask the user> report on the child table which is waiting for the answer to the [Related Parent].
Once you create that report and run it and and observe the URL, then you know what we need to mimic in our URL formula.
So the URL formula would be something like,
IF([# of child records]>0,
URLRoot() & "db/" & [_DBID_table name from advanced properties goes here]
& "?a=q&qid=xx&nv=1&v0=" & ToText([Record ID#]))
where xx is the report number of the <ask the user> report.