Set variable on a related Form B with data from Form A before Form A has been submitted/persisted. Possible?
Form A has a NameA field with data "John Doe" A related Form B has a field NameB that is to accessed half way through filling out Form A. How do I set the value for Name B as "John Doe" before Form A is submitted/persisted?
Creating report of subforms
Hello, I have been working in a purshase management where i have a form named "products" with products and categories of the items., I have a form named "order management", with the fields (Project, date, and the subform named "Products") . I need to create a report group by product, where appears the quantity per project of products, any ideas? Could i Do that with html view? Hope your answer, thanks.
help with zoho.loginuserid
Hi. I'm new to zoho. Had some experience with MS Access. I've created a form for service tickets. I plan to have users pull the tickets from the view for editing. I need to create a script Edit - On load to show, hide, or disable fields. I thought I would start with hide all and then based on the user login show the fields they can edit. I need a sample code to do this. Thanks
Sendmail attachment wiht subform
Hi, it's possible to attach in a sendmail form a subform file uploaded? How? Thanks! Mic
update field in one table with data from another based on certain criteria
Cant seem to get my script to work to pull data in a specific field in a table and update with that information based on certain criteria This is the script on success of the form loading records based on a different forms data entry. r = Client_Rate_Table[Company_Name == input.Company_Name]; if(input.Position == "General Foreman") { input.Bill_Rate=r.General_Foreman; input.OT_Bill_Rate=r.General_Foreman_OT_Rate; }
Automatic create data field
Hello, I got this problem: Product: apple, tomato, banana, caret, Code: 1 , 2 , 3 , 4 , The Case: When user select on drop down filed "Apple" the form will create automatically the code on a single line filed named Code. For example: input - select > Apple output - Automatically get > 1 input - select > Tomato output - Automatically get > 2 What is the best way to do it with big database? Looking forward for your answer. Itai B.
Quick Developer Job
I need a Zoho Creater developer to do a quick interface for me(1 day). We simply want a quick way to select and store many to many relationships between two tables that are entered manually with a benchmark note. 1. Select the table you want to use as base. 2. Select a second table as a comparison benchmark 3. Display first selected table in column mode with an action button next to each record. 4. Action button brings up iframe or popup that allows you to select a record from the second table and
Logout from an embedded form
I embedded a form in a website that requires login. Once logged in is there a way to logout? For example if a user wanted to log in with a different id? Herb Wexler
Permalink for Customer Portal Views
It seems that permalink views are not possible for Customer Portal users. Is this correct?
Best Practices - Performance
We are developing an application that will have 25-50 concurrent users and are concerned with performance. Has anyone published or build a list of Best Practices around Coding for Performance? Any stories on what not to do? Thanks, Troy
Replicate user
Is there a way to replicate a user in Zoho Creator? My users are running into errors here and there and it's difficult to troubleshoot without seeing it first hand. I've asked for their password and have logged in using their UID and PW but one would think there would be a more elegant solution designed into the system. Any ideas are welcome.
Permission integration between customer portal and creator
Hi - I am using the customer portal with creator Now i have realised it appears there is no real integration of permissions between creator and the customer portal. ie. The Customer Portal permissions that are set are applicable to ALL users, whereas the permissions that are set in Creator can be different for every user so my questions are; 1. is my interpretation correct? 2. is there a workaround so that different permissions can be assigned to different users if using the customer portal? 3.
View embedding in HTML-report from another application: Add/Edit - is not working
HTML-Report: When you embed View from another zoho creator application with Form/Report (not IFrame) - you cant edit or add new elements in this View from this - you always get empty popup window with message: "There is no such form in Zoho Creator ". It's beacuse you use short links for add and edit like "#Form:form_name_from_another app" to get form in popup window, and it's not working from another application Do you plan to fix it?
Scroll bar in drop-down list
I have a drop down list with numerous choices. So many that a scroll bar is needed. The scroll bar shows on the form but it does not work. My users must use the arrow keys to scroll. You may see this at the bottom of this webpage..... http://www.jaxareagolf.org/index.php/meeting-notice%E2%80%8E Thanks for any help. Barney
Entering a field value from a variable dependant on checkboxes selected
Hi all, I have been working on this for hours now and am still struggling to find the right process to do this. I have a form with a few checkboxes: 1) All Students 2) All Staff 3) Members of the Public For the purpose of reporting, I have a hidden field which I would like to effectively enter values dependant on the selection above. I originally set this hidden field to contain values according to what was selected, so if all the checkboxes aren't selected, I would end up with null in place of
How to automatically set default value after submit
Hello. I would like when I submit something (e.g a lookup dropdown) then the form to keep as default value the last record. What I mean, If I have a lookup dropdown with: -select- food drink If I choose 'food' and click submit then I want to have food as default (for adding new record). The same if I choose 'drink'. In general I want when I choose something and click submit then this choice to be a default value. Is it possible to do that?
Cannot get image to display in HTML View
I cannot get the image to display in a html view... https://creator.zoho.com/crocked/receipt-application/view-perma/Print/thisID=740075000000264747 This is what I'm trying to use, but it just displays a box with "image" in it. <img src="https://creatorexport.zoho.com/DownloadFile.do?filepath=/ZFS1309176687906_Amato_Image.png&sharedBy=crocked&appLinkName=receipt-application&viewlinkname=Picture_View"/> Can someone help? Damien.
phone number format - Zoho Creator
I must be missing this somehow, but I can't seem to find a "phone number" field when adding fields to a form. The closest field is Number, but that field won't allow ( ) or dashes -. Please tell me I missed it and that Creator isn't missing a phone number field format. That's so basic...
Access zoho.loginuserid field
Is there a way to access this field? I want to pull it into a form as a multi-select field.
after supmit no one can change the amount
i want to make field after entry no one can change again after sumpit frist time for example enter check amount after supmit no one can change the amount
Invalid entries found. Please correct and submit again. Failed to add data.
I have a form linked to paypal and when I try to run it through zoho dashboard or the code embed I got "Invalid entries found. Please correct and submit again." then "Failed to add data." I faced this issue today and I spent a lot of time try to fix. I tried to create another form but I faced the same error. I need help urgently. I sent a support request already.
MAS
I am trying to get a Number field to auto populate in a form, but I keep getting the ID showing.Trying to learn the new Script Builder. Forms - MAS (Lock No), Terminal Information (Mas), Technician Service Call (Mas) As the dispatcher, dispatches the call, she selects the Terminal No and the info auto Populates the fields. The problem is the MAS field populates with the ID record number. see attached script; //adding in MAS SN to app //Variable = Lock, Terminal Information is Form to get data from,
background in html-pdf view
Hi, I have a html view http://www.creator.zoho.com/misca/consulado-geral-do-brasil/htmlview/Print1/edit/ in which I put a background in html language. In a simulator I can see the correct html view, but when I put it in the view of zoho creator I can see the image as background. How can do to see it? Thanks Mic
Zero Response/Follow up from Zoho Support
Zoho Support, I sent an emergency request 7 days ago, and all I have gotten from you is en email saying you will look into it. I have sent repeated follow up emails, and left a voicemail. I don't like to air my dirty laundry but you leave me no choice but to come to the forums. As an "Enterprise" client, I can't imagine doing this to one of my own top payment-tier clients. When is someone going to help me?
Sharing error- User doesn't have access to database
Every time i add a user, this happens. they see the login screen but an error message hovers over it stating that they don't have access please log in as another user.
share app - user denied access
recieved the following message when loggin in. You have logged in as {email}. You are not allowed to access this application. Please click here to login as a different user. Click here to go to your Home Page. I have sharred the application with them, so I am not sure why they are receiving this message.
calculating a midpoint date
Is there a way to calculate and store a date that is midway between two other dates? This is how I would expect it to be calculated, though I'm not sure how to code it: MidpointDate = StartDate + ( (EndDate - StartDate)/2 ) I want this field to be calculated when the StartDate and EndDate have been entered and then to have it stored within the same form. I also plan to create an email notification triggered by the calculated MidpointDate.
Changing field from currency to decimal
On trying to do this I receive a popup warning me that data will be lost when changing the field type. Is there any way to do this without losing Data?
Create New Record Script Issues
I have three separate forms that I've created in ZOHO Creator to push their data into CRM. I have a Contacts, Companies, and a custom made Expense (CustomModule3) modules setup in CRM. I have used the exact same script for all three Creator forms and updated the fields accordingly. When I run the Contacts and Companies application through creator, all data I submit makes it back into CRM and adds the new data. However, when I run it for Expense custom form, I get the Data Added Successfully but
Hide -Select- from dropdown
I would like to ask you if it is possible to hide the '-Select-' from a dropdown menu and also to set a default value on it. As an example: first choice second choice third choice Is it possible to set 'second choice' as a default value? I read this topic https://help.zoho.com/portal/en/community/topic/drop-down-list-hide-select-from-choices but I think that it is based in older version of Zoho Creator and I cannot find 'Initial Value' on it.
Emailing PDF report with single record
Hi, I hope someone can help. Firstly, I will explain what I have working, then describe what I can’t get to work. Working functionality: Find the last record entered by the logged in user, store the record ID, send a PDF version of all records in the view by email, and finally open the view with the single record in the same window. The steps I’m following are: Enter data into my Creator form and click submit. On successful update to the DB, call the below function (MentorProgramme.MentorProgramme).
Auto Populate Drop Down Fields Based on a Numeric Field
I am building a sample request form for my company's sales team to use. It contains a numeric field called "2-digit Area #" and a drop down field called "Regional Sales Manager". I would like the drop down box to auto populate with the appropriate RSM once the unique 2-digit Area # is entered. Each RSM covers a range of 10 to 20 areas as their region. These numbers are consecutive for each region (i.e. west region = 1-19, north = 20-39, etc.). I can't for the life of me get this to work. Please point
Transferring/ a DB with content from one user to another
A Creator DB is created by a employee with his private Zoho user. Now this person i is qutiing our company. I. Is there a way to copy the DB with the content to another Zoho user? Tanks!
Pivot Chart report page not loading when make new report. ZC support not answer by mail.
Problem #1 I try to make Pivot Chart report for one of my app, when press button Create page start loading but after long time waiting still not load. Other type of reports can make without any problem for this app, just Pivot Chart not working. For other app Pivot Chart reports working well. Problem #2 In Report type List can make several criteria and all must have or logical "AND" or logical "OR", can't make complex criteria. Before have group for this, now can't find it. Is it possible to make
Question on report capabilities
I'm interested in using Zoho Creator but before I invest too much time there is one feature I must ensure is available. One of my requirement is to print on to a pre-printed form (membership cards). So a line report doesn't quite fit because I need to be able to lay the fields out across the page. Is it possible to create a report with such a layout?
Note Field
I would like to limit the width of the notes I add so it matches the label width . Also can I would like to open form through an api push with some data for the form already there . I can use script to adjust the note based on form entries but I don't know how to change the CSS of the field - Is there a was to make note change live and still keep the setting - meaning font color , size also how do you word wrap inside a note field
Is it possible to save a record, but stay on the form?
I have a form that I would like to (using script) save the current record, but stay on the form with the record still displayed? The reason is that I need the record ID for the current record so that I can do some further work involving child records (before you ask, using subforms is not suitable for what I want to do).
Auto Generated Number Field with prefix
Any help will be appreciated: Issue ------- The Auto Number starts from "1" - It is missing the following basic abilities: 1- No Prefix can be set For Example Starting with a letter 2- No starting Number - I want to start the first record from 2500+ 2501, 2502.. (Is this too much to ask??) 3- No Leading Zero possible - for example 000001, 000002... I need to create an auto numbered field for item lot number looking like this L0000001, L0000002, L0000003....L0000015... I used a formula field that
iPad and Form Properties
I am a novice at ZOHO and I have an extremely difficult time entering data into any box under Form Properties from my iPad. Has anyone else experienced this or know what I can do about it? Thanks!
new user registration/login
I'd like to build a bulletin board type site where users can submit posts, but only after registering an account. How would I go about implementing user registration and login? Or is Zoho intended more for intranet type collaboration, and not public facing? I'm not a web developer so any insight here would be appreciated.
Next Page