Displaying an image in a HTML page
I have a Child_Registration form with an image field and a HTML search page that fetches and displays individual data from this form. I want to include the child's picture (Photo_ID) but it always displays as a broken image. I have looked at all the guides and information on images but can't seem to get the right code so the image displays.
Mobile Form showing hidden fields.
I have a Form that in the browser is behaving correctly. i.e. it hides a field until a rule/task is activated and then shows the form field. However on the mobile device it behaves differently. On initial load the field appears. Other rules within the form behave correctly. I have deleted and re-created the rules as well as the form fields but each time it is the same. Can you please provide any assistance as to the cause? Thanks Kevin
Logo or Image insert in a form or Page in add note
Dear Sir I have created one form having two field "Name" and "Image", and update data with company logo and create a function module for fatching the logo Code as follows string Pipeline_Management.Image(string name) { imagelnk = Image[Name = input.name].Image; imagelnk = imagelnk.replaceAll("/sharedBy/appLinkName/","https://creator.zoho.com" + zoho.appuri); imagelnk = imagelnk.replaceAll("viewLinkName","#View:Image_Report"); imagelnk = imagelnk.replaceAll("fieldName","Image");
why checkbox automatically deselects and how to sovle it?
hi there is list with 2 variants of checkboxes checked variant_1, before script variant_2, after script script is " // search entry by ID record = zayavki_form [ID == input.record_ID]; // check on in a list "email_process" // value of checkbox "subscription_page_visited" // (in input.email_process variable) record.email_process = input.email_process; " why after script execution "SMS_subscription_sent" is unchecked?
How can I make an Autonumber Creator field visibile?
Is it possible to make an autonumber field visible ?
why there is a endless loop for .remove() ?
hi try remove "On User Input" some characters all works well but interface views that there is a endless loop of operations code "On User Input" mob1 = input.mobile3.remove(")"); mob2 = mob1.remove("("); mob3 = mob2.remove(" "); mob4 = mob3.remove("+"); mob5 = mob4.remove("-"); input.mobile3 = mob5;
Invalid JSON String Format
Hello, We are trying to fill-in the pincode of a customer through an API call. The API returns the values in JSON format such as: {"query":"Delhi","pincode":"110001"} If the pincode cannot be found, the API returns with the values such as: {"query":"Searched Address","pincode":"","error":"Not found"} We get a "Invalid JSON string format" error when address fields are left blank on add customer record form. The code we are using to make the API calls is: if (input.Address_Line1 != null || input.Address_Line2
how to set admin permissions to notes?
hi! need document all fields by notes there are more than 50 fields how can i set for notes view permissions "Admin only"?
Add product detail in PurchaseOrders of CRM
Hello, i user ZCREATOR to create PurchaseOrders in ZCRM. I put only Product in a List as itemsList = List:Map(); ..... For each ligne in MyView..... { itemsList.add({ "Product Id" : ligne.ID_produit_ZCRM, "Unit Price" : MonProduit.get("Unit Price"), "Quantity" : newQty, "Total" : newTotal, "List Price" : ligne.Prix_achat, "Net Total" : newTotal }); } My ItemsList is full with product. responseCreate = zoho.crm.create("PurchaseOrders",{ "VENDORID" : idFournisseur, "Subject" : Subject, "PO Number"
can't able to imort app?
When i just trying to import app as a .ds extension it shows me Invalid Request
Dropdown field is showing "Other" option
We have a Creator application where we are tracking Customer's visit activity. Currently the Activity dropdown field has 4 options: Buy - Yes Buy - No Decision Pending Return/Exchange When adding a record, we get the desired 4 options. However, on the edit screen, Creator shows an additional option - "Other" as shown in the image. We suspect it has something to do with the On Load screen of that form but can't really figure out whats the issue. Any help would be appreciated. Thanks!
lost field in report!
hi! previously was made a report all works well few days ago lost 1 field "дата доставки" in field it is, but in report there it is not how to solve it?
What is wrong with this code?
I am new to Zoho Last_Purch_Price, Sup_Cost_Factor, & DPI_Cost are decimal fields, Units_in_Purch is a number field In the same form. I want to calculate the DPI_Cost, but only if there are valid values in the 3 fields needed for the calculation I tried to enter this code in the On User Input field action of the DPI_Cost field: if(input.Last_Purch_Price != null && input.Sup_Cost_Factor != null && input.Units_in_Purch != null) { input.DPI_Cost = ((input.Last_Purch_Price * input.Sup_Cost_Factor ) /
Searching in a lookup field
I am trying to set up a search page based on a lookup field (Child's Name). This generates the ID number. The search field (Search Child) is defined as a Bigint but in the HTML page the searchParam is defined as a string even though it is actually a number. This means the searchParam never matches the Child's Name field. I tried changing the searchParam to be defined as a number but it gave an error saying it was trying to update to a different data type. How can I adjust the code so the search
Child fields
Hi all, I am building a simple database and I would like to focus on 4 forms : Companies: legal company details Addresses: a list of addresses, zipcode, city, aloso defined by an "address name" Sites: association of a company and an address, because companies may share the same address. I have two lookup fields by company legal name (relation to Companies) and address name (relation to Addresses) People: all details for on person with a lookup field to Sites, so that each person is linked to a site,
Filtering Lookups
I am a newbe to Zoho I have three forms: Inventory (with among others 2 lookup Fields, Product_Class and Product_Sub_Class) ProdClass (with one field, Product_Class) containing all unique ProdClass in ProdSubClass ProdSubClass (with 2 fields, ProdClass and Product_SubClass) containing all valid ProdClass and Product_SubClass combinations The Product_Class lookup of ProdClass works fine. I want to filter the Product_Sub_Class lookup to only include records where ProdSubClass.ProdClass = Inventory.Product_Class
Fetch and Update
Hi, I have a form "Lesson Items" with the dropdown field "To_Do". I have a second form called "Plans" that has a lookup field to "Lesson Items", and (also) a dropdown field called "tasks". I already have it set up to pull in the values of the lookup items "To_Do" field and populate the "Tasks" field. That works fine. But what I want to do is make it so that when I update a "Lesson Items" form, it will update any "Plans" forms that have the same ID in the "Lessons Items" lookup field. I have tried:
Subform Record Delete Behavior
Hi, Can someone confirm for me that as soon as i click the "X" delete button on the subform, that record is deleted, regardless whether i Submit the main form or not. Is there any official documentation about this behavior? Is the subform On Delete script executed before or after the subform record is deleted? Again, can't find any documentation that addresses this.
how to extract email from muti-line text?
hi there is records which contain one email in mutli-line field how to extract such email from whole text of this field?
Form Timeout?
Hi all, Is there a way to implement a form timeout? Ideally, I'd like to be able to set a timeout on a form for a period of time where there has been no user interaction define an action when the timeout is reached (in this case load another form) I could try this by building a page with a timeout if I was using a browser, but my app is used within the Zoho Creator Mobile app so I specifically want it to load a form or view on timeout. Thanks in advance!
too long time - adding field to form
hi there is too long time when i add new field in big form https://creator.zoho.com/appbuilder/rfclient/ikeaserv-app/form/zayavki_form/edit was tried on firefox/chrome/safari, macos when i add in a little form - all works well
How can i make a two colum layout only for particular fields?
I just created a form consist of two columns. i arranged the fields. While arranging the subforms field i just want to display in the single column is it possible ? Please suggest me
zoho.currenttime
Hi Sorry of these are dumb questions .. just started using the system ... When I create a timestamps using zoho.currenttime it seems to include the date .. is there a way to only include the time .. Also is there a way in formula to work out the delta between two timestamps .. Example .. first record is (time) 15:00 and second record is 15:12 - so answer would be 12 Thanks Mark
open url
hi. can someone please help me i am trying to pass values from a report to a stateless form my reports url shows as: https://app.zohocreator.com/******/*******/#Report:Quotation?Fare_ID=3 and i wish to open a form using open url and assign fare id field in the form the value of reports fare id. i appreciate your help regards adeel haroon
Customer Portal
Hi, I have created an application and enabled customer portal thru application settings. Later I registered 2 users to this portal for testing purpose. I created a few records by logging in with user X. However when I logged in with user Y, then I am able to see the records created by X and vice-versa. Both the users have default customer profile. This should not happen as one user should not see the data (records) of other user. I am not sure why this is happening. Anyone please help ? Thanks, Milind
One app two CRM accounts
Hi, is there a way I can share an app from my account (A) to two users that are in two different accounts (B and C) and the app access the users corresponding CRM (A, B and C) ??
How to create a daily attendance sheet that automatically populates
Hello. I have this screen shot from an application from the Marketplace, but I can't find the app anymore. I would like to create something very similar to this in my app. After selecting an Instructor, the Enrolled Students section is displayed & populated. Does anyone know how I would achieve this format in a form?
How to unhide fields that have been hidden on load, when i choose an item from a visible dropdown? Then unhide another dropfield or fields on select from this now visible dropdown and so on???
Hide many fields with hide on load. Now when i make a selection on "Product types" want to unhide some hidden field / fields. Getting errors.. not sure about the script needed
creator customer portal permissions
I see in the user permissions for a zoho creator app that i can define field based permissions. I do not see a way to do that with the customer portal. How would I do this?
Form cannot submit
Hi, I created a form and tried to submit it. It just hangs. Could anyone help? https://app.zohocreator.com/zoho_zoho812/hbhd2016/#Form:Pendaftaran
how to send email from custom email address?
hi! there is email of application admin - "app-admin@email.com" and custom email - "custom-email@mail-xyz.com" how to make sending using internal "sendmail" of zoho creator so that 1) from address will be "custom-email@mail-xyz.com" 2) emails from zoho creator's email service will be not in spam because of SPF and DKIM settings of mail-xyz.com email service
Reorder Multi Select Values
Hi, I have a Multi Select Field and it is working good. Sometimes I need to rearrange the order of the Selected Values in the Multi Select Field for some reason for instance if three Values have been selected in the order Val-01, Val-02, Val-03 .. Then If I need to rearrange that order like Val-03, Val-02, Val-01. What I have to do is delete all selected Records first then again select those three entries in the order that I want to achieve -Val-03, Val-02, Val-01.--. What would be great if there
Subform only works in Mobile App
I have created a subform to sort data on the back end as we process orders. The subform has a status field with a drop down but when I try to edit that field in the report in order to sort submissions I receive an error stating "You can submit this form only through the Zoho Creator App" Is there any way to get around this?
Auto identify subform rows
I am just starting with Zoho Creator. T have a form Jobs with a Job_No field (year & job No). There is a subform Labor. I want to populate a field Job_No in Labor with the Jobs Job_No every time a row is added. Please Help alexscott@btl.net
Error Messages
I'm a complete beginner and am just trying to get to grips with zoho creator. However I'm finding it very frustrating as when I try to add coding which is identical to the examples given in the guide I get error messages e.g. adding an email notification to a schedule sendmail [ from: gillgannon12@gmail to: thegannons@eircom.net subject: "Birthday Alert" message: "Happy Birthday <br />" ] gives an error on line 2, improper statement, even though I used the 'send email' drag and drop! How can a bracket
Modified_Time is not updated in the case of bidirectional relationship lookup fields
"Enable bidirectional relationship" option in lookup fields is a great feature, but I think that there is still a problem related to it. Let me start with an example: I have a form named Participants and another one Workshops. In the Participants form I have a lookup field named ChooseWorkshop - which refer to a field WorkshopName in Workshops form. I enabled the bidirectional relation in the ChooseWorkshop field, so a lookup field WorkshopParticipants is created in Workshop form. The WorkshopParticipants
URGENT: Is sendmail working for other users?
sendmail stopped working this morning in our production code. I wrote this simple test function just to see if emails are being sent. They are NOT. I checked my account usage, I'm not over my email quota. void WalkIn.OM.Temp.Test() { sendmail ( To : "lex.shan@walkintour.com" From : zoho.loginuserid Subject : "zoho testing email subject" Message : "zoho testing email body" ) }
How can i show lookup field id
How can i show lookup field id inside any module
External plugins iframe not working
I tried to use iframe(a widget) from external website in my zoho page. But it is not working. Please let me know what is the problem ? Regards, Webber
OnValidate
Hello everyone. You can use alerts and cancel Submit in native modules (Leads, Accounts ...?, If it's possible, how it would be. I welcome your comments. Regards
Next Page