App works from "Access this Application" button but not from the Dashboard
I am the developer of an App, when I use the Access the Application button at the top of the edit app screens my app works as expected. When I access it from the shared app dashboard it does not. Normal users (i.e not developer) are also seeing the same problem, but Admin is not. The application has been being used regularly without issue, no changes to the app have been made recently, the issue seems to have arrived at the same time the new Creator was put live. Anyone seen anything like this,
Delete Lead from Deluge
Hi, I want to delete ZCRM lead using ZCreator form. I have LEAD_ID. Need help in syntax??
Interactive application header
Hello, Have you think about interactive header?: Space between company logo and SignOut link, above menu bar , is now blank - but it'll be great to have ability to load some constant HTML-view here, where we can notify users about some events, chnages, give him portion of important information and so on. In settings we can change time, when this html-view will be refreshed
Multiple Application Developers
We have not been able to give developer access to multiple developers. Is there a way around this issue? I have not been able to find any information on this in the help forums.
Conditional list of users whom assign order
Hi In new app will exist about 700 users who will receive orders via this app Manager at head office need on editing order assign it to user who will execute this order. How can I in app window make listing of all users whom manager can assign order? Assigning = select one of all users & save entry. User = zoho.loginuser After this assigning I think make one conditional view so that user1 can view from all entries only entries assigning to only user1
Copy Multiple Fields from 1 form to another
I don't want to create a copy of an entire form, I just want to copy 10 fields from 1 form to another. Is there a way to do this?
File Links in Emails (yet again)
OK, so I've followed all the discussions on placing a link to an uploaded file in an email. The code: filelink = "<a target='_blank' href='http://zohocreator/DownloadFile.do?filepath=/" + r.FILE + "&sharedBy=" + zoho.adminuser + " '>Flyer enclosed - click here.</a>"; The result: http://creator.zoho.com/DownloadFile.do?filepath=/1242306054475_5517.pdf&sharedBy=niskypto What I see on the page: You are not authorised to access this in Zoho Creator. Go to Home My application is private. Is that the
single sign-on using our LDAP server
Can we sign into Zoho using the single sign-on using our LDAP server. We also use Microsoft Sharepoint Server and I wonder if we posted this app on a Sharepoint page, could we share the user sign-on data with Zoho?
help with getting values from subform and updating other forms
Subject line is not too good, here is what I want to do. I am building an inventory system that will include components (bottom level part) sub assemblies (made from components) and assemblies (made from sub assemblies and components) What I have now is a sub form in an assembly form that allows me to pick components and assign how many are needed for the assembly. I also have a form field to input the number of assemblies being "built" Now what I need to do is grab the number being built and multiply
How to dynamically replace a dropdown list value?
Hi All, I'm looking for some magic code to solve a small problem please! I have a customer database where each customer can have multiple addresses. I have a dropdown list in the Add Customer form with "Address 1", "Address 2", etc. On Edit, I'd like to indicate to the user which addresses have some data and which are empty. The way I see this is to add an asterisk to the end of say "Address 2" in the dropdown list so that it become "Address 2* ", indicating that address 2 has been filled. I can
Restrict Print to Iframe with barcode image
Hello, I'm working on an application that has a barcode component. I have an HTML view to generate the barcode image from a third party app, and I can print it, but when I embed the HTML view in a page with a form the Print Button Prints the whole page rather than just the barcode. Can I configure the Print Button to only print the Ifame it is in rather that the whole screen? Maybe a custom action?
Pushing Data from Creator to CRM Problem
Has Creator changed when pushing data from it to Zoho CRM. I had used the previous deluge script: myFieldMap = map() ; myFieldMap.put(“First Name”, First_Name); myFieldMap.put(“Last Name”, Last_Name); myFieldMap.put(“Email”, Email_Address); myFieldMap.put(“Sign-up Type”, profile_type); response = zoho.crm.create(“Leads” ,myFieldMap ); That script used to work fine, but not anymore. I have changed any settings on my app. Anyone having a similar issue?
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
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?
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.
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
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;
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
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?
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.
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
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
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)
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.
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
Email Notifications
How do I include an uploaded document in an email notification on Creator?
Set project status to pending as long as current date is before start date
I'm Trying to create an automatic status for a project that will say "Pending" until the Start date of the project is reached. I tried creating a formula field called Status and tried to use an if statement with zoho.currentdate, but it didn't work. Can someone help?
Try Editing Records via Record ID
I have tried to editing Records via Record ID(https://creator.zoho.com/jeremy.nagel/copy-of-teacher-database1/#Form:Teacher?recLinkID=<%=ID%>&viewLinkName=All_Teachers).It work fine and takes to record edit mode. But once I click on update button it redirects to this https://creator.zoho.com/appcreator/jsp/successpage.jsp page and wants to redirect to All Teacher view Any help appreciated.
can i insert data in subform by insert expression
Hi, I have a Form "Create_Invoice" with sub form "Product_Details". I want to insert data into the by a Create_Invoice data which ID I have given. I use following codes: invs = Create_Invoice [ID == input.invId]; insert into Create_Invoice [ Added_User=invs.Added_User Subjects=invs.Subjects Itemline_Products_Type=invs.Itemline_Products_Type Due_Date=curNewDueDate Discount=invs.Discount Sub_Total=invs.Sub_Total
Filter Zoho CRM Field and change columns?
I want to use a zoho crm field in my form. Its easy enough to use the drag and drop method of this but this seems to leave many issues. 1. When using the form and adding a value to the zoho crm field, how can i control what columns show in the popup window? The columns that currently show up when using the invoice module is the Subject, Status, and Grant Total. I want to change these columns and add a couple additional ones. How can this be done? 2. How can I filter out certain records from showing
Syntax errors don't show on correct line
Hi Zoho, I've noticed that I get "improper statement" errors with unhelpful line numbers. E.g. try compiling some code like this: //send out editorial writer emails for each booking in input.Edition_Bookings { //check whether an email has already been sent to this writer writer_obj = Editorial_Writer[ID == booking.Editorial_Writer]; writer_email_address=writer_obj.Email; email_sent_to=booking.Email_sent_to_editor_email; if(email_sent_to != writer_email_address) { //either no email has been sent
Two problem with application: not run imputation to field and not run duplication and import ds
Hi, My first problem (and it is important for us) is not run imputation to field. My applications is kind of survey. I didn't check Zoho Survey, because I need integration with Zoho CRM and i want send data to my service. We have one survey but six other way. So I did one general form and seven stateless forms. One form to define way ( one of this: Women age <29,Women age 30-49,Women age >50,Men age <29,Men age 30-49,Men age >50) Every of this form have ~30 questions. We split every for 5-6 site.
Previous script logic no longer works with new application builder
All, in the old system the following code would ignore fields that had nothing selected, and would only perform the INSERT command for fields that had item selected in the dynamic pick-list. // If the serial number field is set to something other than -Select- then data will be inserted into the data capture form. else will be ignored. if(input.Serial_Number_One != "-Select-") { insert into Crossover_Testing [ Added_User = zoho.loginuser etc........................... this statement
Next Page