Please help. I have a Table named Task whic...

(Taran Bhagat) #1

Please help.

I have a Table named Task which has columns " Task ID", “Task Description” …etc. I have entered some Task Description while running the app and some Task Descriptions are copied from excel sheet.So the sheet shows some Task Description having Task ID generated, while some dont have a task ID generated. My difficulty is that I cant see the Task Description of the rows for which Task ID is not generated.

How can I resolve this?

(Suvrutt Gurjar) #2

@Taran_Bhagat,Could you please mention if

[Task ID] is key of the table? Also when you mention task descriptions are copied from Excel sheet , do you mean those were copied directly at the back end spreadsheet? And you are not able to see those task descriptions in the app where Task ID is not assigned.

If [Task ID] is key of your table Task, then I believe you will need to add unique task id to those rows where you have task Id missing but task description uploaded in the back end spreadsheet.

(Taran Bhagat) #3

@Suvrutt_Gurjar How to add unique task ID? I want to do that.

(Taran Bhagat) #4

@Aleksi_Alkio OK. Thanks


(Michael) #5

@Taran_Bhagat Enter UNIQUEID() as the initial value

(Taran Bhagat) #6

@Michael I did but I dont see anymore UNIQUEID() generated against the rows which earlier had no IDs. What do I do now?

(Suvrutt Gurjar) #7


Could you mention how your table used to generate key earlier? And are keys missing in handful of rows or

many rows?

(Taran Bhagat) #8

@Suvrutt_Gurjar Keys missing in many rows.You may access Smart-Monitor SmartMonitor1-213475

(Taran Bhagat) #9

My table link - project1 project1

(Aleksi Alkio) #10

@Taran_Bhagat You have set the column type to number. Change it to text and it should work.

(Taran Bhagat) #11

@Aleksi_Alkio Changed to text but the earlier copied rows dont show Task ID. I want all rows of the task table to have Task IDs

(Aleksi Alkio) #12

You need to add them manually because initial value will work only when you add a new record.