Multiple applications or 1 big application?
Hello, Rightly or wrongly; I have developed a few applications which combined make a nice suite for us to use at work. I'm not sure if I should have built it as 1 large application rather than 6 small ones. Can someone tell me if there are any restrictions / limitations on doing this? I can access data from each application using the Look-Up field - but can I access data when I want to create a Page which will display data from all different applications? Also, am I able to put Links to the difference
Lookup problem
Hello, I have a similar problem to the one here but my code writing skills are non-existant and I cant seem to adjust the code to suit. I have three forms: Client_entry_form Project_entry_form Document_entry_form Each project is assigegned to a single client and each document is assigned to a single project. The idea is that each client can have multiple projects and each project in turn can have multiple documents. I have the forms set up so that I can lookup project details from the document
Deluge update record - variable not defined
What am I doing wrong here? Deluge complains that thisEpisode is not defined on line 4. if(input.Close_Issue) { thisEpisode = Episode[ID == input.Episode].Episode sort by Added_Time desc; thisEpisode.Closed_Date = input.Date; }
strange math?
I have a simple calculation that's taking a field whose input is minutes and converting it to hours: Finished_Hours=(input.Finished_Length_minutes / 60).round(2); I'm inputting 614 minutes and it's giving me 10.2 as the answer instead of 10.23 why?
magento database
hello, Is it possible to connect magento site to another mysql database?
New App-builder - All set to hit the Screens !!!
A warm welcome to all Creator customers! You would be in the midst of joy using the old App-builder for these many days. Adding to that joy, we are delighted to introduce the new user interface and latest features in the product. The new app-builder possesses a modern outlook and well-organized application creation process that makes the application more dynamic, impressive, agile, user-friendly and robust. It’s time for everyone to change over to the new app-builder and enjoy the nice look & feel
Variable is not declared error when using a field from form
Hi everyone. I have a form for courses that has a Maximum_Capacity field and a Currently_Enrolled field. I'm trying to retrieve all Course_Name's where Currently_Enrolled < Maximum_Capacity. All of these inputs are declared in my Add_Form and I'm trying to access them in a new form called Enroll_Form. I used the Script Builder to set it up, but when I try this: "opt = Add_Course[Currently_Enrolled < Maximum_Capacity].Course_Name;" I receive an error stating that "Variable 'Maximum_Capacity' is
Pull Specific Field from other Form in Lookup
Quick background - I'm creating a project management system and have multiple form for different sub departments. One of the departments need to be able to calculate a project cost. To do this I have a lookup field (on FORM A) to select the product used in this project (FORM B). What I need to do is pull the price field for Form B and set it to a variable in Form A so I can out that into a formula. When I put the code together I keep getting and error that its looking for the boolean not a decimal.
String functions
Is there a tutorial or some sample code which demonstrates the use of the string functions?
Creating a calculation in another form on User Input in current form
I have a form for Assignments based on a project lookup from a Projects Form There can be several assignments per project and hey're delineated by Freelancer name. When I update the final length of a project in the Project Form I want the Length_of_Project field in the Assignment form for each person to update with that value. How can I do this? I've tried: onUpdate and onInput for the final length field in Projects to Fetch Records and the For Each Record, change the value of the Length_of_Project
How to set reminders to a user ?
Is there a way I can evoke reminders for the user for a particular date and time field ? Say if a date is set for 23rd November , on 22nd Nov or otherwise in a particular order I can keep reminders ?
Custom Scripts
Could someone help me with a couple things. I have a form set up and the data goes to a report however I would like to add some custom scripts but don't know where to start. 1) I have a form field that needs to be forced into all caps on user input (or data submit). I have tried a few options with the .toUpperCase() but can not get it to work. 2) Is is possible to have data on my report (specific row) to highlight a specific color based on a the date/time? For example, if the system date is within
Stringlist field in if statement
OK so I'm sure this is simple but I keep getting a syntax error saying Encountered ")" at line 1, column 37. Was expecting one of: "," ... "*" ... "/" ... "%" ... In the field action for Device_Thrombus on user input I am trying to hide all the fields on the form if they select No. Device_Thrombus is a checkbox field with the values Yes and No. if (input.Device_Thrombus.size() > 0) { if(input.Device_Thrombus.contains("No")) { hide input.If_YES_Covers_threaded_insert; hide input.Thrombus_Covers_Threaded_Insert;
False advertising - Misleading - Liars - SCAM Warning
To our disappointment, Zoho is an elaborate scam. DO NOT UPGRADE. According to this link: https://www.zoho.com/creator/help/zoho-creator-pricing.html Clearly shows branding is part of $49 Express plan - Only AFTER you sign up do you find that this was a lie. Typical. In addition - there is NO SUPPORT. The number is an answering machine. No one is there, and no calls back. DO like we did, and use a Virtual Credit Card if you want to upgrade anyway and see for yourself. This business is in India
Count grouped records
Hello, I am new here. I have made a report which shows records by grouping. How can I show the count of records for each group in the report? If I can make this work, I am sold on zoho! Any help will be greatly appreciated. thanks.
Adding existing users to share a report/ form
Hi there, I am trying to share a report with about 120 users (Amateur theatre company) Zoho complains that this is too many users and I should use a group. However when creating a group it asks me to invite users. I do not want to invite users as I do not want them to receive an email from zoho to join a group (for sharing a report/form I can switch the automatic invitation off) . I want to send them a personal email from my email account sending them a link to ZOHO to sign up, login and update their
Cannot log into Creator without security selections?
Hello, I am having trouble logging into Creator bypassing the new security option - it will be difficult to get all of our users to enter daily codes delivered through text messages each time they access the applications. Please advise. Thanks, Silvia
Signups and Password Recovery for Front Facing Apps
Greetings all: Does anyone know if there is a help page/work around for allowing signups and password recovery for front facing apps developed in Creator that: a) at no point shows the zoho logo or involves any screens that contain zoho info (account confirmation page, etc.) b) allows you to specify a different confirmation email so that again, the zoho info doesn't show up... It is obviously very confusing to new people signing up for an app where the app has a different name and the domain is
sharing an application does it even work?
According to this document, its supposed to work, but it doesn't seem to for me. https://www.zoho.com/creator/help/share/adding-new-users.html#Adding_a_Developer_to_account_and_allow_one_of_shared_users_to_access_the_application
Can't save from form Definition
I needed the exact same fields on two different forms. I went to the definition of the first form and copied the field information to the definition of the second form. When I saved I got this error. Error modifying the page null On similar occasions it has saved correctly. Are some field type not allowed? Is the error indicating some other problem?
Could you please code a scale on every axis of a radar/web plot?
Hello there, I checked with other developer and curiously enough, seems there is no way to see a scale on the axis of a radar/web plot. See example below: Maybe I am wrong, but this is quite odd. What is the use of a plot without a reference scale? Could anyone suggest a solution on this? Thank you D
Why my code disappeared in Z creator?
I have written the code in creator and after saving the code when I reopen the page I see the code is missing from the page. Please help me. Please see attachment ZCode.png.
created a user, but it can´t share the app
Hi, I´ve created a user with a zoho.com email and password, but it can´t access my app. I´ve shared the app with that user. Why is that ? What should I do to share my app with a user with a zoho email ?
500 internal error
basically I use zoho creator & try to use API data write but after follow the instruction as per zoho instruction, when code try to the connect the zoho server that time server ( Or Code?) give the response 500 internal error. please give resolution for this problem.
Record Summary View: left-justify data in linked tables
Hello, How do you set data to be left-justified in the columns of a linked table in a Record Summary view? I set both the label and value formats to be left-aligned, but it still comes out centered (see attached images of edit and view pages). Additionally, is there a way to change the column widths, or is that only set automatically? Thanks for your advice. Cheers, Elizabeth
The form created with Zoho creator does not paster entire number in indic fonts
Hello, I have created a form when I can enter a telephone no. The max digit is set to 10. when i pasted the number using indic fonts i see only ५ १ २ ८ ५ pasted. What am i missing? Thank you
Scrip Builder Freezes
In creating a new function, when I select to add the aggregate record function, the screen freezes and it grayed-out. Cheers, John Whitney
Edit record URL not working
Why would it be that, as an Admin, I can view this: https://creator.zoho.com/zoho_admin58/obm-system/#Form:Contracts?reclinkID=1526298000000741045&viewLinkName=Contracts_List (which allows me to edit record, and shows all the Zoho headers), but I get an error message with this URL https://creator.zoho.com/zoho_admin58/obm-system/Contracts/record-edit/Contracts_List/1526298000000741045 The message is "You are not authorized to edit this record." I'm sure this WAS working before.... Alex
Can't even get a simple fetch data to work
Why is this so hard? I have two test forms: Form1: Name Age Form 2: Name lookup dropdown from form1 Age I just want the age field on Form2 to auto enter the age from the selected name in the dropdown. Essentially looking it up from Form1 It keeps telling me the name is an integer. What EXACTLY do I need to do? thank you.
Real time search filtering available?
Is real time search filtering available in zoho creator? i.e. where the results narrow as you type in the search field. See link for video demonstration: http://youtu.be/wfNIK-nhySc
print attached pdf files record summary
Hello, I would like to know if it is possible to have an attached PDF file print from a custom Record Summary. Thanks,
Field Value validation
Hi, I have a form where users enter in a unique coupon code to enter a competition. At the moment the only validation is that the length matches, so a user can enter any X digit number and it will work. I need to be able to compare the entered field value with the unique coupon codes and if there is no match the form doesn't submit.. Any pointers? Thanks
Lookup field in 'Record Summary View' shows ID, not value
Hello, I've got a Record Summary View to summarize customer data. Some of the fields on the source form is are lookup field, such as from a list of technicians or service operations. However, in the view, it displays only the ID of the lookup selection(s), not the value, as shown in the attached image. Is there a way to correct this? Thanks, Elizabeth
Zoho Creator issues importing files
Every time I try to upload an excel file it takes me to the page where it imports the data but even when I name the label and click Finish this error message pops up "Please provide label name for database form."
SubForm edit
I try to connect records from subform into main form. I make 2 simple forms and joined it as a subform. I build simple code: Record = Availability[Date_field =="12-Nov-2013"]; Subrecords = dt.SubForm; info Subrecords; The result is: Time_Schedule[ ID in (1581254000000652651) ] Then i build next code: IDList = Time_Schedule[ID !=0]; Record.SubForm = IDList; info IDList; The result is: Time_Schedule[ ID in (1581254000000652639,1581254000000652647,1581254000000652651,1581254000000652743,1581254000000653527)
automatic data uploading?
Hi. I'm trying to build a web page around an embedded zoho creator application. I need the data to stay up to date for the application to be of any use. This needs to be an automated process. Is there a way to upload data from a server to my zoho creator application? For example, in .csv format?
Lookup field in a subform
How can I detect if a lookup field in a subform does not equal "-Select-" please? I'm sure others must have hit this same problem but I haven't been able to find the answer as yet! I have tried null and even ID=0 but no joy so far. Many thanks for any advice
Creating a form which filters out projects that don't have assignments
Hello - I'm trying to create a report that will show me only projects for which I have no one assigned. Assignments is a separate Form from my Projects Form. The Assignment Form references the project that it's for, so there must be a way to filter just projects that don't have any assignments, but I'm not sure how. Probably involves creating some kind of flag when an assignment is created. Can someone help? and talk me through it? I'm a newbie at this, so I need baby talk... :) thanks in advance.
Extremely poor and unprofessional services from ZOHO Creator
Hello All I may be the only person experiencing this, but since the middle of August, the services provided by Zoho Creator has gone to the dogs. Case in point being unresponsive and dodgy customer service, who among the many ills include unresolved ticket issues and a case of speaking from both sides of the mouth. Additionally, for the last two months, I have had a persistent problem with schedule execution, which despite numerous calls and emails, has remained unsolved. To add salt to an injury,
how to embed a specific form entry on a web page
Hi, I am building an application for real estate, and it has one record per property, with all the property details needed for that property. The data is filled in by the company staff when they are logged into zoho creator. I would like a way to then embed the record view on a web page for a particular property so that our customers can view the property details and make a purchase decision. Of course, the embedded details are not editable. How do embed only one record onto a web page? Thanks, David
Next Page