Welcome, Guest
Username: Password: Remember me

TOPIC: Text based Lookup

Text based Lookup 3 years 9 months ago #6143

Hi,

Long term and avid/rabid user of idoceo. I've just come across something I thought I knew how to do...but apparently not!

Is there a way to convert a text/number input to a text field?
E.g I enter the name of a form group 12.6 in column 1: Form(E.g grade selector) and have column 2: Tutor perform a lookup and return a text field.

So..
Col 1 Form = 12.6
Col 2 Tutor = Mr Huckstep (Returned field)

I've tried various types of text and numeric based calculations but to no avail.
I'm probably overlooking something simple here...

Many thanks,

Brett
The administrator has disabled public write access.

Text based Lookup 3 years 9 months ago #6144

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 2950
  • Thank you received: 530
If the input value can either be number or text you have to handle it as a text grade, if they are numbers you will only have to define the returned fields and create a conversion note.
Let me know the possible values of 'form group' and I'll explain how to configure it.
Please take a moment to add or update your rating for iDoceo 5 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
itunes.apple.com/us/app/idoceo-teachers-...&action=write-review
The administrator has disabled public write access.

Text based Lookup 3 years 9 months ago #6145

Thanks for this - appreciate the super quick reply.
The possible form group 'names' are (e.g year 13) 13.1 to 13.14
These could be treated as a text label.

Thanks,

Brett
The administrator has disabled public write access.

Text based Lookup 3 years 9 months ago #6150

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 2950
  • Thank you received: 530
The first step, create a text grade type with the 'form group' texts and assign a numeric value.
In my example, 13.1 equals 1301 , 13.2 equals 1302 and 13.12 equals 1312 an easy conversion to remember.

Here is the image
example_01.png

This grade type has to be assigned to your 'Form group' column, the one with the grade selector editor

The next step, create a text grade type with the tutors names. In value, assign the same value as in the previous text grade.
Here is the image

example_02.png


The final step: In the gradebook > Add column > Calculation > Average > Select your 'form group' column (100%) The grade type for this 'calculation' is 'Tutors'

And it would look like this.
example_03.png
Please take a moment to add or update your rating for iDoceo 5 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
itunes.apple.com/us/app/idoceo-teachers-...&action=write-review
The administrator has disabled public write access.
The following user(s) said Thank You: Brett Huckstep

Text based Lookup 3 years 9 months ago #6151

Ah! You're the boss Bert!
I tried this any number of ways but I was using decimal points in the value column of the text grade - I didn't think just to enter it as e.g 13.1 = 1301. That's actually opened another level of lookups for me - THANK YOU! :cheer:

As ever - really appreciate your work on this app. I've converted quite a few people over to iDoceo at our school. I'll continue to spread the word...

Cheers,

Brett
The administrator has disabled public write access.
Time to create page: 0.102 seconds
13 APR

iDoceo 5.1 is now available!

An amazing update with tons of new features. Audio questions in iDoceo Connect, countdown timer, feedback and more

Read more

6 JUN

Create Multiple-choice tests with iDoceo Connect!

In addition to self-evaluation rubrics, your students can now fill exams online. Supports text and images - in answers and questions - and can easily be imported from an XLS template

Read more