ContributionsMost RecentMost LikesSolutionsRe: New Forms Opening In Full Screen Thanks Mark. ------------------------------ Charlene Dougall ------------------------------ New Forms Opening In Full Screen Is there a way to open New Forms in Full Screen? &ifv=1 does not work. ------------------------------ Charlene Dougall ------------------------------ Re: How to check if record field is empty in API_DoQuery Thank you, Chayce. I will try that. ------------------------------ Charlene Dougall ------------------------------ How to check if record field is empty in API_DoQuery When I execute API_DoQuery in the Code Page I get the following XML results, whendetail_noteis empty. However, $(this).find("detail_note").text() returns 8 159 Truewww.yahoo.com1689364909773which are the values of the fields below. Does anyone have a suggestion on how check if a field is empty? <qdbapi> <action>API_DoQuery</action> <errcode>0</errcode> <errtext>No error</errtext> <dbinfo> <name>PDA Supporting Documents</name> <desc/> </dbinfo> <variables> </variables> <chdbids> </chdbids> <record> <detail_note/> <support_document/> <record_id_>8</record_id_> <related_pda_support_document___pda_record_id>159</related_pda_support_document___pda_record_id> <iscurrentuserrecordowner>True</iscurrentuserrecordowner> <support_url>www.yahoo.com</support_url> <update_id>1689364909773</update_id> </record> </qdbapi> ------------------------------ Charlene Dougall ------------------------------ How to check if record field is empty in API_DoQuery When I execute API_DoQuery in the Code Page I get the following XML results. detail_note is empty. However, $(this).find("detail_note").text() returns 8 159 True www.yahoo.com 1689364909773 which are the values of the fields below. Does anyone have a suggestion on how check if a field is empty? <qdbapi> <action>API_DoQuery</action> <errcode>0</errcode> <errtext>No error</errtext> <dbinfo> <name>PDA Supporting Documents</name> <desc/> </dbinfo> <variables> </variables> <chdbids> </chdbids> <record> <detail_note/> <support_document/> <record_id_>8</record_id_> <related_pda_support_document___pda_record_id>159</related_pda_support_document___pda_record_id> <iscurrentuserrecordowner>True</iscurrentuserrecordowner> <support_url>www.yahoo.com</support_url> <update_id>1689364909773</update_id> </record> </qdbapi> ------------------------------ Charlene Dougall ------------------------------ Re: API_UserRoles Thank you anyway.... ------------------------------ Charlene Dougall ------------------------------ Re: API_UserRoles Yes, when I run http://target_domain/db/target_dbid?a=API_UserRoles&apptoken=app_token I get the following XML result which list all users and their role. Is there a way to query for certain roles (for example only query role id=18). Similar how we can query, API_DoQuery. <qdbapi> <action>API_UserRoles</action> <errcode>0</errcode> <errtext>No error</errtext> <users> <user type="user" id="69394206.8yji"> <name>First Last</name> <lastAccess>1679500826997</lastAccess> <lastAccessAppLocal>03-22-2023 12:00 PM</lastAccessAppLocal> <firstName>First</firstName> <lastName>Last</lastName> <roles> <role id="12"> <name>Administrator</name> <access id="1">Administrator</access> </role> </roles> </user> <user type="user" id="84394302.ma9h"> <name>First1 Last1</name> <lastAccess>1671212881400</lastAccess> <lastAccessAppLocal>01-16-2023 12:48 PM</lastAccessAppLocal> <firstName>First1</firstName> <lastName>Last1</lastName> <roles> <role id="18"> <name>Officer</name> <access id="2">Basic Access with Share</access> </role> </roles> </user> </users> </qdbapi> ------------------------------ Charlene Dougall ------------------------------ API_UserRoles Is there a way to filter API_UserRoles based on Role ID? ------------------------------ Charlene Dougall ------------------------------ API_UserRoles Is there a way to filter API_UserRoles based on Role ID? ------------------------------ Charlene Dougall ------------------------------ Re: Get an Error when trying to open a Form from Dashboard Code PageThank you I will do that.... ------------------------------ Charlene Dougall ------------------------------