Lookup table clarification please

Hi

There are one or two things I want to check before editing my lookup
tables. I’ve looked at the help pages but they are not totally clear on
some key issues.

I’m already using lookup tables successfully for the specification of
province/district information for retailers (cases).

I now want to add additional districts to one of the provinces.

I have downloaded the existing tables and the existing entries have UID
info (as you’d expect).

Can I insert new rows (districts) in the middle of the table, or do they
need to go at the end?

Should I clear all the UID information or should I leave the existing UID
info in place and just leave this property blank for the new districts?

What are the implications of replacing the existing tables? Would I need to
edit for form that use the lookup tables in form builder and then rebuild
the app? I think the answer to this is “No” but just wanted to check before
diving in!

Thanks in advance.

Regards

Simon
2/3/16

Hi Simon,

Responses in line.

Hope this helps,
Kriti

Hi

There are one or two things I want to check before editing my lookup
tables. I’ve looked at the help pages but they are not totally clear on
some key issues.

I’m already using lookup tables successfully for the specification of
province/district information for retailers (cases).

I now want to add additional districts to one of the provinces.

I have downloaded the existing tables and the existing entries have UID
info (as you’d expect).

Can I insert new rows (districts) in the middle of the table, or do they
need to go at the end?

They can go anywhere. As long as you leave the UID column blank, new UIDs
will be created for the new rows.

Should I clear all the UID information or should I leave the existing UID
info in place and just leave this property blank for the new districts?

Leave the existing UIDs as they are for any rows that already exist. You
can even update data in those rows or delete them (by changing the
"Delete?" column to Y) but it sounds like you don’t need to do either of
those.

What are the implications of replacing the existing tables? Would I need
to edit for form that use the lookup tables in form builder and then
rebuild the app? I think the answer to this is “No” but just wanted to
check before diving in!

Replacing existing tables is generally meant for when you want to wipe
everything that exists (without manually deleting existing rows by changing
by the “Delete?” Column to Y) and replace it with new data.

You wouldn’t need to update anything in the form as long as you aren’t
changing column header or the structure of your table(s) in any way.

Additional reminder that lookup tables are updated for all users once you
upload them as soon as the users sync, so they don’t need to update their
app versions to pull down the updated set of data.

Thanks in advance.

Regards

Simon
2/3/16


You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.

··· On 2 Mar 2016 14:39, "Simon Berry" wrote: > For more options, visit https://groups.google.com/d/optout.

Hi Kriti

An excellent response. Thank you. This gave me the confidence to proceed and it worked EXCEPT that the sort order is now wrong. How do I sort that? If I download the lookup table, sort it as required and re-upload it will that fix it?

Regards

Simon

Hi

Can I nudge you on this…

How do I correct the sort order of a look-up table?

Having edited the districts look-up table the order in which they are
displayed is now wrong.

I’ve tried downloading the look-up table, sorting it and re-uploading it
and that doesn’t solve the problem.

Do I have to sort and then overwrite the the existing table?

Regards

Simon
7/3/16

··· On Wednesday, March 2, 2016 at 9:35:35 PM UTC, Simon Berry wrote: > > Hi Kriti > > An excellent response. Thank you. This gave me the confidence to proceed > and it worked EXCEPT that the sort order is now wrong. How do I sort that? > If I download the lookup table, sort it as required and re-upload it will > that fix it? > > Regards > > Simon > >

Hi Simon,

Would you be able to report an issue from your CommCare HQ page?

That way we can take a look and see what is going on with your look-up table.

Thanks!

Robin Selwitz

··· > On Mar 7, 2016, at 9:27 AM, Simon Berry wrote: > > Hi > > Can I nudge you on this... > > How do I correct the sort order of a look-up table? > > Having edited the districts look-up table the order in which they are displayed is now wrong. > > I've tried downloading the look-up table, sorting it and re-uploading it and that doesn't solve the problem. > > Do I have to sort and then overwrite the the existing table? > > Regards > > Simon > 7/3/16 > >> On Wednesday, March 2, 2016 at 9:35:35 PM UTC, Simon Berry wrote: >> Hi Kriti >> An excellent response. Thank you. This gave me the confidence to proceed and it worked EXCEPT that the sort order is now wrong. How do I sort that? If I download the lookup table, sort it as required and re-upload it will that fix it? >> >> Regards >> >> Simon >> > > -- > You received this message because you are subscribed to the Google Groups "commcare-users" group. > To unsubscribe from this group and stop receiving emails from it, send an email to commcare-users+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout.