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 id…

Here’s how I worked around what I think is the same issue. I had a form where the user is asked to select a Subtype of a Type, but where the Type is predetermined and need not be selected. In coda, the table and the form view both work by filtering Subtypes where the Subtypes’ Type equals the pred…

Hello @Manoj_Gupta_Engrg-SW_IN , 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. [image] Greetings, Joost

Hi @joost_mineur Yes I have enabled this option, see the picture below. sorry for permissions to the document, I have now opened it. Form: Sanbox Document: Sanbox [image]

I think it’s the same topic of this: [image] Coda Form Validation Issue I’m experiencing the same issue. I think that in the validation formula, the only accessible data reference is currentValue. Has somebody found a way? Am I correct? Thank you! Let’s merge int…

Hello @Manoj_Gupta_Engrg-SW_IN , 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 w…

@joost_mineur i want to create tree structure or projects. one project can block another project also.so lookup has to be from project table only.

Is there a reason Project A has itself as a parent? Seems like something that could cause issues, but maybe not.

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, pr…

@N_G it works on coda page, but doesn’t work on published page.

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 …

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) [image] Form in Coda Doc: (Has projects when i select…

Coda Published forms not showing the lookup values from same table

Federico_Stefanato May 14, 2021, 8:59am 4

I think it’s the same topic of this:

Let’s merge into this one

Coda Form Validation Issue

Topic		Replies	Views
Bug: Filtered Lookup fails in Published Form Bugs	0	417	October 25, 2021
Lookup from a different table in form dropdown	5	1264	May 5, 2021
Coda Form Validation Issue	2	1040	May 14, 2021
Lookups in external form	1	921	November 21, 2020
Published form not showing all options	1	78	November 14, 2024

Coda Published forms not showing the lookup values from same table

Related topics