Function to populate a field in a report with corresponding data from another report
I have a form and report (A) in which I forgot to add a field called 'User1'. I have another form/report (B) that has the the field 'User' in it. They both have a field called 'Patient ID' that is common between them. I would like a function script that I can execute as a one off that will do something like this: for each record in FormA where 'FormA Patient ID' = 'Form B Patient ID' update 'FormA User1' with 'FormB User' There are 15000 records to update. Would this be possible? Thanks in advance
Insert Image or logo in a form
Dear Sir I have create on form having two field "Name" and "Image" and create a function module and use above code 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"); return imagelnk; } But the return statement
Error login Mass Downloader
Hi Since 2 days ago I cant login anymore using the file downloader found here: https://help.zoho.com/portal/en/community/topic/download-all-file-attachements I need to back up all my files stored in ZohoCreator locally Please help Raul
Failure to receive Email confirmation on Outlook
Please help us on our problem - We are not receiving email confirmation from Zoho to Outlook emails but in Gmail were able to received all the email confirmation - Before we were able to received it even the recipient use their Outlook emails Hope you can help us or advise us what to check or what to do. Thanks!
Newbie Question
I am looking to see if I can use Zoho to create an application for a mobile device where I can have a set of icons on the screen and pressing an icon or a combination of icons automatically updates a record or number of records depending on the combination of icons pressed Thanks Mark
Display school result system
I want to create a school result system in zoho form, when user enter their roll no they go their result page
customer portal profile fields
I am working on a solution in zoho which is centered around the customer portal. The firs thing I need to do is have some additional customer profile fields. How do I add fields like mailing address, phone number, billing address etc.. to the profile fields? Currently it just asks for email and password.
Dates Between
Good day, I have a form that receive StartDate and EndDate I need to create a record for each date between StartDate and EndDate how I iterate each date to build the insert into?. Thank you,
fetch records
I have two forms in an application. One is called Asset List and the Other Asset Manager. Asset Manager has a field called 'Asset Scan' which scans a bar code. Asset list has a field called 'ID Tag' which lists all of the codes which may appear in Asset scan. How do i fetch the description, depot, serial number and model from the Asset List form and place this as text in a separate field called Asset Details which is in the Asset Manager form, based on the Asset Scan being the same as the ID Tag?
How do I use 3 iterated records to filter a larger list?
I have a large "Price" form with the following fields: Product Date Terminal Price Then I have a form for "Customer" which has the following fields: Customer Name Products Terminals There is also a "Product" and "Terminal" table with additional details. What I Want to Do: I want to create pricing so that it only shows prices for the customer when the prices match their "Product" AND "Terminal". I have tried a lot of things but I am stuck. Any ideas on how to do this? Any help would be FANTASTIC!
Rich-text field deluge
Hi A quick question- is 'on user input' deluge not possible for Rich-Text fields? I only see 'On update'.
Record Access Based on User
I have searched the forums but do not see an answer to this. I need to restrict salespeople to only seeing and updating their own records only. Managers and Admins will be able to see all. But I do not want salespeople to be able to view/update others records. Is this possible? I know I can restrict by Groups but I need more granular control. Thanks in advance for any assistance.
iframe issues
Hi, I have an HTML view which consists of two iframes. One frame is called "info" and another "question". In the question frame, the user can edit information via a creator form. When the user changes a value of a drop-downfield, an open_url function is activated that is supposed to open a web page in the "info" iframe. However, no matter what I try, the web page opens in a blank window. Below the code of the HTML view ____ <iframe name="info" src="https://www.surfgroepen.nl/sites/Q-inspire/QDST/qdst-NL/pro-con-q-formats/dive-general.htm"
Need help with multi-select deluge
Hi I've been struggling with deluge for a multi-select lookup field. I've two forms- "Email_Recepient" and "Miscellaneous_Settings". "Email_To" is a multi-select field in "Miscellaneous_Settings" which is a lookup on "Recipient_Email" field in "Email_Recepient". "Recipient_Email" is the other field in "Email_Recepient". Idea is to let the client decide whom they want emails to be sent to for each submission (of a third form) by collecting the emails in a "Multi_Line" field in "Miscellaneous_Settings"
New PDF engine
Hi, the new PDF engine caused total misconfiguration all our pdf pages. Anyone have experimented the same problem? Thanks Mike
Contact us form returns error.
I tried to fill out a contact us form and get this error. Looks like i'm expected to fill out a field for nr of users, but I see no such field.. Error found while adding the data... Please get back and rectify » [] 1 . No_of*Select a value for No. of Users .
I need help to understand "For each" and "Fetch Record"
I am following this tutorial: https://www.zoho.com/creator/help/tutorials/add-advanced-scripting.html#enhancements and I am stuck with this excercise: //Set Total value with 0.0 USD input.Total = 0.0; //loop through all the selected Items and calculate total //"For each list" task is used for each itemID in input.Products { //Get the Product Row from the Products form //Fetch record task productRow = Products [ID == itemID]; //Calculate Total Price input.Total = (input.Total + productRow.Price);
Fetch Record ID then automatically email link
Hi I've been searching for hours for an answer to this question but with no luck. I've created a form that once submitted fetches an email address and emails the user, but what I want to do is include a link to the record that has just been created for editing. The form is used for a business to record times of jobs beginnings and ends. So once the job has been submitted it automatically gets sent to the user and they must click the link go in and update the times and resubmit the form. I know how
Custom related
HI, I am afraid I don't I have created 3 custom related list (or I am wrong). Where can I check the corresponding "custom related list" Thanks! Andy
Form Builder
Hi, Question 1: I am building a form, And there is 1 dropdown. When I am using Zoho Creator iPhone application, after selecting an option from dropdown, I have to click "Done", is there any option or code which can auto close the dropdown, and go back to the form after selecting any 1 option from dropdown, and do not need to click "Done" in iPhone Zoho application. Question 2: In a same form which I mentioned in Question 1, I have added Radio buttons' group which is in 3 columns format. But in iPhone
Duplicate a Form in a same Application
How can i duplicate a form in the same application I want to use the same extructure of a existent form for another one! Tnks! noduscol.noduscolombia.co
How to switch to Developer edition ?
Hi, I just finished the free trial edition of Zoho Creator. My account automatically switched to the Free version. Since I can't use subforms with free edition, I would like to use the Developer edition. I'm in the developing phase of my project and I don't want to spend money until the app is ready to use. I can't figure how to convert an existing free edition account to a developer edition. The following link allow new user to signup to developper edition : https://www.zoho.com/creator/developers/signup.html
Users Add-on at $1/user for Enterprise Edition
Up until now, subscribers of Enterprise Edition had to contact our sales team to add more users to their account at $3.5/user. We have now slashed the price and made it a much more simpler process. Using our newly introduced User Add-on , Enterprise Edition users can now purchase more users at $1/user directly. To add more users, go to your Subscription tab . If you are in Enterprise Edition, click on "Manage" under that edition and if you are in other editions, click on "Upgrade" corresponding
Restrictions for the From address is not about security.
Dear Zoho Creator, I want to discuss a really annoying thing in Zoho Creator sendmail() function. You have these restrictions (https://www.zoho.com/creator/help/script/send-mail.html): The email sent will have the email id of the application owner or the email id of the login user, as the From address. If the From: address is not a zoho.adminuserid or zoho.loginuserid, the To: address can only be zoho.adminuserid and the sendmail task cannot have any CC: or BCC: address. Actually, this restriction
How do i change the currency format?
I would like to know how to change the Currency format. The default format is X,XXX.XX ; i need to use the Brazilian format currency X.XXX,XX The difference is how to use the "," and "." exactly the opposite. Thanks for any help!
Include empty values in pivot chart
Just wondering the following. I have created chart reports. The form it is based on a form with fields that can stay blank/empty. The chart ignores these fields. For example 1000 records with Gender field: 200 "Male", 300 "Female" and 500 left empty. The chart makes 100% of only the Male (40%) and Female (60%) together, but I would like it to be relative to the total records, so 20% Male, 30% Female and 50% null/empty/unknown. Is that possible? (note the chart also created a value "Unknown" but that
Customer Portal Add-On / Is this per "App" or per "Account" / what about sub-domains
Hi there, I would have 2 questions regarding the "Customer Portal Add-On"... as I'm just not not sure. 1. Is the Customer Portal Add-On per "App" or per "Account"? I see that within each App (under the same account) I can go to Customer Portal and see the provided URL is different. Clicking on that also sends me to the Login Page. Considering this, I would assume that that once you have the "Customer Portal Add-On" (for the 99$/month) this feature is now available for your ACCOUNT, i.e allowing for
Struggling to add a record to a form by email
1) I have a registration form on my website, from which I get an email whenever a record is added. I have mentioned the same mail ID (my Zoho mail account) as the form email alias for a Zoho Creator form. 2) I have setup a filter in my Zoho mail account to forward these mails to the form email ID. This is the process outlined in Latha's response at https://help.zoho.com/portal/en/community/topic/how-may-set-the-form-email-address-for-adding-form-data-by-email But this process breaks down for me
Zoho Creator page take data from form
Hello. I am using Zoho Creator, but not Zoho Invoice. However, some related functions are being done through Creator. I created a page using the "invoice template" from in the pages settings / templates. How do I draw the data from one specific form to populate that invoice? I've changed the variables correspondingly, but I don't know how to invoke the data from one particular entry from a form.
New Creator App Portal Design
Hello, The new design deployed this weekend takes up to much screen real estate. We run scores of apps that need constant management and the list view with search was the most efficient way to drill down to the application needed. Please modify to allow a list or panel view depending on preference. Please return the list narrowing search box! Also the ability to not duplicate applications would be a deal killer! We need that function back! We use a template app and then copy it for our projects.
Counter for number of characters in a multi-line field
Hi, how do I add a counter to show the number of characters in a multi-line field in real-time, meaning, as the user types into it. I'm using Length function as a formula field but the problem with it is the user needs to move out of the multi-line field in question for the counter to update the value. Hence looking for a more ideal solution.
How to fetch and update records from a sub-form in another form
Hi, how to fetch and update records from a sub-form in another form?
Deleting an application
I tried to delete the application OFFLINE SERVICES AND ASSET TRACKING (PREV LIVE) but was getting error messages around my functions so I deleted all the functions and forms manually. When I try and remove the application, I get the following error message Error Occurred. We are sorry for the inconvenience. Can you please remove the application?
STRING and right expression is of type BIGINTLIST and the operator == is not valid
Hi, In Criteria left expression is of type STRING and right expression is of type BIGINTLIST and the operator == is not valid Status = Volunteer_Registation [Name == Select_Volunteer]; Status.Hours_Volunteered = input.Add_Volunteered_Hours; How can I solve this?
Connect Zoho creator to Zoho Reports
Hello. Could you explain me, how i can connect Zoho creator to Zoho reports ? My requirements: every reports have criteria Added user == zoho.loginuserid and instead of Zoho creator pivot charts and tables i would like to user dashboards/tables/charts from Zoho reports in Zoho creator pages (like dynamic HTML pages with embed Zoho reports dashboard for each user with data that they added) But how i can connect certain data from creator to each database of Zoho Reports of my clients. zoho.reports.createRow
Send email function
I was using zoho creator to test the (send email) function ,not knowing there were real records of the clients the function executed it sent out the test email to the clients .So I would like to know how many emails does zoho allow you send to users ?
Use Loop Inside Send Mail
Dear Sir I am using ZOHO Creator, I want to send mail which comprise by taking multiple record having specific criteria. Means I want to use loop inside the send mail. For example I have 3 records with status mail = N I want all 3 records detail mails to user in following way Mail Text area Record -1 Detail......... Record-2 Detail........ Record-3 Detail...... . . . . Please help
An error occurred while publishing
Welcome at attempt publishing site gives an error message: "Error occured while publishing" Do not tell what might happen? Thanks in advance. http://weightloss-system.zohosites.com/
ui.add() function - Add a different code Value and description Value
I have a Stateless form with onClick action to update a zoho CRM record. I'm using zoho.crm.searchRecords to get a filtered list and then dynamically populating a pick list using ui.add() My problem: I need the code value to be the CASEID and the text value to be the Case Name. EG: <option value="CASEID">Case Name</option> Currently when I populate the pick list it looks like <option value="Case Name">Case Name</option> Appreciate any help... I've been reading up for a few days trying to figure it
Help for this problem : Multiselect Field
Hi, y have a form with a multichoice option, when it is complete i need separate options. For example : Field_1: x1;x2;x3;x4;x5 i need 5 new fields f1= x1, f2=x2 f3=x3 f4=x4 f5=x5 y try with getPrefix and getSuffix ,I need a script that works regardless of whether in the future add more options in the menu Multichoice. Thanks and regards.
Next Page