GET
https://api.tadabase.io/api/v1/data-tables/{{hiddenTableIDforPRIVACY}}/records?filters[items][0][field_id]=field_1649&filters[items][0][operator]=is&filters[items][0][val]={Project}&filters[items][1][field_id]=field_1650&filters[items][1][operator]=is&filters[items][1][val]={Reps}&filters[condition]=AND&fields=id,field_1660
PARAMETERS
TEST shows result as needed
BUT table pipe response, no result. Why?
Response Setting is correct also, but no result, even the text field has no data after the PIPE run.
@Kristen @moe @Adi
Could use a little context here, what are you trying to achieve?
I have 3 fields, 2 for condition and when it matches, I need the 3rd column field to be added to the field I assigned to.
Table 1 is where I need it assigned to.
Table 2 is where those fields, it worked already in another table pipe, I don;t don’t know why it doesn’t in this table (although the TEST shows result, but the table doesn’t prefilled after PIPE RESPONSE)
@Kristen
Do you have a previous rule that sets the value for those fields on create?
Because they could be blank if it’s a new create and you’re asking it to return a record values that may not exist.
Can we see a screenshot of the records page and what’s in those fields?
They are the same settings, so I can’t figure out why it’s blank.
? is where it should be, even the text testing fields, has no pipe response
Hi @TadaMan
I’m not quite following what you are trying to achieve here but can you try adding two text fields to this table called PROJECT TEXT ID and SALES REP TEXT ID and then add this rule above the rule you have:
Then adjust your pipe to this:
I know the pipe I’m using isn’t the same as your pipe but you get the idea.
I was trying to recreate your scenario but couldn’t figure how you have it set.
TABLE 1 has 3 fields
- project
- reps
- special field (to be connected to table 2)
TABLE 2 has exact 3 fields
- project
- rep
- special field (missing from table 1)
pipe is to filter 2 considitons then once you meet it, you get th special field
@SuiteUpstairs @Kristen
@SuiteUpstairs TABLE RULE 1 can’t work since text can’t never get data from (Join) field…
it’s blank, after I run it.
Sorry, you are right, you need to use the connected value:
Sorry nothing works.
@Kristen @SuiteUpstairs
Hi @TadaMan , have you tried adding the the id’s in the pipe formula manually to see if that even works:
yes, and yet nothing happens @Adi @Kristen @moe @SuiteUpstairs
I think we need to back up a step here. Instead of focusing on what isn’t working, can you help us understand why you’re trying to do this?
It looks to me like you have two same/similar tables, so what are you trying to accomplish using this pipe? Maybe if you explain the business process you’re trying to build, that will help someone come up with an idea for how to tackle it.
