Forum Discussion
QuickBaseCoachD
Qrew Captain
I don't think that it can be done with an embedded report. It will take a button push at least, although e results after the button push could be on the customer preferences record.
QuickBaseCoachD
8 years agoQrew Captain
There is not a way to simply make a relationship between Customers and properties as you have no natural connection that a property belongs to a single customer.
The lowest Tech solution is to create an <ask the user> report which is waiting for the answer to the number of bedrooms >= <ask the user> and the price is <= <ask the user>.
Then create a URL formula button (probably check the box to open in a new window) on the customer preference record like this.
URLRoot() & "db/" & [_DBID_my properties _Table] & "?a=q&qid=xx&nv=2&v0=" & totext([# of bedrooms]) & "&v1=" & totext([Price])
So in English that says run the ask the user report qid of xx and and there are going to be 2 variables - ie questions (nv=2) and the answer to the first variable v0 is the # of bedrooms and the answer to the 2nd question v1 is the price.
So the button will run the report and answer its own questions and display the result.
The lowest Tech solution is to create an <ask the user> report which is waiting for the answer to the number of bedrooms >= <ask the user> and the price is <= <ask the user>.
Then create a URL formula button (probably check the box to open in a new window) on the customer preference record like this.
URLRoot() & "db/" & [_DBID_my properties _Table] & "?a=q&qid=xx&nv=2&v0=" & totext([# of bedrooms]) & "&v1=" & totext([Price])
So in English that says run the ask the user report qid of xx and and there are going to be 2 variables - ie questions (nv=2) and the answer to the first variable v0 is the # of bedrooms and the answer to the 2nd question v1 is the price.
So the button will run the report and answer its own questions and display the result.