Hey there,
so I have the following setup:
I have a new Field „Test“ in my Form „Main“. It’s a Smart Dropdown field pointing on another form (with 2 values(answer1 and answer2)
I want to use the import api to give all of my existing entries in Form Main (~80) a value for this field (either answer1 or answer2)
This works perfectly fine but there is one thing that does not work: if I want to filter the values in a table view it does not show the values correctly.
e.G Filter is: !Test: answer1 but it still shows every entry.
the thing is if I create a new entry and select the value answer1 in the form, it suddenly works.
does the API import a wrong „format“? Anyone got a clue ?
Greetz Max
Hi
When you import your data into the smart field - do you import an UUID of the record it is linked to?
Alex
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
record id or id?
How does it look like?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
ah sorry - my fault. It’s the ID.
E.g.
0e2100e0-4kei7-b400-7c1947e9kdb
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This looks right. Hard to tell really from here then what can be wrong
You can take a look at the RAW dataset export and see how the value differs from what you have imported with the one that you entered manually
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
So I just compared it in the RAW dataset.
Honestly it looks exactly the same. Just as in the .XLS
I have a screenshot of the unfiltered database of the form.
Here you see 2 entries of the row that are not imported.
In the next picture you see two of the imported entries. As you see they differ from the ones above. Thats the only difference I can spot tho. No difference in the .xls / raw
Maybe one more thing to notice:
When you import data to this smart field you can even import data that is not existent within the smart referenced form. So in this case I could even import "Test" as value although its not a valid option.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
On the last screenshot, the way the value is rendered, actually indicates that is not found and is shown as is (looks like the text is imported, not the UUID)
Feel free to open a support ticket with us, providing the raw export to investigate
https://wiki.vertuna.com/display/VERTUNA/Support+Request+Form
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.