Hi
I have created a table “Project”, which has a another column “Parent”. the Parent column is look up column as i wanted any other project can be parent. this works perfectly in a table or detailed layout. but as soon as i create published form, the form doesn’t show values in parent field, any idea what i am missing?
Did you turn on all lookup columns in the privacy settings of your form. Not sure if that’s you problem, because I can’t see your document since it is locked, but I have had forms where this setting had to be turned on.
I think the problem is that your lookup column is a column in the same table. Make a small table with the projects and call it ‘parent’ (or any other name), fill the 1 column table with your project names and use that as the lookup column. That works for sure. The way you have set it up is asking for problems, because when you delete rows at some point in the future from your projects table, the lookups will fail.
I am kind of surprised it is working in standard view (and it is), but a form needs to do lookups from a ‘master’ lookup table.
Hmm… So i just checked with my Projects table… and in the non-published, still editing the form view in my doc, I saw the following with No Options available. It turns out, I have a filter rule on the Parent Column, that says only give me parents based on my selection above (department, division, project). Since I haven’t selected anything, no parent is available yet to select.
Do you possibly have a filter rule?
Also, is it showing correctly when you are in your Coda page, but not on the published link? Or not working in both places?
Do you get an error on the published page? Can we see a picture of the published page? I am getting the following when I hover over the red triangle on the published page. I have enabled the lookup permission as well.
Edit: Never mind, that was probably still without updating the permissions. I no longer see an error.
Maybe we can tag this as Bug… looks like I am having the same issue (see below). Have you tried asking the coda team using the QuestionMark at the bottom right of your screen?
Published Form: (Does not have projects when i select a tree type)
So, I actually worked directly with tech support on this issue, and it turns out this is intentional on Coda’s part. Essentially, it’s a data protection issue, and last I checked they were not interested in changing it.