Forum Discussion
PhilDupont
Qrew Member
I guess my disconnect is how to exactly implement that on the deals form....
Create some kind of field or drop-down that uses said report as it's source?
------------------------------
Phil Dupont
------------------------------
Create some kind of field or drop-down that uses said report as it's source?
------------------------------
Phil Dupont
------------------------------
MarkShnier__You
3 years agoQrew Legend
If you want to throw the user into grid edit and return the user to Deal On save, you can try this as a formula URL button on the deal.
URLRoot() & "db/" & [_DBID_table-Name_of parking_spots] & "?a=q&qid=99" & "&dlta=mog&navBack=true";
// change the 99 to the report ID of a regular table report for unassigned spaces.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
URLRoot() & "db/" & [_DBID_table-Name_of parking_spots] & "?a=q&qid=99" & "&dlta=mog&navBack=true";
// change the 99 to the report ID of a regular table report for unassigned spaces.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- PhilDupont3 years agoQrew MemberHrm, this didn't quite work... probably something I'm not doing right. It does kick me over to a grid report... but there isn't a way to select the records except by editing the individual spaces one at a time.
Is it possible to either:
- Click the 'add spaces' button, kick over to a report with a list of unassigned spaces... select a space from the list, save and return to the deal... or
- Click the 'add spaces' button, kick over to the report, check 1 to 4 spaces, save and return to the deal.
------------------------------
Phil Dupont
------------------------------- MarkShnier__You3 years agoQrew LegendThe method I suggested assumed that you would use Grid Edit to select the deal but I do acknowledge that this requires the user to remember what deal they launched off of.
Both of the options you requested are possible to do but they are a little too complicated to explain how to do on this forum. I would need to work with you one on one to get those working. Contact me directly by email in my signature line if you want to take this discussion outside the community forum.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------