# Data reference for new data entry

**URL:** <https://forum.getodk.org/t/data-reference-for-new-data-entry/6260>\
**Category:** Support\
**Created:** [February 6, 2017, 4:44am UTC](https://forum.getodk.org/t/data-reference-for-new-data-entry/6260 "2017-02-06T04:44:39Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Khtet](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/k/71e660/32.png) [@Khtet](https://forum.getodk.org/u/Khtet)\
**Post date:** [February 6, 2017, 4:44am UTC](https://forum.getodk.org/t/data-reference-for-new-data-entry/6260/1 "2017-02-06T04:44:39Z")

</div>

Dear All  
Please ,kindly to you answer that I want to known how to data  
reference for new data entry. This attack file yellow cell is once typing  
for (title and other date) and then we fill training personal list and  
click summit . We do not write again at new data entry for (title and  
date) so how to do auto fill or data reference. Please someone ,can you  
help me for this problem.  
Thank a lot.

[training\_attendance.xlsx](https://getodk.b-cdn.net/uploads/default/original/1X/1eed7120d6c69726e5663b3ef27a0ee4ecbe9175.xlsx) (10.4 KB)

---

<div class="post-metadata">

**Author:** ![yanokwa](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/yanokwa/32/1695_2.png) [@yanokwa](https://forum.getodk.org/u/yanokwa)\
**Post date:** [February 8, 2017, 5:08am UTC](https://forum.getodk.org/t/data-reference-for-new-data-entry/6260/2 "2017-02-08T05:08:45Z")

</div>

Hi there,

I'm not exactly sure what you are asking. I think you don't want to  
type the sections marked in yellow every time. If that isn't correct,  
please post the question in your native language and hopefully someone  
can help translate.

In general, you cannot refer to data that has been entered previously.  
You can enter default values or make the entry easier or split the  
forms and link with an id.

If you want a default value, you can use the default column.  
[http://xlsform.org/#default](http://xlsform.org/#default)

If the list of training venues is always the same, you can also use a  
choices list to make it easier for users to enter with a select one.

As to splitting the forms, you can have a Training Venue form where  
you enter data about the venue and a Training Attendance form where  
you enter data about the attendance. Then you can have some Training  
Venue ID (maybe a 2 digit training venue code) that you enter that ID  
in both forms to link them.

Hope that helps,

Yaw

> **···**
>
> On Mon, Feb 6, 2017 at 11:44 AM, wrote: \> Dear All \> Please ,kindly to you answer that I want to known how to data \> reference for new data entry. This attack file yellow cell is once typing \> for (title and other date) and then we fill training personal list and click \> summit . We do not write again at new data entry for (title and date) so \> how to do auto fill or data reference. Please someone ,can you help me for \> this problem. \> Thank a lot. \> \> -- \> -- \> Post: opendatakit@googlegroups.com \> Unsubscribe: opendatakit+unsubscribe@googlegroups.com \> Options: http://groups.google.com/group/opendatakit?hl=en \> \> --- \> You received this message because you are subscribed to the Google Groups \> "ODK Community" group. \> To unsubscribe from this group and stop receiving emails from it, send an \> email to opendatakit+unsubscribe@googlegroups.com. \> For more options, visit https://groups.google.com/d/optout.