HTML page to create record
Hi, I'm very new to Zoho Creator, is it possible, in Creator, to create an html page that users can use to create/edit records? We are finding that the 2 column CRM modules and Creator forms are very restrictive in terms of layout. I have created an HTML page with multiple columns but all I have found is that you can import data into the page from existing records where the input method would be a 2 column form. Our data is working data that is constantly changing and updating, not data that is
Creating picklist in code referencing form in other app
This is weird. I can have a lookup field which references a form in another creator app... but cant have descending order within the lookup field. I looked at the syntax for how the form lookup is declared and figured I'd try and manually build the lookup field contents mylist = othercreatorapp.formname[formfield == input.myfield] ; The above errors with Form 'formname' does not exist in this app! Whereas the form definition has type = picklist values = othercreatorapp.formname[formfield == input.myfield].ID
Attachment
When i add attachment as link ( Record Summary as PDF link in Zoho Creator ) in zoho crm it shows as 400 Bad Request How to change that Name? The link that i have used was "https://app.zohocreator.com/parath2/management/report/Management_Report/exportRecSummary?recLinkID=" + input.ID Anyone Solve this
Custom Report looking for differences between records
I'm having a hard time figuring out how to create this report. Let's say I have these forms. Product ID Name Package Template ID Template_Subform Product Package ID Package_Template Package_Subform Product There are other fields in the Subforms, but they're not important. I would like to find out which packages don't match the template. So it's something like: Show me all packages where Package.product not in Package.Package_Template.Product Thanks for any help.
Set Display in a Lookup field to a field in another form which is itself a lookup field
Is it possible to set Display in a Lookup field to a field in another form which is itself a lookup field? Say I am setting the lookup field to connect to the auto index number in another form since it is unique but I want the user to see a combination of a Customer Name + Lot Number since that make more sense for him. How do I do this. Any ideas?
Complex formula in Creator
Hi I have a formula in Excel: =0.3*POWER(EXP(1), (-5*x)) "x" is the only input. Exp(1) is equivalent to the mathematical constant e. Is there a way to render this in Zoho Creator in a formula or in Zoho Reports? thanks.
Matches Function issue:Fetch record task,unable use Matches in criteria
Using Matches function for a crateria to Fetch record do has a bug or not supported for example matchedRecords = formName [Single_Line.matches("abc.{4}d")]; abc.{4}d is regular expression return variable matchedRecords contains all record from in formName. it means regular expresstion do not work。 how let regular expression do work in matches function at fetch record task?
Intermittent Math Errors
I have a simple app which works perfectly over and over, then, randomly, it makes a math error. I'm talking about simple addition and subtraction. Maybe it is a processing time issue. Perhaps the next entry is happening while the last one is still processing? Regardless, it makes our scorecards unreliable in the eyes of the users. Help would be appreciated... Our techs use the app/form to walk through a checklist. The result is a number of "passed" items and a percent passed score. Basically, at
PDF View first page blank
When I create a PDF view from a HTML view, it is creating a blank first page. Following is a snippet of the view code: htmlpage Rental_Agreement_HTLM(ReservationNo) displayname = "Rental Ageeement" pdf = true content <%{ RentalAgreement = Rental_Agreement [Reservation = input.ReservationNo.toLong()]; PropertyInfo = Propery [Code == RentalAgreement.Property_Code];%> <table width="100%" cellspacing="1" cellpadding="1" border="0"> <caption><b><%=PropertyInfo.Property1.toUpperCase()%> RENTAL
MIME type may not contain reserved characters / Internal Exception
Good Afternoon everyone, When I try to call SOAP request, it responses with the exception messages 'Internal Exception' map validateXML() { xmlString = ""; xmlString = xmlString + "<soapenv:Envelope "; xmlString = xmlString + "xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" "; xmlString = xmlString + "xmlns:ec=\"http://ec.gob.sri.ws.recepcion\">"; xmlString = xmlString + "<soapenv:Header/>"; xmlString = xmlString + "<soapenv:Body>"; xmlString = xmlString + "<ec:validarComprobante>"; xmlString
Auto-populate multiselect lookup field from another multiselect field
Hi, I want to auto-populate a multi-select lookup field with the data from another multi-select lookup field. Form 1 "Item" "Name" (text field) "type" (multi-select lookup) Form 2 Multi-select field "Item Name" (this lets me pull up any of the form 1 entries) Multi-select field "type" --- this is the one I want to auto-populate from whatever was on the form 1 entry. For instance if form 1 entry was: Name: Pencils Type: Office supplies Then when I select "pencils" entry in form 2, I want it to be
URGENT - Zoho ID seems to have a 1 appended to the end of some users
Hi there I have an issue where by a database that is more than 2 years old has suddenly started acting strangely. Specifically, some "Active Users" ID's seemed to have changed. For example, i have one user who's id is zoho_bear in our system, but in the active users section under Manage Users, it now says zoho_bear1 There are a number of users this has affected, but not all of them. Does anyone have any ideas? Thanks Aaron
single select radio button default value
I want to make a single select radio field with no default value selected. Then I want the field to be mandatory. In other words, the user must select one of the several items, otherwise, he will receive a message reminding him he must make a selection
Public forms not loading/working
Hi, We are getting this error message when accessing our forms that are set to public. Some accounts are able to view it while some are getting the error below. We are also getting the same problem w/ public pages w/ embeded public forms. We already emailed support@zohocreator.com regarding the issue and we haven't received reply for the past 2 weeks. Here's the email reference no.: 18938532
Published view/report from Zoho Creator to be exported by any user with the link?
I have published a view/report from within Zoho Creator with a PermaLink with a long random string in it. I have enabled this Report to be exported by users. But if a user opens the link without logging in, the view can't be exported. Is this by design? This is not very convenient.
Scheduling recurring appointments in Zoho creator
Hello. We are builind an app for a corporate course providing company. The courses are or recurring nature, for example: Start date 10 nov 2017 time: 10:00-11:30 repeat: Every Friday and Wednesday this means every Wednesday and Friday, this course takes place between 10:00 and 11:30 Until: date is reached (date x) OR a number of (lets say 20) occasions have occured additional fields: location, customer, instructor Then we need to view these events in a calendar and ? or report view, and be able
Background App Refresh on iphones or ipads??
I'm not seeing an option for "Background App Refresh" offered on our mobile devices. This translates into having to come back to a report or record you were working off of as if you are opening zoho for the first time - from the top level of zoho, then click the application, then locate the report, then the record, etc. They take calls, read texts, emails, etc in between zoho updates as well. Coming back to where you left off, background app refresh, seems like basic functionality. Is there a setting
"," separator in numbers
I found that in all Zoho Applications the "," thousands separator is causing the number not being recognized as a number. Can this be rectified? this is very annoying.
Multi-language
How to develop a multi-language database with Zoho? The aim is to select a language at the opening of the database and only one.
Connect with ZohoBooks Software, FREE Manage Order, Inventory, Customer data, Tax, Shipping, etc…
Zohobooks solutions for All Business, Satva Solutions provides zohobooks service like zohobooks API integration, zohobooks connector, zohobooks installation, zohobooks repair service, zohobooks enterprise solutions, zohobooks desktop solutions, zohobooks online solutions, zohobooks support, for all small business, accounting firms, ecommerce, online stores, ERP, Accountants and Bookkeeping enterprise businesses and CRM systems. http://satvasolutions.com/services/api-integration-services/accounting-integrations/zoho-api-integration-services
Integration
which voice calling Third party applications will Integrate with Zoho Creator ? and Further Integrate with Zoho CRM Satish Kaushik Zoho Certified Developer, Net Greater Technologies,LLP Mobile: +91 956 071 6262 Email: netgreater@gmail.com Website:www.netgreater.com Skype: netgreater
Help! One to many relationship - idexing
I am new to Zoho Creator, but hope to create some simple but usefull applications. Currently I have a problem that I cant find a solution too, I hope someone can help me. I am creating an applications which makes to possible to register several "targets" in form#1 which has a one to many relationship to values ("tasks") in form#2, which again har a one to many relationship to values ("subtasks") in form#3. TARGETS=>TASKS=>SUBTASKS I am able to create this with lookup fields and subforms, but how
Invitación a AppCreator
Estimados, llevo mucho tiempo esperando la invitación para utilizar AppCreator; cada vez que entro recibo el mismo mensaje: "AppCreator - Your invite is on its way! You have requested an invite to sign up for Zoho AppCreator. Thank you for your interest. While we are excited to have you on board, there are a couple of things we need to do to make your experience comfortable with us. We shall send you an invite as soon as we are ready." Podrían indicarme por favor en qué estado se encuentra mi solicitud?
Is There a Way to Turn Off Picklist Filtering
Hi, I have a lookup field "lessons" that I want to be filtered by a lookup field above it called "modules". Here's the thing: I also want the option to choose a lesson regardless of module. Is there a way to create an option to switch the filtering "off" from the form? Thanks,
Run a Google Script from Zoho
Hi All, I have a script in Google Scripts that I'd like to run from Zoho. The script has a few parameters, including a file that I need to attach. Is it possible? Thank you Ravid
Concern
Hi, Every time i submit it will always pop up error like the picture below: 1 picture is the first error. 2 picture is "Successfully send remarks" and i attach my code;
Updating Application/Patch
I have two zoho creator application 1 is the original and 2 is the duplicate. 1. The original application will be used by others by sharing to them the permission to used. 2. The duplicate one is for me to change or to update the application. My question is: How do i update my original application from duplicate one without deleting the users,data and the user profile of the application? Thank you in advance, Jee Zoho creator User
Set report criteria via URL to view data in subform
Hi, Can you open a report to a specific record (and maybe other criteria) where that record ID and other criteria is passed in via the URL? I have a Master Form with a Subform. The Subform of course has a lookup back to the Main Form (let's call that MF_Link_ID). Let's say the Main Form has information about a contract and the Subform has some details about the contract, some of which require approval (a decision box in the Subform). I want have a report that has custom actions for a person to approve
Application Form Width - Wide Screens
Not sure what I am missing, but why do the Application Forms only utilize a small portion of the screen aligned to the left? Is there anyway to adjust the forms to take advantage of wider displays? Do I just need to develop HTML pages for each of my forms?
Deluge scripts run OK when subform is standalone, but not when embedded in a parent form
Hi all, I'm modifying the Order Management application. When a New Product is added, I have a SubForm to add Serial #s for unique SKUs. For the first row, the user can use the Barcode read function to get the first Serial #. After that, when each row is added, for the Item_ID_UPC_Barcode field, I have added a script (that I found here) that will increment the original Serial # by 1 and place that value in the new row's Item_ID_UPC_Barcode field, thus saving the user the work of having to scan or
We need to pick the fields automatically while we perform the click action
We need to store the (Gross Size, Size , Price) fields in purchased view from the stock form. And need to pick automatically those fields (Gross Size, Size , Price) to the Add sales view. Our problems are marked in Screen shots and uploaded with this request , so we need support
We need to pick the fields automatically while we perform the click action
We need to store the (Gross Size, Size , Price) fields in purchased view from the stock form. And need to pick automatically those fields (Gross Size, Size , Price) to the Add sales view. Our problems are marked in Screen shots and uploaded with this request , so we need support
Building an FAQ App in Creator
Hi, We want to build an app in zoho creator on FAQ. We will upload all our FAQs belonging to different categories(About 10 categories) using forms. Each category will have 100s of FAQs. A Report will be embedded in the FAQ page of our website. We want to use button field for categories. App will display a list of FAQs whenever a choice category button is selected. At a time only one question can be displayed. When another FAQ is selected previous one will be shut. Similar FAQ APP is readily available.
Different price based on field value
Hi, I have one service, gymnastics classes at various preschools, I'd like to sell via a form in Zoho Creator. I want to use the same form for all locations/class times but need price to change based on field "school name" parent selects for their child. For example, Parent registers child at school selected in drop down field "school nam" called ABC School. the price may be a recurring monthly cost of $49. Another parent may select school DEF school and the price there is a recurring monthly cost
Variable Field names for reporting product attributes
I would like to create a report of Products that for every Product includes fields like: Part number Description Product Type Manufacturer Data sheet link but also has a number (say 10) fields that contain attribute values (text or decimal) such as: Weight Power Type etc. BUT I need to be able to change the attribute field name depending on the Product Type i.e. some product types will require certain attributes but not others. Does anyone know how to achieve this?
Office 365 Single Sign On for Zoho Creator
Hi, We are using Zoho Creator to build apps to be used across our enterprise and are interested in using Office 365 Single Sign On for all our Active Directory users (about 2400) to access our Creator apps. Do you know when SSO will be supported in Zoho Creator? I see that the Office 365 SSO option is available on the accounts.zoho.com login page, but that provides a poor user experience for our end users. We need single click access and pass through to our zoho dashboard. Thanks Phil
Allowing a user from outside the organisation access a report and update a form using a custom action
I have create a report and also a custom action that allows a user to see a list of records in a report and then click a custom action which will open. dialogue window where they can enter data using a stateless form which then updates a record in the database once submitted. This works for an internal user however when I send a link to the items I want to share with a user external to the organisation. All that is visible is a form which is not what I want. If I send a published link or embedded
Check previous forms from the same day
Hi For my form created in Zoho creator, i want to have a check. Only 1 time a day the form can be submitted for K&n K2, G1, .. So when someone tries to send the form again on the same day when K1 (or K2,..) is selected a message should be displyed. How can this be achieved as a script in delunge? Kind regards
How to build Api integration
Hi there, i've been using creator for our standalone app in the past year. Now I would like to build an integration with local (Dutch) accounting software. They do have an API available, and I'd like to have Creator create a new customer when we do that in our accounting software, and vice versa. I'm not an API expert so was looking online but couldn't really find how to do this. anyone that can point me in the right direction? eg online explanation etc. I remember this was part of the developer
Import existing customers with paypal
Hi, I need to import about 180 existing students into our database whose parent already pays monthly via PayPal recurring payments...what is the best workaround/way to: A) import these students with their associated parent contact (2 separate forms: 1 for students, 1 for parents then Set in creator to Lin) infoand B) import their payment information either automatically (hopefully) or manually if I absolutely had to do it that way?
Next Page