IOS 17.2.1
version 5.3.33 (1101)
I created a form to record the growth rate of a litter of pups
i used numbers to record the pups using a pick list
i now want to change numbers to pup names and want to know what’s the easiest way as there are 4 pups with 240+ records so doing it manually is not really an option
many thanks
Vaughan
I’d use multi-column view. Sort by the pup numbers. Replace the first number with the name and then click on the yellow dot and pull it down until the next pup’s number. Repeat for the next 3 pups.
Hi Vaughan,
The iOS version would need a script to do something like this. But if you have the Mac version, then Daniel’s suggestion is a good one. It also has a Fill Down function which does a similar function.
But for a script to do it, you’d need to loop through all the records in the form, searching the field for the old value and then replace the value with the new value.
There’s instructions on scripting here:
https://www.tapforms.com/help-mac/5.3/en/topic/scripts
It’s definitely easier to do this with the Mac version as Daniel suggested.
Thanks,
Brendan
Hi
its an iPhone not a mac sorry should have said
could I export to excel then import back in ?
Vaughan
Hi Vaughan,
Yes, you can. Just make sure you enable the Export Record IDs option on the Import & Export settings screen before you export. Then when you import the CSV file, Tap Forms will update the records using the record ID.
.
