Open Dental Forum

Hi Team,

I want to know, how I can get the Subscriber's Birthdate from the Patient Registration form.

I tried using GET [/sheets] & [/sheetfield], but I got this response,

{
"SheetFieldNum": 17835860,
"SheetNum": 126029,
"FieldType": "StaticText",
"FieldName": "",
"FieldValue": "Subscriber’s Birthdate:",
"IsRequired": "false",
"ReportableName": "",
"DateTimeSig": "0001-01-01 00:00:00"
}

But I don't know, from where I can get the value of the subscriber birthdate entered by the patient.

Please guide me.

Good morning,

In your example JSON, the FeildType value is "StaticText". From our Sheet Field Types Manual Page:

Static Text: Text information such as labels and large paragraphs. Also includes fields that can be inserted as static text so that resulting text is specific to the patient (e.g., patient address, gender, age, etc.)

I would guess that the sheetfield in your JSON is a label because the FieldValue of this StaticText sheetfield is "Subscriber’s Birthdate:".

If you are trying to pull information the patient typed into the sheet, you are after "InputField" types.

Input Field: Fields that expect the user to input data. Data can be imported into the database. Importable data fields can also be pulled from the database in a new sheet.

I got it. Thanks.