IOS App Suggestions for Offline Front-end Using ZC as Back-end
I need to be able to collect data offline. Does anyone have experience with or a suggested app that is available on the market? I don't want to waste my time with junk as there are many apps out there. Thanks for any suggestions!
Expanding field in zoho creator
I'm working on a project which includes showing created leads from zoho crm into zoho creator form. i.e if there are 2 leads, 2 lead names should be visible on the form . Which field can we use for this purpose in "form builder" to build this application in zoho creator which gets expanded in accordance no. of leads names available to be shown ?
.toLong() not working
I have a user defined function that calls .toLong() built in function I have added it to one line and it works fine. I tried adding it to another line of code but I get the following error. Is anyone else experiencing this issue? How can I overcome it? Not able to find 'toLong' function
Subform picklist problem
I mailed support about his problem a few days ago, but have had no response other than "we will respond soon". So I thought I'd try my luck here. I was running the script below on the On Edit > On Load action of a parent form to populate dynamic picklists on a subform with the data that was saved previously. This has been working fine until a few days ago. When I made a change to a different line in the script totally unrelated to this code I got an error message saying "variable record not defined"
Is "Duplicate" broken?
I've been trying to duplicate my own application all weekend and I just get the "Duplicating - Please Wait..." message until everything times out. What's going on?
Button on a form to run a script?
I have a series of data input fields, visible calculated fields and fields that show as set variable results. I want the script to run after the user has completed inputting the data and this is of course easy to do as an 'on user input' on the last field. However in many instances the user will see the results and wish to recalculate after modifying one of the input fields. I need something like a RECALCULATE button at the bottom of the page. Any ideas?
Label colour: change background or text?
It would be useful to be able to differentiate fields on a form by colour, either the text or the background. For example I have visible calculated fields and financial summary fields where this would be handy. Any ideas? Right now all that I can think of is running a red line in a notes field.
Auto Number issue after import an application from .ds file
The Auto Number field was working perfectly when we initially created the application. However, after we import the application again from a .ds file, the Auto Number field is ignoring 'Start Index' and always start from 1. Any suggestions?
How can I prepopulate one form with data that has been previously entered in another form, in same application?
I am looking in https://kbase.creator.zoho.com/records/populate-one-form-with-data-from-another-form But I could not make it work :-( On my application (which I am trying to build) is like that: There is a Form "Registration" and 3 fields (Number; Name; Email) There is a From "Feedback" and 3 fields (Number; Email; Comments) So, every time that the customer put his Number on "Feedback" form, I want his email to be automatic updated. Could you make an exemple to me? Thanks!!!
Issue with Groups
I just sent a bunch of invitations to join a security group for an app in zoho creator. When I got the invitation and clicked "join group" I get an Invalid Confirmation message.
Zoho Creator Support Still on Holiday??? [Urgent] Pages Script is disappear and Version History Gone
Hi There One of our Zoho Creator Pages (PLC-Monitor) has been changed to something else by system, and all version history are disappear recently. Could some one help Support Function is Enabled. Thank you!
Add a URL to an Add notes field within a form
Hi, I want to insert some Add Notes fields into a form as help. I then want to create a link so a user can click it and go to another website. The Link icon in the Add Notes field asks me to insert the URL but does not then allow me to create the Thanks, Clive
Make a form field mandatory based on response in another form field
For reference, see my Creator form at http://www.jaxareagolf.org/index.php/meeting-notice%E2%80%8E. In the Attendance Options, if a user chooses "Meeting, lunch, and golf", I want it to be mandatory that the user also put a response in 'Tee choice:' and 'Handicap INDEX'. I am not quite sure how to go about doing that. I would appreciate any help. Barney
Multiple conditions( Help)
I have the Client Rate Table that contains the Company Name that is a lookup to the Company Table. The Client Rate Table has multiple records for one company. the records are differentiated by the Rate Category Field in the Client Rate Table. Based on a radio button selection in The Time Entry table <Rate_Type>, either "Normal" or "Storm" I want to load the rates from the Client Rate Table that are based on that Category from the Client Rate Table. r = Client_Rate_Table[Company_Name == input.Company_Name
Populate field in form1 with Data from form2 based on a lookup in form1 that looks up from form3
Populate field in form1 with Data from form2 based on a lookup in form1 that looks up from form3 I have 3 forms Patriot_Time_Entry Client_Rate_Table Work_Type I am working in the Patriot Time Entry form When I select a Work TypeLookup that matches a Company Name in the Client Rate Table, I want to populate fields in the Patriot Time Entry Form.
Alternate to subforms
Let me start by saying I'm frustrated and losing faith in Zoho. Zoho pitches their service as easy to use and mobile compatible....but they neglect to make it clear that certain features do not work well on mobile devices. And the new Android Creator app does not handle subforms with image uploads. So I invested a lot of time and money creating and app that allows us to create work order tickets for our field service tech. Everything we do is documented by photos. It can be 5 photos or 20 depending
Application Context
I was testing out the password retrieval / reset for an app and discovered a few things that should be fixed to keep the user's experience focused on my app rather than on Zoho services. This is related to my other post which has yet to be addressed although the service was updated today. The sign-in page and link to password help is within the application context. No problems here. Clicking on password help, the user is taken outside the application context. Here is the first issue: the logo is
Another window type for openUrl
Hello! Can you add a new window type in openUrl function? Type "New Tab". "New window" is not easy to tabbed browsers. Thank you, Ulia
Sub Form Fields
Hi There I am creating my first ever App in Zoho, using a number of Sub-Forms as my one-to-many relationships, and also to create one "Master Form". Would I repeat my Primary Key Field on each Sub-Form as a Look-up Field, to accommodate "Auto Filtering"reporting from a field on one of the Sub-Forms when creating a Report from the Master etc? Would I need to repeat other Fields from the Master or other Sub Forms to also accommodate this? Kevin
I can't get a condition for a Report to work
I have a report that lists all companies grouped by territory. I want to open that report restricted to companies in the territory in which the current user resides. The user's territory is PersonForm[Email_fld==zoho.loginuserid].Territory_fld In the report definition I want to say show all rows from CompanyForm[Territory_fld == this user's territory] But if I code it thus show all rows from CompanyForm[Territory_fld == PersonForm[Email_fld==zoho.loginuserid].Territory_fld] the
Is there a field limit?
I searched but could not find the answer. I have a zoho creator application that needs over a hundred fields on a single form. I get 99 added, but when I drag the 100th field onto the form, I just get a spinning "adding". Have I reached a limit?
Need unique case ID field
If I use the auto number field, it is hidden and the user cannot see the field to use that as a case id. Due to confidentiality requirements, using the victim name is not an option. I am assuming I will have to use a single text with no duplicate entries. But, this means the users will have to generate their own case ids. Is there a better way to insure compliance and consistency? I would really like to keep my current method, ##-####-#### first two digits, member program service provider id
Creating a composite report
Hi everyone, I need to produce a composite report for my database. The database contains student information. The first table contains the "front page" information, consisting: Name, DOB, Class, Residential House. Then there are other tables all with a lookup selection box in each pointing to Name+DOB from this front page. These tables contain: Home Information Family Contact Information Emergency Medical Information Daily Requirements etc etc I need to produce a final report using the majority
Change Custom Action button
Is there away to change / disable an action button? I have a button that is for sending a request for proposal. Once it's sent I want to disable the button so you don't resend the same RFQ to the same suppliers. How would you change or disable a custom action button after it has been used? The code Im using in the formula that creates the button is as follows: "<a class='zc-formbutton' href='#Form:Send_Request_for_Proposal?zc_LoadIn=dialog&Request_ID=" + ID + "' >Send RFQ</a>" How would this be changed
Reports Scheduled
I have had my auto scheduled reports going now for about 7 months without a hitch, now the last three days it stopped. When I went to look at the schedule, it added all my reports that are in my database, instead of the one I had. I tried to remove the others, but it will not let me, even when I delete the schedule and redo it. GREAT......:(
Application group share setting can not use
Hello group share setting can not fetch my google apps group information I can only specify the share setting in users mode did the server side anything wrong? Regards Matthew
Form fields onUpdate action
Hello, Now, when you update fields in Form by deluge script, onUpdate action of this field is not executed. But sometime you need to do it. May be it's possible to make new deluge statement to 'fire' this action in database? like this: appName.formName.fieldName.update()
ZCML search - how to?
Hi there, I don't quite get how you define specific search patterns using ZCML. Say I want to get a list containing only Date2=="15/12/2014". Here's what I tried: <script type="text/zcml" elName="zc-component" id="firmwares" viewLinkName="List" params="" appLinkName="iac-schedule" sharedBy="kfiram" adminuser="IAC" params="Date2=15/12/2014"> I've tried substituting "=" with "==" or "?" or any number of different thins, but no matter what I do, I always get the full list, and the params value is just ignored.
input fields aren't accessible in Import Data tasks
BrandModels = (Model[Brand == input.Brand].Name_utilized).getall(); if(BrandModels.contains(input.Name_utilized)) { alert ("Duplicate Brand - Model pair!"); cancel submit; } That simple validation works perfect in form but ends up with error on Import Data. While debugging I came up to conclusion that no "input" is accessible because if you try to: test = input.Brand;... it crashes with same error. How should I validate Imported Data if I cant access it via input? Any Ideas?
Links for Forms/Reports/HTML-Reports in application menu
It will be excellent to have ability to place links for Forms/Reports/HTML-Reports in several menu actions For example: we have sales and tech departments. Sales employers have their instruments only in "Sales" section of application, technical persons have many sections for different processes. But they both use one special HTML-report for edit client information (contacts list, addresses list and so on). And it's logical to place it in Sales section and some section for tech department. Now I need
Zoho Creator Reports - Grouping by Month
I run training classes as a business. I would like to run a report that show revenue by month. I have a report that list the reports in chronological fashion but how do I group them by month? The report is closed.
Zoho Creator API to modify HTML?
I thought this would be very easy to do, but I am having issues. I want to use the Zoho Creator API to hide/show an HTML element with CSS. This is on a custom web site and we want to show/hide a div based on who is logged into Zoho and the field variable attached to their login. For example, If somehow with the Zoho API in html we could do {zohovariable == true} then CSS is display:none. It seems that the Zoho API is used for form elements in HTML only. Is there a way to pull a field value
Changing an e-mail address
Say over the course of a few years I used a certain e-mail address all over my zoho database. Now that e-mail address is no longer used. How do I change each instance of that e-mail address easily and efficiently? Is there a way to change all in one step or do I need to go in and change each one individually?
Error in Fetch Task
Hi Dears, today we have trouble in ´´on success´´ time with our form CMC_Eleitoral. System reporting that an ´´Error in executing Fetch Record task. Unable to fetch Matr_cula_Consular and update variable temp´´ happen. Yesterday we tried to modify a script in on success, but without any reference to this fetch record reported from the system. We have checked all fetch record script but any error wasn´t found by us. We hope in some help from you. Thanks a lot M&Y
Issue with executeXPath attributes? Any ideas what Im doing wrong?
I'm trying to use the executeXPath function upon doing a getURL call and am able to get the element text but not the attribute text. I've used the xPath builder for the following XML and all I get is blank info when I run it in Creator. Here is a sample of the XML I'm attempting to parse: <Availability> <BookedStays property_id="1596-60334"> <BookedStay> <ArrivalDate>2014-01-17</ArrivalDate> <DepartureDate>2014-01-21</DepartureDate> </BookedStay> </BookedStays> </Availability> I
Can you change the Picklist value not to be the ID
I have written a system for a client that uses a number of Lookup Dropdowns (Picklists), the picklist displayed a description but the 'Value' stored was a different column from the source. This was done in the old version. They client has now asked me to add some more functionality and I cannot seem to be able to replicate what I did before as the Picklist will not allow me to choose what Value is stored, it always chooses ID. Two questions really 1. Do I now not have a choice and have to used ID's?
Call function from other app - unsolved
Hi Related to the recent problem (call function from other app): Unfortunately, it doesn't fix the problem - actually the problem is a bit different. The function(s) Works well in the report when this is opened in the "mother" app. But we have made another app and on a Page we embed the report using the script builder Embed Form/Report (the code: <div elName='zc-component' appLinkName='event-manager' sharedBy='jesper.johansen' viewLinkName='FreeApp_event_overview_2014' .....) And HERE the functions
Integrate zoho creator with joomla users
Hi, I'm completely new to Zoho Creator. My idea is to develop an application and integrate it with my Joomla website. I'd like users to log in and be able to keep their data in the server so that when they come back or login from another location the data is still there. I've done this before using PHP and JSON files for other projects. Basically, every time data changed, a JSON file was created in the server and reopened when the application started. I would like to know if zoho creator allows exporting
Call function from other other app - unsolved ver 2
Hi Again, We just testet Again. On the Freelancer App/Home (where we embed the report/view from Event Manager App) the functions are NOT working. Have tried with both IE, Chrome and Safari. Have also tried with different logins. This is pretty vital. If it doesn't Work we have to downgrade from Prof to Enterprise edition. Thanks
export the data definitions
We are trying to rationalize two databases into one. I would like to take my primary data entry form in Zoho Creator and export the data definitions including field type, length, drop down choices etc. Is there a quick and dirty way to do this?
Next Page