Forum Discussion
MichaelTamoush
5 years agoQrew Captain
See below.
When using an editable report link, to add new entries you can simply make selections/enter data on the next blank row. One of my selections in this scenario is a related field with a conditional dropwdown. In my picture below, the field the condition is based on (where it says NAD-A) is only filled in the following circumstances:
a) the entry has already been saved or
b) the child is created in the traditional way using an add 'child' button which actually takes you to the new record form.
You can see on a new row, the conditional dropdown field isn't filled in yet, so the selection cannot take place (if I click make a selection it instructs that I need to choose that column first. The column that says nad-a is a lookup field from the parent.).
------------------------------
Mike Tamoush
------------------------------
When using an editable report link, to add new entries you can simply make selections/enter data on the next blank row. One of my selections in this scenario is a related field with a conditional dropwdown. In my picture below, the field the condition is based on (where it says NAD-A) is only filled in the following circumstances:
a) the entry has already been saved or
b) the child is created in the traditional way using an add 'child' button which actually takes you to the new record form.
You can see on a new row, the conditional dropdown field isn't filled in yet, so the selection cannot take place (if I click make a selection it instructs that I need to choose that column first. The column that says nad-a is a lookup field from the parent.).
------------------------------
Mike Tamoush
------------------------------
MarkShnier__You
Qrew Legend
5 years agoI have not tested but one work around might be to add a dummy field or move the data entry fields so that the first column get populated, such that the record does have some data entry which would cause the lookup to be populated. I will try a test when I get a chance.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- MarkShnier__You5 years ago
Qrew Legend
OK I did a little test and was able to replicate the problem. Adding a dummy field to be completed first didn't help. I had to "save and keep working" in order for the new record to be seen by Quick Base and have a look up field populated.
So you might need to have a button that creates some actual blank records for the user to fill out. You could show those records on the grid edit form but then in view form hide the records if certain fields are not populated i.e. if they seem to be blank. But I suppose you could have an automation run at night to clean up those extra blank rows that people may have added. So maybe you make a button that adds five blank rows (records) to the bottom of the credit form.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- MichaelTamoush5 years agoQrew CaptainThanks. Good thoughts and tricks. For now I might remove the conditional dropdown, and then decide how to move forward.
------------------------------
Mike Tamoush
------------------------------