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
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!
I can create a feedback system with stars, for people to qualify and turn this rate is associated with a record?
I can create a feedback system with stars, for people to qualify and turn this rate is associated with a record? I would like to go with Zoho creator to interact with existing records. If not possible, any ideas? Something like this.
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) ??
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
How to show an activated checkbox in an order listing to indicate that the "notes" field contains additional info
I have set up an orders application in Zoho Creator which includes a “notes” field for additional info. On the order listings form, I want an activated checkbox to show up indicating that the “notes” field contains additional info (if the "notes" field is empty, the checkbox is non-activated). On the orders entry form, I need to include a checkbox, which, when activated, shows the activated checkbox on the order listings form. Any help would be very much appreciated.
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?
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.
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
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,
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
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!
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" ) }
Rich-text field deluge
Hi A quick question- is 'on user input' deluge not possible for Rich-Text fields? I only see 'On update'.
How can i show lookup field id
How can i show lookup field id inside any module
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.
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
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"
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
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"
how to autorefresh Date_Time in views of zoho creator reports?
hi! made report when i open entry - i can change Date_time field. This field depends on system current time. is it possible autorefresh this field in view without openning entry? example 1) i open this view and see list of entries 2) for each entry there is own Date_time setting 3) after 10 minutes in browser window i refresh this view 4) after refreshing - for each entry their settings of Date_time has increased at 10 minutes each
Feature Updates Page
https://www.zoho.com/creator/help/general/feature-updates-and-bug-fixes.html This was updated through July but seems to have reverted back to April?
how to make search string - inside a form?
hi there is working form and there is database with about 1,500 records like "city - area" how can i in working form make a search string in which user enters first N characters of city name and below this search string appers a list with all cities which names correspond entered characters with ability to pick up city name see example from other website
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);
Footer with paging numbers
I know that this question is quite old (as I find it in the forum the last years) but as an update, does anyone of you found a hack way to create paging footer? Something like 1/5, 2/5 etc in each page.. I know how to create sticky footer but what about paging?
"Sort by" in reports not working?
Hi Zoho, I'm trying to sort my Flags_n_Alerts report in my app, I try to sort the report by Added Date and by Recepient, the added date and time sorting is only sorting by the time (meaning 12:00 tomorrow will be higher ranked than 17:00 today) and the text sorting is not working at all.... Please fix Thanks Ravid
how do I make a subform show multiple records that were already added according to an action in the mainform?
Hi! I have an application with the following forms: Products Purchase Order Purchased Products Sales Orders The Purchase Order form has the "Purchased Products" as a subform. The "Purchased Products" form has lookup field from Products. So the user loads the form Purchase Order, clicks on Add New "Purchase Products", selects the product and add the purchasing price and quantity. Then other fields as Subtotal and Total are updated on the form "Purchase Order". So far so good. Now, my problem is on
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
Next Page