Styles for Embedded Forms: IE issue with blockquote CSS
In Internet Explorer, the blockquote shown below is white. In Chrome, it takes the color of the form. Can this be fixed? I'm using style url attributes to control the appearance of these i-framed forms (ref). Cheers, John Whitney
Popup window reported a bug
Hello Zoho Support team and Developers, I am added a problem here which i am encounter in my application, i am add many clickable icons or links in my HTML view and all of them are opened in popup window. now the popup window encountered a problem. when i am click on the clickable link i am see a popup window appear now i am close the popup window by click on cross icon on the popup window. as i click on the cross icon of popup window the popup window is disappeared, now when i am again click on
Add Data by Email Issues
Shared to support https://creator.zoho.com/buzzap/form/209/edit/ I have a custom gmail account authorized to forward email to the form linked above. It worked a couple times but now it's not. Cheers, John Whitney
convert xml response (from ZohoCRM) to simple “key=value” pairs (for SurveyGizmo) using php or Zoho Creator
Hi there, This deals with exchanging data between CRM & Gizmo. I'd like to Creator (or php) to convert the response. SurveyGizmo posts (insert) data to ZohoCRM. After insert, Zoho responds with xml that includes an ID of the inserted record. Gizmo needs that ID for subsequent updates. The problem is, Gizmo will only accept a response in a simple "key1=value1,key2=value2" format.I'd like to have ZohoCreator receive Gizmo's post, pass it through to ZohoCRM, receive the xml response from ZohoCRM,
Add row to subform in other application
Hello! I'm new in ZC. I have Application 1 and Application 2 with subform. In Application 1 i have Lookup field wich show name of records from Appl. 2. I need to add new row in Appl.2 subform, when i chose data in Lookup field of Appl. 1 and save it. Row in Appl.2 subform contain some data from Appl.1 Can you show me example how to do this? I try to use bedirectional relationship in Lookup field wich add to Appl. 2 subform, but it not add new row to subform when i chose data in new record Appl.1,
Is there a good way to create random passwords
I'm trying to create random passwords for users, but there is no random function. Yes I can use input.var = zoho.currenttime.toLong() 00; to generate something similar based on time, but try running this serveral times rapidly to choose characters in a list and you'll get similar numbers. Just as a test I tried: random1 = (zoho.currenttime.toLong() % 1000); random2 = (zoho.currenttime.toLong() % 1000); random3 = (zoho.currenttime.toLong() % 1000); random4 = (zoho.currenttime.toLong()
database restructure help
Hi I'm at the stage now where I need to restructure my database as I've decided on a solution which will meet my requirement to avoid duplicate rows. My issue is this - I have two core tables of 'organisations' and 'stations' as well as a table linking them to manage ownership relationships. Historically I have linked owners to the stations through a lookup on the 'station' table but this has left it impossible to sensibly manage joint owned stations. What I want to do is copy all the
on import (excel file)
Hello, I have three fields in a form I created (serial number, module type, is used(checkbox yes) On the import the user will select from the excel file just the serial number. I want the checkbox to be automatically set to false ( I imagine since it is not considered checked it is false, but I think it is actually Null instead) and I want the module type to be 0. Is there a way on import on each field imported the two other fields get their default values? Thank you.
Help on viewing a related record field captured using aggregate records function
I wonder if anyone can help me please? I'm relatively new to Creator and i'm struggling to find a way to do the following: Using the syntax below, I can capture the appropriate value for the "Date_Worked_1" field, but i'm stuck when it comes to returning the value from another field in the same record that this returns. Suggested_Date = jobs[Allocation == "AVAILABLE"].minimum(Date_Worked_1) ; What i'm aiming for it to return the value for a field called "Hours_Worked_1" from the same record that
Want to include a Linking icon in Form View?
Hello developers and Support team. I have any application and in this application there are many forms and different views. i want to palace a icon like help icon to all forms views, where when user click on that icon they will automatically redirect to an another address. please see below picture for more clarification: If it is not possible to add icon to the form header then also provide me an alternative for where i can use it? Cheers
Common script
Hi, I've created a form that has a number of look-up fields. When the look-up values are selected, it changes various numeric fields, I therfore need to re-calulate all field upon update. I've copied the required script in each field. As the code is common, is there an easier way to call a script to re-calculate. This way I only need to maintain a common script? Thanks, Martyn
Can I submit once to multiple tables?
I need to have a single form that contains fields associated with different tables. When the "submit" or "save" button is pressed it saves the field data to the appropriate table. An example would be: Data entered into the "part description" field would save to the "Parts" table. Data entered into the "List Price" field would save to the "Pricing" table, and so on. Is this possible? Thanks for looking at this.
User Permissions
Hello, I am working in ZoHo and I have a Permissions question. Basically, is it possible to control the permissions of each user based on what I need them to be able to do? For example, I have an "Application" form, and I want to allow my HR department to be able to accept and reject applicants using the appropriate drop down fields, which I, as an administrator, have hidden. Currently, I am the only one who can accept or reject these applicants. UPDATE: I have created a duplicate
Wrong entry populates form when submitted.... Argh!
I'll try to make this brief..... I have an application that has 2 forms (Buy and Customer) and two views (Buy and Customer), and one HTML page. Form "Buy" is filled out and then submitted, which then generates the HTML page from which I can send straight to a printer. Problem is when I have 2 entries that are similar (these are names - Last_Name and First_Name), the wrong entry often gets put on the HTML page. So if there is, say, a "Thompson, Darryl" in my database, and also a "Thompson, Matthew",
New UI seems to adversely affect two column Forms that contain CSS and HTML in notes fields
Hi Zoho Team! I have been using Notes fields to display dynamic data in my Forms using a combination of deluge script, HTML and CSS. Immediately upon trying the new UI for views yesterday I noticed that a number of my forms were displaying their content differently. On forms that used the two column layout (as opposed to the single column layout), Notes fields were dramatically changing the widths of the columns. These columns have always been locked into a 50/50 split of the width...in other words
One or more fields were dynamically changed
Getting the message "One or more fields were dynamically changed. Please resubmit the form." What could be causing this? I have neither On Update nor On Success scripts in my form.
Fetch and Update records from sub form
I have a parent for in which have a sub form with several values in each record. how can I fetch and update the sub form in the parent form
Cascade deleting on Parent-Child Relationships
I've built my app to be able to hold parent and child relationships. I want to be able to select the parent record and delete it. Once I do that, I want all the child records that belong to this parent to be deleted as well. I was thinking of using a script to delete the child records when before the parent record gets deleted but I'm not sure how I can identify all the child records. Anyone have ideas how I can do this? Thanks!
OAuth/REST/JSON interaction with other services
G'day all I'm considering Zoho Creator as a data management option for a mobile app service that I'm developing. The data is delivered to mobile app by Stackmob.com & that works well. StackMob use a REST/JSON API with OAuth & any data management solution I use must be able to interact with that API. Can anyone tell me if I should be able to do that with Zoho Creator & if so point me to the relevant docmentation? Cheers & TIA, Pedro :)
Fetch and Update and then perform actions on success
I have two forms: Add_Products Notify Add_Products holds my stock availability information. Notify contains a list of customers that are signed up to receive an email when the item is back in stock. Both of them share a common field which is Product_Code_SKU. I have the following script in my Add_Products (On Edit->On Success) form: if (input.User_Product_Availability == "In stock") { for each OOSItem in Notify [Product_Code_SKU == input.Output_Product_Code_SKU] { OOSItem.Status
Misbehaving 'Close' button in html view popup
I use custom 'View' buttons to open records in my views (with ... href=\ \"#View:myView?zc_LoadIn=dialog&recID=... in a Formula Field). This has been working nicely for a long time. Since fairly recently, the 'Close' button/link is suddenly outside the popup (in the "dark" area surrounding the popup) and is displayed in plain black text. I really have to search for it... Any help appreciated. Regards, Filip PS to Zoho Team: App in question: bmpm; Edit access is granted.
Searching through dropdown inputs
Im searching for a particular customer to create a Work Order. The dropdown is a lookup of Customer_Name from another form. Lets say I want to find a customer named "Fletcher's Jewelers (Colonial Heights)". If I start typing in the Dropdown Search field, the text "fletcher's", all of my accounts begenning with "Fletcher's" appear in a list. If I then type "fletcher's j", all of my "Fletcher's Jewelers" customers disappear. Why is that? It doesnt seem right. I have a Ton of customers that start
Can log in data be sent with the URL?
Can a URL be constructed that includes the Zoho log in data so the user is automatically logged in to the application just by clicking on the URL?
why is an embeded from in my website showing "hidden fields to others"?
When I try to embed a form into my website all the form fields are shown. How can I embed a form without it showing the supposedly hidden fields? This is without using a user login as well. thanks, brian
Importing Data from TEXT FILE
I have information in a TEXT (actually .dvc but can be viewed in notepad) file I'd like to be able to import into ZOHO creator. Every line of text I'd like to be a different entry of data in a form. This is the example of the file I'd like to import: // DVC VERSION 2 // "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/producerpromos11.m2t" 00:01:29.880 SU --/--/-- --:28:30 *.dcmd PS "/media/hd0/media/producerpromos11.m2t" // "Start" "TRANSPORT" "PLAYSPOT" "/media/hd0/media/communityboardslides43a.m2t"
How can i add Emails under Contacts through Creator
Dear Respected Zoho Programmers and Support team I have an application in CRM, which adds Contacts at the Zoho CRM. now i create an another form which used to sent emails in Creator to CRM Contacts. So after sent a mail that email should be listed automatically at the Zoho CRM under the particular contact, in which the Contact mail is sent. i am follows following post: https://kbase.creator.zoho.com/crm/create-crm-lead-and-add-note with the help of above post i do following at my form >> add >>
Fetch a score
Hello, I am working on retrieving a score based on a chioce that a user makes from a drop down. I have the following forms: Policy Write-Up (Database) - This is where I have a database of all the possible policy violations and a point number attached to each. The fields are: Policy Number Policy Violation Policy Rule Points Write-Up Data - This is a formula that combines Policy Number + Policy Violation + Policy Rule Write-Up - This is where I want the user to be able to enter in an employee
Score
Hello, I am working on retrieving a score based on a chioce that a user makes from a drop down. I have the following forms: Policy Write-Up (Database) - This is where I have a database of all the possible policy violations and a point number attached to each. The fields are: Policy Number Policy Violation Policy Rule Points Write-Up Data - This is a formula that combines Policy Number + Policy Violation + Policy Rule Write-Up - This is where I want the user to be able to enter in an employee
PHP-Fusion
My current website uses the software PHP-Fusion and our non-profit organization has gathered 7 years worth of data using the CMS. Is it possible to take the MySQL database and integrate it into a new, search and display application through Zoho Creator? Please advise. - Potential Customer
formula1's result as variable in formula2. how?
hi i have 5 too complex formulas in my application each formula has a result - result1, result2, result3, result4, result5 in what way can i use result1 as a variable in formula 2 ? and other formulas right now i just copy full code from formula1 to formula2. this make application code too complex
Retrieve the loginuserid using the corresponding loginuser ?
Hi, I use a form to dynamically share forms/views with users. I just have to fill the "Email" and use it for the sharing details. I'd like to add a field like "zoho_username" to be autofilled according to the the email (registered in Zoho) : I fill "myUsername@myEmail.com" then my field "zoho username" should be filled with Deluge. Is there a way to do it please ? (I precise that all accounts will always be created first in Zoho). Something like : myUsername = zoho.username(input.Email) ; Actually
Greater Than and Less Than nuisance
Deluge script is replacing "<" and ">" with "&lt;" and "&gt;", respectively. Is there a way to stop that behavior?
Reports to Creator: Iterate Records
Currently I keep employee information in Creator but what I am trying to do is pull it from Reports. What I have currently is the following: for each var in Harvesters [Team = input.Team] { insert into Harvesters_Daily [ Added_User = zoho.loginuser EEID = var.EEID Harvester_ID = var.Harvester_ID Id1 = input.ID Name = var.Name Team = var.Team Team_Position = var.Team_Position ] } ^This creates a new record for each harvester for
Basic question for selecting and Updating records
I'm new and know very little about programming or code. I want to create a very simple form that manages contact info that I can update from the form view. For instance, if I had a form that was simply Name, Address, and Phone number, I would populate the info and submit it. However, I would like to have a drop down list above the Name field to search for an existing name that I can select and have all the existing information populated into the fields. From there, if I modified the phone number
I want a site where users log in... can I do this?
Hi. I want to build a real estate site, where sellers log in to create their ad, and then buyers can search/query the data to find the properties they are looking for. Is that possible? Thanks. Maryanne
Block form for Weekend
Hi, I need some help in a code. I´m blocking the access for this code if (((hr >= 19) && (min > 0)) && (sec > 0)) { hide Nome; hide N_de_Colaborador; hide Email; hide Data_de_Registo; hide ideia; hide Tipo_de_Ideia; hide Descri_o_da_Ideia; hide Benef_cios; hide Coment_rios; alert("Este acesso só está disponível no seu local de trabalho"); } But in case of Saturday and Sunday I want the forms to be blocked all day, the schedule only applies for weekdays
Hide/show actions on user input from checkboxes
Im trying to hide and show a few fields based on if checkboxes are checked or not checked. I have the fields hidden initially on form load. I also successfully show the fields when the option is checked. My problem is i dont know how to make those fields disappear if i uncheck that box... what would be the best way to approach the opposite function of input.contains()? ____________________________________________________________________________________________ ON LOAD _____________________________________________________________________________________________
Apply autonumber with Form Object Function?
I have a form object function that sets the value of a date field in a collection of records (script below). Now I would like to set the value of the ItemNumber field in each record of this collection as well... ...BUT I would like to autonumber those values so that the ItemNumber fields start at 1 and continue with 2, 3, etc. until the entire collection has been assigned an ItemNumber field value. ALSO the order of the assignments is important and should follow the order of a field called Unit which
openURL not executing in function
Here is the function code: void JulDepositDateSet() { JulNextDepositList = Payment [(JulPayment > 0.01 && (JulDepositDate is null))]; JulNextDepositList.JulDepositDate = zoho.currentdate.addDay(1); openUrl("https://creator.zoho.com/rampartcrossinghoa/rcb/#View:Jul?JulDepositDate_op=33", "Same window"); }What I done wrong to not have this openUrl command execute? Thank you for your help.
dialer
is there any way to enable a phone number field to be clicked in a view and trigger a dialer?
Next Page