I need to copy the result of a pick-list and display into a different text field.
The pick-list is a Cascading Pick-List inside a table and I only need the primary category.
Category 1
Category 2
Category 3
Why am I trying to do this…..Having a pick-list inside a table means its not searchable and Tags doesn’t seem to work either. Also can’t display it in a column in records view.
What doesn’t work….
When I create a new separate calculation field to pull the column from the table it copies over as a COUNT(), which obviously doesn’t work even if its set to display as text.
Scripts can’t seem to show a result of a cascading Pick-List but does show in Log with no errors, just blank. Child record loop doesn’t work either.
I know what im doing can be fixed by having 3 separate text (Pick-List) fields. But since every record needs all 3 Categories, why not save space and make the form flow a little better.
Any suggestions would be helpful. Hoped I described in a way that makes sense to someone else.
Hi Michael,
If you’re referencing a Link to Form or Table field in a Calculation, you will get COUNT() as the aggregate calculation for a non-numeric field. That’s because there could be multiple records in the Table or Link to Form field, so Tap Forms doesn’t know which record you want to get the value of. So it defaults to an aggregate function.
If you want to get the value of a specific field and a specific record in a Table or Link to Form field then you have to use a Field Script for that. I’m not sure what you mean though that Scripts can’t seem to show a result of a cascading Pick-List. I don’t know what your script looks like, so I don’t know if what you’ve programmed is correct or not. And I’m also not sure why the Child record loop isn’t working. Did you select a field from your child form before you double-clicked on the Child record loop script?
Thanks,
Brendan
.
