Record locking mechanism?
I'm making an application that is essentially going to be a community queue where users grab individual records and when make a decision for it. I need to make sure 2 users cannot open the same record at the same time. I'd like some kind of record locking mechanism that checks if someone else has a record open in which case the 2nd user would receive an error message saying the record is locked already. Is this possible? Has anyone done this before?
Display int with commas in html view
I have an html view that shows several numeric fields (forumla values) from a form. When displayed in the html view the take the following format: 1234.00 I would like them to be in the following format: 1,234.00 Is there away to get zoho to show the number value with commas? Thanks Matthew Steele
Linking two fields and forms
I have been trying to establish a relationship like the one in this example. I want to a record from a Look up field and fetch records from another Form and into these records into fields of the Same type and Name as the related Form. i am using script with my form and app names that looks like this: string externalapps.GetType(int name) { if (Enrollment_Information[ID == input.name].count() > 0) { return Enrollment_Information[ID == input.name].Dog_s_Name_1; } return
calculated forms values before submit
when I need suggestive value of the field ItemID is calculated based on the form values specified for the Model and Serial# I use this : on add { on validate { input.ItemID = input.Model + " " + input.Serial# it is work to add record, but I need see the value as suggest before submit, because I want to modify before submit Omar
A function sends an automatic email with information from other fields
I made a button that automatically sends the customer a quote from a mailbox, the problem is that all the information of all entries is sent to that email. How I avoid that? void CORREO.Email2(Cotizador_Multiple CM) { String1 = ""; for each r in Cotizador_Multiple { String1 = String1 + CM.Articulos.Foto + CM.Articulos.Link + CM.Articulos.Precio + "<br>"; } sendmail ( To : CM.Email From : zoho.adminuserid Subject : "Prueba"
Zoho Creator with SQL Server connector
I have a few SQL Server instances running. I need Zoho Creator to connect to them for read/write CRUD CREATE READ UPDATE DELETE. Can you guys recommend a good SQL server hosting service, plus a good connector /middleware between Zoho Creator and SQL Server? thanks.
print in the background
hello, Is it possible to trigger a print job in the background (without any print dialog boxes)? Need to trigger the print job during a save event, and also via a custom hyperlink or button. Also, we will be triggering different print jobs for background printing - print a zoho record, print an image (via url), print a webpage (outside zoho). Is this possible? Thanks!
Bulk Edit does not trigger "On Validate" event
I have a logic On Edit/On Validate whenever decision box is checked to recalculate another field "Status". When I edit single record it works fine, but in bulk edit mode it does not work
Insert Subform row On Success Action
Hi, I would like to insert row(s) of each Subform row into a form on Success Action of Main Form. Below is the script I was trying to but it not working correctly. for each selectedValue in input.Coverage.PCM_Fips { insert into MVPD_Partial_Coverage [ Added_User = zoho.loginuser MC_TVStation = input.Coverage.PCM_TVStation MC_MVPD = input.Coverage.PCM_MVPD MC_ChannelType = "0.1" MC_Fips = selectedValue ] } Note: PCM_Fips is the MultiSelect
How do I enable decimals in my "Price" field?
I can't seem to figure out how to enable decimals on my Price field in my Product Subform. The inserted products all have prices with two decimals, but once I've selected a product in the "New order" form, it shows its respective price rounded up or downwards, depending of course if the decimal being higher or lower than 0.5. The Field Deluge Name is linked to the actual Price, though.
Record Summaries missing!
When I duplicate my program, all my record summaries vanish! Please tell me this is supported!
Allow function to run when some details are missing
Hello all I have created the attached function and I would like to run it for a collection of records, however some records are missing the inputs for the fields needed to run the function. Is it possible to code the function such that when there is no input in the field, the function skips that record and carries on to the next record? Ideally, it should also insert a comment to the form stating which record was lacking input in which field. Here is my function: float calculateKVGunder25(Client_Details
Schedule a custom Function and run it daily
Hi, I am trying to run the below function on a daily basis.It is possible by using Scheduler in Zoho Creator ? void MVPD.AddUpdateLink_SubchnnelMVPD() { for each rec in Not_1_MVPD sort by Added_Time desc range from 1 to 500 { link01 = "<a href='https://creator.zoho.com/mikekokernak/across-platforms-web-proxy/Not_1_MVPD/record-edit/Not_1_MVPD_Report/"; link02 = rec.ID; link03 = ("' target='_blank' title='Click to Update Record'>Update Record</a>");
Updating string field based on lookup field
I have a form with a look up called "Customer" What I want to do is when a user selects a certain customer, I want the customer information that is tied to the selected customer (on the form the look up points to) to be inserted into the "Address" string field. How can I do this? Thank you in advanced
Signature Html
Good day, How do I put the signature captured in a form in a Html Page? Best Regards,
Linking data from two forms, each located in different application
Dear Creator community, Hello :) My situation is as follow: I have one application which contains a form with customer data: Application A, Form A: Row: Customer ID, First Name, Last Name Application B, Form B Row: Customer ID (look up field to Application A, Form A ,Customer ID) First Name, Last Name Application A is my master database, while application B is a secondary database created per user The desired process is as follows: I register a new user in application A database then, when i create
How do I allow duplicate entries of products?
I want to link or restrict all my individual products to their respective suppliers, so that when I select a supplier in, for instance, a purchase subform, only the products of that particular supplier show and not the entire list of products. In addition, I need to allow duplicate product entries, as several suppliers often produce a product that has the same name (in this case, a type of wine, based on the same grape), but is entirely different by nature. Many thanks in advance!
How do I know that email is bounced?
Hi, how could I know using Zoho Creator that my email has failed? Have you any solution to know that some of send emails were bounced by email server?
Zoho Creator website not loading
I've been unable to load any Zoho Creator pages since this morning. The site hangs & I get a connection error in multiple browsers. My internet connection is fine. Any idea how to resolve?
Lookup filtering and subform
Hello, could you help me? I've a form (i.e. customer) with subform(i.e. cars). in another form, I need to filter lookup CARS when I choose the CUSTOMER. How can I do it? I already seen the link, but it don't help me. Will place an example for clarity FORM A Customer name Subform Cars (plate, type, color) FORM B Lookup Customer Lookup Car in Form B, if I select the Customer "Mr. White", I would like to see in the lookup Car only the cars of Mr. White. Can I do this with lookup filters? How? Thanks
Bug in getDayOfYear function
I have found an issue with the subject function. For my testing I have the following: The values are: input.Loan_Date = 12-16-2014 16:00:00 input.Claim_Date = 02-16-2015 and I have the following code. input.Number_of_Days = (input.Claim_Date.getDayOfYear() - input.Loan_Date.getDayOfYear()); The result: input.Number_of_Days = -303 I have run a few test data and it seems this bug occurs whenever the year are different. If it's the same year then the getDayOfYear function works Ok. Has someone encountered
Hangs on "Adding..." when inserting new field to form
My items were all working correctly yesterday until mid-day when suddenly adding any new fields to the form (Drop down, Single line, Check box, anything) result in the page simply hanging with "Adding" for the field. If it is a lookup source, it does go through to steps to determine what the source will be and has the same result of the addition simply hanging there... Any suggestions?
Custom Schedules
Hi Guys, I have a requirement to create custom schedules that run every 14 days and every 30 days. It looks to me that I can't do this as the options are daily, weekly, monthly and yearly. Perhaps I'm missing something? Thanks for any assistance!
How do I associate a Customer portal login with an account ID?
I want the database entry form accessed by the customer portal to pre-populate with an account number assigned to the customer logging in ... how do I do this?
Report View
I have my database set up and want to view it by item # in a report view. However, when I look at the report for each item, the rows are so spread apart that the report runs over to 3 pages. I want this to be single spaced so that everything fits on one page. Any idea how to do this?
Creator Icon Images are gone
Dear Zoho, Over the last couple of weeks something must have changed in your Creator backend infrastructure as the majority of the UI images are gone. Images like https://creator.zoho.com/platform/helpdesk/images/app/spacer.gif now report a 404 If I go to the Admin page in order to add technicians the following screen (see attachment) shows up, and it looks bad. Could you please fix this? Thanks, -Jaap
Subform Links in List Report
I have put Multiple SUbforms in my Parent Form but when I access the Report, List style, and i choose to access the Info in the SUbform Via a link in the Report i am no being shown the Data inputed into the fields. I am only getting Field names displayed when the link is clicked. Is there something i can do to have the Data included in the window generated by the Link?
How to learn input.vars or the Record ID within "On Delete" script?
Seems that both OnDelete.Validate, and OnDelete.Success, are unaware of the form's input vars?? The same scripts that work in OnAdd, and OnEdit, don't work when in OnDelete. Seems not even aware of its own record ID, at least not via input.ID. I must be missing something... :-) I have searched the dox and forum. How do I learn at LEAST the record ID, so I can look up the field values via x = <Form>[ID = input.ID]; ? In this our first brush with On Delete, we are updating some record counts successfully
"sharing done with selected users"
I have 3 more opening for users yet I keep getting this message. When I send a invitation the recipient receives the following link and not a invitation. How do I fix this so the recipient receives second invitation below. Invitation # 1 Hi, Check out my ' US-CAT ' application in the below link. https://creator.zoho.com/inovacion/us-cat/login/zc_email=jcolburnus.cat@gmail.com Have a nice day! inovacion Invitation #2 Hello and welcome skutzkeus.cat Thank you for registering with Zoho Services.
Need help defining a reports criteriia
I have a form "Site_Directory" that contains information regarding customers sites - including the managers name, his email, the stores location and location name etc.. Using the customer portal - The manager logs in ( using his email address as a login) - and is presented with a form to enter asset data. Within this form, by using deluge script ( on load) - I can identify which store etc. he belongs to, which helps pre-populate the form called " Asset_Management" where data regarding the stores
Can you allow editing in a multi-text field in a stateless form but not delete previous input in that field?
I have two Forms - one is called New Request, and one is called Request Status (stateless form). Employees will fill out the New Request form when they are requesting something from the Purchasing department. The requests are then emailed to the appropriate Purchaser upon submission. I have placed an Auto Number field in the New Request form, and a corresponding "Request Number" number field in the Request Status form so that upon receiving the request via email, they can enter the Request number
Cant access my forms, blank page shows when trying to load any regular form
all of my forms are showing up blank
URGENT! how to disable export entries for users?
hi need to disable export permissions for all users except account administrator how to make it
How to create a Customer Card?
hello, I'm new to the world zoho. I'm trying to create a database of clients, connecting multiple tables. I would like to create a page: 1) with a drop down menu where you can select the customer by Username; 2) extract, by query, all the necessary information about the client from the join of multiple tables ; 3) print to video information (i.e. photo, name, phone Number etc ...) Can someone help me? thanks a lot Giuseppe
Retrieve data based on each Multiselect selection
hi, I have a multiselect field and I would like to retrieve the value from another view based on each multiselect selection and input it another field View1: Form: when user first selects the 1001 in the multiselect field then a script will retrieve the respective "Subs" value from view1 which is 3000 and input it to "Est.Subs-Selected Fips" and then when user selects next Fips value --1003 -- then the the "Est.Subs-Selected Fips" will be updated to 4000. Could anyone please help me on script ? Thanks
Switch statments
HI I am in need of using Switch statement in deluge script for an application which i build. by switch i refer to this statement in PHP: $i switch $i { case 0: Do something case 1: Do something else } Is there such a statement in deluge? if not, can you add this functionality? Thank you Tal
Kitting or multiple units, stumper
So I have multiple forms: Form1 Form2 Form3 Form4 Form2 contains a 1 to many relationship with Form1 example... in form2 I have UNIT A, which contains multiple Items from Form1 so UNIT A may have ITEM 1, ITEM 2 and ITEM 3, all with different quantities I want to be able to select UNIT A in Form3 and have it create an individual record in Form4 (I think thats what i want to do) for each Item in UNIT A Thanks
can you pass data from one form to another that the first form opened with an open url command?
can you pass data from one form to another that the first form opened with an open url command?
Look up field value different in view than when editing record?
Please take a look at the following screen shot. Highlighted in Red: Request_ID shown in view = 1185428000007018175 - m3steele@gmail44.com - 9 Highlighted in Green: Request_ID in edit record = 1185428000007018240 - - m3steele@gmail44.com - 9 What is wrong, why is this happening? Im not sure if the value is set wrong or what. I know the lookup field is referring to the correct record because of the part " m3steele@gmail44.com - 9" that is also included. These values are not in any other record in
How to fetch date data from completed form
Hi I am very new to this software, and would appreciate some advise I am building an application to log maintenance on a variety of hydraulic and mechanical equipment. I have created the forms, that include all required information fields, including the date that the work was completed. What I would like to do is have a field on the form, that will automatically fill with the date that the last maintenance was completed on. I think the fetch data is how I need to do this, but I am pretty lost trying
Next Page