Lookup field in pipeline
Hello,
I'm having an issue adding a lookup field to my pipeline.
I want to update my current records when a criteria is met and then create a copy of the records. So I set up my pipeline like thi...
Forum Discussion
If Site ID is a lookup field in the table then it won't appear because you're not able to manually update the value. You need to make sure you're updating the 'Related Site' field as part of your copy - and in doing so the value of Site ID should populate along with the relationship being set through Related Site.
------------------------------
Chayce Duncan
------------------------------
Hi Chayce,
I'm still working on this and decided to take another approach but I'm still having issues figuring this out.
My new approach is to copy data in the fields from one table to another in the same app.
So the pipeline needs to find the records from table A and copy that data into table B. I have the same fields in table B, the only difference is that I changed all the calculated and lookup fields to a regular text field. (because table B is only meant to house the data at the specific time the pipeline is run. Formulas or relationships aren't needed so the data will not change)
I started the pipeline by adding Search Records, I put in table A info and selected all the fields. Then the next step is Create Records. I put in table B info and selected all table B fields in the 'Select fields to specify values' box.
The issue I am having is in the 'Select fields to specify values for when the record is created' part. First problem is that not all the fields from table B are showing. I do have them selected in the 'Select fields to specify values' box but they are not showing under. And yes, I did use the 'more' arrow to check.
Second problem is that not all the fields from table A shows in the drag and drop box on the side (mainly the lookup fields).
Not sure if it's because I have a lot of fields (about 200) or if its because I'm trying to copy some data from a lookup field to a text field but I'm stuck.
------------------------------
Shalom Eguale
------------------------------
That all makes sense - by chance did you create the Pipeline and then change all of the fields from formula/lookup to static text? It sounds like the Pipeline might have an old schema and doesn't show those fields because it still thinks they aren't editable. Try to 'Refresh schemas' in the upper right hand corner of the Pipeline under the 3 dots.
Once the schema is refreshed, give the page a quick refresh and see if the fields then appear in the dropdown as available to write information into.
------------------------------
Chayce Duncan
------------------------------I did that multiple times but it still doesn't show up. Would this warrant a support ticket maybe?
------------------------------
Shalom Eguale
------------------------------I suppose it's possible. Based on your description of the fields not showing up my initial thoughts will always be the table configuration or a lagging schema - but I've never tried mapping 200+ fields which it sounds like your comment. If your confident that you're mapping to the right table and the schema is updated/accurate then support might be able to help identify the issue or point you in the right direction by actually being able to access the Pipeline/Application with your support.
------------------------------
Chayce Duncan
------------------------------